本文目标如题所述,直接上代码,运行环境python3.6
import json
import pandas as pd
import csv
df = pd.DataFrame()
with open(r'./colorChina.json','r',encoding='utf-8')as f:
for ff in f:
data = json.loads(ff)
row = pd.DataFrame(data)
df = df.append(row,ignore_index=True)
print(df.head())
df.to_csv('colorChina.csv',index=None,mode='a')