dataframe read csv dtype category object code example

Example 1: 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 2: treat NaN as a category

g_without_nan = g.cat.add_categories("D").fillna("D")