Delete rows or column with NaN for a cell array

I really thanks in advance any help. How can I delete NaN's of column from the cell attached as example file here.
Thanks

 採用された回答

Bhaskar R
Bhaskar R 2020 年 2 月 17 日

1 投票

nan_loc = cellfun(@(x)any(isnan(x)), P_QC, 'UniformOutput', false);
for ii=1:length(P_QC)
P_QC{ii}(:,nan_loc{ii}) = [];
end

4 件のコメント

Farshid Daryabor
Farshid Daryabor 2020 年 2 月 17 日
Dear Bhaskar,
Thanks, but now by removing NaN I have to also remove the longitude corresponding to the NaN. Could you please tell me how can I do it. please find lon as attached you can compare with P_QC
Farshid Daryabor
Farshid Daryabor 2020 年 2 月 17 日
Dear Bhaskar,
I thinks the following cod is working,
for ii=1:length(P_QC)
lon{ii}(nan_loc{ii}) = [];
end
Bhaskar R
Bhaskar R 2020 年 2 月 17 日
Yeah, same applicable for lon
Farshid Daryabor
Farshid Daryabor 2020 年 2 月 17 日
Thanks

サインインしてコメントする。

その他の回答 (1 件)

Pruthvi G
Pruthvi G 2020 年 3 月 12 日

0 投票

Data(cellfun(@(cell) any(isnan(cell(:))),Data))={''};

カテゴリ

タグ

質問済み:

2020 年 2 月 17 日

回答済み:

2020 年 3 月 12 日

Community Treasure Hunt

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

Start Hunting!

Translated by