Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get a .csv file into R?

Tags:

r

csv

I have this .csv file:

ID,GRADES,GPA,Teacher,State  3,"C",2,"Teacher3","MA"  1,"A",4,"Teacher1","California" 

And what I want to do is read in the file using the R statistical software and read in the Header into some kind of list or array (I'm new to R and have been looking for how to do this, but so far have had no luck).

Here's some pseudocode of what I want to do:

inputfile=read.csv("C:/somedirectory")  for eachitem in row1:{  add eachitem to list } 

Then I want to be able to use those names to call on each vertical column so that I can perform calculations.

I've been scouring over google for an hour, trying to find out how to this but there is not much out there on dealing with headers specifically.

Thanks for your help!

like image 808
Brian Avatar asked Aug 02 '10 21:08

Brian


People also ask

Which function is used to import a CSV file to R?

Read csv in R function (read. csv) If your file is not stored in the default working directory, then you will have to indicate its path for importing it into R.

How do I import a CSV file into R markdown?

Go to the Files tab in RStudio (lower right). Click Upload and browse to select the file you created. Then, use the read. csv() function to read in the file.


1 Answers

You mention that you will call on each vertical column so that you can perform calculations. I assume that you just want to examine each single variable. This can be done through the following.

df <- read.csv("myRandomFile.csv", header=TRUE)  df$ID  df$GRADES  df$GPA 

Might be helpful just to assign the data to a variable.

var3 <- df$GPA 
like image 193
ATMathew Avatar answered Oct 03 '22 00:10

ATMathew