@RVC2023 one way to get data from and to R is to use Parquet files. You can use them in one go or you can use chunks which is especially useful if you have large data.
The large file can be split into smaller parts. If they have the same structure you could also write them in a loop and later import them back as one file:
