pandas读取json文件，文件中包含多个json对象

文档为 file_path=test.json, 内容如下，里面包含多个 json 对象

{"workspace_id":"20414","project_name":"创达"}
{"workspace_id":"5513","project_name":"盟博"}
{"workspace_id":"91345","project_name":"CA"}
{"workspace_id":"455512","project_name":"输入法"}
{"workspace_id":"454037","project_name":"马自"}
{"workspace_id":"454036","project_name":"CM"}
{"workspace_id":"53111","project_name":"01"}
1
2
3
4
5
6
7

直接使用 json 读取会报错

data = json.load(fp=file_path)
错误: AttributeError: 'str' object has no attribute 'read'
1
2

可以使用 jsonlines 库，读取多个json对象的json文件

也可以使用 pandas 读取

import json
import pandas as pd

with open(file_path, encoding='utf-8') as file:
    tweets = file.readlines()
df = pd.json_normalize([json.loads(tweet) for tweet in tweets])
1
2
3
4
5
6

参考：

如何将包含多个JSON对象的推文JSON文件加载到Pandas数据帧中？ -相关文档
python读取和解析含有多个json对象的json文件