Learn Pandas in Under 3 Hours | Filtering, Joins, Indexing, Data Cleaning, Visualizations

____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:30 Reading in Files
19:03 Filtering and Ordering
30:30 Indexing
41:33 Group By and Aggregating
52:12 Merge, Join, and Concatenate
1:13:29 Visualizations
1:29:45 Data Cleaning
2:07:53 Exploratory Data Visualization
2:39:30 Outro

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[filminsightful]

Man....the quality you are providing free of any penny, is amazing. Salute to your contribution to community man

[alexrosen]

Thanks! If this tutorial is half of the quality compared to the latest SQL tutorial, then it is really worth watching 👌

[nilosamson]

so excited for this. I'm going to kill my procrastination and i will finish this :) thank you Alex.

[xtravengersgaming]

you sir are a GEM !! thank you so much

[AndrewT]

@2:02:39 I believe it is best practice to avoid using for loops since the pandas operations are built on numpy and are vectorized. You can do something like df.loc[df['Do_Not_Contact'] != 'Y'] to filter out the y's and then set that whole column to N with df['Do_Not_Contact'] = 'N'

[AndrewT]

For merge, I use left_on and right_on when the columns that I am merging on have different names in the two tables.

[hwchannel]

Thanks for the knowledge sharing sir. Since when I started watching your JavaScript tutorial, it was understandable and clear.

[AlexAlex-eizf]

Спасибо Вам огромное! Вот это действительно очень полезный урок!

[NostraDavid]

Now do it again, but for Polars - the superior dataframe library! It's WAY faster, can handle WAY more data, uses WAY less memory, the API is MUCH cleaner (i.e. more readable) and I truly believe it's the future of dataframe libraries.

I say that after using Pandas for 2 years, and Polars for 2 months. No more abusing the index, when you really just want to do a group_by.

[mulikinatisiddarthasiddu]

Alex do you added any new topics in this video or is it same as the one in the bootcamp ? @Alex

[yaqubnaqiyev]

we need matplotib, seaborn that are used only in data analyst, can you do that

[danielnjeru]

I downloaded this zip file from GitHub but when I copy the path in python it is returning a not found error, How do I do it?

[AA-kqon]

hi
is that work in notebook in Microsoft Fabric ???

[FromPlanetZX]

Hi All, I need help for th GroupBy section. I'm getting error while applying aggregator on group_by_frame.

group_by_frame = df.groupby('Base Flavor') --> run succesfully

group_by_frame.mean() --> gave error

TypeError: Could not convert ChocolateRocky RoadChocolte Fudge Brownie to numeric

[dark_legions]

Hey thank you for making the best content

[dark_legions]

Make a video where you fetch data of the Olympic 2024 medalists using web scraping and display it on the frontend using Flask or Streamlit, with a feature for filtering as well. This project will give many ideas, and there isn't a video like this on YouTube.

[Anurag]

Hello Alex. This line is not working **fl.groupby('Base Flavor').mean()**.
I see error TypeError: agg function failed [how->mean, dtype->object]. But it is working on your jupyter?

[xtravengersgaming]

2:03:30

This will work for making 'NNN' to 'N'

').replace(' ', 'N')