how to put in zeros in the empty spaces of a matrix read by xlsread()?

Question

Debanjan Dasgupta 2014-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/157382-how-to-put-in-zeros-in-the-empty-spaces-of-a-matrix-read-by-xlsread

评论： Debanjan Dasgupta 2014-10-4

I have a xlsx data sheet which needs to be imported as a matrix. I am using xlsread for the same. But many spaces in the dataset are empty which are read as Nan. I want to replace these values with zeros. I have tried to initialize the matrix as:

a = magic(100); a = xlsread(filename.xlsx);

But still the same problem as I believe the matrix gets resized after the import.

Debanjan

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

请先登录，再进行评论。

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

Answer 1

per isakson 2014-10-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/157382-how-to-put-in-zeros-in-the-empty-spaces-of-a-matrix-read-by-xlsread#answer_153923

编辑：per isakson 2014-10-4

在 MATLAB Online 中打开

Try

M(isnan(M))=0;

&nbsp

In response to comments:

See the on-line documentation on xlsread. This is copied from one of its example

    values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
    headers = {'First', 'Second', 'Third'};
    xlswrite('myExample.xlsx', [headers; values]);
    [ndata, text, alldata] = xlsread('myExample.xlsx')

it returns

    ndata =
         1     2     3
         4     5   NaN
         7     8     9
    text = 
        'First'    'Second'    'Third'
        ''         ''          ''     
        ''         ''          'x'    
    alldata = 
        'First'    'Second'    'Third'
        [    1]    [     2]    [    3]
        [    4]    [     5]    'x'    
        [    7]    [     8]    [    9]

You are right ndata doesn't include the "header-rows", alldata does.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Debanjan Dasgupta 2014-10-4

Thankx a lot per isakson. But after these steps, the size function is giving me errors. command used: rows = size(a, 1) Error: Subscript indices must either be real positive integers or logicals.

Error in buzsakiIInetwork_coherence_multifiles_multirows (line 26) rows = size(a, 1)

Debanjan Dasgupta 2014-10-4

I could do it.. Actually there was some old variable size in the workspace but not in my script which was creating the trouble... Thankx a lot guys for all the help.. :)

请先登录，再进行评论。