Read Excel Files with Python & Pandas πŸ“Š

Learn how to read Excel files using Python and Pandas, covering basics and essential techniques in this tutorial.

Read Excel Files with Python & Pandas πŸ“Š
Dave Ebbelaar
52.1K views β€’ Sep 4, 2022
Read Excel Files with Python & Pandas πŸ“Š

About this video

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

Tags and Topics

Browse our collection to discover more content in these categories.

Video Information

Views

52.1K

Likes

662

Duration

23:23

Published

Sep 4, 2022

User Reviews

4.5
(10)
Rate:

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.

Trending Now