How to convert RDS file into excel

0

Entering edit mode

23 months ago

Athena • 0

Im trying to conver an rds file (about 6Gb) into excel and having a bit of trouble. Is there away to covert this file?

Python R data • 6.8k views

ADD COMMENT • link updated 23 months ago by zx8754 11k • written 23 months ago by Athena • 0

1

Entering edit mode

It can be inferred that you mean an R Data Set (RDS) file? There is no way for us to tell you how to convert this into a format readable by Excel until you tell us the type of data that is being stored in the RDS file. Hint: please open a session of R and load the RDS file via readRDS(), and then please share a sample of the contents here.

ADD REPLY • link 23 months ago by Kevin Blighe 87k

1

Entering edit mode

first .rds file into R (readRDS) and then write to xlsx file (write_xlsx or write.xlsx) or to a tab separated file (write.table). However, I suggest doing against this as output xlsx file will be huge. Any operations insidue such a huge file, is difficult.

ADD REPLY • link 23 months ago by cpad0112 21k

0

Entering edit mode

With 6GB file we will need at least 12GB of memory. There is also Python package to read R rds files:

ADD REPLY • link 23 months ago by zx8754 11k

Login before adding your answer.