How to Read Excel Files with Python (Pandas Tutorial)

Published: 04 September 2022
on channel: Dave Ebbelaar
56,895
727

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  


On this page of the site you can watch the video online How to Read Excel Files with Python (Pandas Tutorial) with a duration of 23 minute 23 second in good quality, which was uploaded by the user Dave Ebbelaar 04 September 2022, share the link with friends and acquaintances, this video has already been watched 56,895 times on youtube and it was liked by 727 viewers. Enjoy your viewing!