Google Sheets is a common alternative to Microsoft Excel and is especially useful if you wish to work collaboratively on your spreadsheet or share your data. I want to quickly share two ways of reading Google Sheets data into a pandas DataFrame through the .read_csv()  method without having to safe the sheet locally first or having to use the GoogleAPI.

#data #google-sheets #python #data-science #pandas

Read Data From Google Sheets into Pandas without The Google Sheets API
1.90 GEEK