python3: 将json格式数据转换存储到excel文件中

 

 

 

# -*- coding: utf-8 -*-

import json
import pandas as pd

data = [] # 存储每一行转化过来的Json格式的数据
with open('./xxxxxxxxx.json','r', encoding = 'UTF-8') as fr:
for line in fr:
j = json.loads(line)
data.append(j)

df = pd.DataFrame() # 存取转换得到的结果数据集
for line in data:
for i in line:
df1 = pd.DataFrame([i])
df = df.append(df1)

# 写入excel表格
df.to_excel('transfereddata.xlsx', sheet_name='Data', startcol=0, index=False)