deals.groupby('owner')['amount'].sum() is GROUP BY owner with SUM. .sort_values(ascending=False) orders it. deals.merge(accounts, on='account_id') is an inner JOIN on the shared key; add how='left' for a LEFT JOIN. .to_dict('records') turns rows into a list of dicts.