Re: [R] problems when merging two data sets

2019-02-05 Thread Francois COLLIN
Quite agree with Jeff Newmiller and Bert Gunter. The error you get (" 'by' must specify a uniquely valid column") is a very common mistake when the function merge is misused. Although, the function merge is the good choice. Have you read the manual of the function sending the command `?merge`.

Re: [R] problems when merging two data sets

2019-02-05 Thread Jim Lemon
Hi Sasha, I'll take a wild guess that your column names have periods (.) replacing the spaces in the names you use: species occurrence -> species.occurrence The error message means that R can't find the variable name you have used in the "by" argument. The second wild guess is that your column na

Re: [R] problems when merging two data sets

2019-02-05 Thread Bert Gunter
Show us your code! (as the posting guide below requests. Please read the posting guide). Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Tue, Feb 5, 2019 at 10

Re: [R] problems when merging two data sets

2019-02-05 Thread Jeff Newmiller
There are many examples of how to do this properly on the web, and many ways you could have failed to follow those examples. You need to be much more specific (using actual R code) about what you did in order for us to help you get past your specific error. [1][2][3] You will also avoid the wha

[R] problems when merging two data sets

2019-02-05 Thread sasa kosanic
Dear All, I would like to merge two data sets however I am doing something wrong... 1 data set contains 2 columns of 'species occurrence'(1 column) in Germany and 'species names' (2 column). and the second one names of 'Red list species'(1 column) and 'species status' (2 column). so I would like