将教师表中年龄大于30的教师信息导出C:\data\tt2.csv当中

将教师表中年龄大于30的教师信息导出C:\data\tt2.csv当中

import csv
import pymongo

# 连接 MongoDB 数据库
client = pymongo.MongoClient('mongodb://localhost:27017/')

# 选择数据库和集合
db = client['your_database']
col = db['teacher']

# 查询年龄大于 30 的教师信息
query = {'age': {'$gt': 30}}
result = col.find(query)

# 将查询结果写入 CSV 文件
with open('C:\\data\\tt2.csv', mode='w', newline='') as csv_file:
    writer = csv.writer(csv_file)
    writer.writerow(['Name', 'Age', 'Gender'])  # 写入标题行
    for teacher in result:
        writer.writerow([teacher['name'], teacher['age'], teacher['gender']])

print('导出成功！')

import pandas as pd

# 读取教师表数据
df_teachers = pd.read_excel('教师表.xlsx')

# 筛选年龄大于 30 的教师
df_result = df_teachers[df_teachers['年龄'] > 30]

# 将结果导出为 csv 文件
df_result.to_csv('C:/data/tt2.csv', index=False, encoding='utf-8')

print("符合条件的教师信息已成功导出到 C:/data/tt2.csv 文件中！")