Hi,
datA<-read.table(text="
Tdate symbol TA
12/12/12 AX 123
12/11/12 ZZ A4R
12/12/12 WQ B8R
",sep="",header=TRUE,stringsAsFactors=FALSE)
datB<- read.table(text="
Tdate symbol TA
12/12/12 AX 123
12/11/12 ZZ A4R
",sep="",header=TRUE,stringsAsFactors=FALSE)
library(sqldf)
sqldf('SELECT * FROM datA EXCEPT SELECT * FROM datB')
# Tdate symbol TA
#1 12/12/12 WQ B8R
#or
datA[!as.character(with(datA,interaction(Tdate,symbol,TA)))%in%
as.character(with(datB,interaction(Tdate,symbol,TA))),]
# Tdate symbol TA
#3 12/12/12 WQ B8R
A.K.
----- Original Message -----
From: "Mossadegh, Ramine N." <ramine.mossad...@finra.org>
To: arun <smartpink...@yahoo.com>
Cc:
Sent: Monday, May 13, 2013 4:17 PM
Subject: RE: [R] how to merge 2 data frame if you want to exclude mutual obs
Hi Arun,
I am trying to replicate sas code in R.
So if in data frame A you have
Tdate symbol TA
12/12/12 AX 123
12/11/12 ZZ A4R
12/12/12 WQ B8R
Data frame B
Tdate symbol TA
12/12/12 AX 123
12/11/12 ZZ A4R
I want to end up w/
Tdate symbol TA
12/12/12 WQ B8R
All obs not in B
Thanks
-----Original Message-----
From: arun [mailto:smartpink...@yahoo.com]
Sent: Monday, May 13, 2013 4:13 PM
To: Mossadegh, Ramine N.
Subject: Re: [R] how to merge 2 data frame if you want to exclude mutual obs
HI,
Please provide a reproducible example and the output you expected.
----- Original Message -----
From: ramoss <ramine.mossad...@finra.org>
To: r-help@r-project.org
Cc:
Sent: Monday, May 13, 2013 3:22 PM
Subject: [R] how to merge 2 data frame if you want to exclude mutual obs
In the example below, I am merging 2 data frames & I want everything in the
first one(all)
all2 <- merge(all,spets, by.x=c("tdate","symbol"),
by.y=c("tdate","symbol"),all.x=TRUE)
What if I want to exclude everything in y? I tried below but doesn't seem to
work.
all2 <- merge(all,spets, by.x=c("tdate","symbol"),
by.y=c("tdate","symbol"),all.y=FALSE)
In SAS I would do:
All2;
merge all(in=a)
spetz(in=b)
;
by tdate symbol;
if a and not b;
run;
How can I do this in R?
Thanks ahead for your help.
--
View this message in context:
http://r.789695.n4.nabble.com/how-to-merge-2-data-frame-if-you-want-to-exclude-mutual-obs-tp4666975.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
Confidentiality Notice: This email, including attachments, may include
non-public, proprietary, confidential or legally privileged information. If
you are not an intended recipient or an authorized agent of an intended
recipient, you are hereby notified that any dissemination, distribution or
copying of the information contained in or transmitted with this e-mail is
unauthorized and strictly prohibited. If you have received this email in
error, please notify the sender by replying to this message and permanently
delete this e-mail, its attachments, and any copies of it immediately. You
should not retain, copy or use this e-mail or any attachment for any purpose,
nor disclose all or any part of the contents to any other person. Thank you
______________________________________________
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.
