Indexing between numerical and cell arrays

1 次查看（过去 30 天）
Ben
Ben 2022-10-12
评论： 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!
  4 个评论
显示 2更早的评论
Stephen23
Stephen23 2022-10-12
@Ben: please upload a sample data file by clicking the paperclip button.
Most likely you should be using READTABLE et al.
dpb
dpb 2022-10-12
"...originally come from numerical and raw outputs from reading a spreadsheet using the xlsread function."
And, as @Stephen23 notes, there's the root of all your trouble--using the deprecated xlsread function instead of readtable

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by