Upload DataFrame into S3 Bucket using python

Published: 27 September 2021
on channel: sumit kumar
3,736
45

##Code used in video####
import pandas as pd
import boto3
from io import StringIO

df=pd.read_csv("C:\\Users\\Arunima.Choubey\\Downloads\\annual_final0910.csv")

def upload_s3(df,i):
s3 = boto3.client("s3",aws_access_key_id="AKIATHOPBKF3Y5LTVKUX",aws_secret_access_key="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")
csv_buf = StringIO()
df.to_csv(csv_buf, header=True, index=False)
csv_buf.seek(0)
s3.put_object(Bucket="deltafrog-training-dev", Body=csv_buf.getvalue(), Key='client-data/external/'+i)


upload_s3(df,"test2.csv")

####
Ref Doc:-
https://docs.python.org/3/library/io....


On this page of the site you can watch the video online Upload DataFrame into S3 Bucket using python with a duration of hours minute second in good quality, which was uploaded by the user sumit kumar 27 September 2021, share the link with friends and acquaintances, this video has already been watched 3,736 times on youtube and it was liked by 45 viewers. Enjoy your viewing!