How to Read Excel Files with Python (Pandas Tutorial)
Dave Ebbelaar
@daveebbelaarAbout
Hi, I'm Dave, an AI engineer with over a decade of experience in artificial intelligence. At Datalumina, I lead the AI projects, where we're always pushing the boundaries of what's possible while still building reliable applications. I'm not going to impress you with theory, but teach you (without hype) how to build real AI systems, using lasting engineering principles. Along the way: - 10M+ views across YouTube, LinkedIn, and courses - Helped 1M+ developers get started with AI - Building and scaling a 7-figure AI company - Delivered 50+ custom B2B AI solutions - Consulted for TimescaleDB, ClickUp, and n8n - Helped 500+ developers launch freelance careers - BSc + MSc in Artificial Intelligence (VU Amsterdam) I post about AI engineering, building real systems, and what it takes to go independent as a developer. If you want to build AI that actually works, or build a freelance career around it, follow along 👊🏻
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
High-Performance Laptop Heatsink Compatible with 17 9700, RTX 2060 6GB, Precision 5750, Quadro RTX 3000 6GB - 0YC6P3 YC6P3 460.0JD02.0012
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
