Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

read.csv Read Specific Row [duplicate]

How can we read specific rows into R using the read.csv command? Say if I have a CSV file which has 10 rows of data, and I just want to only read the 5th row of data, I tried doing the following but it doesn't seem to be working:

myFile <- "MockData.csv"
myData <- read.csv(myFile, row.names=5)
myData

Thanks!

like image 242
Outrigger Avatar asked Jul 02 '13 09:07

Outrigger


2 Answers

Try:

myData <- read.csv(myFile, nrows=1, skip=4)
like image 178
Thomas Avatar answered Sep 22 '22 22:09

Thomas


In order to read from 2nd row till the bottom of the file row by row (assuming that the first row is the header and can be omitted), what has been done is as such:

myFile <- "MockData.csv"
myData <- read.csv(myFile, skip=0, nrows=1)

And then:

myData <- read.csv(myFile, skip=1, nrows=1)

Followed by:

myData <- read.csv(myFile, skip=2, nrows=1)

And so on...

like image 32
Outrigger Avatar answered Sep 21 '22 22:09

Outrigger