Splitting values within a column into separate columns

Nleongard — Sun, 01 Apr 2018 17:11:52 GMT

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?

Re: Splitting values within a column into separate columns

txnelson — Sun, 01 Apr 2018 17:52:58 GMT

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

Re: Splitting values within a column into separate columns

Nleongard — Sun, 01 Apr 2018 17:58:12 GMT

Wauw thanks! I tried the split option, but I had done the group wrong...

awesome, have a good day

topic Re: Splitting values within a column into separate columns in Discussions

Splitting values within a column into separate columns

Re: Splitting values within a column into separate columns

Re: Splitting values within a column into separate columns