Indexing between numerical and cell arrays

1 次查看（过去 30 天）

Ben 2022-10-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1823648-indexing-between-numerical-and-cell-arrays

评论： dpb 2022-10-12

Hi,

I have the below three variables that originally come from numerical and raw outputs from reading a spreadsheet using the xlsread function. The third variable ('NumcCrop") is a subset of "Numc" that was created by removing rows where selected columns had NaN values. I would like to truncate the first variable ("SubRaw") in the same way so that I can extract the names from column two relating to the subset identified in the third variables.

I can't simply remove the rows in the same way as I did to create ('NumcCrop") as the 'raw' output when reading the file only has NaNs for empty cells, whereas the "Numc" variable has NaNs for all non-numerical elements.

It seems like something that should have a simple solution but I have been running into issues with incorrect or inconistent data types when trying to convert the cell arrays into something where they can be indexed or concatenated together. I've tried various cellfun methods including find and ismember but none seem to work.

Thanks a lot!