规范化json列并与dataframe的其余部分连接

import pandas as pd
import json
from pandas.io.json import json_normalize

data = {
    'id': [1, 2, 3],
    'name': ['John', 'Jane', 'Alice'],
    'json_data': [
        '{"age": 25, "city": "New York"}',
        '{"age": 30, "city": "London"}',
        '{"age": 35, "city": "Paris"}'
    ]
}

df = pd.DataFrame(data)

# 解析JSON数据
df['json_data'] = df['json_data'].apply(json.loads)

# 规范化JSON列并与DataFrame连接
normalized_df = pd.json_normalize(df['json_data'])
df = pd.concat([df.drop('json_data', axis=1), normalized_df], axis=1)