[R] problems when merging two data sets

[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 what-we-see-is-different-than-what-you-saw problems with your email if you read the Posting Guide and insure that your email client is configured to send plain text format rather than HTML- format email to the mailing list.

[1] http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example

[2] http://adv-r.had.co.nz/Reproducibility.html

[3] https://cran.r-project.org/web/packages/reprex/index.html (read the vignette) 


On February 5, 2019 9:56:37 AM PST, sasa kosanic <sasa.kosanic using gmail.com> wrote:
>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 to merge Red list species with species names from the
>first
>table and to sign the  species status
>I have tried with merge function but got this an error:" 'by' must
>specify
>a uniquely valid column"
>I also tried with the function left_join, however no success.
>
>Also columns in two data sets are different in size. 1 table has 7189
>rows
>and 2 table just 426 rows as we do not have much Red list Species.
>
>I would appreciate your help.
>
>Kind regards,
>Sasha
>
>
>Dr Sasha Kosanic
>Ecology Lab (Biology Department)
>Room M842
>University of Konstanz
>Universitätsstraße 10
>D-78464 Konstanz
>Phone: +49 7531 883321 & +49 (0)175 9172503
>
>http://cms.uni-konstanz.de/vkleunen/
>https://tinyurl.com/y8u5wyoj
>https://tinyurl.com/cgec6tu
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.

-- 
Sent from my phone. Please excuse my brevity.