Aggregations
Aggregations (also referred to as reductions) help you to reduce multiple values from a series of values down to a single value. Even if the technical term is new to you, you have no doubt encountered many aggregations in your data journey. Things like the count of records, the sum or sales, or the average price are all very common aggregations.
In this recipe, we will explore many of the aggregations built into pandas, while also forming an understanding of how these aggregations are applied. Most analysis you will do throughout your data journey involves taking large datasets and aggregating the values therein into results that your audience can consume. Executives at most companies are not interested in receiving a data dump of transactions, they just want to know the sum, min, max, mean, and so on of values within those transactions. As such, effective use and application of aggregations is a key component to converting your complex data transformation pipelines...
