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
- github.com/dav...
Requirements
- Python - www.python.org...
- Pandas - pip install pandas
- Openpyxl - pip install openpyxl
Installing packages with pip
- packaging.pyth...
How to Set up VS Code for Data Science
- • How to Set up VS Code ...
The Best Way to Organize Your Data Science Projects
- • Data Science Tutorial ...
Let's Connect
- Instagram | / daveebbelaar
- LinkedIn | / daveebbelaar
- Twitter | / daveebbelaar

[@Claudio-gv2lz]

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 :)

[@Planning_Statistics]

Could you upload statistical analysis exclusively through python

[@AarJay8587]

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

[@bin4ry_d3struct0r]

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

[@tiborszekeres5798]

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?

[@daveebbelaar]

Check out this video: kzbin.info/www/bejne/aaSsq3Z8qrGaf7M

[@tiborszekeres5798]

@@daveebbelaar thanks!

[@matthewdaunis]

How are you inserting the comment blocks? # ----- # # -----

[@daveebbelaar]

Hey Matthew, I am using VS Code snippets for that. Check it out here → kzbin.info/www/bejne/kJKraKF7r8yLbdE

[@daveebbelaar]

And here's the code: "Create code block header": { "prefix": "#", "body": [ "# --------------------------------------------------------------", "# $1", "# --------------------------------------------------------------", ], "scope": "python" },

[@matthewdaunis]

@@daveebbelaar Thanks, you're the man!