目 录
1、两类json格式
(1)对象格式
{
"name":"JSON","address":"北京市西城区","age":25}#JSON的对象格式的字符串
(2)数组对象格式
[{
"name":"JSON","address":"北京市西城区","age":25},{
"name":"ROSE","address":"北京市东城区","age":23}]#数组对象格式
本文将分别讲解对象格式json和数组对象格式json与dataframe相互转化。
2、json转dataframe
2.1 对象格式json
- json文件转dataframe
import pandas as pd
import json
from pandas import json_normalize
obj={
"col_1":[1,2,3,4],
"col_2":[4,3,2,1]}
with open("test.json","w",encoding="utf-8") as f:
f.write(obj)
import pandas as pd
df = pd.read_json("test.json",encoding="utf-8", orient='records')
print(df)
输出:
- json对象(变量)转dataframe
import pandas as pd
import json
from pandas import json_normalize
obj={
"col_1":[1,2,3,4],
"col_2"