Converting multiple columns variable into dummy variables

Question

I'm thinking to convert multiple columns of categorical variables in a data frame to dummy variables using pandas. The code below works, but it seems too long. May I know how do I combine these 3 lines in a single line of code, please? Thank you

X = pd.get_dummies(df.height, prefix=['height'])

Y = pd.get_dummies(df.weight, prefix=['weight'])

Z = pd.get_dummies(df.age, prefix=['age'])**

xgsktx · Accepted Answer · 2021-08-26 11:18:44Z

1

You can use:

pd.get_dummies(data=df, columns=["height", "weight", "age"])

answered Aug 26, 2021 at 11:18

xgsktx

19814 bronze badges

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

3 Comments

Nicole Oppenheim Over a year ago

Thanks the code works well but I would like to save these 3 variables into another variable called "J". so I used J = pd.get_dummies(data=df, columns=["height", "weight", "age"]). However, 2 other columns in the original data frame appear as well. How do I exclude these 2 columns?

xgsktx Over a year ago

A possible approach could be to create a list with the new column names: new_cols = ["name1", "name2", "name3"] and then create the new dataframe as J = J[new_cols].

mozway Over a year ago

@NicoleOppenheim for clarity, please provide the expected output

Collectives™ on Stack Overflow

Converting multiple columns variable into dummy variables

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related