try something like this:
rw1 <- c("AA", "AG", "GG", NA, NA)
rw2 <- c(NA, "AG", "GG", "AA", NA)
#######
rw <- rw1
rw[is.na(rw)] <- rw2[is.na(rw)]
rw
I hope it helps.
Best,
Dimitris
----
Dimitris Rizopoulos
Ph.D. Student
Biostatistical Centre
School of Public Health
Catholic University of Leuven
Address: Kapucijnenvoer 35, Leuven, Belgium
Tel: +32/(0)16/336899
Fax: +32/(0)16/337015
Web: http://med.kuleuven.be/biostat/
http://www.student.kuleuven.be/~m0390867/dimitris.htm
----- Original Message -----
From: "Iris Kolder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 11, 2007 3:32 PM
Subject: [R] Matching and merging two rows with missing values
> Hello,
>
>
>
> I have two rows which are almost identical but miss different values
> at
> different locations. I would like to merge these two rows so that
> the
> missing values are replaced by the element in the same column on the
> other
> row making one row. If both rows contain a NA, NA remains in the
> output.
>
>
>
> 1 2 3 4 5
>
> Row1 AA AG GG NA NA
>
> Row2 NA AG GG AA NA
>
>
>
> The output i want is one row
>
>
>
> 1 2 3 4 5
>
> Row AA AG GG AA NA
>
>
>
> I tried to use the functions match,grep, and gsub but I can't seem
> to make
> it work I would appreciate any suggestions!
>
>
>
> Best regards,
>
>
>
> Iris Kolder
>
>
> [[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.
>
Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
______________________________________________
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.
