What are all Pandas .agg functions? Asked 6 years, 10 months ago Modified 10 months ago Viewed 53k times

I'm having trouble with Pandas' groupby functionality. I've read the documentation, but I can't see to figure out how to apply aggregate functions to multiple columns and have custom names for …

Let's say I have a log of user activity and I want to generate a report of the total duration and the number of unique users per day. import numpy as np import pandas as pd df = …

0 One-line solution: df.join( df.groupby('state').agg(state_total=('sales', 'sum')), on='state' ).eval('sales / state_total') This returns a Series of per-office ratios -- can be used on it's own …

Jun 8, 2012 · df_ret[dcol] = grouped.agg({dcol:min}) return df_ret The function df_wavg() returns a dataframe that's grouped by the "groupby" column, and that returns the sum of the weights for …

I've had success using the groupby function to sum or average a given variable by groups, but is there a way to aggregate into a list of values, rather than to get a single result? (And would this ...

As @unutbu mentioned, the issue is not with the number of lambda functions but rather with the keys in the dict passed to agg() not being in data as columns. OP seems to have tried using …

I am grouping by item-date pairs in a PD dataframe and would like to add some custom conditional functions using lambda to a larger aggregation function. Using the tip here, I can …

May 29, 2018 · Another possibility to get unique strings from STRING_AGG would be to perform these three steps after fetching the comma separated string: Split the string (STRING_SPLIT)

Mar 10, 2013 · agg is the same as aggregate. It's callable is passed the columns (Series objects) of the DataFrame, one at a time.