Pandas create new columns with count

Question

I have a df that looks like:

import pandas as pd

df = pd.DataFrame({'car_id':[01,02,03,04,05],
               'crash_severinity' :[unknown, possible injury,not injury,possible injury, unknown]})

df

I would like it to look like this

df

df = pd.DataFrame({'car_id':[01,02,03,04,05],
               'unknown' :[1,0,0,0,1],
               'possible injury' :[0,1,0,1,0]
               'not injury:[0,0,1,0,0]})

thanking you in advance!!

`pd.get_dummies(df.crash_severity)` – Quang Hoang Nov 26 '19 at 17:17 — Quang Hoang, Nov 26 '19 at 17:17

Julien Roullé · Answer 1 · 2019-11-26T18:15:18.583

0

This is what you are looking for:

df = pd.get_dummies(df)

Output is:

    crash_severity_not injured  crash_severity_possible injury  crash_severity_unknown
0                0                            0                           1
1                0                            1                           0
2                1                            0                           0
3                0                            1                           0
4                0                            0                           1

edited Nov 26 '19 at 18:15

answered Nov 26 '19 at 17:19

Julien Roullé

622
4
14

not sure what dummnies is for but i want to create new columns for each type of injury from crash_severity column – Dear_Gabe Nov 26 '19 at 17:53
This is what dummies do. I added the output of the function on your dataframe. – Julien Roullé Nov 26 '19 at 18:15
Thanks Julien. I got it. It is so simple and useful. – Dear_Gabe Nov 26 '19 at 18:17
Then please consider upvoting and accepting the answer so others might find it! – Julien Roullé Nov 26 '19 at 18:19
how to do that. still new here – Dear_Gabe Nov 27 '19 at 02:38

Pandas create new columns with count

I would like it to look like this

thanking you in advance!!

1 Answers1