Differentiating data per attribute
Hello all,
I have the following data
att1 att2 att3
1 8 9 9
2 9 10 8
So, attribute 1 can assume values 8 or 9, attribute 2 values 9 and 10, and attribute 3 values 8 and 9. Thing is, all those nines do not represent the same thing. How can I change those values in order to avoid conflict?
If I change all the nines at the same time it does not help me. In a way, I have "9 of attribute 1", "9 of attribute 2" and "9 of attribute 3". Same thing with 8 for attributes 1 and 3. How can map them (I tried the map operator and could not do it) into different numbers/representations to avoid confusion?
Regards,
Bernardo
I have the following data
att1 att2 att3
1 8 9 9
2 9 10 8
So, attribute 1 can assume values 8 or 9, attribute 2 values 9 and 10, and attribute 3 values 8 and 9. Thing is, all those nines do not represent the same thing. How can I change those values in order to avoid conflict?
If I change all the nines at the same time it does not help me. In a way, I have "9 of attribute 1", "9 of attribute 2" and "9 of attribute 3". Same thing with 8 for attributes 1 and 3. How can map them (I tried the map operator and could not do it) into different numbers/representations to avoid confusion?
Regards,
Bernardo