迭代json结果，并在pandas dataframe中获得所需的数据。

import json
import pandas as pd

json_data = '{"key1": "value1", "key2": "value2"}'
data = json.loads(json_data)

df = pd.DataFrame(columns=['key', 'value'])
for key, value in data.items():
    df = df.append({'key': key, 'value': value}, ignore_index=True)

{
  "key1": {
    "sub_key1": "sub_value1",
    "sub_key2": "sub_value2"
  },
  "key2": "value2"
}

def process_json(data, df):
    for key, value in data.items():
        if isinstance(value, dict):
            process_json(value, df)
        else:
            df = df.append({'key': key, 'value': value}, ignore_index=True)
    return df

df = process_json(data, df)

specific_key = 'key1'
filtered_data = df[df['key'] == specific_key]['value']