展平Pandas中的嵌套JSON列

import pandas as pd
import json

# 假设有一个包含嵌套JSON的DataFrame，列名为'json_column'
df = pd.DataFrame({'json_column': [{'name': 'John', 'age': 30, 'address': {'city': 'New York', 'state': 'NY'}},
                                   {'name': 'Alice', 'age': 25, 'address': {'city': 'San Francisco', 'state': 'CA'}}]})

# 将'json_column'展平为一维DataFrame
df_flat = pd.json_normalize(df['json_column'])

# 打印展平后的DataFrame
print(df_flat)

   name  age   address.city address.state
0  John   30       New York            NY
1 Alice   25  San Francisco            CA