Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)

Maaaaan, I sincerely can't thank you enough! this was so helpful

I'm surprised Nintendo didn't already take this down.

Thank you sir

Dude already won my heart when he used the pokemon dataset😍

I Hate Pandas : (

Thank you so much brother ❤ I finally understood it properly 😊

verry good lesson

I have a doubt what # represents and why there is 3 repeated? if anyone can help.

how can i change object data type to other data type (.i.e. int )

How did you import the csv? and how can i do that in visual studio code?

Greg from Succession

thanks for this valuable content

A video on machine learning

U have saved my entire recess semester

thanks man this was good

if u have error in groupby try this
df.groupby(['Type 1']).mean(numeric_only=True)

Take you flowers💐💐💐💐

Really great, I tried all the examples you discussed, but I am getting agg funcion failed wih the 'mean' df1.groupby(['Total']).mean().sort_vallues('Attack', ascending=False), thx

i haven't watched pokemon cartoon for years lol it was quite nostalgic to learn via all the things i learned in my childhood

this is really helpful i have bad English but i could understand everything thank you Galli (btw chat GBT recommended you to me 😂)

On working with large amounts of data, I keep getting an error message ( 'read_excel() got an unexpected keyword argument 'chunksize''). Could you please help me figure out where I went wrong. Also, I was working with the excel data frame df_xlsx.

You are awesome man. Thank you!

What's in the 'Swag' bookmark folder?

so is no one gonna talk about how he does not know about mega evolutions

I think taking the Pokémon data set makes this tutorial so much fun. Loved it.

This one video is all I needed to learn everything I needed for pandas. This is perfect. Thank you!

The way ur teaching it like sipping a wine 😜🍷 so easy. Thank you so much for making kifeeasier withur thoughts and Bro literally ur teaching is. Way awesome keep rocking!!!
All love from India😍(Hyderabad)

A fellow man of culture I see. Funny enough as I was multi-tasking through Python tutorial videos while playing x2 Switch SwSh pokemon. I'm nearly at the end of your tutorial video and so far, good job on this. Keep it up!

Better than my professor tough in entire semester

Keith you're the best.
This is one of the best videos on pandas.

Thanks Keith for this video! I'm new on data science I'm using your videos to practice and learn a lot more. Really thanks!

It is still very helpful... straight to the point, many thanks

On the final steps I get the error - agg function failed (using groupby). What might it be?

Man, I have a comment here, to execute what you're doing in the part of groupby, it was necessary to do this: numeric_columns = df.select_dtypes(include='number')
result = numeric_columns.groupby(df['Type 1']).mean()
result
The TypeError indicate that was not longer available the type of operations that you were doing in the video, hope this helps anyone!

Hi Keith, can you check this out and pin @_Nelyen 's comment.

Instead of writing: df.groupby(["Type 1"]).mean()
Try writing: df.groupby(["Type 1"]).mean(numeric_only=True)

The last part was not clear like the rest about the new data frame storing the count..

Loved the video, inspired to try, but no matter what I do I cannot get files to upload.

Hey, nice video Keith! Just a small suggestion, could you please move your face frame at the top right of the screen with a smaller size or completely remove it so it doesn't block the code?

thx for tutorial

If you're getting an error in the Groupby section try: df.groupby('Type 1').mean(numeric_only = True).sort_values('Defense', ascending=False)

Added "numeric_only = True" inside of ".mean()" and it worked 👍

Hi Keith, how do you shortcut to comment out multiple lines by highlighting?? thanks :)