How can I seperate these number from a cell and put it into a matrix.

Question

Hai Luu 2020-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505526-how-can-i-seperate-these-number-from-a-cell-and-put-it-into-a-matrix

评论： Star Strider 2020-2-15

采纳的回答： Star Strider

I have tried systax "cell2mat" but it didnt work.

2 个评论
显示无隐藏无

Star Strider 2020-2-14

You will have to provide (attach) that file if you want help with it. I was able to find it online although not able to download it.

Hai Luu 2020-2-14

Sorry, here are my files

请先登录，再进行评论。

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

Answer 1

Star Strider 2020-2-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505526-how-can-i-seperate-these-number-from-a-cell-and-put-it-into-a-matrix#answer_415607

在 MATLAB Online 中打开

Try this:

[num,txt,raw] = xlsread('2019_nC0v_20200121_20200126_cleaned.xlsx');
vars = regexp(txt(1,:), ',', 'split');
varsc = string(vars{:})
newcell = regexp(txt(2:end), ',', 'split');
C1 = cellfun(@(x)str2double(x(:,1)), newcell);
C2 = cellfun(@(x)x(:,2), newcell);
C3 = cellfun(@(x)x(:,3), newcell);
C4 = datetime(cellfun(@(x)x(:,4), newcell), 'InputFormat','MM/dd/yyyy');
for k = 1:4
    C(:,k) = cellfun(@(x)str2double(x(:,k+4)), newcell);
end
COVID19 = table(C1,C2,C3,C4,C(:,1),C(:,2),C(:,3),C(:,4));
COVID19.Properties.VariableNames = {'Nr','Province/State','Country','Date Last Updated','Confirmed','Suspected','Reecovered','Deaths'};

and:

Check = COVID19(1:5,:)

produces:

Check = 
    Nr    Province/State         Country          Date Last Updated    Confirmed    Suspected    Reecovered    Deaths
    __    ______________    __________________    _________________    _________    _________    __________    ______
    0      {'Shanghai'}     {'Mainland China'}       21-Jan-2020           9           10            0           0   
    1      {'Yunnan'  }     {'Mainland China'}       21-Jan-2020           1            0            0           0   
    2      {'Beijing' }     {'Mainland China'}       21-Jan-2020          10            0            0           0   
    3      {'Taiwan'  }     {'Taiwan'        }       21-Jan-2020           1            0            0           0   
    4      {'Jilin'   }     {'Mainland China'}       21-Jan-2020           0            1            0           0   

I cannot get the variable names to import correctly or parse correctly. I added them manually.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Hai Luu 2020-2-15

Cool. Any possible way to classify the people come from Main Land, Taiwan,.... for instance.?

Star Strider 2020-2-15

在 MATLAB Online 中打开

I am not certain what you mean by ‘classify’. If you want to assign numbers to them, use the findgroups function.

For example —

CountryID = findgroups(COVID19(:,3));

You can do the same for 'Province/State' by referring to column 2 instead.

To combine them, use either of these:

CountryStateID = findgroups(COVID19(:,[2 3]));
CountryStateID = findgroups(COVID19(:,2), COVID19(:,3));

Both produce the same result.

There are other options as well. See: Grouping and Binning Data in the Preprocessing Data documentation section.

请先登录，再进行评论。

Answer 2

Jon 2020-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505526-how-can-i-seperate-these-number-from-a-cell-and-put-it-into-a-matrix#answer_415606

You will not be able to put your data from the cell array you show to a matrix because you have both numeric and non-numeric data in your cell array and a MATLAB matrix can be either numeric or non-numeric but not both.

I suggest instead that you store your data in a table where it will be very natural to work with it

2 个评论
显示无隐藏无

Hai Luu 2020-2-15

test1.xlsx

the reason I want to put it into a matrix is because I want to do something with machine learning :D. I have tried put numbers like this file but with systax cell2mat, I still cannot put it into a matrix.