尝试将多个pandas数据帧写入电子邮件并发送

import pandas as pd
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication

df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df2 = pd.DataFrame({'C': [7, 8, 9], 'D': [10, 11, 12]})

html1 = df1.to_html(index=False)
html2 = df2.to_html(index=False)

msg = MIMEMultipart()
msg['From'] = 'sender@example.com'
msg['To'] = 'recipient@example.com'
msg['Subject'] = 'Multiple Pandas DataFrames'

msg.attach(MIMEText(html1, 'html'))
msg.attach(MIMEText(html2, 'html'))

df1.to_csv('df1.csv', index=False)
df2.to_csv('df2.csv', index=False)

with open('df1.csv', 'rb') as file:
    attachment1 = MIMEApplication(file.read(), Name='df1.csv')
    attachment1['Content-Disposition'] = 'attachment; filename="df1.csv"'
    msg.attach(attachment1)

with open('df2.csv', 'rb') as file:
    attachment2 = MIMEApplication(file.read(), Name='df2.csv')
    attachment2['Content-Disposition'] = 'attachment; filename="df2.csv"'
    msg.attach(attachment2)

smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_username = 'username'
smtp_password = 'password'

with smtplib.SMTP(smtp_server, smtp_port) as server:
    server.starttls()
    server.login(smtp_username, smtp_password)
    server.send_message(msg)