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!

[@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 :)

[@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 :)

[@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!

[@MohamedKhasim16]

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

[@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!

[@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!

[@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!

[@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?

[@ayanchoubisa2462]

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

[@misraturp]

Thank you very much!

[@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!

[@catalindemergian2973]

this pandas series was great! thank you

[@misraturp]

Awesome to hear, you're welcome!

[@inkdfist3702]

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

[@misraturp]

Glad it was helpful!

[@suhaibmudassir3272]

I found someone successfully who actually I can understand ❤

[@MaxMustermann-on2gd]

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

[@misraturp]

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

[@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

[@FelipeCampelo0]

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

[@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 😥

[@khanhhoanggiabao6240]

Helpful video. Thank you

[@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?

[@pilarbaldominos2505]

Fantastic! You helped me a lot!

[@misraturp]

Awesome!!

[@aldalail]

That's been helpful, Thank you !!

[@Latif127]

Very informative, thank you.

[@rushikeshn9715]

Very Helpful Mam 🙏🙏🙏

[@misraturp]

You’re welcome :)

[@anurajms]

thank you. video is really useful

[@kennethstephani692]

Great video!

[@misraturp]

Glad you enjoyed it!

[@j3553hh]

Nice angle on this. Thank you.

[@swapnilpalsapure9781]

Great Teaching

[@krishj8011]

great tutorial...

[@gossipgirl9508]

thanks! this video was great

[@misraturp]

You're very welcome :)

[@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

[@victoriabraimoh8994]

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

[@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

[@HarySiiigit]

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

[@wilsontower]

Very good!

[@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 :(

[@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

[@HarySiiigit]

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

[@ytcdi]

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

[@bay-bicerdover]

nosql😎

[@marcelocampos665]

Thank you!

[@abdulkadirguven1173]

Thank you

[@FRANKWHITE1996]

Thanks for sharing

[@misraturp]

Thanks for watching!

[@ChandrashekarCN]

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

[@misraturp]

Thank you!

[@sanooosai]

rock star

[@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

[@lord_voldemort44]

where is ur accent from pls