Data Science Stack Exchange is a question and answer site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field. It only takes a minute to sign up.
Sign up to join this community
So I have this data which which has the 12 months as below:
When I one-hot encode it using pd.get_dummies the result is this:
You see that the new columns are ordered alphabetically losing the months order, which makes reading the data hard. Is there any way to preserve the order?
One option is to create a separate dataframe with the dummy variables, reorder it, and concat it with the original dataframe.
df = pd.DataFrame({'month': ['jan', 'feb', 'jan', 'march', 'jan']})
dummies = pd.get_dummies(df.month)
dummies = dummies[['jan', 'feb', 'march']]
pd.concat([df, dummies], axis=1)
