如何在Python中将json文件中的特定密钥插入到数据框中

import json
import pandas as pd

with open('data.json', 'r') as file:
    json_data = json.load(file)

df = pd.DataFrame(columns=['key1', 'key2', 'key3'])  # 替换'key1', 'key2', 'key3'为你的特定密钥

for entry in json_data:
    key1_value = entry['key1']  # 替换'key1'为你的特定密钥
    key2_value = entry['key2']  # 替换'key2'为你的特定密钥
    key3_value = entry['key3']  # 替换'key3'为你的特定密钥
    df = df.append({'key1': key1_value, 'key2': key2_value, 'key3': key3_value}, ignore_index=True)

print(df)

[
  {
    "key1": "value1",
    "key2": "value2",
    "key3": "value3"
  },
  {
    "key1": "value4",
    "key2": "value5",
    "key3": "value6"
  }
]