Home » How to Export a Data Frame to a CSV File in R (With Examples)

How to Export a Data Frame to a CSV File in R (With Examples)

by Erma Khan

Suppose we have the following data frame in R:

#create data frame
df #view data frame
df

  team points assists
1    A     78      12
2    B     85      20
3    C     93      23
4    D     90       8
5    E     91      14

There are three common ways to export this data frame to a CSV file in R:

1. Use write.csv from base R

If your data frame is reasonably small, you can just use the write.csv function from base R to export it to a CSV file.

When using this method, be sure to specify row.names=FALSE if you don’t want R to export the row names to the CSV file.

write.csv(df, "C:\Users\Bob\Desktop\data.csv", row.names=FALSE)

2. Use write_csv from reader package

An even faster way to export a data frame to a CSV file is with the write_csv function from the reader package. This is about 2x faster than write.csv and it never writes the row names from the data frame to a CSV file.

library(readr)

write_csv(df, "C:\Users\Bob\Desktop\data.csv")

3. Use fwrite from data.table package

Yet a faster way (and a recommended method for large datasets) to export a data frame to a CSV file is with the fwrite function from the data.table package. This function is about 2x faster than the write_csv method.

library(data.table)

fwrite(df, "C:\Users\Bob\Desktop\data.csv")

Note that in each example we used double backslashes (\) in the file path to avoid the following common error:

Error: 'U' used without hex digits in character string starting ""C:U"

The Output

Each of the three methods above produce an identical CSV file. If we open this file with Excel, here’s what it looks like:

Export data frame to a CSV file in R

And if we open the CSV file with a text reader like Notepad, here’s what it looks like:

Export data frame to CSV in R

Related: How to Import CSV Files into R

Related Posts