Pivot Status Counts · IoT readings 58

IoT readings DataFrame, variant 58. Return category with paid and cancelled count columns, filling absent counts with 0, ordered by category. Implement `solve(df)` and return a PySpark DataFrame.