Dummy Variable ased on categorical vars in table

Question

Matthew Worker 2018-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/427782-dummy-variable-ased-on-categorical-vars-in-table

回答： Peter Perkins 2018-11-6

hi everyone! I'm tying to create a dummy variable in a table based on two categorical variables. My table contains numerical and categorical variables. I now want to add an additional column with values either zero or one. I have a 27x7 table. My code goes as follows:

Data.DV = zeros(27,1)

for x = 1:27

if Data.BS== 'Total assets' & Data.Bank =='Bank X'

Data.DV =1;

else Data.DV =0;

end

However, when I try this I receive the error message 'To assign to or create a variable in a table, the number of rows must match the height of the table.' Could you help me explain how to generate this new dummy? Many thanks ahead! Lea

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jeff Miller 2018-11-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/427782-dummy-variable-ased-on-categorical-vars-in-table#answer_345004

在 MATLAB Online 中打开

Since you are using a loop on x to go through the table one row at a time, you have to index the table variables BS, bank, and DV to select out one row at a time, like this:

Data.DV(x) = 1;

Another problem is that you can't compare strings with ==. Instead, you have to use strcmp().

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Matthew Worker 2018-11-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/427782-dummy-variable-ased-on-categorical-vars-in-table#answer_345052

在 MATLAB Online 中打开

Thanks!! Now I tried

Data.DV = zeros(27,1)
for x = 1:27
if strcmp(Data(x).BS, 'Total assets')
Data.DV(x) =1;
else Data.DV(x) =0;
end
end

But it still doesn't work. Instead, I get two new error messages:

"Error using tabular/subsrefParens (line 15) You cannot subscript a table using linear indexing (one subscript) or multidimensional indexing (three or more subscripts). Use a row subscript and a variable subscript.

Error in tabular/numArgumentsFromSubscript (line 59) x = subsrefParens(t,s(1));"