I have a data set like this, How can i delete raw ofs values less than 10, and T values which are zero, How can i sum s values which are related to same T values ?

          S             T
        878.00          9.00
          1.00         12.00
        166.00         12.00
        143.00         12.00
        160.00         12.00
        173.00         12.00
        144.00         12.00
       3229.00             0
        150.00         12.00
        144.00         12.00
        122.00         13.00
        132.00         13.00
          2.00         13.00
        138.00         13.00
        139.00         14.00
        133.00         14.00
          4.00         14.00
        137.00         14.00
       2473.00             0
        118.00         14.00
        127.00         14.00

Answer 1

[C.J. Harris]

One way to do it:

data =   [878.00          9.00
          1.00         12.00
        166.00         12.00
        143.00         12.00
        160.00         12.00
        173.00         12.00
        144.00         12.00
       3229.00             0
        150.00         12.00
        144.00         12.00
        122.00         13.00
        132.00         13.00
          2.00         13.00
        138.00         13.00
        139.00         14.00
        133.00         14.00
          4.00         14.00
        137.00         14.00
       2473.00             0
        118.00         14.00
        127.00         14.00];

% Remove S values less than 10    
data = data(data(:,1)>=10,:);

% Remove T values that are zero
data = data(data(:,2)~=0,:);

% Sum equal elements of T
elems    = unique(data(:,2));
elemSums = arrayfun(@(x)(sum(data(data(:,2)==x))), elems);

% Display results
fprintf('T value: %.2f | Sum: %.2f\n', [elems elemSums].')

Result:

T value: 9.00 | Sum: 878.00
T value: 12.00 | Sum: 1080.00
T value: 13.00 | Sum: 392.00
T value: 14.00 | Sum: 654.00

[Nadeera Gunartna]

Thank you very much Harris. I appreciate it

[Lakshmi Navya Sunkara]

Hello, I tried this in different way and would like to share it

 k = find(S(S<10));
 P = find(T(T==0));
 S(k;:)=[];
 T(k;:)=[];
 sum = sum(S(S==T))