35. Pandas GroupBy | GroupBy Without Using GroupBy | Python Pandas Tutorial

Published: 19 December 2020
on channel: Data Thinkers

585

In this video, We are going to discuss the Groupby function Without Using Groupby to understand the internal working of pandas GroupBy function.

import pandas as pd
d = {'City': ['Ahmedabad','Baroda','Anand','Ahmedabad','Baroda','Anand'],
'Temp':[40,35,32,45,37,34]}
data = pd.DataFrame(d)
data
------------------------------------------------------------

Spilt
------------------------------------------------------------
grp_a=data[data['City']=='Ahmedabad']
grp_a
grp_b=data[data['City']=='Baroda']
grp_b
grp_c=data[data['City']=='Anand']
grp_c
------------------------------------------------------------------
Apply
----------------------------------------------------------------
grp_a=data[data['City']=='Ahmedabad']
avg_a=grp_a['Temp'].mean()
avg_a
grp_b=data[data['City']=='Baroda']
avg_b=grp_b['Temp'].mean()
avg_b
grp_c=data[data['City']=='Anand']
avg_c=grp_c['Temp'].mean()
avg_c
---------------------------------------------------------------------
Combine
--------------------------------------------------------------------
dataf=pd.DataFrame({
'City':['Ahmedabad','Baroda','Anand'],
'Temp':[avg_a,avg_b,avg_c]
})
dataf
------------------------------------------------------

Github Link: https://github.com/PRIYANG-BHATT/Data...

If you enjoy these tutorials, like the video, and give it a thumbs-up, and also share these videos with your friends and families if you think these videos would help him.
Please consider clicking the SUBSCRIBE button to be notified of future videos.

groupby pandas
pandas group by
python groupby
pandas groupby count
dataframe groupby
pandas agg
pandas aggregate
pandas groupby agg
pandas groupby multiple columns
pandas groupby sum
pandas dataframe groupby
pandas group by count
pandas groupby apply
dataframegroupby
pandas groupby to dataframe
groupby count pandas
groupby count pandas

#pandas
#PandasGroupby
#groupby