How do I count how many NaN's in a data cell?

Question

Sarah Mullin 2021-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/752134-how-do-i-count-how-many-nan-s-in-a-data-cell

评论： Sarah Mullin 2021-2-22

I was given a csv file by my teacher to download and i read it using this code below:

clear;

fclose all;

fileID = fopen('accidents_2017.csv');

text1 = textscan(fileID,'%s%s%s%s%s%s%d%d%s%d%d%d%d%f%f','HeaderLines',1,'Delimiter',{','},'EmptyValue',NaN);

fclose(fileID);

I tried using the function isnan(text1) but it tells me "Undefined function 'isnan' for input arguments of type 'cell'. " Is there a different function I should be using>

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/752134-how-do-i-count-how-many-nan-s-in-a-data-cell#answer_629544

在 MATLAB Online 中打开

nnz(isnan(text1{7})

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sarah Mullin 2021-2-22

Will this only work for columns that are numerical values? I tried converting column 1(which are strings) to numbers with str2double(text1{1}) and it worked. then when i do nnzisnan(text1{1}) it gives me the error of "Undefined function 'isnan' for input arguments of type 'cell'."

请先登录，再进行评论。