Python Pandas Tutorial 7. Group By (Split Apply Combine) 

Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced

Your tutorials are excellent, better than Coursera's course. Thanks! :)

You are the first tutor I came across who manage to do the visualization of the groupby process!

Iterating a groupby object is something I liked most! wasn't aware of this before

man you are the best! even after paying good amount of fees, one can't expect this kind of teaching.

I really like these short tutorials. Great refresher content here! Maybe you can make a video with aggregations and complex groupbys and how to visualise them conceptually like you showed us the grioupby object conceptual viz? That would really really help. Please!

To get different kinds of stats on different columns over the groupby Object (g) we can use like so - g.aggregate({'temperature':'mean', 'windspeed':'max'}) --- will give average temperatures and max windspeed for the cities in the group by object (g)

I believe that a good teacher is not the one , who spoon feed you , but the who can inspire you to appreciate the beauty of Subject. You have same impact on me. Thank you for showing me the whole new world of analytics :)

exceptional, maja aa gya. I was just brushing up and literally this is the best course because I am doing it in 2X and your voice and speed both highly correlate to give a best course. Superb.

I always had trouble understaing 'group by' and that's not uncommon, No one has explained it better than you, that pictorial representation explains a lot Using pictures to make the concept clear is something what a really good data scientist and a really good teacher would do

I never understood groupby and it is used a lot in data analytics. Thank you for the explanation.

far better than college lectures, excellent teaching method and easiest way to learn the topics, man you are gem. I've followed you since when I'd watch your data basic roadmap, now I also wanna become data analytics and I followed your roadmap and it's far more better than other classes. You've helped so many youth's who wanted to become data analytics. Thank you sir once again. appreciate your work. keep goin'

at 5:45, let me correct you, statement below throws error SELECT * FROM CITY_DATE GROUP BY CITY when grouping, you can only select aggregated date rather than all columns *. To get what exactly you want, please write: SELECT * FROM CITY_DATE where CITY = 'cityname' Thanks for making awesome tutorials!

Just came across this video. Have watched a lot of these tutorials on groupby and this is by far the best. Perfect explanation and description of groupby in a small amount of time. Well done and thank you

This is the first time I have seen in any channel. This make shim different than others.. keep going.

May God Bless.Your tutorials are better than an MIT or Harvard class.

Your Tutorials are more than Excellent and Thank you for your service to the people of the world.

Thank you so much for this great tutorial! I look forward to seeing more of your work especially tutorials on pandas. All the best.

Fantastic job with these tutorials! Keep it up!

clear explanation thanks.

better than the coursera lectures.

Excellent way of teaching i seen so far for data science thank you so much sir

this was the best explanation of groupby i've come across. thank you.

Really Your teaching method is so excellant

Thank you so much for making it so logical and clear explanation. Your knowledge is precious to people like me. Thanks a ton

Thank you man i'm using this for my doctorate research

Love your tutorial , your explanation is very clear and easy to understand

The best explanation of groupby I've ever seen :) What if you want to groupby multiple categories? For example, cities and districts.

Very well explained and a simple tutorial for Groupby.

An interesting lecture cleared many points.

You are really intelligent.Please share more videos on Python.Like Take one project and help completing that.Like wise you can help making at least 5 to 6 Projects of different genre.Anyways You are doing great .May God keep u healthy, wealthy and wise.

Awesome.. you have made so easy to learn Panda . Thank you very much

Every tutorial of yours is so interesting.

You just explained it brilliantly 🙏🙏🙏

Shouldn't we do g['temperature'].max()? As is g.max() it just states the max for every column which doesn't make much sense

Groupby explained in such detail. Thanks for sharing this!

Great video.. i have 1 question when you apply g.max() function the it returns maximum value from each column but what in case of event ? is it return max size string from the events?? that's why it returned "sunny" from mumbai dataframe????

you are very good teacher.

Best tutorial on this platform.. Well done

great video. the visualization of what groupby does helped immensly

Thank you so much !!!! for making this video.It gives picture of what is going inside and gives more control on coding

you have made such good videos for Pandas. Keep up the good work.My wishes

Loved the explanations and diagrams of what is happening! Thanks!

