pandas学习笔记—json与dataframe的互相转换

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,