Converting categories to numbers in pandas code example

Example 1: using df.astype to select categorical data and numerical data

df = pd.DataFrame({'vertebrates': ['Bird', 'Bird', 'Mammal', 'Fish', 'Amphibian', 'Reptile', 'Mammal']})

df.vertebrates.astype("category").cat.codes

Example 2: how to convert each string to a category or int in python dataframe

In [3]: df = pd.DataFrame({"A": ["a", "b", "c", "a"]})

In [4]: df["B"] = df["A"].astype('category')

In [5]: df
Out[5]: 
   A  B
0  a  a
1  b  b
2  c  c
3  a  a

Example 3: using df.astype to select categorical data and numerical data

df.satisfaction.astype("category",
  ordered=True,
  categories=ordered_satisfaction
)

Tags:

Python Example

Related