How to convert RDS file into excel

0

Entering edit mode

2.6 years 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 • 9.3k views

ADD COMMENT • link updated 2.6 years ago by zx8754 12k • written 2.6 years 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 2.6 years ago by Kevin Blighe 88k

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 2.6 years 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 2.6 years ago by zx8754 12k

Login before adding your answer.