Not able to make dummy variables

Question

Malene Brautaset 2022-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1675534-not-able-to-make-dummy-variables

评论： Voss 2022-3-25

Hello.

We have a problem making dummy variables since our variables has ' ' around them ('M'). We have a column with 'M' and 'F' and have to make dummy variables in order to use it in our regression.

How do we fix this?

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

请先登录，再进行评论。

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

Answer 1

Voss 2022-3-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1675534-not-able-to-make-dummy-variables#answer_921844

编辑：Voss 2022-3-19

在 MATLAB Online 中打开

data.csv

C = readcell('data.csv')
C = 4×6 cell array
    {'pcid'     }    {'year'}    {'currency'}    {'gender'}    {'revenue'}    {'netIncome'}
    {[887700702]}    {[2010]}    {''NOK''   }    {''F''   }    {[9837000]}    {[   533000]}
    {[887704902]}    {[2010]}    {''NOK''   }    {''M''   }    {[ 757000]}    {[  -224000]}
    {[887705992]}    {[2010]}    {''NOK''   }    {''M''   }    {[6631000]}    {[   681000]}
dummy_gender = strcmp(C(2:end,4),'''M''')
dummy_gender = 3×1 logical array
   0
   1
   1

2 个评论
显示无隐藏无

Malene Brautaset 2022-3-25

Thank you! This worked. But however, we want to keep our dataset in a table; is there a code we can use for the original dataset in a table?

Voss 2022-3-25

在 MATLAB Online 中打开

data.csv

You're welcome!

Sure, here is a table version:

T = readtable('data.csv')
T = 3×6 table
       pcid       year    currency     gender      revenue     netIncome
    __________    ____    _________    _______    _________    _________

     8.877e+08    2010    {''NOK''}    {''F''}    9.837e+06     5.33e+05
     8.877e+08    2010    {''NOK''}    {''M''}     7.57e+05    -2.24e+05
    8.8771e+08    2010    {''NOK''}    {''M''}    6.631e+06     6.81e+05
dummy_gender = strcmp(T{:,'gender'},'''M''')
dummy_gender = 3×1 logical array
   0
   1
   1