Step by step roadmap to learn data science in 6 months: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H4YcqULY1-Q.html Machine learning tutorials with exercises: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gmvvaobm7eQ.html 5 FREE data science projects for your resume with code: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-957fQCm5aDo.html

Very helpful! Couldn’t find it better anywhere else. Thanks!

Really very good presentation, keep it up sir. Rakesh Deo from Kathmandu, Nepal.

Thank you for covering this topic really helpful, please tell me how to groupby dates in your data set and setting frequency to monthly

This was a great tutorial, thank you!

TE AMO MUITO MANO, NAMORAL VOCE SALVOU A MINHA GRADUAÇÃO

Always just in the right time with the right tutorial. Thank you very much!

In PyCharm you need for the graphs: import matplotlib.pyplot as plt g.plot() plt.show()

U explained it properly. Thanks

It is very well explained!!! Thx a lot for the video!

Simply mind-blowing nice explanation sir

Genius explainer you are!

Exactly what I was searching for, thx a lot !

Very simple explaination of the Group by concept....keep it up mate...

Hi there again, Is it possible to recommend some datasets(short or long) to use them during pandas documentation toturials please? Thanks

i have been using pandas , but never knew this about group by

i have spent thousand of money to buy courses from diff diff vendors and at last learning from here, which is far far batter than anywhere else.

Your tutorials are really good, but please include the Excel sheets you will be using in the video description, it's a hassle to create them ourselves every time

simply outstanding !

you are doing great....!!! Good work.. Looking forward to it...

Very informative, thank you for this. One question I have is there a way we can run a liner regression model for each of the group separate from the other?

Thanks man. You saved me. What a legend

Very Useful .Thank you so much

g.max() should be used for a specific column, otherwise it just gives the maximum value of each column in one row which may or may not be associated.

Excellent tutorials ,thanks

Great tutorial...Thanks for this. I want to know how can we apply a custom function on each group.? Say i hve grou by column 'A', and Column B contais some string value. and i want to apply a custom logic on Group for column B. How can i do that.?

Thank you very much for these very useful and "easy to learn" tutorials!!

The visual you created is very helpful. Thanks.

Sir can you please do vedio on how a group by output can we convert into a dataset .

thank you sir, your visual representation was really helpful. do you have tutorial part - II for this group by

Great Tutorial! Do you know how to save to .csv after you group them into 3 different cities?

Thanks for the vedio.... Can we do grouping by months!!

for getting maximum temperature i would have preferred to pass a dictionary mapping aggregating column i.e temperature to aggregating function i.e max to agg method... g.agg({'temperature' : 'sum'})

This is a super helpful video. What if I want to get the average windspeed on days in Mumbai hotter than 70? I am having trouble returning the windspeed value based on multiple criteria. Can someone show me example code on how I would get that?

Really, I am liking so much. 👌👌👌👌

Great tutorials and Awesome explanation !!!! Thank you again.

Great Explanation.

Nice 👍

Nice, thanks for share this!... you rock!

it is a great presentation! I wish you could also add things like how to select the row with the max temperature within each city.

Great video! Concise and to the point! Thank you :)

That's an awesome tutorial bro😉😄😄😄

Do you have any suggestions as to the best way to plot the temperature and wind speed in separate plots for each city group? Ideally, there would be three plots for each city with date as the x-axis, and value of either temp or windspeed on the y-axis.

This entire course you put together is exceptional! I really appreciate this information along with the effort and focus you used to make such an excellent series of tutorials!

i am with you till the end

Thank you بارك الله فيك

big thanks, awesome!!, can i turned in a dataframe ?

Clear and to the point. Thanks dude.

Could you run the g.describe() and evaluate by city without having done the group by prior? Or do you have to split the data in a groupby beforehand?

Great.........................!

Add some more real world live project, your videos are very easy to understand.

good video bro. keep it up!

Excellent tutorial.. I learnt a lot because of you.. Thank you so much

great to have these videos. how can I write the values in excel after applying for loop??

Thanks for posting! Great Video! How can you save the filtered data frame "groups" as new csv files?

hats off to you Sir...

Nice tutorial, the whole series