</>
pythonbeginner

Pandas Named Aggregations

Use named aggregations in groupby().agg() to produce readable, self-documenting summary tables.

python
import pandas as pd

df = pd.DataFrame({
    'dept':   ['eng','eng','hr','hr','eng'],
    'salary': [90000,85000,60000,65000,95000],
    'tenure': [3,5,2,7,8],
})

summary = df.groupby('dept').agg(
    total_headcount=('salary','count'),
    avg_salary=('salary','mean'),
    max_salary=('salary','max'),
    avg_tenure=('tenure','mean'),
)
print(summary)

Use Cases

  • HR reporting
  • team analytics
  • summary tables

Tags

#pandas#groupby#named-agg#readable

Related Snippets

Similar patterns you can reuse in the same workflow.

pythonintermediate

Pandas GroupBy Aggregation Examples

GroupBy operations with multiple aggregations, named aggregations, and transform for DataFrame analysis.

Best for: Sales reporting by region and time period

#pandas#groupby
pythonbeginner

Pandas .query() for Readable Filters

Use DataFrame.query() with expressions for cleaner, SQL-like row filtering syntax.

Best for: data filtering

#pandas#query
pythonintermediate

Pandas Custom Aggregation Functions

Pass custom lambda and named functions to .agg() for complex groupby aggregations.

Best for: HR analytics

#pandas#groupby
pythonintermediate

Grouped Time-Series with ffill

Forward-fill missing time-series values within groups to handle irregular measurement intervals.

Best for: IoT sensor data

#pandas#ffill