Learn R
rio (version 0.4.8)

export: Export

Description

Write data.frame to a file

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

Details

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

The output file can be to a compressed directory, simply by adding an appropriate additional extensiont to the file argument, such as: “iris.csv.tar”, “iris.csv.zip”, or “iris.csv.gz”.

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.
  • CSVY (CSV with a YAML metadata header) using write.csv with row.names = FALSE and stringsAsFactors = FALSE (or, if fread = TRUE, fread). The YAML header lines are preceded by R comment symbols (\#) by default; this can be turned off by passing a comment_header = FALSE argument to export.
  • Pipe-separated data (.psv), using write.table with sep = '|' and row.names = FALSE.
  • Feather R/Python interchange format (.feather), using write_feather
  • 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
  • YAML (.yml), using as.yaml
  • 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 a simple XML tree
  • HTML (.html), using a custom method to create a single-table HTML file
  • Clipboard export (on Windows and Mac OS), using write.table with row.names = FALSE

Examples

Run this code
# 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)

# write data to a zip-compressed CSV
export(iris, "iris.csv.zip")

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

Run the code above in your browser using DataCamp Workspace