R Data Import and Export

Reading and writing data files in R

CSV Files

read.csv("file.csv") # read CSV file
read.csv("file.csv", header=TRUE) # with header
write.csv(df, "output.csv") # write to CSV
write.csv(df, "output.csv", row.names=FALSE) # no row names

Text Files

read.table("file.txt") # read table
read.delim("file.txt") # tab-delimited
write.table(df, "output.txt") # write table

Excel Files

library(readxl) # load readxl package
read_excel("file.xlsx") # read Excel file
library(writexl) # load writexl package
write_xlsx(df, "output.xlsx") # write Excel file

RData Files

save(df, file="data.RData") # save R object
load("data.RData") # load R object
saveRDS(df, "data.rds") # save single object
df <- readRDS("data.rds") # read single object