When you are working on a Data Science or Analytics project there are usually a ton of spreadsheets stored everywhere.
If you are like us, you probably do something like this:
Download your Google Sheet as a spreadsheet
Download your Dropbox spreadsheet
Put them all in the same folder as your Desktop Files
Use Pandas to read all the files
Which is an okay workflow. But then Steve in Marketing goes and changes some data in the Google Sheet.
“No worries”, you reply back as you re-download the Sheet and re-run your workflow.
And now Kamala in HR has added two more spreadsheets to Dropbox.
“I got it”, you say while slowly using your cool.
And then your boss tells you to email her all your spreadsheets so she can triple check your data. “Oh, and by the way”, she says, “don’t forget to change all the spreadsheets names using the style our VP is pushing for”

#google-sheets #python #spreadsheets #programming #data-science