Pick up gropu of values in multiple arrays

Hi,

I have a data array like this.

[X=B T A

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

0 1 0

0 1 0

0 1 0

0 1 0

0 1 0

0 1 0

0 1 0

0 0 1

0 0 1

0 1 0

1 0 0

1 0 0];

In this I have to pick up the values from group sum of X(:,1)=[10 2];

X(:,2)=[7 1]; X(:,3)=[2];

Now I need to pick up the triad=[10 7 2 ]; Bold values

And with the condition X(:,1) groupsum >=3 then only consider that .

Also, consider B (groupsum of >=3) next corresposning T (doesnt have any condition) and T corresponding A(gropu sum can be >1)

Thanks,

[Fifteen12]

It's not clear to me what you're asking. You might want to rephrase your question for clarity. When you say group sum of X(:, 1) = [10 2] are you trying to find the sum of all X values from rows 1 to 10, and columns 1 to 2? If so that would be sum(X(1:10, 1:2))

[Poorna Durga Geesupalli]

Hi John,

Okay let me repharse my sentence.

I need to pick the values from [B T A].

When we do the group sum, the values from B has to pick up where the group sum is >=3.

Here is the example excel sheet for your better understading.

Thank you,

[Voss]

I gather that "group sum" means the number of consecutive 1's in a given column.

[Fifteen12]

Unfortunately I'm still not following. You say you need to pick values from B where the group sum is >= 3, can you explain what you mean? You can pick values from B, are you saying you need to pick a random assortment of values until that collected set has a group sum greater than or equal to 3?

[Poorna Durga Geesupalli]

Hi, john

I rearranged my data for your better understading. Now, data consits of single column.

Please find the excel sheet atttached here. Follow only sheet 2 values

Answer 1

[Rohit]

Hi,

I am adding a sample example below which has a 2D array ‘x’ (you can create this from the 'XLSX' file) and find the sum of ones in a consecutive group with the constraint of >=min (the min value) using the “givegroupsum()” function. I assume that ‘x’ only contains zeros and ones. You can take it as a reference and modify it based on your use case.

x=[[1	0	0]
[1	0	0]
[1	0	0]
[1	0	0]
[0	0	0]
[1	0	0]
[1	0	0]
[1	0	0]
[1	0	0]
[1	0	0]
[0	1	0]
[0	1	0]
[0	1	0]
[0	1	0]
[0	1	0]
[0	1	0]
[0	1	0]
[0	0	1]
[0	0	1]
[0	1	0]
[1	0	0]
[1	0	0]];

result = givegroupsum(x(:,1),3);
disp(result);

     4
     5

function groupsum = givegroupsum(arr,min)
    if(nargin<2)
        min=1;
    end
    countgrp=0;
    consec=0;
    conseccount=0;
    for i=1:length(arr)
        if(~consec && arr(i))
            countgrp=countgrp+1;
        end
        if(arr(i))
            conseccount=conseccount+1;
        end
        if(consec && ~arr(i))
            if(conseccount<min)
                countgrp=countgrp-1;
            end
        end
        %updating values based on currect item
        consec=arr(i);
        if(~arr(i))
            conseccount=0;
        end
    end
    if(consec && conseccount<min)
        countgrp=countgrp-1;
    end
    groupsum=zeros(countgrp,1);
    
    consec=0;
    conseccount=0;
    j=1;
    for i=1:length(arr)
        if(arr(i))
            conseccount=conseccount+1;
        end
        if(consec && ~arr(i))
            if(conseccount>=min)
                %adding the value to results array
                groupsum(j)=conseccount;
                j=j+1;
            end
        end
        consec=arr(i);
        if(~arr(i))
            conseccount=0;
        end
    end
    if(consec && conseccount>=min)
        groupsum(j)=conseccount;
    end
end

You can refer to the below documentation of 'readmatrix' to read the data from 'XLSX' file:

https://www.mathworks.com/help/matlab/ref/readmatrix.html