How to Read Excel Files with Python (Pandas Tutorial)
Dave Ebbelaar
View ChannelAbout
Hi! I’m Dave, an AI Engineer and founder of Datalumina®. On this channel, I share practical tutorials that show developers how to build production-ready AI systems. My goal is to cut through the hype and avoid unnecessary complexity, focusing instead on engineering principles that actually last. I also help developers kick-start their freelance careers. Check out the links below to learn more!
Latest Posts
Video Description
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/pandas-tutorials Requirements - Python — https://www.python.org/downloads/ - Pandas — pip install pandas - Openpyxl — pip install openpyxl Installing packages with pip - https://packaging.python.org/en/latest/tutorials/installing-packages/ How to Set up VS Code for Data Science - https://youtu.be/zulGMYg0v6U The Best Way to Organize Your Data Science Projects - https://youtu.be/MaIfDPuSlw8 Let's Connect - Instagram | https://instagram.com/daveebbelaar - LinkedIn | https://linkedin.com/in/daveebbelaar - Twitter | https://twitter.com/daveebbelaar
Data Analysis Power-Ups
AI-recommended products based on this video
Laplink PCmover Ultimate 11 - Migration of your Applications, Files and Settings from an Old PC to a New PC - Data Transfer Software - With Optional High Speed Ethernet Cable - 1 License
