以下是从美国职业棒球大联盟提取的JSON文件的数据子集:
"liveData": {
"plays": {
"allPlays": [
{
"runners": [
{
"details": {
"event": "Single",
"runner": {
"id": 656941,
"fullName": "Kyle Schwarber",
},
"responsiblePitcher": null,
"isScoringEvent": false,
"rbi": false,
"earned": false,
"teamUnearned": false,
"playIndex": 6
}
}
]
我无法访问id值,因此无法将其包含在正在构建的dataFrame中.
我从对JSON文件使用json_normalize
开始.
在成功提取其他值之后,我得到以下结果:
data=[]
plays = j['liveData']['plays']['allPlays']
for play in plays:
x = play['runners']['details']
我得到的信息是,‘详细信息’不是一个可接受的索引,因为它是一个字符串,而不是整数或切片.
我怎样才能得到‘id’的内在价值?