Yes, this is the good one Arun! Thank you very much.
I tried each solution but yours was the best. It works well.
Thanks anyway for all your replies!
--
View this message in context:
http://r.789695.n4.nabble.com/remove-duplicated-row-according-to-NA-condition-tp4691362p4691422.html
Sent fr
Hi,
May be this helps:
data1 <- data[with(data, order(col1, col2,1*is.na(col3))),]
data1[!duplicated(data1[,1:2]),]
A.K.
On Wednesday, May 28, 2014 11:28 AM, jeff6868
wrote:
Hi everybody,
I have a little problem in my R-code which seems be easy to solve, but I
wasn't able to find the soluti
It would help if you said what you want done when none or all or some
of the col1-col2 duplicates have NA's in the col3. E.g., what do you
want the function to do for the following input?
> data2 <- data.frame(col1=c("a","a","a","b","b","c","c","d","d","e"),
col2=c(1,1,1,2,2,3,3,4,4,5),
c
Hi!
How about trying this:
data[ data$col1!=data$col2 & !is.na(data$col3), ]
col1 col2 col3
2a1 ST001
3b2 ST002
HTH, Kimmo
28.05.2014 15:35, jeff6868 wrote:
> Hi everybody,
>
> I have a little problem in my R-code which seems be easy to solve, but I
> wasn't able to find t
Hi everybody,
I have a little problem in my R-code which seems be easy to solve, but I
wasn't able to find the solution by myself for the moment.
Here's an example of the form of my data:
data <-
data.frame(col1=c("a","a","b","b"),col2=c(1,1,2,2),col3=c(NA,"ST001","ST002",NA))
I would like to r
5 matches
Mail list logo
