Dear "R Gurus",
I am having two dummy csv data sets A and B containing 19 and 15 cases/observations respectively. From the two data set 13 cases are intersection. From one of the two (any) data set, How do I then retrieve the unmerged data ? let's take A for example, six cases must appear in our results. See the R codes below. Please assist. Looking forward to hearing from the group sooner and thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +27 12 422 7357, Cell: +27 82 456 4669, Fax:+27 12 422 6579 E-Mail : pmakanan...@sars.gov.za <mailto:pmakanan...@sars.gov.za> > A = read.csv("C:/Documents and Settings/S1033067/Desktop/A.csv", header = TRUE, dec =",", sep = ",") > names(A) [1] "NAME" "SALARY" > dim(A)[1] [1] 19 > B = read.csv("C:/Documents and Settings/S1033067/Desktop/B.csv", header = TRUE, dec =",", sep = ",") > names(B) [1] "NAME" "B.SALARY" > dim(B)[1] [1] 15 > common = merge(A,B) > names(common) [1] "NAME" "SALARY" "B.SALARY" > dim(common)[1] [1] 13 > Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf
______________________________________________ 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.