以下是一个使用 Python 根据 DataFrame 数据内容构建邮件收件人、主题、附件名等信息并发送邮件的示例代码。假设 DataFrame 中包含收件人邮箱、邮件主题、附件名等信息，并且邮件内容可以根据需求自定义。 ```python import pandas as pd from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.mime.application import MIMEApplication import smtplib def send_email(sender_email, sender_password, receiver_email, subject, body, attachment_path=None): msg = MIMEMultipart() msg["From"] = sender_email msg["To"] = receiver_email msg["Subject"] = subject msg.attach(MIMEText(body, "plain")) if attachment_path: with open(attachment_path, "rb") as file: part = MIMEApplication(file.read(), Name=attachment_path.split("/")[-1]) part['Content-Disposition'] = f'attachment; filename="{attachment_path.split("/")[-1]}"' msg.attach(part) server = smtplib.SMTP('smtp.example.com', 587) server.starttls() server.login(sender_email, sender_password) text = msg.as_string() server.sendmail(sender_email, receiver_email, text) server.quit() # 示例 DataFrame data = { 'recipient_email': ['recipient1@example.com', 'recipient2@example.com'], 'subject': ['Subject 1', 'Subject 2'], 'attachment_name': ['attachment1.txt', 'attachment2.txt'] } df = pd.DataFrame(data) sender_email = "your_email@example.com" sender_password = "your_email_password" for index, row in df.iterrows(): receiver_email = row['recipient_email'] subject = row['subject'] body = "This is the email body." attachment_path = row['attachment_name'] send_email(sender_email, sender_password, receiver_email, subject, body, attachment_path) ``` ### 代码解释 1. **`send_email` 函数**：该函数用于发送邮件，接收发件人邮箱、发件人密码、收件人邮箱、邮件主题、邮件正文和附件路径作为参数。函数内部构建邮件对象，添加正文和附件，连接 SMTP 服务器并发送邮件。 2. **示例 DataFrame**：创建一个包含收件人邮箱、邮件主题和附件名的 DataFrame。 3. **遍历 DataFrame**：使用 `iterrows` 方法遍历 DataFrame 中的每一行，获取收件人邮箱、邮件主题、附件名等信息，并调用 `send_email` 函数发送邮件。 ###