has a json file as follows:
{
"cover": "http://p2.music.126.net/wsPS7l8JZ3EAOvlaJPWW-w==/109951163393967421.jpg?param=140y140",
"title": "2018上半年最热新歌TOP50",
"author": "网易云音乐",
"times": "1264万",
"url": "https://music.163.com/playlist?id=2303649893",
"id": "2303649893"
}
{
"cover": "http://p2.music.126.net/wpahk9cQCDtdzJPE52EzJQ==/109951163271025942.jpg?param=140y140",
"title": "你的青春里有没有属于你的一首歌?",
"author": "mayuko然",
"times": "4576万",
"url": "https://music.163.com/playlist?id=2201879658",
"id": "2201879658"
}
when I try to read the file with pd.read_json('data.json')
, I get an error. The error part is as follows:
File "D:\python\lib\site-packages\pandas\io\json\json.py", line 853, in _parse_no_numpy
loads(json, precise_float=self.precise_float), dtype=None)
ValueError: Trailing data
after a baidu found that it was a json format error, is the first time I know there is such a thing as jsonviewer. You need to save the dictionary in the file as an element in the list, modified as follows.
[{
"cover": "http://p2.music.126.net/wsPS7l8JZ3EAOvlaJPWW-w==/109951163393967421.jpg?param=140y140",
"title": "2018上半年最热新歌TOP50",
"author": "网易云音乐",
"times": "1264万",
"url": "https://music.163.com/playlist?id=2303649893",
"id": "2303649893"
},
{
"cover": "http://p2.music.126.net/wpahk9cQCDtdzJPE52EzJQ==/109951163271025942.jpg?param=140y140",
"title": "你的青春里有没有属于你的一首歌?",
"author": "mayuko然",
"times": "4576万",
"url": "https://music.163.com/playlist?id=2201879658",
"id": "2201879658"
}]
another method is to file each behavior of a complete dictionary, and then modify the parameters in the function pd. Read_json ('data.json',lines=True)
. lines
default to False
, set to True
can read json objects according to the row. In the psor.read_json document, it is explained as follows:
lines: Boolean, default False. Read the file as a json object perline.new in version 0.19.0.
the modified json file is as follows:
{"cover": "http://p2.music.126.net/wsPS7l8JZ3EAOvlaJPWW-w==/109951163393967421.jpg?param=140y140","title": "2018上半年最热新歌TOP50","author": "网易云音乐","times": "1264万","url": "https://music.163.com/playlist?id=2303649893","id": "2303649893"}
{"cover": "http://p2.music.126.net/wpahk9cQCDtdzJPE52EzJQ==/109951163271025942.jpg?param=140y140","title": "你的青春里有没有属于你的一首歌?","author": "mayuko然","times": "4576万","url": "https://music.163.com/playlist?id=2201879658","id": "2201879658"}
div>