How to Read Excel Files with Python (Pandas Tutorial)

Published: 04 September 2022
on channel: Dave Ebbelaar
33,400
452

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 Scienc...  

The Best Way to Organize Your Data Science Projects
   • Data Science Tutorial - Project Struc...  

Let's Connect
Instagram |   / daveebbelaar  
LinkedIn |   / daveebbelaar  
Twitter |   / daveebbelaar  


Watch video How to Read Excel Files with Python (Pandas Tutorial) online without registration, duration hours minute second in high quality. This video was added by user Dave Ebbelaar 04 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 33,400 once and liked it 452 people.