index rows containing specific value

Question

Oliver Kumar 2016-3-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275535-index-rows-containing-specific-value

编辑： Oliver Kumar 2016-3-26

Hello everyone

I've a cell 352X79. The first row contains the marker names. The first column contains the filenames.

Now i need to find all the NaN values and write the row containing the NaN to a new variable X, so I have all colums with NaN values in one variable.

Or is it even possible to get the filename and the names of the NaN marker into the new variable? So it woul look like X(1,1) = filname, X(1,2) = markar_Name etc.

Thanks for your help!

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

Stephen23 2016-3-26

"I've a cell 352X79. The first row contains the marker names. The first column contains the filenames."

You would be much better off using a table.

Alternatively you could use a simple numeric array and two cell arrays (See my answer).

Oliver Kumar 2016-3-26

Hi Stephen

Ok, I have all the nummeric data also as a matrix. Column 1 has the numbers for marker1, Column2 for marker2, etc. So I could build a table out of that data. And I have a Cell with all the VPN.

What would be the next step after I've build the table? Thank you!

请先登录，再进行评论。

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

Answer 1

Stephen23 2016-3-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275535-index-rows-containing-specific-value#answer_215110

编辑：Stephen23 2016-3-26

在 MATLAB Online 中打开

Using a cell array is a total waste of MATLAB's abilites for processing numeric arrays quickly and efficiently. You would be much better off storing the data in three arrays (col-names, row-names, numeric data), or (even better) in a table. Whatever method you use for processing a cell array of mixed data is going to be much more complicated that if you simply stored your numeric data in a numeric array.

Here is an example showing how simple this task can be when the data is stored in a simple numeric array:

colC = {'marker1',' marker2'};
rowC = {'testvpn1','testvpn2','testvpn3'};
mat = [5,NaN;1,0;6,NaN] % your data
[idxR,idxC] = find(isnan(mat))
[colC(idxC),rowC(idxR)]