9951 explained code solutions for 126 technologies


python-pandasHow to group by dataframe


import pandas as pd

data = pd.DataFrame({
  'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
  'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
  'Phone Price': [204, 304, 404, 405, 305]
})

res = data.groupby(['Vendor']).mean()ctrl + c
import pandas as pd

load Pandas module

pd.DataFrame

creates Pandas DataFrame object

.groupby(

groups given dataframe by list of columns

Vendor

column to group dataframe by

.mean()

calculate means for grouped values

res

will contain aggregated dataframe