How to convert a column with multiple values into binary variables in Pandas

Question

I have a dataframe with 1.5M rows and one column. It looks like:

I want to split the column 'jobroles' into multiple columns with 1s and 0s (hot-coding). Following is what I have tried so far:

df_bits = df['jobroles'].str.join(sep=',').str.get_dummies(sep=',')

But it is not just splitting on "," but each and every digit. For example, "2424638" gets split into "2", "3", "4", "6" and "8". Below the result I am getting.

John Zwinck · Accepted Answer · 2016-04-29 04:00:34Z

1

It should be just this:

df['jobroles'].str.get_dummies(',')

answered Apr 29, 2016 at 4:00

John Zwinck

252k44 gold badges346 silver badges459 bronze badges

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

Collectives™ on Stack Overflow

How to convert a column with multiple values into binary variables in Pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related