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

Very Useful .Thank you so much

g.mean() shows error. Instead we can use g[['temperature','windspeed']].mean()

Nice video

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'

This is great.

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)

g.mean() threw a TypeError: Could not convert 01-01-201701-02-201701-03-201701-04-2017 to numeric for me. g.describe() however worked fine. Is there a way to skip the non-numeric columns from g.mean()

U explained it properly. Thanks

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

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

g.max() is giving max temp of cities............why ??????????

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

Thanks

Great Explanation.

thanks sir

Thanks sir

clear explanation thanks.

Nice 👍

Jupiter notbook 😂

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

I amgetting and error when i do df_grp = df.groupby('ProviderSpecialty')
df_grp.get_group(['ProviderSpecialty'])

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

Really Your teaching method is so excellant

thank you sir

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

when i am trying to print this output in csv format its giving a error called "'DataFrameGroupBy' object has no attribute 'to_csv' ples help me with how i can print this output in csv format

Exactly what I was searching for, thx a lot !

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?

thank you so much

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

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

i love you so much, huggies from brazil <3

Yes,I am interested...

Groupby explained in such detail. Thanks for sharing this!

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

hats off to you Sir...

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

You just explained it brilliantly 🙏🙏🙏

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'm trying to plot the data but I'm unable to the results as my plotting is between day and Wind speed and not between temperature and wind speed how to correct it can anyone help me with it???

Please Add Some Problems andd answer to enhance your teaching and understanding

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

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

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

simply outstanding !

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

Hi Dhaval, what if we pass two features let's say .groupby(['city','day']) so then how would be the representation please?

you are very good teacher.

How it has decided data for event column when max() is applied.