Python ValueError：将json作为pandas数据帧读取时的预期对象或值
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/44287011/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ValueError: Expected object or value when reading json as pandas dataframe
提问by adimohankv
Sample data:
样本数据：
{
"_id": "OzE5vaa3p7",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "nebCwWd2Fr"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/shopgro-1376.appspot.com/o/Barcode%20Data%20Upload%28II%29%2FAnil_puttu_flour_500g.png?alt=media&token=9cf63197-0925-4360-a31a-4675f4f46ae2",
"barcode": "8908001921015",
"isFmcg": true,
"itemName": "Anil puttu flour 500g",
"mrp": 58,
"_created_at": "2016-10-02T13:49:03.281Z",
"_updated_at": "2017-02-22T08:48:09.548Z"
}
{
"_id": "ENPCL8ph1p",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "B4nZeUHmVK"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/kirananearby-9eaa8.appspot.com/o/Barcode%20data%20upload%2FYippee_Magic_Masala_Noodles,_70_g.png?alt=media&token=d9e47bd7-f847-4d6f-9460-4be8dbcaae00",
"barcode": "8901725181222",
"isFmcg": true,
"itemName": "Yippee Magic Masala Noodles, 70 G",
"mrp": 12,
"_created_at": "2016-10-02T13:49:03.284Z",
"_updated_at": "2017-02-22T08:48:09.074Z"
}
I tried:
我试过：
import pandas as pd
data= pd.read_json('Data.json')
getting error ValueError: Expected object or value
获取错误 ValueError：预期的对象或值
also
还
import json
with open('gdb.json') as datafile:
data = json.load(datafile)
retail = pd.DataFrame(data)
error: json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 509)
错误：json.decoder.JSONDecodeError：额外数据：第 2 行第 1 列（字符 509）
with open('gdb.json') as datafile:
for line in datafile:
data = json.loads(line)
retail = pd.DataFrame(data)
error: json.decoder.JSONDecodeError: Extra data: line 1 column 577 (char 576)
错误：json.decoder.JSONDecodeError：额外数据：第 1 行第 577 列（字符 576）
How to read this json into pandas
如何将这个 json 读入 Pandas
回答by rahul
I got the same error, read the function documentationand play around with different parameters.
我遇到了同样的错误，阅读函数文档并使用不同的参数。
I solved it by using the one below,
我通过使用下面的一个解决了它，
data= pd.read_json('Data.json', lines=True)
data= pd.read_json('Data.json', lines=True)
you can try out other things like
你可以尝试其他的东西，比如
data= pd.read_json('Data.json', lines=True, orient='records')
data= pd.read_json('Data.json', lines=True, orient='records')
data= pd.read_json('Data.json', orient=str)
data= pd.read_json('Data.json', orient=str)
回答by Mingming Qiu
you should be ensure that the terminal directory is the same with the file directory (when this error occurs for me, because I used vscode, is means for me that the terminal directory in the vscode is not the same with my python file that I want to execute)
你应该确保终端目录与文件目录相同（当我发生这个错误时，因为我使用了vscode，对我来说意味着vscode中的终端目录与我想要的python文件不同执行）
回答by Shakeel
I am not sure if I clearly understood your question, you just trying to read json data ?
我不确定我是否清楚地理解了您的问题，您只是想读取 json 数据？
I just collected your sample data into list as shown below
我刚刚将您的样本数据收集到列表中，如下所示
[
{
"_id": "OzE5vaa3p7",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "nebCwWd2Fr"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/shopgro-1376.appspot.com/o/Barcode%20Data%20Upload%28II%29%2FAnil_puttu_flour_500g.png?alt=media&token=9cf63197-0925-4360-a31a-4675f4f46ae2",
"barcode": "8908001921015",
"isFmcg": true,
"itemName": "Anil puttu flour 500g",
"mrp": 58,
"_created_at": "2016-10-02T13:49:03.281Z",
"_updated_at": "2017-02-22T08:48:09.548Z"
},
{
"_id": "ENPCL8ph1p",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "B4nZeUHmVK"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/kirananearby-9eaa8.appspot.com/o/Barcode%20data%20upload%2FYippee_Magic_Masala_Noodles,_70_g.png?alt=media&token=d9e47bd7-f847-4d6f-9460-4be8dbcaae00",
"barcode": "8901725181222",
"isFmcg": true,
"itemName": "Yippee Magic Masala Noodles, 70 G",
"mrp": 12,
"_created_at": "2016-10-02T13:49:03.284Z",
"_updated_at": "2017-02-22T08:48:09.074Z"
}
]
and ran this code
并运行此代码
import pandas as pd
df = pd.read_json('Data.json')
print(df)
Output:-
输出：-
_created_at ... mrp
0 2016-10-02 13:49:03.281 ... 58
1 2016-10-02 13:49:03.284 ... 12
[2 rows x 10 columns]
回答by Steven
Your JSON is malformed.
您的 JSON 格式错误。
ValueError: Expected object or valuecan occur if you mistyped the file name. Does Data.jsonexist? I noticed for your other attempts you used gdb.json.
ValueError: Expected object or value如果您输入错误的文件名，可能会发生。是否Data.json存在？我注意到你使用的其他尝试gdb.json。
Once you confirm the file name is correct, you have to fix your JSON. What you have now is two disconnected records separated by a space. Lists in JSON must be valid arrays inside square brackets and separated by a comma: [{record1}, {record2}, ...]
确认文件名正确后，您必须修复 JSON。您现在拥有的是两个由空格分隔的断开连接的记录。JSON 中的列表必须是方括号内的有效数组，并用逗号分隔：[{record1}, {record2}, ...]
Also, for pandas you should put your array under a root element called "data":
此外，对于熊猫，您应该将数组放在名为 的根元素下"data"：
{ "data": [ {record1}, {record2}, ... ] }
Your JSON should end up looking like this:
您的 JSON 最终应如下所示：
{"data":
[{
"_id": "OzE5vaa3p7",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "nebCwWd2Fr"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/shopgro-1376.appspot.com/o/Barcode%20Data%20Upload%28II%29%2FAnil_puttu_flour_500g.png?alt=media&token=9cf63197-0925-4360-a31a-4675f4f46ae2",
"barcode": "8908001921015",
"isFmcg": true,
"itemName": "Anil puttu flour 500g",
"mrp": 58,
"_created_at": "2016-10-02T13:49:03.281Z",
"_updated_at": "2017-02-22T08:48:09.548Z"
}
,
{
"_id": "ENPCL8ph1p",
"categories": [
{
"__type": "Pointer",
"className": "Category",
"objectId": "B4nZeUHmVK"
}
],
"isActive": true,
"imageUrl": "https://firebasestorage.googleapis.com/v0/b/kirananearby-9eaa8.appspot.com/o/Barcode%20data%20upload%2FYippee_Magic_Masala_Noodles,_70_g.png?alt=media&token=d9e47bd7-f847-4d6f-9460-4be8dbcaae00",
"barcode": "8901725181222",
"isFmcg": true,
"itemName": "Yippee Magic Masala Noodles, 70 G",
"mrp": 12,
"_created_at": "2016-10-02T13:49:03.284Z",
"_updated_at": "2017-02-22T08:48:09.074Z"
}]}
Finally, pandas calls this format split orientation, so you have to load it as follows:
最后，pandas 调用此格式split orientation，因此您必须按如下方式加载它：
df = pd.read_json('gdb.json', orient='split')
dfnow contains the following data frame:
df现在包含以下数据框：
_id categories isActive imageUrl barcode isFmcg itemName mrp _created_at _updated_at
0 OzE5vaa3p7 [{'__type': 'Pointer', 'className': 'Category', 'objectI... True https://firebasestorage.googleapis.com/v0/b/shopgro-1376... 8908001921015 True Anil puttu flour 500g 58 2016-10-02 13:49:03.281000+00:00 2017-02-22 08:48:09.548000+00:00
1 ENPCL8ph1p [{'__type': 'Pointer', 'className': 'Category', 'objectI... True https://firebasestorage.googleapis.com/v0/b/kirananearby... 8901725181222 True Yippee Magic Masala Noodles, 70 G 12 2016-10-02 13:49:03.284000+00:00 2017-02-22 08:48:09.074000+00:00
回答by user12240240
make your path easy, it will be helpful to read data. meanwhile, just put your file on your desktop and give that path to read the data. It works.
使您的路径变得轻松，这将有助于阅读数据。同时，只需将您的文件放在桌面上并提供读取数据的路径。有用。
回答by matt.robinson17
I dont think this would be the problem as it should be the default (I think). But have you tried this? Adding an 'r' to specify the file is read only.
我不认为这会是问题，因为它应该是默认值（我认为）。但是你试过这个吗？添加“r”以指定文件是只读的。
import json
with open('gdb.json', 'r') as datafile:
data = json.load(datafile)
retail = pd.DataFrame(data)
import json
with open('gdb.json', 'r') as datafile:
data = json.load(datafile)
retail = pd.DataFrame(data)
