python - How to convert my json data to dataframe pandas
问题描述
Hi i cannot seem to convert my json data to csv using python please help:
{
"metadata": {
"application": "orders-prod",
"host": "ldn001"
},
"OrdID": "123",
"EventSeq": "328",
"EventTS": "2019-04-17T01:01:14.569000Z"
}
{
"metadata": {
"application": "orders-prod",
"host": "ldn001"
},
"OrdID": "234",
"EventSeq": "328",
"EventTS": "2019-04-17T01:01:14.569000Z"
}
{
"metadata": {
"application": "orders-prod",
"host": "ldn001"
},
"OrdID": "554",
"EventSeq": "328",
"EventTS": "2019-04-17T01:01:14.569000Z"
}
df=pd.read_json('smallordersl.json',lines=True)
I tried the above but it doesn't work- i get the error ValueError: Expected object or value.
解决方案
您的 json 文件不是您指定的每行。请参阅文档中有关读取 json 文件的以下注释。 https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_json.html
lines : boolean, default False
Read the file as a json object per line.
下面是在参数中使用lines=True 的示例
pd.read_json('{"a":1,"b":2}\n{"a":3,"b":4}', lines=True)
注意上面的 json 文件有 line1 和 line2,用换行符 (\n) 隔开