对json键值对的解析

Question

我有来自facebook的以下JSON：

{
  "insights": {
"data": [
  {
    "name": "page_fans_city",
    "period": "day",
    "values": [
      {
        "value": {
          "Lakki Marwat, Khyber Pakhtunkhwa, Pakistan": 704,
          "Dera Ghazi Khan, Punjab, Pakistan": 725,
          "Tank, Khyber Pakhtunkhwa, Pakistan": 750,
          "Khwazakhela, Khyber Pakhtunkhwa, Pakistan": 792,
          "Dammam, Saudi Arabia": 828,
          "Chakdara Fort, Khyber Pakhtunkhwa, Pakistan": 936,
          "Gujrat, Punjab, Pakistan": 975,
          "Al Ain, United Arab Emirates": 1011,
          "Wah, Punjab, Pakistan": 1082,
          "Kabul, Afghanistan": 1108,
          "Bahawalpur, Punjab, Pakistan": 1144,
          "Sargodha, Punjab, Pakistan": 1148,
          "Sialkot, Punjab, Pakistan": 1290,
          "Parachinar, Federally Administered Tribal Areas, Pakistan": 1322,
          "Chitral, Khyber Pakhtunkhwa, Pakistan": 1396,
          "Hyderabad, Sindh, Pakistan": 1532,
          "Swabi, Khyber Pakhtunkhwa, Pakistan": 1654,
          "Hangu, Khyber Pakhtunkhwa, Pakistan": 1680,
          "Karak, Khyber Pakhtunkhwa, Pakistan": 1784,
          "Doha, Qatar": 1873,
          "Charsadda, Khyber Pakhtunkhwa, Pakistan": 1936,
          "Sharjah, United Arab Emirates": 2169,
          "Gujranwala, Punjab, Pakistan": 2313,
          "Nowshera, Khyber Pakhtunkhwa, Pakistan": 2350,
          "Dir, Khyber Pakhtunkhwa, Pakistan": 2449,
          "Jeddah, Saudi Arabia": 2739,
          "Mansehra, Khyber Pakhtunkhwa, Pakistan": 3358,
          "Multan, Punjab, Pakistan": 3383,
          "Haripur, Khyber Pakhtunkhwa, Pakistan": 3735,
          "Faisalabad, Punjab, Pakistan": 3815,
          "Quetta, Balochistan, Pakistan": 3862,
          "Abu Dhabi, United Arab Emirates": 4374,
          "Mingora, Khyber Pakhtunkhwa, Pakistan": 5641,
          "Dera Ismail Khan, Khyber Pakhtunkhwa, Pakistan": 6143,
          "Bannu, Khyber Pakhtunkhwa, Pakistan": 6623,
          "Kohat, Khyber Pakhtunkhwa, Pakistan": 6760,
          "Abbottabad, Khyber Pakhtunkhwa, Pakistan": 7204,
          "Dubai, United Arab Emirates": 7767,
          "Rawalpindi, Punjab, Pakistan": 7869,
          "Riyadh, Saudi Arabia": 8477,
          "Mardan, Khyber Pakhtunkhwa, Pakistan": 16039,
          "Lahore, Punjab, Pakistan": 16371,
          "Islamabad, Islamabad Capital Territory, Pakistan": 18291,
          "Karachi, Sindh, Pakistan": 22880,
          "Peshawar, Khyber Pakhtunkhwa, Pakistan": 93904
        },
        "end_time": "2022-05-27T07:00:00+0000"
      },
      {
        "value": {
          "Lakki Marwat, Khyber Pakhtunkhwa, Pakistan": 703,
          "Dera Ghazi Khan, Punjab, Pakistan": 727,
          "Tank, Khyber Pakhtunkhwa, Pakistan": 754,
          "Khwazakhela, Khyber Pakhtunkhwa, Pakistan": 790,
          "Dammam, Saudi Arabia": 829,
          "Chakdara Fort, Khyber Pakhtunkhwa, Pakistan": 939,
          "Gujrat, Punjab, Pakistan": 978,
          "Al Ain, United Arab Emirates": 1013,
          "Wah, Punjab, Pakistan": 1086,
          "Kabul, Afghanistan": 1113,
          "Bahawalpur, Punjab, Pakistan": 1138,
          "Sargodha, Punjab, Pakistan": 1145,
          "Sialkot, Punjab, Pakistan": 1292,
          "Parachinar, Federally Administered Tribal Areas, Pakistan": 1317,
          "Chitral, Khyber Pakhtunkhwa, Pakistan": 1398,
          "Hyderabad, Sindh, Pakistan": 1537,
          "Swabi, Khyber Pakhtunkhwa, Pakistan": 1664,
          "Hangu, Khyber Pakhtunkhwa, Pakistan": 1678,
          "Karak, Khyber Pakhtunkhwa, Pakistan": 1787,
          "Doha, Qatar": 1874,
          "Charsadda, Khyber Pakhtunkhwa, Pakistan": 1941,
          "Sharjah, United Arab Emirates": 2167,
          "Gujranwala, Punjab, Pakistan": 2330,
          "Nowshera, Khyber Pakhtunkhwa, Pakistan": 2372,
          "Dir, Khyber Pakhtunkhwa, Pakistan": 2454,
          "Jeddah, Saudi Arabia": 2732,
          "Mansehra, Khyber Pakhtunkhwa, Pakistan": 3359,
          "Multan, Punjab, Pakistan": 3380,
          "Haripur, Khyber Pakhtunkhwa, Pakistan": 3737,
          "Faisalabad, Punjab, Pakistan": 3825,
          "Quetta, Balochistan, Pakistan": 3858,
          "Abu Dhabi, United Arab Emirates": 4378,
          "Mingora, Khyber Pakhtunkhwa, Pakistan": 5646,
          "Dera Ismail Khan, Khyber Pakhtunkhwa, Pakistan": 6137,
          "Bannu, Khyber Pakhtunkhwa, Pakistan": 6624,
          "Kohat, Khyber Pakhtunkhwa, Pakistan": 6747,
          "Abbottabad, Khyber Pakhtunkhwa, Pakistan": 7201,
          "Rawalpindi, Punjab, Pakistan": 7523,
          "Dubai, United Arab Emirates": 7763,
          "Riyadh, Saudi Arabia": 8476,
          "Mardan, Khyber Pakhtunkhwa, Pakistan": 16058,
          "Lahore, Punjab, Pakistan": 16361,
          "Islamabad, Islamabad Capital Territory, Pakistan": 18422,
          "Karachi, Sindh, Pakistan": 22981,
          "Peshawar, Khyber Pakhtunkhwa, Pakistan": 93840
        },
        "end_time": "2022-05-28T07:00:00+0000"
      }
    ],
    "title": "Lifetime Likes by City",
    "description": "Lifetime: Aggregated Facebook location data, sorted by city (top 50), about the people who like your Page. (Unique Users)",
    "id": ""
  }
],
"paging": {
  "previous": "",
  "next": "?access_token="
}
  },
  "id": ""
}

如您所见，它由带有城市名称和值的键值对组成。我想要的是对键值对进行解析，并通过api将它们插入数据库中。城市名称将进入“城市”列，而值将进入“值”列。

代码：

graph = facebook.GraphAPI(access_token=i)
profile = graph.get_object(id='me', fields='insights.metric(page_fans_city)')
x = json.dumps(profile, indent=4)
# print (x)


# pageID = profile['id']
# pageName = profile['name']

raw_data = json.loads(x) # parse the string into a python dictionary

useful_data = raw_data['insights']['data'] # Only picking concerned fields

output = {'totalCount' : []} # This is where we will store the results as tuples of (value, end_time)
secondOutput = {'newTuple': []}
d = []

for el in useful_data:
    if el['period'] == "day":
        for i in el['values']:
            output['totalCount'].append( (i['value'], i['end_time']) )
            
print (output)

上面的代码存储整个值，我想要的是单独的键值对，这样我就可以使用它们了。任何帮助都将不胜感激。

Answer 1

在您的内部循环中，您可以按以下方式迭代i['value']：

for key, value in i['value'].items():
    # do something with the data

有关更多信息，请参见Python3文档中的Python教程的数据结构部分。