Hi Dennis Thank you so much it helped me to go a step ahead. Regarding comparisions, here is what I want to do. If value of imarkP1 = 22, imarkP2 = 11, and mark1= 12 then the value of mark1 should be coded as 1 (means that all three conditions must be satified to get a code "1") imarkP1 = 22, imarkP2= 11, and mark1= 22 then the value mark should be coded as 2 (imarkP1 = 22, imparkP2=11, and mark1= 11 then the value of mark should be coded as 0) will go to else imarkP1= 33, imarkP2= 14, and mark=13 the value of mark1 should be coded as 0 imarkP1=33, imarkP2=14, and mark=34, the value of mark1 should be coded as 1 ..... I do have more such condtions I tried the following for the first conditon listed above, but could not get the result I want. I do not know what is wrong. Ifelse (imarkP1==22|imarkP2==11|mark1==12,1,0) I could not go forward.............. Thank you so much for the help. Best regards; Umesh R
_____ From: Dennis Murphy [mailto:djmu...@gmail.com] Sent: Friday, February 18, 2011 12:28 AM Cc: r-help@r-project.org Subject: Re: [R] recoding a data in different way: please help Hi: This is as far as I could get: df <- read.table(textConnection(" Individual Parent1 Parent2 mark1 mark2 1 0 0 12 11 2 0 0 11 22 3 0 0 13 22 4 0 0 13 11 5 1 2 11 12 6 1 2 12 12 7 3 4 11 12 8 3 4 13 12 9 1 4 11 12 10 1 4 11 12"), header = TRUE) df2 <- transform(df, Parent1 = replace(Parent1, Parent1 == 0, NA), Parent2 = replace(Parent2, Parent2 == 0, NA)) df2 <- transform(df2, imark1p1 = df2$mark1[df2$Parent1], # Parent 1's mark1 imark1p2 = df2$mark1[df2$Parent2], # Parent 2's mark1 imark2p1 = df2$mark2[df2$Parent1], # Parent 1's mark2 imark2p2 = df2$mark2[df2$Parent2]) # Parent 2's mark2 I created df2 so as not to overwrite the original in case of a mistake. At this point, you have several sets of vectors that you can compare; e.g., mark1 with imark1p1 and imark1p2. Like Josh, I couldn't make heads or tails out of what these logical tests were meant to output, but perhaps this gives you a broader template with which to work. At this point, you can probably remove the rows corresponding to the parents. I believe ifelse() is your friend here - it can perform logical tests in a vectorized fashion. As long as the tests are consistent from one individual to the next, it's likely to be an efficient route. HTH, Dennis On Thu, Feb 17, 2011 at 6:21 PM Dear R users The following question looks simple but I have spend alot of time to solve it. I would highly appeciate your help. I have following dataset from family dataset : Here we have individuals and their two parents and their marker scores (marker1, marker2,....and so on). 0 means that their parent information not available. Individual Parent1 Parent2 mark1 mark2 1 0 0 12 11 2 0 0 11 22 3 0 0 13 22 4 0 0 13 11 5 1 2 11 12 6 1 2 12 12 7 3 4 11 12 8 3 4 13 12 9 1 4 11 12 10 1 4 11 12 I want to recode mark1 and other mark2.....and so on column by looking indvidual parent (Parent1 and Parent2). For example Take case of Individual 5, who's Parent 1 is 1 (has mark1 score 12) and Parent 2 is 2 (has mark1 score 11). Individual 5 has mark1 score 11. Suppose I have following condition to recode Individual 5's mark1 score: For mark1 variable, If Parent1 score "11" and Parent2 score "22" and recode indvidual 5's score, "12"=1, else 0 If Parent1 score "12" and Parent2 score "22" and recode individual 5's score, "22"=1, "12"= 0.5, else 0 .........................more conditions Similarly the pointer should move from individual 5 to n individuals at the end of the file. Thank you in advance Umesh R [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. _____ No virus found in this message. Checked by AVG - www.avg.com [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.