将JSON解析为Dataframe python

import pandas as pd
import json

# 读取JSON文件
with open('data.json') as f:
    data = json.load(f)

# 或者将JSON字符串转换为Python对象
json_str = '{"name": "John", "age": 30, "city": "New York"}'
data = json.loads(json_str)

df = pd.DataFrame(data)

# 查看Dataframe的前几行
print(df.head())

# 对Dataframe进行统计分析
print(df.describe())

# 对Dataframe进行筛选和排序
filtered_df = df[df['age'] > 25]
sorted_df = df.sort_values('name')

# 对Dataframe进行数据可视化
df.plot(kind='bar', x='name', y='age')