How do I import a CSV file in R?

r csv import
Uselesssss picture Uselesssss · Nov 7, 2012 · Viewed 308k times · Source

I have a .csv file in my workstation. How can I open that file in R and do statistical calculation?

Answer

Paul Hiemstra picture Paul Hiemstra · Nov 7, 2012

You would use the read.csv function; for example:

dat = read.csv("spam.csv", header = TRUE)

You can also reference this tutorial for more details.

Note: make sure the .csv file to read is in your working directory (using getwd()) or specify the right path to file. If you want, you can set the current directory using setwd.

Related questions

How to import multiple .csv files at once?

Suppose we have a folder containing multiple data.csv files, each containing the same number of variables but each from different times. Is there a way in R to import them all simultaneously rather than having to import them all …

Read More
How can you read a CSV file in R with different number of columns

I have a sparse data set, one whose number of columns vary in length, in a csv format. Here is a sample of the file text. 12223, University 12227, bridge, Sky 12828, Sunset 13801, Ground 14853, Tranceamerica 14854, San Francisco 15595, shibuya, Shrine 16126, fog, San Francisco 16520, California, …

Read More
Preserving large numbers

I am trying to read a CSV file that has barcodes in the first column, but when R gets it into a data.frame, it converts 1665535004661 to 1.67E+12. Is there a way to preserve this number in an integer format? …

Read More