if you just want to sum by the group here is how you do it
sumA = grpstats(A(:,2),A(:,1),{@sum})
If later you want to calculate more statistic for each group determined in first column you can still use grpstat. for example:
[sumA,meanA,stdA,count]=grpstats(A(:,2),A(:,1),{@sum, 'mean','std', @numel})
where sumA stores the sum and meanA stores the mean and stdA stores the standard deviation for each group.
By group, I mean those that have 733943 in first column are considered one group and those having 734005 in their first column are considered another group.
actually by passing the function handle you can do any arbitrary operation that you want, based on each group separately.
Here are the results
results=table(num2str(unique(A(:,1))),count,sumA,meanA,stdA, ...
'VariableNames',{'group','count','sum','mean','std'})
results =
group count sum mean std
______ _____ _______ _______ _______
733943 3 1.8889 0.62962 0.78209
733949 1 3.0025 3.0025 0
733967 1 0.25892 0.25892 0
733988 1 1.5226 1.5226 0
733998 1 1.8316 1.8316 0
734005 3 5.6437 1.8812 0.8518
734020 4 4.8649 1.2162 1.1419
734044 2 2.9196 1.4598 0.432
734052 6 5.0248 0.83746 1.5723
734053 1 0.2708 0.2708 0
734082 8 11.659 1.4574 1.1591
734108 2 2.7792 1.3896 0.2677
734117 1 0.94883 0.94883 0
734128 1 1.6262 1.6262 0
734142 1 1.5916 1.5916 0
734171 7 5.0134 0.7162 0.93109
