How to use the Pandas GroupBy function

No video

How to use the Pandas GroupBy function | Pandas tutorial

Рет қаралды 29,427

2 жыл бұрын

The GroupBy function is sometimes confusing and overwhelming for people who are just starting with programming in pandas, or even for people who have been using pandas for years. In this tutorial, I will show you the ins and outs of the groupby function, how to use it, what it returns and how to deal with the groups that are created.
There is also an introduction for a little bonus function at the end that I think will be very useful for you called the pd.Grouper.
Get the code here: github.com/mis...
You can find the data here: data.cityofnew...
Groupby documentation: pandas.pydata....
Pandas Grouper documentation: pandas.pydata....
👋 Keep in touch?
==========================
🐥 Twitter - / misraturp
🔗 LinkedIn - / misraturp
📹 KZfaq - / @misraturp
🌎 Website - misraturp.com/
Courses & resources
============================
📙 Fundamentals of Deep Learning in 25 pages
misraturp.gumr...
👩‍💻 Hands-on Data Science: Complete your first portfolio project
www.misraturp....
📥 Streamlit template
misraturp.gumr...
🤖 Deep Learning 101 with Python and Keras (FREE)
• 50 Days of Deep Learning
🏃‍♀️ Data Science Kick-starter mini-course (FREE)
www.misraturp....
🐼 Pandas cheat sheet (FREE)
misraturp.gumr...
📝 NNs hyperparameters cheat sheet (FREE)
misraturp.gumr...

Пікірлер: 72

@misraturp Жыл бұрын

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

@MohamedKhasim16 Ай бұрын

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

@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 8 ай бұрын

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

@FelipeCampelo0 3 ай бұрын

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

@himanshupandey9902 2 жыл бұрын

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

@misraturp 2 жыл бұрын

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

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

@khanhhoanggiabao6240 29 күн бұрын

Helpful video. Thank you

@swapnilpalsapure9781 4 ай бұрын

Great Teaching

@harysigit8887 Ай бұрын

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

@j3553hh 7 ай бұрын

Nice angle on this. Thank you.

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

@suhaibmudassir3272 Жыл бұрын

I found someone successfully who actually I can understand ❤

@invictus327 2 жыл бұрын

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 2 жыл бұрын

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

@bay-bicerdover Жыл бұрын

Keep up the good work!

@ayanchoubisa2462 2 жыл бұрын

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

@misraturp 2 жыл бұрын

Thank you very much!

@catalindemergian2973 Жыл бұрын

this pandas series was great! thank you

@misraturp Жыл бұрын

Awesome to hear, you're welcome!

@behradio 2 жыл бұрын

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 2 жыл бұрын

That's great Behrad! Thank you!

@inkdfist3702 Жыл бұрын

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

@misraturp Жыл бұрын

Glad it was helpful!

@MrMH0 2 жыл бұрын

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

@misraturp 2 жыл бұрын

Glad it was helpful!

@bay-bicerdover Жыл бұрын

hows weather in germany?

@CEOLISSS 4 ай бұрын

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?

@MaxMustermann-on2gd Жыл бұрын

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

@misraturp Жыл бұрын

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

@krishj8011 10 ай бұрын

great tutorial...

@victoriabraimoh8994 Жыл бұрын

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

@Sabre5106 4 ай бұрын

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

@Latif127 Жыл бұрын

Very informative, thank you.

@szw21 6 ай бұрын

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 😥

@Ayoubased 2 жыл бұрын

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 2 жыл бұрын

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

@wilsontower Жыл бұрын

Very good!

@kennethstephani692 Жыл бұрын

Great video!

@misraturp Жыл бұрын

Glad you enjoyed it!

@marcelocampos665 Жыл бұрын

Thank you!

@rushikeshn9715 2 жыл бұрын

Very Helpful Mam 🙏🙏🙏

@misraturp 2 жыл бұрын

You’re welcome :)

@aldalail Жыл бұрын

That's been helpful, Thank you !!

@pilarbaldominos2505 Жыл бұрын

Fantastic! You helped me a lot!

@misraturp Жыл бұрын

Awesome!!

@abdulkadirguven1173 Жыл бұрын

Thank you

@bottonline4544 10 ай бұрын

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 ?

@ytcdi Жыл бұрын

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

@bay-bicerdover Жыл бұрын

nosql😎

@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

@FRANKWHITE1996 Жыл бұрын

Thanks for sharing

@misraturp Жыл бұрын

Thanks for watching!

@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