counting density at attribute value ranges
harris
New Altair Community Member
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
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
Tagged:
0