清空筛选条件
清空筛选条件

Remove NAN from cell array, and calculate the average of each column through each cell

4 次查看（过去 30 天）
F Z
F Z 2015-4-22
评论： F Z 2015-4-23
I have a 1 x 17 cell array called M, with each cell containing a 16 x 27 Matrix. I need to get rid of NaN in each cell. I tried this code:
for i=1:length(M) ind = isnan(M{1}); M{i}(ind)=[]; end
But the cells are reshaped to rows (1x240) and I need the expected result to be a p*q Matrix. Once the expected result is obtained, I have to go through each cell and calculate the average of each column q Any help please?
  2 个评论
Punit
Punit 2015-4-22
First of all
ind = isnan(M{1});
should be ind = isnan(M{i});
Also, try replacing M{i}(ind) = 0;
then sum(M(:,q))/length(find(~ind(:,q))) would be the average of column q
Guillaume
Guillaume 2015-4-22
编辑：Guillaume 2015-4-22
What does 'get rid of NaN' mean? Obviously, you need something in that matrix entry where the NaN is: a number, NaN, Inf or +Inf are the only possibilities.
If you remove the matrix element, then the matrix cannot be square anymore.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2015-4-22
As of version 2015a, mean can ignore NaNs (in earlier version you had to use nanmean in the stat toolbox).
So the simplest way to calculate the mean is with:
colmeans = cellfun(@(m) mean(m, 'omitnan'), M, 'UniformOutput', false);
celldisp(colmeans);
Even simpler, would be to just store all your matrices as a 3D matrix (of size 16 x 27 x 17) and avoid cell arrays entirely:
M = cat(3, M{:});
colmeans = mean(M, 'omitnan')
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by