使用boto3将csv文件保存到s3
问题内容:
我正在尝试将CSV文件写入并保存到s3中的特定文件夹(存在)。这是我的代码:
from io import BytesIO
import pandas as pd
import boto3
s3 = boto3.resource('s3')
d = {'col1': [1, 2], 'col2': [3, 4]}
df = pd.DataFrame(data=d)
csv_buffer = BytesIO()
bucket = 'bucketName/folder/'
filename = "test3.csv"
df.to_csv(csv_buffer)
content = csv_buffer.getvalue()
def to_s3(bucket,filename,content):
s3.Object(bucket,filename).put(Body=content)
to_s3(bucket,filename,content)
这是我得到的错误:
Invalid bucket name "bucketName/folder/": Bucket name must match the regex "^[a-zA-Z0-9.\-_]{1,255}$"
我也尝试过:
bucket = bucketName/folder
和:
bucket = bucketName
key = folder/
s3.Object(bucket,key,filename).put(Body=content)
有什么建议?
问题答案:
这应该工作
def to_s3(bucket,filename, content):
client = boto3.client('s3')
k = "folder/subfolder"+filename
client.put_object(Bucket=bucket, Key=k, Body=content)