How to use the Pandas GroupBy function | Pandas tutorial

Подписаться 38 тыс.

Просмотров 30 тыс.

50% 1

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
📹 RU-vid - / @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...

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 72

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

@MohamedKhasim16 2 месяца назад

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

@message59 10 месяцев назад

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 5 месяцев назад

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

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

@suhaibmudassir3272 Год назад

I found someone successfully who actually I can understand ❤

@islamalmsarrhad2152 2 года назад

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 2 года назад

Thank you Islam!

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

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

@khanhhoanggiabao6240 2 месяца назад

Helpful video. Thank you

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

@catalindemergian2973 Год назад

this pandas series was great! thank you

@misraturp Год назад

Awesome to hear, you're welcome!

@ayanchoubisa2462 2 года назад

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

@misraturp 2 года назад

Thank you very much!

@inkdfist3702 Год назад

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

@misraturp Год назад

Glad it was helpful!

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

@swapnilpalsapure9781 6 месяцев назад

Great Teaching

@anurajms 10 месяцев назад

thank you. video is really useful

@Latif127 Год назад

Very informative, thank you.

@aldalail Год назад

That's been helpful, Thank you !!

@j3553hh 9 месяцев назад

Nice angle on this. Thank you.

@krishj8011 11 месяцев назад

great tutorial...

@pilarbaldominos2505 Год назад

Fantastic! You helped me a lot!

@misraturp Год назад

Awesome!!

@kennethstephani692 Год назад

Great video!

@misraturp Год назад

Glad you enjoyed it!

@MaxMustermann-on2gd Год назад

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

@misraturp Год назад

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

@wilsontower Год назад

Very good!

@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

@marcelocampos665 Год назад

Thank you!

@rushikeshn9715 2 года назад

Very Helpful Mam 🙏🙏🙏

@misraturp 2 года назад

You’re welcome :)

@szw21 7 месяцев назад

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 😥

@gossipgirl9508 Год назад

thanks! this video was great

@misraturp Год назад

You're very welcome :)

@abdulkadirguven1173 Год назад

Thank you

@harysigit8887 2 месяца назад

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

@victoriabraimoh8994 Год назад

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

@ytcdi Год назад

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

@bay-bicerdover Год назад

nosql😎

@CEOLISSS 6 месяцев назад

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?

@FRANKWHITE1996 2 года назад

Thanks for sharing

@misraturp Год назад

Thanks for watching!

@Sabre5106 6 месяцев назад

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

@sanooosai Год назад

rock star

@ChandrashekarCN Год назад

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

@misraturp Год назад

Thank you!

@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 2 месяца назад

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

@ebierealexandria 2 года назад

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

@misraturp 2 года назад

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

@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