counting density at attribute value ranges

harrisharris Member Posts: 8 Contributor II
edited November 2018 in Help
Hello all.

I have an example set with n numeric attributes and m examples. For each example, I need to be able to count density (number) of its values at fixed value ranges which are same for all features (e.g. range1 0-0.3, range2 0.3-0.6, range3 0.6-1.0).

i.e. from input of the following kind:
id att1 att2 att3
1 0.1 0.1 0.1
2 0.1 0.5 0.5
3 0.1 0.5 0.8

the output should be:
id range1 range2 range3
1 3 0 0
2 1 2 0
3 1 1 1

or the same cumulatively:
id range1 range2 range3
1 3 3 3
2 1 3 3
3 1 2 3

Is there a way to do that ?
best, Harri S
Sign In or Register to comment.