Python -将Pandas数据帧写入电子邮件正文

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

data = {'姓名': ['张三', '李四', '王五'],
        '年龄': [25, 30, 35],
        '城市': ['北京', '上海', '广州']}
df = pd.DataFrame(data)

html = df.to_html(index=False)

msg = MIMEMultipart()
msg['Subject'] = 'Pandas数据帧写入电子邮件正文示例'
msg['From'] = 'sender@example.com'
msg['To'] = 'recipient@example.com'

body = MIMEText(html, 'html')
msg.attach(body)

smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_username = 'your_username'
smtp_password = 'your_password'

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