categorize values based on given criteria

[nynamyna]

Hello everybody

I have categories like below

values> .75
values> .5
values > .25
values > 0
vallues = 0
Code:
I have a data like below

64080	0.4	1	90913
64080	0.4	1	90913
64080	0.4	0	94876
64083	1	1	90913
64083	1	1	90913
64085	1	0	90913
64085	1	0	3462

So for each value in column1 if the value in column3 is 1 then only unique values in column4 should be counted and classified under different categories

for example
90913 should be counted only once for 64080 and should be categorized under
values > 0.25 = 1
90913 should be counted only once for 64083 and should be categorized under
values> .75 = 1
90913 should not be counted at all for 64085 because the value in column3 is 0

Similarly for each value in column1 the values should be counted and added under different categories.

Thanks,
vb

 

[Aladin Akyurek]

1) Care to post the desired results?

2) Clarify a bit more how categorization proceeds for it's unclear how 'values' correlates with the data.

 

[nynamyna]

Sorry for not being clear....the categorization is based on the values in column2.

So for each item in column1 (zipcode),

if column3 value is 1 then
if value in column4 is unique (which has never appeared before for that zipcode) then
if column2 value is >0.75 then

1 should be added under values> 0.75 column
else if column2 value is >0.5 and <=0.75then 1 should be added under values > 0.5 column ....

Zipcode
64080	0.4	1	90913
64080	0.4	1	90913
64080	0.4	0	94876
64083	1	1	90913
64083	1	1	90913
64085	1	0	90913
64085	1	0	3462

values> .75	   values> .5   values > .25    values > 0    values = 0
10                   10               10               10               10

 

[Aladin Akyurek]

Do not use arbitrary numbers when they would confuse. What are all those 10's, that's, how do I correlate such results with the data you have posted?

 

[nynamyna]

sorry again...I just gave an example as 10.....after adding a total number should appear under each column..that what I wanted to convey. Please let me know if you need more details

 

[nynamyna]

Can someone help me regarding this please....