在 Python 中，可以根据 `DataFrame` 数据内容构建邮件收件人、主题、附件名等信息，并使用 `asyncio` 实现异步发送邮件。以下是一个示例代码，使用 `pandas` 处理 `DataFrame`，`yagmail` 发送邮件： ```python import pandas as pd import yagmail import asyncio async def send_email_async(sender_email, password, recipient, subject, contents, attachment=None): yag = yagmail.SMTP(sender_email, password) yag.send(to=recipient, subject=subject, contents=contents, attachments=attachment) yag.close() def build_email_info(df): # 假设 DataFrame 中有 'recipient', 'subject', 'attachment_name' 列 recipient = df['recipient'].tolist() subject = df['subject'].tolist() attachment_name = df['attachment_name'].tolist() return recipient, subject, attachment_name async def main(): # 示例 DataFrame data = { 'recipient': ['recipient1@example.com', 'recipient2@example.com'], 'subject': ['邮件主题1', '邮件主题2'], 'attachment_name': ['attachment1.pdf', 'attachment2.pdf'] } df = pd.DataFrame(data) sender_email = 'your_email@example.com' password = 'your_email_password' recipients, subjects, attachment_names = build_email_info(df) tasks = [] for recipient, subject, attachment_name in zip(recipients, subjects, attachment_names): contents = f"这是关于 {subject} 的邮件内容。" task = asyncio.create_task(send_email_async(sender_email, password, recipient, subject, contents, attachment_name)) tasks.append(task) await asyncio.gather(*tasks) if __name__ == "__main__": asyncio.run(main()) ``` ### 代码解释 1. **`build_email_info` 函数**：从 `DataFrame` 中提取收件人、主题和附件名信息。 2. **`send_email_async` 函数**：异步发送邮件，使用 `yagmail` 库。 3. **`main` 函数**：创建 `DataFrame`，构建邮件信息，创建异步任务并执行。