Pandas Ultimate Tutorial 2023 | Python Data Analysis

If you have any questions about the content, feel free to comment and I will respond :) Also, if you have any feedback on this video, please let me know in the comment section!

NAVIGATE THE CONTENT!
0:00 Introduction to Codealong
0:37 Download Anaconda
1:04 Open Jupyter Notebook
2:50 Import libraries
PART I
3:28 DataFrame vs. Series
6:19 Inspecting Data in Pandas
9:16 Selecting Columns in Pandas
15:01 Methods vs. Attributes
18:41 Intuition or Common Sense in Pandas
23:53 Method Chaining in Pandas
PART II
27:08 loc[] and iloc[] to locate data in a DataFrame
34:35 Filter with Conditional Logic using loc
46:27 isin()
49:25 between()
52:52 Negating a condition with ~
54:29 Tricky Exercise to see if you understood ;)
59:38 Most Useful Methods for Data Analysis
1:00:30 query()
1:02:10 unique() and nunique()
1:04:24 rename() and reset_index()
1:09:27 nlargest() and nsmallest() with visualization
1:15:00 save a visualization as image with transparent background
1:16:59 value_counts() with visualization
1:21:03 sort_values()
1:24:12 The Aggregation Functions
1:27:33 quantile()
1:28:23 agg()
1:29:22 cumsum() with area plot
1:38:25 apply()
1:45:45 corr() with a heatmap
1:48:06 mask upper part of heatmap
PART III
1:49:08 GroupBy, the most important thing!
1:56:44 Double Groupby
1:58:04 Double Groupby + unstack()
1:59:00 fixing legend in plot with get_level_values()
2:00:36 How to Pivot our Data
2:01:10 transpose() or T
2:01:38 pivot_table()
2:06:37 crosstab()
PART IV
2:19:44 Joining DataFrames with merge()

[nodcoding]

Here are the links to the dataset, until I can post them in the description:

[bondoasanidze]

This is the best Python Pandas tutorial on YouTube, thank you

[mistazed]

Just wanted to say thank you mate Been really helpful. I’d love your take on machine learning

[alecg]

I was just looking for a way to make a summary with Pandas functions and YouTube recommended your video. It's excellent!

[zahidhussainzd]

I highly suggest to youtube algorithm to promote/recommend this crash course on pandas to others. Thank you sir.

[tinashechaturuka]

I just started working on Pandas and for novices like me, this is the best tutorial. The confidence I have gained from practising along is just epic!!!

[LogicVertix]

Bro, you deserve more subscribers. Nice video! I've completed your tutorial.

[StefanoVerugi]

hands down the best video on pandas, if you are a beginner (or intermediate) look no further, truly the Ultimate in the title is not an overstatement
kudos to Mr. Nod 🙂 for this superb video

[rahulranjan]

Actually an ultimate video, most topics covered in one video

[isidroleonyork]

I have seen several pandas and data science tutorials.
Yours was the best one because of your clear explanation and variety of situations you presented to explain the features you wanted to present. Thank you very much! Super Excellent.

[ArchBrew]

Nice lecrure, thank you! I was able to understand several concepts which were not clear for me before. Pandas is really great stuff!

[viktorponomarev]

Thanks for your efforts.Great content! Wish your channel to grow.

[arturopastrana]

Thanks for sharing this content, I just learned many concepts that I thought I knew, I'm waiting for the bootcamp hopefully it's free. :)

[tommyhagvall]

Wow it was packed with good stuff - thanx !

[anantharjun]

The very good tutorial for pandas in youtube❣️✨love from India ...Keep rock I will support ..you made my day man🛐...The way you explain the groupby, crosstab, and unstack are very awesome...plz upload Numpy and Matplotlib also❣️💫I hope you will do

[imothar]

Good tutorial. A video for advanced users would be nice😊

[gamingwolf]

I swear to GOD, i was struggling since 1 year to clear my basic concepts, after watching your video, i am confident. thankyou very much for creating such wonderful stuff. I want to join boo camp, can you please share the more details.

[rahulranjan]

similar video on matplotlib and seaborn? Starting from scratch!

[analyticseveryday]

your videos are really amazing, when do you plan to upload the next and which topic

[piesgaming]

bro video in nice but i have a questions that i'm learning python so how i can become master at python and what mistake i can make in this journey