how to remove NAN from a double inside a cell array?

8 次查看（过去 30 天）
Farshid Daryabor
Farshid Daryabor 2020-1-23
评论： Justin Xuereb 2022-4-19
can some one how can I remove NAN from a double inside a cell array (attached file)?
  5 个评论
显示 3更早的评论
Guillaume
Guillaume 2020-1-23
You haven't answered my question and we can't really answer yours until you do. You may get some answers that do something but possibly not what you want.
Given the matrix M in my example, you could
  • Delete rows that have any NaN, in my example this would also remove the numbers 7, 8, 9 and 10, ending up with:
M = [1 2 3
4 5 6]; %all the other rows have NaN
  • Delete rows that are all NaN, this still leaves some NaN, but doesn't delete any number, ending up with:
M = [1 2 3
4 5 6
7 8 NaN
9 10 NaN
11 NaN NaN];
  • Delete columns that have any NaN, in my example this delete all columns, ending up with
M = []
  • Delete columns that are all NaN. In my example this doesn't delete any rows. You get the same M
  • Delete all the NaNs, since you can't have holes in a matrix, you'd end up with a vector:
M = [1 4 7 9 11 2 5 8 10 3 6] %in this order
  • do something else that you haven't explained.
So, please clarify.
Farshid Daryabor
Farshid Daryabor 2020-1-23
Each columns are corresponds to a latitude and longitude to introduce seawater temperature profiles. I want to keep the matrix structure as is, but delete the NaNs from each column.
I tried to interpolate NaNs, but problem is converting cell to number, I used the following function, encountering with error, Out = cellfun(@cell2mat, (inpaint_nans(mycelldata,0)) ); Any comment to improve.

请先登录，再进行评论。

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

回答（2 个）

Hamdan Almusaibeli
>> uq =
1×3 cell array
{3×3 double} {7×3 double} {7×3 double}
>> uq{1}
ans =
0.5000 0.3333 0.0500
2.5000 0.3333 0.0500
2.5000 0.3333 0.0500
NaN NaN NaN
NaN NaN NaN
NaN NaN NaN
NaN NaN NaN
NaN NaN NaN
uq{1}(isnan(uq{1}(:,1)),:) = []
>> uq{1}
ans =
0.5000 0.3333 0.0500
2.5000 0.3333 0.0500
2.5000 0.3333 0.0500
KSSV
KSSV 2020-1-23
You can fill the nans using fillmissing. Also you can do interpolation ang the values at the places of nan. Read about interp1.
  7 个评论
显示 5更早的评论
Guillaume
Guillaume 2020-1-23
Note that this is a solution to my second bullet point.
A better way (probably faster) to do the above is:
newA = A(~any(isnan(A), 2), :)

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by