Python Tutorial: Calculate cohort metrics

Want to learn more? Take the full course at https://learn.datacamp.com/courses/customer-segmentation-in-python at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- Great! We have assigned the cohorts and calculated the monthly offset for the metrics. Now we will learn how to calculate business metrics for these customer cohorts. We will start by using the cohort counts table from our previous lesson to calculate customer retention. Then we will calculate the average purchase quantity. The retention measures how many customers from each of the cohort have returned in the subsequent months. We will use the dataframe called cohort_counts which we created in the previous lesson. Our first step is to select the first column which is the total number of customers in the cohort. Next, we will calculate the ratio of how many of these customers came back in the subsequent months which is the retention rate. One word of caution, you will see that the first month's retention - by definition - will be 100% for all cohorts. This is because the number of active customers in the first month is actually the size of the cohort. We will select the first column from the table and store it as cohort_sizes. Then we will use the divide() function on the cohort_counts dataframe and pass the cohort_sizes. We set the axis parameter to zero to ensure we divide along the row axis. Finally, we round the ratio to 3 digits and multiply it by a 100 to make it look like a percentage. With these simple commands, we have completed retention metric calculation. Let's take a look at it. As you can see, the first column has a 100% retention rate for all cohorts, as expected. We can now compare the retention rate over time and across cohorts to evaluate the health of our customers' shopping habits. Let's take a look at another example. Let's step back a little bit and go back to our original online dataset. We will show you how t