[R] possible reason for merge not working

world peace buysellrentoffer at gmail.com
Mon Aug 1 18:47:45 CEST 2011


the answer was indeed in subtle differences, and 'str' did help.
Problem is solved.
Thanks everybody for comments which was all very useful.

Best,


On Mon, Aug 1, 2011 at 12:25 PM, jim holtman <jholtman at gmail.com> wrote:
> What you "see" and what the data really is may be two different
> things.  You should have at least enclosed an 'str' of the two data
> frames; even better would be a subset of the data using 'dput'.  Most
> likely your problem is that your data is not what you 'expect' it to
> be.
>
> On Mon, Aug 1, 2011 at 12:17 PM, world peace <buysellrentoffer at gmail.com> wrote:
>> 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 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.
>>
>
>
>
> --
> Jim Holtman
> Data Munger Guru
>
> What is the problem that you are trying to solve?
>



More information about the R-help mailing list