Indexing between numerical and cell arrays
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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!
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1153518/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1153523/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1153528/image.png)
4 comentarios
dpb
el 12 de Oct. de 2022
"...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
Respuestas (0)
Ver también
Categorías
Más información sobre Data Type Conversion en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!