Datasets / Subscription cohorts
Accounts still active, by months since signup
Every cohort is put on the same x axis - months since signup, not calendar months - which is the only way curves of different ages can be compared.
How it decided
Subscription cohorts: 1,056 rows, 6 columns. months_since_signup and active_accounts, summed over every cohort.
1,056 rows in, 19 out across 2 columns. Every cohort is put on the same x axis - months since signup, not calendar months - which is the only way curves of different ages can be compared.
area. A single decaying series reads as an area: the fill carries the magnitude that is being lost, which a bare line does not.
Palette, spacing, axis titles and legend placement applied. 0 issues found.
The transformation
This is the code, not a description of it — the chart above was drawn from what it returns, and the notebook download runs the same lines against the same file.
result = df.groupby("months_since_signup", as_index=False)["active_accounts"].sum()What it charted
19 rows out of 1,056, 2 columns. First 8 shown.
| months_since_signup | active_accounts |
|---|---|
| 0 | 5520 |
| 1 | 4557 |
| 2 | 3853 |
| 3 | 3348 |
| 4 | 2960 |
| 5 | 2668 |
| 6 | 2443 |
| 7 | 2132 |