{"id":31464,"date":"2023-01-21T17:24:27","date_gmt":"2023-01-21T11:54:27","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/"},"modified":"2023-01-21T17:24:27","modified_gmt":"2023-01-21T11:54:27","slug":"solved-cannot-allocate-a-vector-in-r","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/","title":{"rendered":"[Solved] Cannot allocate a vector in R"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-25315880\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"25315880\" data-parentid=\"25314580\" data-score=\"2\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Simplest answer: Purchase more RAM.  If you work in R with large datasets often, it&#8217;s worth it.  If you don&#8217;t have enough memory to load your files, you may not have enough to manipulate them as you want either.<\/p>\n<p>Let&#8217;s assume that you could hold this data in RAM and manipulate it as you wish so that reading it in is your only problem.  The comments to your question have provided some ideas.  You could also use <code>scan()<\/code> to read your file instead of <code>read.csv<\/code>.  It requires a little more setup but is faster and relatively memory friendly. <\/p>\n<p>There are several packages available to help people whose data is too large for memory.  The one I&#8217;m familiar with (though I haven&#8217;t used it in years thanks to falling RAM prices) is <code>filehash<\/code>.  This will store your data on disk instead of RAM but you still interact with it the same way.  It will be slower, but likely resolve your problem.<\/p>\n<pre><code>library(filehash)\ndbCreate('tmp.db')\ndbhandle &lt;- dbInit('tmp.db')\ndb &lt;- db2env(dbhandle)    \ndb$test &lt;- ldply(list.files(path=\"C:\/rcsv\",pattern=\"csv\",full.names=TRUE),\nfunction(filename) {\n  db$dum &lt;- read.csv(filename)\n  db$dum$filename &lt;- filename\n  return(dum)\n})\n<\/code><\/pre>\n<p>I don&#8217;t know whether this approach has been deprecated, but I believe it still works.  I&#8217;m not sure to what extent <code>ldply()<\/code> will put temporary stuff in RAM.  If this fails you could instead create a list inside of <code>db<\/code>, read each of the files into the list in a <code>for<\/code> loop and then rbind them together yourself.<\/p>\n<p>Another approach would be maybe to create an sqlite database and use <code>read.csv.sql()<\/code> from the sqldf package to put everything in there and then bind them.  Then at the end you can read the final dataframe out.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Cannot allocate a vector in R <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Simplest answer: Purchase more RAM. If you work in R with large datasets often, it&#8217;s worth it. If you don&#8217;t have enough memory to load your files, you may not have enough to manipulate them as you want either. Let&#8217;s assume that you could hold this data in RAM and manipulate it as you &#8230; <a title=\"[Solved] Cannot allocate a vector in R\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\" aria-label=\"More on [Solved] Cannot allocate a vector in R\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[535,321],"class_list":["post-31464","post","type-post","status-publish","format-standard","hentry","category-solved","tag-memory","tag-r"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Cannot allocate a vector in R - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Cannot allocate a vector in R - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Simplest answer: Purchase more RAM. If you work in R with large datasets often, it&#8217;s worth it. If you don&#8217;t have enough memory to load your files, you may not have enough to manipulate them as you want either. Let&#8217;s assume that you could hold this data in RAM and manipulate it as you ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-21T11:54:27+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Cannot allocate a vector in R\",\"datePublished\":\"2023-01-21T11:54:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\"},\"wordCount\":271,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"memory\",\"r\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\",\"name\":\"[Solved] Cannot allocate a vector in R - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-21T11:54:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Cannot allocate a vector in R\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Cannot allocate a vector in R - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Cannot allocate a vector in R - JassWeb","og_description":"[ad_1] Simplest answer: Purchase more RAM. If you work in R with large datasets often, it&#8217;s worth it. If you don&#8217;t have enough memory to load your files, you may not have enough to manipulate them as you want either. Let&#8217;s assume that you could hold this data in RAM and manipulate it as you ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/","og_site_name":"JassWeb","article_published_time":"2023-01-21T11:54:27+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Cannot allocate a vector in R","datePublished":"2023-01-21T11:54:27+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/"},"wordCount":271,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["memory","r"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/","url":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/","name":"[Solved] Cannot allocate a vector in R - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-21T11:54:27+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-cannot-allocate-a-vector-in-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Cannot allocate a vector in R"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/31464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=31464"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/31464\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=31464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=31464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=31464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}