python json 转化成 DataFrame
1、json_normalize
json数据形式:
转化后的 DataFrame 形式:
代码实现:
import pandas as pd
from pandas import json_normalize
# from pandas.io.json import json_normalize(不推荐)
with open("jsondata.json", "r")as f:
jsondata = json.load(f)
data = json_normalize(jsondata)
2、read_json / eval + pd.DataFrame
json 数据形式:
转化后的 DataFrame 形式:
代码实现:
import pandas as pd
from pandas import DataFrame as df
# 法1
data = pd.read_json("jsondata1.json",orient = "columns")
# 法2
with open("jsondata1.json","r") as f:
jsondata1 = f.read()
data = df(eval(jsondata1))
注:可以根据数据的不同形式选择不同的转化方法。另附两个常用的json解析网址:
https://www.json.cn/
http://www.bejson.com/
jsondata = '{"age": 18, "phone": "12345654321", "boolValue": false, "nullValue": null,"info": {"name" : "yezi","address": {"country": "china","city": "HeBei"}}, "updatedate": [22, 23, 24]}'
jsondata1 = '[{"name": "D", "age": 27}, {"name": "W", "age": 29}]'