Average a cell with ignoring NaN

6 次查看（过去 30 天）

显示更早的评论

Ahmad Bayhaqi 2021-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/816645-average-a-cell-with-ignoring-nan

评论： Jan 2021-4-30

采纳的回答： Jan

在 MATLAB Online 中打开

Hi all,

I want to average with ignoring the NaN. I used the script below:

Intens2 = cellfun(@(C) cellfun(@mean, C), new_table3.extData, 'uniform', 0)

and the and I do average to Intens2

Intens3=cellfun(@mean, Intens2);

Is there a way to average in Intens2 and Intens2 with ignoring NaN?

where I can put 'omitnan'?

Thank you very much,

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2021-4-29

Please post an example for your inputs.

请先登录，再进行评论。

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

采纳的回答

Jan 2021-4-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/816645-average-a-cell-with-ignoring-nan#answer_687690

在 MATLAB Online 中打开

C = {[1,2,4,6,NaN], [NaN, 2, 3, NaN]};
MC = cellfun(@(x) mean(x, 'omitnan'), C)
MC = 1×2
    3.2500    2.5000

2 个评论
显示无隐藏无

Ahmad Bayhaqi 2021-4-29

Hi @Jan, yes it works.

Thank you very much

Jan 2021-4-30

You are welcome. There are 3 nested cellfun calls in your code. Usually loops are faster than the nice cellfun. I'd post a loop method, if it is clear, what exactly your inputs are.

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Tables

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

Community Treasure Hunt

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

Start Hunting!

Translated by