How to learn to unify Google Sheets, Excel, and CSV files – a code-along guide. By Fabian Bosler.
Python is often called a glue language. This is due to the fact that a plethora of interface libraries and features have been developed over time — driven by its widespread usage and an amazing, extensive open-source community. Those libraries and features give straightforward access to different file formats, but also data sources (databases, webpages, and APIs).
This story focuses on the extraction part of the data. Next week’s story will then dive a little deeper into analyzing the combined data to derive meaningful and exciting insights.
What you will learn:
- Extracting data from Google Sheets
- Extracting data from CSV files
- Extracting data from Excel files
As this article is intended as a code-along article, you should have your development environment (recommended: Jupyter Notebook/Lab) set up and start a new Notebook. You can find the source code and files in provided GitHub repository. Great resource!
[Read More]