使用特定字段时分发报告

import smtplib
from email.message import EmailMessage
import pandas as pd

# 假设我们有一个DataFrame df，其中包含要报告的数据
df = pd.read_csv('data.csv')

# 根据特定字段（如'category'）筛选数据
filtered_df = df[df['category'] == 'important']

# 生成报告（这里简单地转换为CSV格式）
report_filename = 'report.csv'
filtered_df.to_csv(report_filename, index=False)

# 发送报告
msg = EmailMessage()
msg.set_content(f'Please find the attached report.\n\nRegards,\nYour Name')
msg['Subject'] = 'Important Report'
msg['From'] = 'your_email@example.com'
msg['To'] = 'recipient_email@example.com'

with open(report_filename, 'rb') as f:
    file_data = f.read()
    file_name = f.name
msg.get_payload()[0].add_related(file_data, 'application/octet-stream', cid=file_name)

with smtplib.SMTP('smtp.example.com') as server:
    server.login('your_email@example.com', 'your_password')
    server.send_message(msg)