[R] Matching and merging two rows with missing values

Dimitris Rizopoulos dimitris.rizopoulos at med.kuleuven.be
Thu Oct 11 15:51:46 CEST 2007


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" <I.C.Kolder at amc.uva.nl>
To: <r-help at stat.math.ethz.ch>
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 at 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



More information about the R-help mailing list