In this video, I will show you how to read Excel files with Python and the Pandas library in particular. I will first quickly show the basics and then cover some more advanced tips.
Timestamps
00:00 Introduction & Overview
00:33 Requirements
01:48 Additional information and tips
02:08 Dataset
02:58 Read single Excel file
05:23 Practical Tips
12:25 Reading multiple Excel Files
Link to project
https://github.com/daveebbelaar/panda...
Requirements
Python — https://www.python.org/downloads/
Pandas — pip install pandas
Openpyxl — pip install openpyxl
Installing packages with pip
https://packaging.python.org/en/lates...
How to Set up VS Code for Data Science
• How to Set up VS Code for Data Science & AI
The Best Way to Organize Your Data Science Projects
• Data Science Tutorial - Project Structure
Let's Connect
Instagram | / daveebbelaar
LinkedIn | / daveebbelaar
Twitter | / daveebbelaar