从由json字符串组成的列到DataFrame

import pandas as pd
import json

# 假设我们有一个包含JSON字符串的列表
json_strings = [
    '{"name": "Alice", "age": 30}',
    '{"name": "Bob", "age": 25}',
    '{"name": "Charlie", "age": 35}'
]

# 将JSON字符串转换为Python字典列表
data = [json.loads(js) for js in json_strings]

# 将字典列表转换为DataFrame
df = pd.DataFrame(data)

print(df)

try:
    data = [json.loads(js) for js in json_strings]
except json.JSONDecodeError as e:
    print(f"JSON解析错误: {e}")

def clean_data(js):
    try:
        data = json.loads(js)
        # 确保所有字段都是期望的数据类型
        data['age'] = int(data['age'])
        return data
    except (json.JSONDecodeError, ValueError) as e:
        print(f"数据清洗错误: {e}")
        return None

cleaned_data = [clean_data(js) for js in json_strings]
df = pd.DataFrame(cleaned_data).dropna()