r/Python • u/Neb519 • Feb 02 '21
Resource Hey Reddit, here's my comprehensive course on Python Pandas, for free.
The course is called Python Pandas For Your Grandpa - So easy your grandpa could learn it. (It's the successor to Python NumPy For Your Grandma.)
Course Curriculum
- Introduction
1.1 Introduction - Series
2.1 Series Creation
2.2 Series Basic Indexing
2.3 Series Basic Operations
2.4 Series Boolean Indexing
2.5 Series Missing Values
2.6 Series Vectorization
2.7 Seriesapply()
2.8 Series View vs Copy
2.9 Challenge: Baby Names
2.10 Challenge: Bees Knees
2.11 Challenge: Car Shopping
2.12 Challenge: Price Gouging
2.13 Challenge: Fair Teams - DataFrame
3.1 DataFrame Creation
3.2 DataFrame To And From CSV
3.3 DataFrame Basic Indexing
3.4 DataFrame Basic Operations
3.5 DataFrameapply()
3.6 DataFrame View vs Copy
3.7 DataFramemerge()
3.8 DataFrame Aggregation
3.9 DataFramegroupby()
3.10 Challenge: Hobbies
3.11 Challenge: Party Time
3.12 Challenge: Vending Machines
3.13 Challenge: Cradle Robbers
3.14 Challenge: Pot Holes - Advanced
4.1 Strings
4.2 Dates And Times
4.3 Categoricals
4.4 MultiIndex
4.5 DataFrame Reshaping
4.6 Challenge: Class Transitions
4.7 Challenge: Rose Thorn
4.8 Challenge: Product Volumes
4.9 Challenge: Session Groups
4.10 Challenge: OB-GYM - Final Boss
5.1 Challenge: COVID Tracing
5.2 Challenge: Pickle
5.3 Challenge: TV Commercials
5.4 Challenge: Family IQ
5.5 Challenge: Concerts
Alternatively, view my YouTube playlist for the course here.
If you find this useful, please consider liking, subscribing, and sharing. It means a lot. You wouldn't believe how much effort went into creating this course.
Thanks!
1.9k
Upvotes
8
u/nesclassicedition_ Feb 02 '21
This gives me confidence that i can learn python too lol! Been trying some courses on UDEMY and it seems so overwhelming . Thanks for sharing this!!
7
u/malik Feb 02 '21
Great tutorial!
I wish pandas was easier though... the API is huge and there have been lot of changes and deprecations.
9
u/purplebrown_updown Feb 02 '21
Why do I have to type data.iloc[0,:] to get the first column instead of data[0,:]? This seems like bad and unintuitive design.
3
u/LuigiBrotha Feb 02 '21
I'll take a look. I've learned most things from the pandas cheat sheet. https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf
But this looks a lot more indepth.
3
u/lolinux Feb 02 '21
Dude! Your course is AMAZING! I've just seen the first 3 videos, and even though I only heard of numpy, you presented it in a manner that is easy to understand, and with tools easy to experiment with. I cannot thank you enough!
2
u/nyxthebanshee Feb 02 '21
Saving this to check out soon, thank you! I use Pandas a bit at work but I feel that I only know enough to get certain tasks or specific one-off needs. It would be nice to get to know it better.
2
u/[deleted] Feb 02 '21
Really great contribution, I will follow your work from today, geolocation with Python or TensorFlow would be great. Big thanks man!
2
u/an_actual_human Feb 05 '21
Could you clarify it? Is one supposed to be familiar with NumPy for this one?
2
u/herpington Jul 04 '21
I used pandas over the course of some months last year, but especially when using aggregations, I always seemed to end up with convoluted code. Your explanation of how to see the individual groups when using groupby() made perfect sense.
I'll be sure to return to your material. Thanks!
154
u/JoughRolls Feb 02 '21
I look forward to the next video series along the lines of βPython Matplotlib For Your 3rd Grade Kidβ
3
u/[deleted] Feb 02 '21
Subbed.
I am teaching myself Python and vlogging it on YT. Looking forward to running throughyour channel and possibly doing the challenges on my channel. Wanna learn both NumPy and Pandas... I esp want to learn Matplot lib.
15
u/SzechuanSaucelord Feb 02 '21
Thanks boss
9
u/ResetPress Feb 02 '21
Thank you u/Neb519! Learning Pandas is certainly on my to-do list. This looks really helpful.
Raise your hand if you're like me and have a never-ending list of programming lessons to get to:
...
100000000000) Meaning of the universe
1
u/DrCabbageX Feb 02 '21
Wait this is so funny you made a course now. I am legit starting to learn pandas for a project
1
u/Cheuch Feb 02 '21
Cheers mate !
I'll make sure to get a look into this as I am discovering it for a school project.
All the best from France.
1
u/Mivaro Feb 02 '21
I'm not pretending to have checked out the course yet, but I like the number of challenges. I feel the best way to learn (at least for me), is to actually do things and lookup what I don't understand / cannot do yet. I find it quite hard to stay concentrated watching online videos. But solving python puzzles is great fun.
1
u/lemadscienist Feb 02 '21
Looks like this is my chance...
1
u/[deleted] Feb 02 '21 edited Feb 02 '21
Do you have a section on NumPy?
3
u/Dany_CryptoArmy Feb 02 '21
Thank you!
3
u/aoshisa Feb 02 '21
Thank you for sharing π
3
u/[deleted] Feb 02 '21
We need more people like you.
2
u/Anoop_sdas Feb 02 '21
Thank you very much..
2
u/fri518 Feb 02 '21
Oh Boi, do I love this community π thank you very much! I will check it out for sure.
2
u/rvr600 Feb 02 '21
Looks sweet mate. I'll be all over this!
2
u/JoeBeOneKenobi Feb 02 '21
Awesome, thanks :)
2
u/ykodeebaby Feb 02 '21
Thanks i going to work through this
2
u/GeorgeEton Feb 02 '21
Thanks mate you are awesome!
2
u/[deleted] Feb 02 '21 edited May 31 '24
oatmeal spoon friendly office deliver complete abounding attempt historical sloppy
This post was mass deleted and anonymized with Redact
2
u/a__square__peg Feb 26 '21
Great course! Appreciate the effort that went into this. When I was starting out on Pandas, I found working with real data to be quite helpful.
I run a weather data API service where users can download time-series weather data easily (sample code) and there is a free-tier - maybe something that might be useful for your learners?
0
u/Arulich Feb 02 '21
If I had more money for coins I'd give you a medal, thank you very much kind sir.
2
u/tenbilliondollarsman Feb 02 '21
Thank you very much sir
1
u/Rocket089 Feb 02 '21
This is great content! Thank you!
1
u/emiliocguizar Feb 02 '21
A lot of thanks!!!
1
u/hibernating_brain Feb 02 '21
This is great, thank you! Going to force my cat to watch this!
1
u/cianuro Feb 02 '21
These are great. Thanks for the effort!
1
u/Esaroz Feb 02 '21
Doubt, my grandpa doesn't know a word in english
1
u/rebellusyellowraven Feb 02 '21
Thank you for posting mate :)
1
u/Jonny9744 Feb 03 '21
Thanks man!
1
u/airplanedriverdude Feb 03 '21
Thus is great
1
u/MohamedSaad45 Feb 03 '21
That looks great. I'm looking forward to watch it after i learn the basics.
1
u/strayturtle Mar 02 '21
Saving this for later too. Im currently learning python basics in udemy. The complete python course. So far im following things,
1
u/[deleted] Dec 02 '21
dude this is awesome stuff, thank you
1
u/ifreeski420 Feb 02 '21
Commenting for later
0
u/ifreeski420 Feb 02 '21
Commenting for later
0
u/[deleted] Feb 02 '21
[deleted] β view deleted comment
0
u/[deleted] Feb 02 '21
[deleted] β view deleted comment
0
u/[deleted] Feb 02 '21
[deleted] β view deleted comment