Create index vector from grouping variable
조회 수: 5 (최근 30일)
이전 댓글 표시
I am using grp2inx command to convert categorical data into numbers that I can find correlation between the variables. When matlab index them automatically, it substitute the categories based on their order in the table. In other words {'No Damage'} {'Destroyed'} {'1-9%'} {'10-25%'} {'51-75%'} {'26-50%'} are replaced with 1 2 3 4 5 6, respectively. I want to replace them meaningfully; 1 instead of {'No Damage'}, 2 instead of {'1-9%'} ......and 6 instead {'Destroyed'}. How can I do that? Here is what I use, but doesnt work
gL1={'No Damage','1-9%','10-25%','26-50%','21-75%','Destroyed'};
[g1,gN1,gL1] = grp2idx(Table.Damage_rate);
Thank you
댓글 수: 0
채택된 답변
dpb
2018년 10월 11일
편집: dpb
2018년 10월 11일
gr2idx is used with the Statistics Toolbox implementation of a categorical variable type. Unfortunately, while it was useful and ahead of the ultimate native categorical data type later introduced, it is now deprecated and use is discouraged.
Use the base categorical data type and findgroups combined with splitapply to process table data by groups:
gL1={'No Damage','1-9%','10-25%','26-50%','21-75%','Destroyed'};
gC1=categorical(gL1,gL1,'ordinal',1); % create ordinal categorical variable with names given
>> [g,id]=findgroups(gC1) % find the groups and the group id associated with...
g =
1 2 3 4 5 6
id =
1×6 categorical array
No Damage 1-9% 10-25% 26-50% 21-75% Destroyed
>>
ADDENDUM
Hmmm...I thought the computational routines ought to have been amended to handle ordinal categorical variables but apparently that was a unwarranted assumption.
To get the numeric values, just use
Table.Damage=double(Table.Damage_rate);
once you've created the categorical variable--make a new variable for it; no sense in destroying the other.
댓글 수: 5
dpb
2018년 10월 12일
See the addendum/update to the Answer I posted last night...convert the string variables to ordinal categorical variables as shown initially then double().
There's "no change" in the above because you didn't assign the results to anything, but that's the harder and less pleasing way; the character strings are categorical variables; use the facility Matlab provides for the purpose.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!