9951 explained code solutions for 126 technologies

python-pandasHow to aggregate (groupby) dataframe using sum

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']).sum()ctrl + c
import pandas as pd

load Pandas module


creates Pandas DataFrame object


groups given dataframe by list of columns


calculate sums for grouped values


will contain aggregated dataframe