Convert cell array to numerical array while keeping format and removing NAN

12 次查看（过去 30 天）
Oscar Hernandez
Oscar Hernandez 2015-10-1
回答： Oscar Hernandez 2015-10-2
I have a cell array comprised of a single column and many rows. Some rows have 'NAN' and some have numbers such as 42.54. I want to extract the data from this cell array while keeping the format. I also want to get rid of the NAN values. I don't care if the NAN values are removed completely or replaced with 0. A for loop was ineffective and took to long. I tried isnan and isfinite, but they did not seem to remove the nan. I also tried cell2mat but that removes the format of my column and puts every character together. My cell looks something like this:
'NAN'
'NAN'
'NAN'
'NAN'
'NAN'
'NAN'
'NAN'
'43.16'
'43.16'
'43.1'
'43.1'
'43.08'
'43.08'
'43.06'
'NAN'
'NAN'
'NAN'
'43.1'
'43.1'
'43.08'
'43.08'
However there are thousands of data points and hundreds of 'NAN' scattered throughout.
Thank you

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

采纳的回答

Walter Roberson
Walter Roberson 2015-10-1
T = str2double(YourCellArray);
T(isnan(T)) = [];

更多回答（1 个）

Oscar Hernandez
Oscar Hernandez 2015-10-2
Awesome, thank you Walter Roberson

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by