How to use the Pandas GroupBy function | Pandas tutorial

[@misraturp]

👉 All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) misraturp.gumroad.com/l/pandascs

[@aayushk.c.2081]

Wow! I haven't even finished watching your entire video, and I'm already getting goosebumps from the wealth of knowledge it contains. I will definitely be checking out all of your videos on pandas.

[@misraturp]

Wow, thank you! Glad you enjoyed it!

[@suhaibmudassir3272]

I found someone successfully who actually I can understand ❤

[@message59]

your videos saved me 😅 so I just wanted to thank you for the effort and say that you have great way of explaining things :)

[@davideschreiber2821]

Very nice. So thorough that I began to worry it would get confusing, but by the end I think I had a good grasp on the topic. Thanks!

[@himanshupandey9902]

Hello misra, Your really made pandas library so easy to learn. I always wait to get your notification because you simplify everything.

[@misraturp]

Thank you Himanshu, that’s so nice to hear :)

[@MohamedKhasim16]

Really learned more from this video and exceptionally clear, truly a valuable resource! Thank you and keep up the amazing work! 🙌🏼

[@invictus327]

Misra, your ability to convey what might otherwise be impenetrable concepts is really very good. I know it's a lot of work and effort/time but I can see you making a successful additional income stream out of Udemy or similar. I've seen a lot of this kind of education in the last couple of years and you really have the perfect blend of articulation and authenticity. Keep up the good work. ✌😉

[@misraturp]

Thank you Even Horizon! That's amazing to hear. :)

[@bay-bicerdover]

Keep up the good work!

[@islamalmsarrhad2152]

Actually I'm really happy, finding talented people to learn from and following their footprints makes my happy and comfortable. Thank you so much and keep going>>>>

[@misraturp]

Thank you Islam!

[@programmingchannel9739]

I love all of your work. You save me a lot of time reading, searching, and figuring out what to do.

[@misraturp]

That's amazing to hear, thank you!

[@catalindemergian2973]

this pandas series was great! thank you

[@misraturp]

Awesome to hear, you're welcome!

[@FelipeCampelo0]

This makes clear what the kaggle intro to pandas could not.

[@ayanchoubisa2462]

Your method of explaining is excellent. Greetings, you'll grow a lot.

[@misraturp]

Thank you very much!

[@khanhhoanggiabao6240]

Helpful video. Thank you

[@Latif127]

Very informative, thank you.

[@inkdfist3702]

Great explanation, just what I was looking for, thank you so much!

[@misraturp]

Glad it was helpful!

[@aldalail]

That's been helpful, Thank you !!

[@behradio]

Amazing as always. These types of videos can be so helpful. I improved the performance of my code from your latest videos; thanks a lot.

[@misraturp]

That's great Behrad! Thank you!

[@MrMH0]

Thank you very much for the explanation of the Grouper function, I think that can help me a lot. :) Greetings from Germany.

[@misraturp]

Glad it was helpful!

[@bay-bicerdover]

hows weather in germany?

[@j3553hh]

Nice angle on this. Thank you.

[@szw21]

Hi Misra! You explain everything with such a simple language, thank you ❤ But as a newbie i don't fully get the Grouper. When you put freq=2W why it didn't add 9th jan in the first group? If we open the calendar, 1st jan in 2000 was a saturday, every date in dataset is sundays. First two calendar weeks included 2nd and 9th if jan, first 14 days include the same, so i don't get how Grouper put the separation 😥

[@anurajms]

thank you. video is really useful

[@swapnilpalsapure9781]

Great Teaching

[@MaxMustermann-on2gd]

Loved the scuba diving hint 🤣 are you a diver? Great explanation!

[@misraturp]

Heheh thanks! Yes, I'm a diver :)

[@CEOLISSS]

How do you know when to use .agg() and .apply() ? Is .agg() used for built in functions such as max, min, count. While .apply() is more for lambda, or custom functions?

[@victoriabraimoh8994]

please my dataset has 34 genders, how do I group them into three main genders i.e male, female and others in pandas

[@Ayoubased]

love these videos. Are you thinking of making a video about a project from the beginning to end? Including pandas and maybe other softwares you use

[@misraturp]

Hey Ayoub, I have an online course where I teach how to do a project from beginning to end. Here it is: www.soyouwanttobeadatascientist.com/hods

[@harysigit8887]

I cant do it data.groupby("Agency").mean() syntax said error

[@pilarbaldominos2505]

Fantastic! You helped me a lot!

[@misraturp]

Awesome!!

[@Sabre5106]

I'm getting a TypeError when I copy this code: TypeError: agg function failed [how->mean,dtype->object] I can't seem to find an answer in the documentation or any videos :(

[@rushikeshn9715]

Very Helpful Mam 🙏🙏🙏

[@misraturp]

You’re welcome :)

[@krishj8011]

great tutorial...

[@chastippett]

Hi Misra: what's the difference between Pivot and Groupby? And/Or ... does Groupby always have an aggregation function or some apply function to a column, or is that Not the case?

[@bay-bicerdover]

pandas.DataFrame.pivot

[@kennethstephani692]

Great video!

[@misraturp]

Glad you enjoyed it!

[@wilsontower]

Very good!

[@ebierealexandria]

Thanks, Misra Turp for the tutorial. Do you have any courses on Data Analysis?

[@misraturp]

Not directly on data analysis but I have a course on building a data science project. You can see my courses here: www.soyouwanttobeadatascientist.com/roadmap

[@bay-bicerdover]

​@@misraturp link çalışmıyor

[@gossipgirl9508]

thanks! this video was great

[@misraturp]

You're very welcome :)

[@ytcdi]

Great1 You could also explore pandasql, a great package to also do 'group by' directly in sql, for python.

[@bay-bicerdover]

nosql😎

[@bottonline4544]

Hello, I am using Pandas V 2.1.1 in Python 3.15 and when running The following code: data.groupby('Agency').mean() It gives me the following error: TypeError: “agg function failed [how->mean,dtype->object]” But when I run it with an older version of pandas eg .1.2.1 and Python 3.9.7 it runs without problems

[@harysigit8887]

Your problem is a same with me, what must to do brother ?

[@ChandrashekarCN]

you miss one pandas dataframe.style one more video for pandas playlist

[@misraturp]

Thank you!

[@marcelocampos665]

Thank you!

[@abdulkadirguven1173]

Thank you

[@FRANKWHITE1996]

Thanks for sharing

[@misraturp]

Thanks for watching!

[@sanooosai]

rock star

[@lord_voldemort44]

where is ur accent from pls

[@chikwaz4500]

Great videos and content. I have two issues (i) Please include MARKDOWNs or Text instructions on what you are doing with the coding. This is good for beginners and also makes it easy to remember. (ii) Secondly, your KZbin channel name is not very attractive I advise you RENAME it to something that reflect what you do. Otherwise your teaching style is very GOOD. Hope this helps