Convert large json file into csv using python

simple,

1. get a json file for testing,

example file : https://github.com/zeMirco/sf-city-lots-json

2. install the module pandas if not installed

pip install pandas

3. run the following python script

python json-to-csv.py

json-to-csv.py file contains

import json
import pandas as pd
from pandas.io.json import json_normalize
f = open('citylots.json') # open the json file
data = json.load(f) # load as json
f.close()
df = json_normalize(data['features']) #load json into dataframe
df.to_csv('json-to-csv.csv', sep=',', encoding='utf-8') #save as csv