python - 使用 Pandas 嵌套 JSON

Question

我正在尝试从下面的 JSON 文件创建一个数据框。我一直在使用 d1 = pd.read_json('user.json')，但这并没有为嵌套值 accessToken,facebookId 等创建列。

有没有一种简单的方法告诉 pandas 处理这些嵌套值？

这个问题已在其他地方提出，但我要求将嵌套值作为较大数据框中的列输入。

{
"_id": 11,
"claimToFame": "Send me some tunes...or your GitHub!",
"commentCount": 230,
"coverImage": "img.jpg",
"currentLanguage": "en-GB",
"dateOfBirth": "07/29/1982",
"email": "l@gmail.com",
"facebookDetails":    {
        "accessToken": "123",
        "facebookId": "123"
    }
,
"facebookId": 1,
"firstName": "David",
"followerCount": 422403,
"following": false,
"followingCount": 253,
"googleDetails": 
    {
        "googleId": "111411986454983058357",
        "accessToken": "123"
    }
}

Answer 1

这里有一个方法:

import pandas as pd
import json

data = json.dumps([{
"_id": 11,
"claimToFame": "Send me some tunes...or your GitHub!",
"commentCount": 230,
"coverImage": "img.jpg",
"currentLanguage": "en-GB",
"dateOfBirth": "07/29/1982",
"email": "l@gmail.com",
"facebookDetails":    {
        "accessToken": "123",
        "facebookId": "123"
    }
,
"facebookId": 1,
"firstName": "David",
"followerCount": 422403,
"following": False,
"followingCount": 253,
"googleDetails": 
    {
        "googleId": "111411986454983058357",
        "accessToken": "123"
    }
}], separators=(',',':'))

pd.read_json(data)