Python - 如何将 json 对象数组转换为 Dataframe？

Question

我是 python 的新手。我需要一些帮助才能过滤我的 JSON。

json = { 
    "selection":[ 
         {
          "person_id":105894,
          "position_id":1,
          "label":"Work",
          "description":"A description",
          "startDate":"2017-07-16T19:20:30+01:00",
          "stopDate":"2017-07-16T20:20:30+01:00"
          },
          {
         "person_id":945123,
         "position_id":null,
         "label":"Illness",
         "description":"A description",
         "startDate":"2017-07-17T19:20:30+01:00",
         "stopDate":"2017-07-17T20:20:30+01:00"
         }
       ]
     }

具体来说，我想做的是将我的 JSON(上文)转换为 Dataframe，以便能够在其上使用查询方法，例如:

selected_person_id = 105894
query_person_id = json[(json['person_id'] == selected_person_id)]
or
json.query('person_id <= 105894')

列必须是:

cols = ['person_id', 'position_id', 'label', 'description', 'startDate', 'stopDate']

我该怎么做？

Answer 1

使用:

df = pd.DataFrame(json['selection'])
print (df)
     description    label  person_id  position_id                  startDate  \
0  A description     Work     105894          1.0  2017-07-16T19:20:30+01:00   
1  A description  Illness     945123          NaN  2017-07-17T19:20:30+01:00   

                    stopDate  
0  2017-07-16T20:20:30+01:00  
1  2017-07-17T20:20:30+01:00  

编辑:

import json

with open('file.json') as data_file:    
    json = json.load(data_file)