遍历 JSON 并转换为 CSV

Question

我有以下 JSON 对象：{  "h": [    {      "id": "242611",      "minute": "2",      "result": "MissedShots",      "X": "0.9359999847412109",      "Y": "0.534000015258789",      "xG": "0.1072189137339592",      "player": "Ari",      "h_a": "h",      "player_id": "2930",      "situation": "OpenPlay",      "season": "2018",      "shotType": "Head",      "match_id": "9071",      "h_team": "FC Krasnodar",      "a_team": "Ural",      "h_goals": "2",      "a_goals": "0",      "date": "2018-12-02 11:00:00",      "player_assisted": "Wanderson",      "lastAction": "Chipped"    },我想要的输出如下所示：我写了以下脚本：def scrap_understat():    csv_file_path = currentDir + '/output_shots' + current_time + '.csv'    file = None    writer = None    file = io.open(csv_file_path, 'w', newline='', encoding='ISO-8859-1')    writer = csv.writer(file)    writer.writerow(        ['ID', 'Result', 'X', 'Y', 'xG', 'Player', 'Home/Away', 'Player_ID', 'Situation', 'Season', 'Shot_Type',         'Match_ID', 'xG', 'Home_Team', 'Away_Team', 'Home_Goals', 'Away_Goals', 'Date', 'Player_Assisted', 'Last_Action'])    for i in range(10096, 10097):       try:           driver.get('https://understat.com/match/' + str(i))           time.sleep(1)           if try_find_Element(driver, By.CLASS_NAME, 'error-code') is not None:               continue           shots = driver.execute_script("return shotsData")           for v in shots.items():               writer.writerow(v)变量shot给了我包含的 JSON 对象。我不想要键h和a。但是，我的脚本提供了以下输出：我究竟做错了什么？是否也可以指定我想在 CSV 中包含哪些特定项目？

Answer 1

假设您将数据保存在名为 的变量中data：

data = {

  "h": [

    {

      "id": "242611",

      "minute": "2",

      "result": "MissedShots",

      "X": "0.9359999847412109",

      ....

写完标题后试试这个循环：

for items in data.values():

  for item in items:

    writer.writerow(item.values())