/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

-1 vote387 views1 answer
How to delete django superuser
Python Django
0 vote298 views1 answer
Gematria python
Python
14 votes300 views6 answers
Python if condition
Python
0 vote323 views1 answer
How to read file again in python
Python
5 votes289 views1 answer
Fetch row where column is equal to a value pandas
Python
1 vote315 views1 answer
Django model choice field from another model
Python
0 vote296 views1 answer
Skip error python
Python
11 votes293 views2 answers
Regression python
Python
1 vote294 views2 answers
Copy string python
Python
2 votes410 views4 answers
Min and max in python
Python