Dan, If the variables you are merging by are character variables, there may be subtle differences that you haven't noticed, e.g., capitalization or spacing. You can look for differences by listing off the unique values:
table(c(annotatedData$names, UCSCgenes$Ensembl.Gene.ID)) Jean `·.,, ><(((º> `·.,, ><(((º> `·.,, ><(((º> Jean V. Adams Statistician U.S. Geological Survey Great Lakes Science Center 223 East Steinfest Road Antigo, WI 54409 USA From: world peace <buysellrentof...@gmail.com> To: r-help@r-project.org Date: 08/01/2011 11:24 AM Subject: [R] possible reason for merge not working Sent by: r-help-boun...@r-project.org Hi Guys, working on a "merge" for 2 data frames. Using the command: x <- merge(annotatedData, UCSCgenes, by.x="names", by.y="Ensembl.Gene.ID", all.x=TRUE) names and Ensembl.Gene.ID are columns with similar elements from the x and y data frames. annotatedData has 8909 entries, so has x(as expected). x has columns for UCSCgenes, but there is no data in them, all n/a, as if no match exists. This is not true as I can manually see and find many similarities between the names and UCSCgenes columns. I am wondering if there is any syntax error, or logical. comments appreciated. Thanks Dan ______________________________________________ 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. [[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.
