/Python/Boto3 read excel file from s3 into pandas

Boto3 read excel file from s3 into pandas

import io
import pandas as pd

s3 = boto3.client('s3')
obj = s3.get_object(Bucket='bucket_name', Key='key_name')
df = pd.read_excel(io.BytesIO(obj['Body'].read()))

Similar codes

0 vote194 views1 answer
Get derivative of interp1d
Python
3 votes235 views1 answer
Flask upload
Python Flask
0 vote269 views1 answer
Using rstrip() method to remove the newline character from a string
Python
20 votes204 views3 answers
String to float python
Python
0 vote182 views1 answer
Python printing hello world
Python
2 votes191 views1 answer
How to move your cursor using python
Python
0 vote249 views1 answer
Pyplot rectangle over image
Python
0 vote272 views1 answer
Subtract constant from list
Python
7 votes200 views2 answers
Python concatenate list of lists
Python
1 vote201 views1 answer
A list inside a list python
Python