Practice / reshaping
A support lead wants a status dashboard: one row per team, with counts of open and closed tickets.
tickets
Your task: produce one row per team with an open and a closed column counting tickets in each status. If a team has none of a status, that cell must be 0, not null.
Assign your answer DataFrame to result. Row order doesn't matter.
ticketsinput DataFrame| column | type |
|---|---|
| ticket_id | long |
| team | string |
| status | string |
| ticket_id | team | status |
|---|---|---|
| 1 | Billing | open |
| 2 | Billing | open |
| 3 | Billing | closed |
| 4 | Sales | closed |
teamopenclosed· 2 rowsgroupBy("team").pivot("status", ["open", "closed"]).agg(F.count("*")) builds
the grid; a team missing a status gets a null cell, so finish with
.fillna(0, subset=["open", "closed"]).
This problem builds on Reshaping Data (~7 min). Pop it open in a new tab if you want a quick recap.