python - 将 JSON 读取到 pandas 数据框 - ValueError : Mixing dicts with non-Series may lead to ambiguous ordering

Question

我试图将下面的 JSON 结构读入 pandas 数据框，但它抛出了错误消息:

ValueError: Mixing dicts with non-Series may lead to ambiguous ordering.

Json数据:

{
    "status": {
        "statuscode": 200,
        "statusmessage": "Everything OK"
    },

    "result": [{
        "id": 22,
        "club_id": 16182
    }, {
        "id": 23,
        "club_id": 16182
    }, {
        "id": 24,
        "club_id": 16182
    }, {
        "id": 25,
        "club_id": 16182
    }, {
        "id": 26,
        "club_id": 16182
    }, {
        "id": 27,
        "club_id": 16182
    }]
}

我该如何做对？我试过下面的脚本...

j_df = pd.read_json('json_file.json')
j_df

with open(j_file) as jsonfile:
    data = json.load(jsonfile)

Answer 1

如果您只需要数据框中的结果部分，那么这里的代码可以帮助您。

import json
import pandas as pd
data = json.load(open('json_file.json'))

df = pd.DataFrame(data["result"])