Median first response, by priority
The median, not the mean: response times have a long tail and one ticket left over a weekend moves an average and not a median.
Question
what is the median first response time by priority?
How it decided
Finding the data108 ms
Support tickets: 3,358 rows, 8 columns. priority and first_response_hours.
Shaping the data13 ms
3,358 rows in, 4 out across 2 columns. The median, not the mean: response times have a long tail and one ticket left over a weekend moves an average and not a median.
Choosing the chart9 ms
bar. Few categories, one measure, an obvious ordering: bars.
Applying defaults1 ms
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("priority", as_index=False)["first_response_hours"].median().sort_values("first_response_hours")What it charted
4 rows out of 3,358, 2 columns. First 4 shown.
| priority | first_response_hours |
|---|---|
| Urgent | 0.615 |
| High | 1.75 |
| Normal | 4.425 |
| Low | 9.25 |