This lesson you will learn about aggregates in Pandas. An aggregate statistic is a way of creating a single number that describes a group of numbers. Common aggregate statistics incluse mean,...

In the previous lesson, you learned how to perform operations on each value in a column using [...] . In this exercise, you will learn how to combine all of the values from a column for a sing...

When we have a bunch of data, we often want to calculate aggregate statistics (mean, standard deviation, median, percentiles, etc.) over certain subsets of the data. Suppose we have a grade book w...

After using [...] , we often need to clean our resulting data. As we saw in the previous exercise, the [...] function creates a new Series, not a DataFrame. For our ShoeFly.com example, the in...

Sometimes, the operation that you want to perform is more complicated than [...] or [...] . In those cases, you can use the [...] method and lambda functions, just like we did for individual ...

Sometimes, we want to group by more than one column. We can easily do this by passing a list of column names into the [...] method. Imagine that we run a chain of stores and have data about the...

When we perform a [...] across multiple columns, we often want to change how our data is stored. For instance, recall the example where we are running a chain of stores and have data about the n...

This lesson introduced you to aggregates in Pandas. You learned: How to perform aggregate statistics over individual rows with the same value using [...] . How to rearrange a DataFrame into...