从偶尔丢失元素的JSON生成的多级列表中提取到数据框

import json

def preprocess_json(json_data):
    if isinstance(json_data, dict):
        return {k: preprocess_json(v) for k, v in json_data.items()}
    elif isinstance(json_data, list):
        return [preprocess_json(item) for item in json_data if item is not None]
    else:
        return json_data

# 示例JSON数据
json_str = '{"a": [1, null, {"b": 2}], "c": null}'
json_data = json.loads(json_str)

# 预处理
cleaned_data = preprocess_json(json_data)
print(cleaned_data)

import pandas as pd

def json_to_dataframe(json_data):
    try:
        df = pd.json_normalize(json_data)
        return df
    except Exception as e:
        print(f"Error parsing JSON: {e}")
        return None

# 使用预处理后的数据生成数据框
df = json_to_dataframe(cleaned_data)
print(df)

try:
    df = json_to_dataframe(cleaned_data)
except Exception as e:
    print(f"Failed to convert JSON to DataFrame: {e}")