从Python dataframe中的JSON中移除外部数组

import pandas as pd
import json

data = {'id': [1, 2, 3],
        'json_data': ['{"name": "John", "age": 30, "hobbies": ["reading", "swimming"]}',
                      '{"name": "Alice", "age": 25, "hobbies": ["gaming", "painting"]}',
                      '{"name": "Bob", "age": 35, "hobbies": ["cooking", "gardening"]}'
                     ]}
df = pd.DataFrame(data)

df['json_data'] = df['json_data'].apply(lambda x: json.loads(x))
df['json_data'] = df['json_data'].apply(lambda x: {k: v for k, v in x.items() if k != 'hobbies'})

print(df)

   id               json_data
0   1  {'name': 'John', 'age': 30}
1   2  {'name': 'Alice', 'age': 25}
2   3    {'name': 'Bob', 'age': 35}