R directly save data as zip file

Question

I found zip and the RCompression package but can they do:

write.zip(x, file = "foo.zip")

as you'd with write.csv?

I'm also aware of gzfile.

Related to [How to directly perform write.csv in R into tar.gz format?](http://stackoverflow.com/q/17492409/271616) — Joshua Ulrich, Jul 08 '13 at 19:00
I believe I almost got it working: `zz <- unz(description="temp.csv.zip", filename="temp.csv") open(zz) not.a.DF <- readLines(zz)` — Rico, Jul 11 '13 at 18:40

score 24 · Accepted Answer · answered Oct 18 '15 at 08:04

24

It's possible using gzip.

write.csv(mtcars, file=gzfile("mtcars.csv.gz"))

answered Oct 18 '15 at 08:04

Ven Yao

3,680
2
27
42

Using `write.csv` with .gz extension I got the maximum compression. – zabala Nov 14 '21 at 01:58

score 4 · Answer 2 · edited Oct 15 '20 at 00:07

This can be accomplished pretty easily using the readr functions and gzip.

library(readr)

write_tsv(mtcars, file.path(dir, "mtcars.tsv.gz"))

write_csv(mtcars, file.path(dir, "mtcars.csv.gz"))

From the docs, ?write_csv:

The write_*() functions will automatically compress outputs if an appropriate extension is given. Three extensions are currently supported: .gz for gzip compression, .bz2 for bzip2 compression and .xz for lzma compression. See the examples for more information.

R directly save data as zip file

2 Answers2