Exercise

Changing the data type to category

Since the rating column only has a few possible values, you'll change its data type to category in order to store the data more efficiently. You'll also specify a logical order for the categories, which will be useful for future exercises.

Instructions

100 XP

Create a CategoricalDtype object called cats that lists the weather ratings in a logical order: 'good', 'bad', 'worse'. Make sure to specify that the categories should be treated as ordered.
Use the cats object to change the data type of the rating column from object to category.
Examine the head of the rating column to confirm that the categories are logically ordered.