These functions are equivalent to
write_csv() etc., but instead
of writing to disk, they return a string.
format_delim( x, delim, na = "NA", append = FALSE, col_names = !append, quote_escape = "double", eol = "\n" ) format_csv( x, na = "NA", append = FALSE, col_names = !append, quote_escape = "double", eol = "\n" ) format_csv2( x, na = "NA", append = FALSE, col_names = !append, quote_escape = "double", eol = "\n" ) format_tsv( x, na = "NA", append = FALSE, col_names = !append, quote_escape = "double", eol = "\n" )
A data frame.
String used for missing values. Defaults to NA. Missing values
will never be quoted; strings with the same value as
The type of escaping to use for quoted values, one of
The end of line character to use. Most commonly either
Factors are coerced to character. Doubles are formatted to a decimal string
using the grisu3 algorithm.
POSIXct values are formatted as ISO8601 with a
UTC timezone Note:
POSIXct objects in local or non-UTC timezones will be
converted to UTC time before writing.
write_csv2 were created to allow users with
different locale settings to save .csv files using their default settings
; as the column separator and
, as the decimal separator).
This is common in some European countries.
Values are only quoted if they contain a comma, quote or newline.
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.
Florian Loitsch, Printing Floating-Point Numbers Quickly and Accurately with Integers, PLDI '10, http://www.cs.tufts.edu/~nr/cs257/archive/florian-loitsch/printf.pdf
data(band_members, package = "dplyr") # format_()* functions are useful for testing and reprexes cat(format_csv(band_members))#> name,band #> Mick,Stones #> John,Beatles #> Paul,Beatlescat(format_tsv(band_members))#> name band #> Mick Stones #> John Beatles #> Paul Beatlescat(format_delim(band_members, ";"))#> name;band #> Mick;Stones #> John;Beatles #> Paul;Beatles#>  "x\n1\nmissing\n3\n"# Quotes are automatically added as needed df <- data.frame(x = c("a ", '"', ",", "\n")) cat(format_csv(df))#> x #> a #> """" #> "," #> " #> "