How to copy csv file from Amazon S3 bucket

Question

I was trying reading a .csv file from Amazon S3 bucket. This was the code i was using.

library(aws.s3) Sys.setenv("AWS_ACCESS_KEY_ID" = "Key src","AWS_SECRET_ACCESS_KEY" = "Key dest") df <-get_object("s3://dataset/Data.csv") obj <- rawToChar(df) con <- textConnection(obj) claim<- read.csv2(con)

Is there any other method for doing so?

Answer 1

Boto3 is the library to use for AWS interactions with python. The docs are not bad at all and the api is intuitive. The details of the process can be found in the link below. This was the most efficient method i knew! Hope this helps. . .

http://anthonyfox.io/2017/07/how-i-used-python-and-boto3-to-modify-csvs-in-aws-s3/