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 ?
2 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
C.J. Harris
2016-1-21
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
2 个评论
Lakshmi Navya Sunkara
2016-2-23
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))
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Point Cloud Processing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!