/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

3 votes309 views2 answers
Split by tab python
Python
0 vote331 views1 answer
Qiskit setup
Python
12 votes347 views5 answers
Turtle write
Python
1 vote343 views1 answer
Conda python 3.8
Python
4 votes338 views3 answers
Iterate python
Python
0 vote340 views1 answer
Read file from s3 python
Python
0 vote327 views1 answer
Python collections Counter sort by key
Python
2 votes333 views1 answer
How to append element python
Python
0 vote357 views1 answer
Discard method in python
Python
3 votes342 views1 answer
Python plot cut off when saving figure
Python