import pandas as pd import numpy as np df = pd.DataFrame({ "quarter": ["Q1", "Q2", "Q3", "Q4"], "teleconsults": [1200, 1850, 2400, 3100], }) df["growth_%"] = (df["teleconsults"].pct_change() * 100).round(1) df
| quarter | teleconsults | growth_% | |
|---|---|---|---|
| 0 | Q1 | 1200 | NaN |
| 1 | Q2 | 1850 | 54.2 |
| 2 | Q3 | 2400 | 29.7 |
| 3 | Q4 | 3100 | 29.2 |
# mean quarter-on-quarter growth df["growth_%"].mean().round(1)
37.7