counting the number of elements under multiple conditions

조회 수: 121 (최근 30일)
Alexandra Brian
Alexandra Brian 2017년 2월 1일
댓글: Alexandra Brian 2017년 2월 3일
Hi there,
I need to count the number of elements in column y that confirm two conditions:
  1. When the column x is greater than 0.
  2. When column y is greater than 0.
clear all
rB5_SMA50Diff14 = xlsread('xy.xlsx');
x = xlsread('xy.xlsx', 'B:B');
y = xlsread('xy.xlsx', 'A:A');
rows = x(:,5)>0; %Logical vector with the rows which satisfy all conditions.
if any(rows) % True if there is at least 1 row which meats the condition.
Winners= numel(y(rows)>0); %Counts the number of elements that are greater than 0.
end
My code returns the total number of elements in column y that fall under rows where column x > 0.
Can you please help me find the number of elements in column y that are > 0 and correspond to column x when column x > 0.
Best, A

채택된 답변

Image Analyst
Image Analyst 2017년 2월 2일
Assuming x and y are 1-D column vectors and are the same length, why can't you just get the count like this:
Winners = sum(x>0 & y>0)

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Propagation and Channel Models에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by