rio (version 0.2)

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), usingwrite.tablewithrow.names = FALSE
• Comma-separated data (.csv), usingwrite.csvwithrow.names = FALSE
• Pipe-separated data (.psv), usingwrite.tablewithsep = '|'androw.names = FALSE
• Fixed-width format data (.fwf), usingwrite.tablewithrow.names = FALSE,quote = FALSE, andcol.names = FALSE
• Serialized R objects (.rds), usingsaveRDS
• Saved R objects (.RData), usingsave
• JSON (.json), usingtoJSON
• Stata (.dta), usingwrite_dta
• SPSS (.sav), usingwrite_sav
• "XBASE" database files (.dbf), usingwrite.dbf
• Weka Attribute-Relation File Format (.arff), usingwrite.arff
• R syntax object (.R), usingdput(by default) ordump(ifformat = 'dump'
• Excel (.xlsx), usingwrite.xlsx
• XML (.xml), using a custom method to create an XML tree and write to disk usingsaveXML
• Clipboard export (on Windows and Mac OS), usingwrite.tablewithrow.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 w

...

Additional arguments for the underlying export functions.

Value

• The name of the output file as a character string (invisibly).

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")