boto3 read excel file from s3 into pandas code example

Example: 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()))