How to Read Excel Files with Python (Pandas Tutorial)
ฝัง
- เผยแพร่เมื่อ 18 ส.ค. 2024
- 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
amazing video, this was like an introduction to data analysis in a very short video, cheers
Good video Dave. Let's keep it up :)
Could you upload statistical analysis exclusively through python
How Dave is seeing individual variable values.. ex he selects 'data' and we can see the values at right side pane.
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?
Check out this video: th-cam.com/video/3sIzCFuLgIQ/w-d-xo.html
@@daveebbelaar thanks!
Yes, in my experience, XLSX files do not play perfectly nice with Pandas, whereas CSV files never posed a problem.
How are you inserting the comment blocks?
# -----
#
# -----
Hey Matthew, I am using VS Code snippets for that. Check it out here → th-cam.com/video/ZaH7nEzgX7o/w-d-xo.html
And here's the code:
"Create code block header": {
"prefix": "#",
"body": [
"# --------------------------------------------------------------",
"# $1",
"# --------------------------------------------------------------",
],
"scope": "python"
},
@@daveebbelaar Thanks, you're the man!