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...