read.csv Read Specific Row

r read.table read.csv
Outrigger picture Outrigger · Jul 2, 2013 · Viewed 36.4k times · Source

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!

Answer

Thomas picture Thomas · Jul 2, 2013

Try:

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

Related questions

How can I read the header but also skip lines - read.table()?

Data.txt: Index;Time; 1;2345; 2;1423; 3;5123; The code: dat <- read.table('data.txt', skip = 1, nrows = 2, header =TRUE, sep =';') The result: X1 X2345 1 2 1423 2 3 5123 I expect the header to be Index and Time, as follows: Index Time 1 2 1423 2 3 5123 How do I …

Read More
Specify custom Date format for colClasses argument in read.table/read.csv

Question: Is there a way to specify the Date format when using the colClasses argument in read.table/read.csv? (I realise I can convert after importing, but with many date columns like this, it would be easier to do …

Read More
read.csv vs. read.table

I have seen in several cases that while read.table() is not able to read a tab delimited file (for example the annotation table of a microarray) returning the following error: Error in scan(file, what, nmax, sep, dec, quote, …

Read More