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

For elements in two arrays/columns of numbers, how can I find the average only if both elements are non-zero?

2 次查看（过去 30 天）
Srh Fwl
Srh Fwl 2020-7-21
评论： Srh Fwl 2020-7-21
I have many external files. Each file contains two long columns of numbers, like this:
1 2
11 12
6 48
9 0.0
3 0.5
I can read each file in. Now I want to calculate the average of each row. In the column of results, for example, the elements would be:
(1 + 2 / 2)
(11 + 12 / 2)
(6 + 48 / 2) ...
The problem is, I don't want to take the average of rows where one element is zero. For example, I want the row that has
9 0.0
to be "9." Does anyone know how I can do, "calculate the average of each row, but leave the row alone if one element is zero?" I'm using 2016a. Thank you for any advice.

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

采纳的回答

madhan ravi
madhan ravi 2020-7-21
matrix(matrix == 0) = nan
nanmean(matrix, 2)
  5 个评论
显示 3更早的评论
Srh Fwl
Srh Fwl 2020-7-21
Thank you, @madhan ravi. I found that I couldn't use "nanmean" because I don't have the statistics toolbox. However, I found an alternative and it works with the first part of your suggestion. Really appreciate it.
A = [3; 4; 5; 0]
B = [7; 8; 9; 10]
C = [A(:), B(:)]
C(C == 0) = nan
D = mean(C,2,'omitnan')

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by