How to use the Pandas GroupBy function | Pandas tutorial
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- 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
📹 TH-cam - / @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...
👉 All you need to know about Pandas in one place!
Download my Pandas Cheat Sheet (free)
misraturp.gumroad.com/l/pandascs
Really learned more from this video and exceptionally clear, truly a valuable resource! Thank you and keep up the amazing work! 🙌🏼
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.
Wow, thank you! Glad you enjoyed it!
Hello misra, Your really made pandas library so easy to learn. I always wait to get your notification because you simplify everything.
Thank you Himanshu, that’s so nice to hear :)
your videos saved me 😅 so I just wanted to thank you for the effort and say that you have great way of explaining things :)
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!
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>>>>
Thank you Islam!
This makes clear what the kaggle intro to pandas could not.
I love all of your work. You save me a lot of time reading, searching, and figuring out what to do.
That's amazing to hear, thank you!
this pandas series was great! thank you
Awesome to hear, you're welcome!
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. ✌😉
Thank you Even Horizon! That's amazing to hear. :)
Keep up the good work!
I found someone successfully who actually I can understand ❤
Thank you very much for the explanation of the Grouper function, I think that can help me a lot. :)
Greetings from Germany.
Glad it was helpful!
hows weather in germany?
Helpful video. Thank you
Nice angle on this. Thank you.
Your method of explaining is excellent. Greetings, you'll grow a lot.
Thank you very much!
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.
That's great Behrad! Thank you!
Great explanation, just what I was looking for, thank you so much!
Glad it was helpful!
Great Teaching
Loved the scuba diving hint 🤣 are you a diver?
Great explanation!
Heheh thanks! Yes, I'm a diver :)
great tutorial...
Great video!
Glad you enjoyed it!
Very good!
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
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
That's been helpful, Thank you !!
Very informative, thank you.
Thank you!
Fantastic! You helped me a lot!
Awesome!!
please my dataset has 34 genders, how do I group them into three main genders i.e male, female and others in pandas
Thank you
I cant do it data.groupby("Agency").mean() syntax said error
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 😥
Very Helpful Mam 🙏🙏🙏
You’re welcome :)
thanks! this video was great
You're very welcome :)
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?
Great1 You could also explore pandasql, a great package to also do 'group by' directly in sql, for python.
nosql😎
Thanks for sharing
Thanks for watching!
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 :(
rock star
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?
pandas.DataFrame.pivot
Thanks, Misra Turp for the tutorial. Do you have any courses on Data Analysis?
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
@@misraturp link çalışmıyor
you miss one
pandas dataframe.style
one more video for pandas playlist
Thank you!
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
Your problem is a same with me, what must to do brother ?
where is ur accent from pls
thank you. video is really useful