How to Read Excel Files with Python (Pandas Tutorial)

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

Requirements
- Pandas — pip install pandas
- Openpyxl — pip install openpyxl

Installing packages with pip

How to Set up VS Code for Data Science

The Best Way to Organize Your Data Science Projects

Let's Connect

[Claudio-gvlz]

amazing video, this was like an introduction to data analysis in a very short video, cheers

[SorianoTech]

Good video Dave. Let's keep it up :)

[binry_dstructr]

Yes, in my experience, XLSX files do not play perfectly nice with Pandas, whereas CSV files never posed a problem.

[AarJay]

How Dave is seeing individual variable values.. ex he selects 'data' and we can see the values at right side pane.

[tiborszekeres]

hello
sorry for my dumb question but I would like to know how did you managed that in your right panel in your VSCode the actual python code is running?

[matthewdaunis]

How are you inserting the comment blocks?
#
#
#