Google Drive CSV file link to Pandas DataFrame

How to read in a csv file from Google Drive to a Pandas DataFrame:

url = ' google drive sharing link'
path = ''+url.split('/')[-2]
df = pd.read_csv(path)

Show DataFrame output on Streamlit app:


If you run into any issues, try making the CSV file link public on Google Drive. This could be a potential workaround for uploading large files.



Works great, any chance there is a way to upload files in a similar way (without google API), overwriting the file? I would like to read the file, append it and the save it back to google drive and still use the same URL.

Thanks in advance!