Python

Search

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

Comment

PREVIOUS	NEXT

Code Example
Python :: show all urls django extensions
Python :: assign python
Python :: how to determine python project parent dir
Python :: find common values in different dataframes pandas
Python :: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable
Python :: get sum from x to y in python
Python :: subsetting based on column value with list
Python :: convert string to integer in dictionary python
Python :: select 2 cols from dataframe python pandas
Python :: shutil move file
Python :: reverse key order dict python
Python :: Read text file line by line using the readline() function
Python :: shebang python
Python :: how to create a tuple from csv python
Python :: python series get value
Python :: convert dict to string python
Python :: opencv erosion
Python :: pyhton mahalanobis distance
Python :: check where bool in a list python
Python :: slicing string in python
Python :: show multiple plots python
Python :: how to add two numbers in python
Python :: pandas distinct
Python :: import time in python
Python :: python webbrowser close tab
Python :: creating data frame in python with for loop
Python :: pandas delete column by name
Python :: dataframe delete duplicate rows with same column value
Python :: tensorflow_version
Python :: get tail of dataframe pandas

Search

PYTHON

boto3 read excel file from s3 into pandas

ADD CONTENT