Pandas Coding for Data Tasks

Pandas coding for a dataset

Using the supplied dataset, produce a category-level summary of usable observations. Include only observations with a valid status and a non-null value, while retaining categories that have no usable observations.

Output

1. One row per category with category_name, observation_count, average_value, and maximum_value.
2. Include categories with zero usable observations, with zero counts and null summary values.
3. Order by observation_count descending, then category_name ascending.