Hi!
Pleas help. I cannot figure out how to split the values of a column into seperate columns.
My dataset is on police shootings in the US, occuring in 2015-2017. it has the following columns attached:
- ID
- Name
- Date
- Manner of death
- Armed
- Age
- Gender
- Race
- City
- State
- Signs of mental illness
- Threat level
- Flee
- Body camera
Within 'Race', there are the given values of A, W, H, B, N, O.
I would like to do a decision tree on how fx Black people vs White are more likely to get shot if they were fleeing, threatning, carrying a weapon etc. As it is right now I can only target race as a variable compared to the other variables, but I cannot look into a specific race.
I think I can do this by splitting A, W, H, B, N, O, into new columns where 'yes' or '1' were giving to each individual that was that particular race, and the other races values would just be empty or be given a 'no' (see picture for example)
Is this even the correct way of targeting a specific race, if yes, how do i then split all the race values into their own column?
Wauw thanks! I tried the split option, but I had done the group wrong...
awesome, have a good day
I believe you can accomplish what you want by using
Tables==>Split
selecting Race as your Split By column
also selecting Race as your Split Columns
selecting ID as your Group column
and selecting Keep All option
