创建CSV文件，然后使用boto3附加到电子邮件

import csv

data = [
    ['Name', 'Age', 'City'],
    ['John', '25', 'New York'],
    ['Alice', '30', 'San Francisco'],
    ['Bob', '35', 'London']
]

filename = 'data.csv'

with open(filename, 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(data)

print('CSV file created successfully.')

import boto3
from botocore.exceptions import NoCredentialsError

def send_email(subject, body, recipient, attachment):
    SENDER = 'your_email@example.com'
    AWS_REGION = 'us-west-2'
    SUBJECT = subject
    BODY_TEXT = body
    CHARSET = 'UTF-8'

    client = boto3.client('ses', region_name=AWS_REGION)

    try:
        response = client.send_email(
            Destination={
                'ToAddresses': [
                    recipient,
                ],
            },
            Message={
                'Body': {
                    'Text': {
                        'Charset': CHARSET,
                        'Data': BODY_TEXT,
                    },
                },
                'Subject': {
                    'Charset': CHARSET,
                    'Data': SUBJECT,
                },
            },
            Source=SENDER,
            ReplyToAddresses=[
                SENDER,
            ],
            # 添加CSV文件附件
            Attachments=[
                {
                    'FileName': attachment,
                    'Data': open(attachment, 'rb').read(),
                    'ContentType': 'text/csv'
                },
            ]
        )
    except NoCredentialsError:
        print('Error: AWS credentials not found.')

# 调用send_email函数发送邮件
subject = 'CSV File Attached'
body = 'Please find the attached CSV file.'
recipient = 'recipient@example.com'
attachment = 'data.csv'

send_email(subject, body, recipient, attachment)