Python Pandas Creating a Copy of a String column but setting the new column to integers

Asked Jul 07 '23 at 15:05

Active Jul 07 '23 at 15:06

Viewed 10 times

I would like to change string information to a new integer column.

I would like tried this type of solution below:

department_str department_int 
sales           1
RandD           2
tech            3

Thanks for the help!

I tried the pd.get_dummies which is getting some of the information I need.

edited Jul 07 '23 at 15:06

mozway

asked Jul 07 '23 at 15:05

Mick Hirsh

`df['department_int'] = pd.factorize(df['department_str'])[0] + 1` – mozway Jul 07 '23 at 15:07
Just for fun, an inefficient method with `get_dummies`: `np.argmax(pd.get_dummies(df['department_str']), axis=1)` – mozway Jul 07 '23 at 15:09

0 Answers0