将嵌套JSON中的值添加到pandas数据框中

import pandas as pd
import json

with open('data.json') as f:
    data = json.load(f)

df = pd.DataFrame(columns=['key1', 'key2', 'key3'])

for entry in data:
    key1 = entry['key1']
    key2 = entry['key2']['nested_key']
    key3 = entry['key3']
    df = df.append({'key1': key1, 'key2': key2, 'key3': key3}, ignore_index=True)

[
  {
    "key1": "value1",
    "key2": {
      "nested_key": "value2"
    },
    "key3": "value3"
  },
  ...
]