df = pd.DataFrame({'vertebrates': ['Bird', 'Bird', 'Mammal', 'Fish', 'Amphibian', 'Reptile', 'Mammal']}) df.vertebrates.astype("category").cat.codes
df.satisfaction.astype("category", ordered=True, categories=ordered_satisfaction )