There are many ways to process larger than RAM objects in R. The dbplyr package makes it possible to use a local db table as if they are in-memory data frames

There are many ways to process larger than RAM objects in R. The dbplyr package makes it possible to use a local db table as if they are in-memory data frames (https://dbplyr.tidyverse.org/ https://dbplyr.tidyverse.org/). https://diskframe.com/ https://diskframe.com/ is also a pretty great solution that processes data by chunks.