将嵌套的mongoDB文档转换为平面pandas DataFrame (对象数组中的对象数组)

import pandas as pd
from pymongo import MongoClient

# 连接到MongoDB数据库
client = MongoClient('mongodb://localhost:27017/')
db = client['mydatabase']
collection = db['mycollection']

# 查询嵌套文档
query = collection.find({})

# 转换为Python对象
data = list(query)

# 扁平化嵌套文档
def flatten_dict(d, parent_key='', sep='.'):
    items = []
    for k, v in d.items():
        new_key = parent_key + sep + k if parent_key else k
        if isinstance(v, dict):
            items.extend(flatten_dict(v, new_key, sep=sep).items())
        else:
            items.append((new_key, v))
    return dict(items)

flattened_data = [flatten_dict(d) for d in data]

# 创建Pandas DataFrame
df = pd.DataFrame(flattened_data)

# 打印DataFrame
print(df)