-
Book Overview & Buying
-
Table Of Contents
Practical Data Wrangling
By :
In this next demonstration, you will read the output data from the previous chapter and convert it to CSV format.
To start off with, I will create a file called json_to_csv.py which will make use of both the csv module and the json module. In the json_to_csv.py file, I will start by importing both the csv module and the json module and reading the JSON data from the scf_extract.json file into a Python list:
import csv
import json
## read in the input json data
fin = open("../data/input_data/scf_extract.json","r")
json_data = json.load(fin)
fin.close()Writing CSV data using the csv module is a bit like reading data with the CSV module in reverse. When opening a file with write permission, you can use the corresponding file object to create a writer object. This is done using the csv.writer() function. The writerow() function of the writer object will take an array of values and write it to a row in the output file.
Recall that the extracted data entries...