python KeyError,找不到错误
问题描述:
import json
import pandas as pd
data = """
{
"name": "Wes",
"place_lived": ["United Stats", "Spain", "Germany"],
"pet": null,
"Siblings": [
{"name": "Scott", "age": 25, "pet": "Zuko"},
{"name": "Katie", "age": 33, "pet": "Cisco"}]
}
"""
result = json.loads(data)
df = pd.DataFrame(result['siblings'], columns=['name', 'age'])
print(df)
我从“Python for Data Analysis”一书中得到了这个例子,我得到的只是keyerror,我不知道错误在哪里。python KeyError,找不到错误
答
可能是最简单的答案了。注意区分大小写。
import json
import pandas as pd
data = """
{
"name": "Wes",
"place_lived": ["United Stats", "Spain", "Germany"],
"pet": null,
"Siblings": [
{"name": "Scott", "age": 25, "pet": "Zuko"},
{"name": "Katie", "age": 33, "pet": "Cisco"}]
}
"""
result = json.loads(data)
df = pd.DataFrame(result['Siblings'], columns=['name', 'age'])
print(df)
您需要大写''Siblings''。 –
注意区分大小写! ''兄弟姐妹''和'兄弟姐妹'不一样'' – mmenschig
我只是很笨!非常感谢 –