On 16/06/2014 23:21, Kate Ignatius wrote:
Hi All,
I'm trying to merge two files together using:
combinedfiles <- merge(comb1,comb2,by=c("Place","Stall","Menu"))
comb1 is about 2 million + rows (158MB) and comb2 is about 600K+ rows (52MB).
When I try to merge using the above syntax I get the error:
Error in merge.data.frame(comb1, comb2, by = c("Place","Stall","Menu")) :
negative length vectors are not allowed
Is there is something that I'm doing wrong? I've merged larger files
Not telling us the the 'at a minimum' information asked for in the
posting guide.
together in the past without a problem so am curious what might be the
problem here...
Thanks in advance!
~K
This is usually an indication that you are trying to create more than
2^31 rows in the result, which looks plausible given your data set
sizes. AFAICS merge does not allow long vectors on a 64-bit system in
released versions of R.
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax: +44 1865 272595
__
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.
