rio (version 0.3.0)

export: Write data.frame or matrix to a file

Description

This function exports a data frame or matrix into a file with file format based on the file extension (or the manually specified format, if format is specified).

export supports many file formats. See the documentation for the underlying export functions for optional arguments that can be passed via ...

• Tab-separated data (.tsv), using write.table with row.names = FALSE
• Comma-separated data (.csv), using write.csv with row.names = FALSE
• Pipe-separated data (.psv), using write.table with sep = '|' and row.names = FALSE
• Fixed-width format data (.fwf), using write.table with row.names = FALSE, quote = FALSE, and col.names = FALSE
• Serialized R objects (.rds), using saveRDS
• Saved R objects (.RData), using save
• JSON (.json), using toJSON
• Stata (.dta), using write_dta
• SPSS (.sav), using write_sav
• "XBASE" database files (.dbf), using write.dbf
• Weka Attribute-Relation File Format (.arff), using write.arff
• R syntax object (.R), using dput (by default) or dump (if format = 'dump'
• Excel (.xlsx), using write.xlsx
• XML (.xml), using a custom method to create an XML tree and write to disk using saveXML
• Clipboard export (on Windows and Mac OS), using write.table with row.names = FALSE

Usage

export(x, file, format, ...)

Arguments

x

A data frame or matrix to be written into a file.

file

A character string naming a file. Must specify file and/or format.

format

An optional character string containing the file format, which can be used to override the format inferred from file or, in lieu of specifying file, a file with the symbol name of x and the specified file extension will be created. Must specify file and/or format. Shortcuts include: “,” (for comma-separated values), “;” (for semicolon-separated values), “|” (for pipe-separated values), and “dump” for dump.

...

Additional arguments for the underlying export functions.

Value

Examples

# specify only `file` argument
export(iris, "iris.csv")

# specify only `format` argument
"iris.dta" 
export(iris, format = "stata")
"iris.dta" 

# specify `file` and `format` to override default format
export(iris, file = "iris.txt", format = "csv")

# export to JSON
export(iris, "iris.json")

# pass arguments to underlying export function
export(iris, "iris.csv", col.names = FALSE)

# write data to .R syntax file and append additional data
export(iris, file = "data.R", format = "dump")
export(mtcars, file = "data.R", format = "dump", append = TRUE)
source("data.R", echo = TRUE)

# cleanup
unlink("iris.csv")
unlink("iris.dta")
unlink("iris.json")
unlink("data.R")