Averaging data between two integer and corresponding column of a matrix

Question

Sudhir Rai 2023-3-21

编辑： Sudhir Rai 2023-3-23

I have this type of matrix

A = [1 2 3 4 5 6; 1.234 1.11 1.3 2.31 2.3 2.4]'

I want to average all data between two integer of 2nd column and corresponding data of firs clumn to form new matrix

Sudhir Rai 2023-3-23

For A = [1 2 3 4 5 6; 1.234 1.11 1.3 2.31 2.3 2.4]'

I need output B= [2 7.5; 1.21 2.33]'

i.e average (1.234 1.11 1.3) and corresponding 1st column average = avg(1 2 3)

(1.234 1.11 1.3) is between 1 & 2

similarly (2.31 2.3 2.4) is between 2&3

Answer 1

KSSV 2023-3-21

A = [1 2 3 4 5 6; 1.234 1.11 1.3 2.31 2.3 2.4]' ;
idx = fix(A(:,2))==2 ; 
mean(A(idx,1))
ans = 5

Sudhir Rai 2023-3-22

编辑：Sudhir Rai 2023-3-23

This not the out put I want

For A = [1 2 3 4 5 6; 1.234 1.11 1.3 2.31 2.3 2.4]'

I need output B= [2 7.5; 1.21 2.33]'

i.e average (1.234 1.11 1.3) and corresponding 1st column average = avg(1 2 3)

(1.234 1.11 1.3) is between 1 & 2

similarly (2.31 2.3 2.4) is between 2&3