Pandas - Convert Text To Binary Columns

Question

I have a large dataframe "df":

    ph_level
0   low
1   medium
2   low
3   high
4   low
5   medium

I would like to add 3 binary columns for the low,medium,high data. Below is the output I am seeking:

    ph_level low_binary  medium_binary  high_binary
0   low      1           0              0 
1   medium   0           1              0
2   low      1           0              0
3   high     0           0              1
4   low      1           0              0
5   medium   0           1              0

Is there a very fast way to do this with pandas?

Thanks

akuiper · Accepted Answer · 2017-02-10 04:11:11Z

4

You can use pandas.get_dummies and concatenate the result with the original data frame:

pd.concat([df, pd.get_dummies(df.ph_level).rename(columns = "{}_binary".format)], axis = 1)

answered Feb 10, 2017 at 4:11

akuiper

216k33 gold badges363 silver badges380 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeff Saltfist Over a year ago

Super fast! Thank you Psidom.

Collectives™ on Stack Overflow

Pandas - Convert Text To Binary Columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related