python - 如何使用 pandas 展平文件夹布局的 json 文件

Question

我需要使用 pandas 将此 json 文件夹结构展平为表格格式。我已经尝试了一段时间，但一直无法得到它。我似乎无法让 json_normalize 工作。

[
{
    "folderId": 0,
    "pid": 0,
    "path": "/All Traits",
    "parentFolderId": 0,
    "folderCount": 12,
    "subFolders": [
                    {
                        "folderId": 5098,
                        "pid": 0,
                        "path": "/All Traits/3rd-Party Data",
                        "parentFolderId": 0,
                        "folderCount": 0,
                        "subFolders": [],
                        "dataSourceId": 0,
                        "name": "3rd-Party Data"
                    },
                    {
                        "folderId": 671518,
                        "pid": 2343,
                        "path": "/All Traits/Analytics Traits",
                        "parentFolderId": 0,
                        "folderCount": 62,
                        "subFolders": [
                            {
                                "folderId": 766737,
                                "pid": 2343,
                                "path": "/All Traits/Analytics Traits/300000767",
                                "parentFolderId": 671518,
                                "folderCount": 6,
                                "subFolders": [
                                                {
                                                    "folderId": 872557,
                                                    "pid": 2343,
                                                    "path": "/All Traits/Analytics Traits/300000767/deltadeltamicrositedev",
                                                    "parentFolderId": 766737,
                                                    "folderCount": 0,
                                                    "subFolders": [],
                                                    "name": "deltadeltamicrositedev"
                                                }],
                                "name": "300000767"
                            },
                            {
                                "folderId": 766740,
                                "pid": 2343,
                                "path": "/All Traits/Analytics Traits/dalbadprod",
                                "parentFolderId": 671518,
                                "folderCount": 0,
                                "subFolders": [],
                                "name": "dalbadprod"
                            },
                            {
                                "folderId": 766743,
                                "pid": 2343,
                                "path": "/All Traits/Analytics Traits/dalchrome",
                                "parentFolderId": 671518,
                                "folderCount": 0,
                                "subFolders": [],
                                "name": "dalchrome"
                            }
                        ],
            "name": "Analytics Traits"
        }],
    "name": "All Traits"
}

]

输出路径、dataSourceId、subFolders、parentFolderId、name、pid、folderCount、folderId

标签： pythonjsonpython-3.xpandasdirectory