数据分析-pandas处理json文件

data_dict = {
    "zs":{
            "name": "zs",
            "addr": "sx",
            "age": 23,
            "hobbies": [
                "basketball",
                "billiards",
                "swimming"
            ]
    },
        "ls":{
            "name": "ls",
            "addr": "sx",
            "age": 28,
            "hobbies": [
                "basketball",
                "billiards",
                "swimming"
            ]
    }

}
type(data_dict)

dict

import json

data_json = json.dumps(data_dict)

print(type(data_json),data_json)

<class 'str'> {"name": "zs", "addr": "sx", "age": 23, "hobbies": ["basketball", "billiards", "swimming"]}

import pandas as pd

df = pd.DataFrame(data_dict)
# to_json
print(df)

                                        zs                                 ls
addr                                    sx                                 sx
age                                     23                                 28
hobbies  [basketball, billiards, swimming]  [basketball, billiards, swimming]
name                                    zs                                 ls

import pandas as pd

df = pd.DataFrame(data_dict, columns=["zs"])
# 指定输出的列
print(df)

                                        zs
addr                                    sx
age                                     23
hobbies  [basketball, billiards, swimming]
name                                    zs

import pandas as pd

df = pd.read_json('json文件路径', encoding='utf-8')
# 使用 gbk 写入的是中文
# to_json

data_list = [
    {
        "name": "zs",
        "age": 20
    },
    {
        "name": "ls",
        "age": 29
    }
]

pd.DataFrame(data_list)

	age	name
0	20	zs
1	29	ls

data_list = [
    ["zs", "ls", "ww"], ["zs1", "ls1", "ww1","qq"]
]

pd.DataFrame(data_list)

	0	1	2	3
0	zs	ls	ww	None
1	zs1	ls1	ww1	qq