lessR (version 3.7.6)

Write: Write the Contents of a Data Frame to an External File

Description

Abbreviation: wrt, wrt.r

Writes the contents of the specified data frame, such as with the default mydata, to the current working directory as either the default csv data file, an Excel data table, or a native R data file of the specified data frame. If the write is for a csv file, then any variable labels are written to a second csv file with "_lbl" appended to the file name. Any variable labels and variable units are automatically included in a native R data file.

Usage

Write(ref=NULL, data=mydata, format=c("csv", "R", "Excel"), 
         row.names=TRUE, …)
wrt(…)
wrt.r(…, format="R")

Arguments

ref

Name of the output file as a character string, that is, with quotes. If not included in the name, the file type is automatically added to the name, either .csv or .rda, depending of the value of format.

data

Data frame to be written as an object, that is, no quotes.

format

Format of file to be written with .csv as the default.

row.names

Format of file to be written with .csv as the default.

...

Other parameter values consistent with the usual write.table.

Details

Can specify the file name without the file type, which Write adds automatically, .csv for a comma separated values data file and .rda for a native R data file. The default file name is the name of the data frame to be written. The name of the file that is written, as well as the name of the working directory into which the file was written, are displayed at the console.

An Excel file is written using functions from Alexander Walker's openxlsx package.

Write is designed to work in conjunction with the function Read from this package, which reads a csv, fixed width format, or native SPSS or R data files into the data frame mydata. Write relies upon the R functions write.csv and save.

When writing the data frame in native R format, the specified name of the resulting .rda file is distinct from the name of the data frame as stored within R.

See Also

Read, write.csv, save.

Examples

# NOT RUN {
# create data frame called mydata
n <- 12
X <- sample(c("Group1","Group2"), size=n, replace=TRUE)
Y <- rnorm(n=n, mean=50, sd=10)
mydata <- data.frame(X,Y)

# write the current contents of default data frame mydata to GoodData.csv
Write("GoodData")
# short name
# write the default data frame mydata to the R data file mydata.rda
wrt.r()

# write the data as an Excel data table in an Excel file
# do not include row names in the output Excel files
Write("GoodData", format="Excel", row.names=FALSE)

# access the R data frame warpbreaks
data(warpbreaks)
# write the file warpbreaks.rda
wrt.r(data=warpbreaks)

# }