[R] Help with read.csv

From: Giovanni Petris <gpetris_at_uark.edu>
Date: Wed, 09 Mar 2011 16:32:29 -0600

Hello,

I have a file that looks like this:

Date,Hour,DA_DMD,DMD,DA_RTP,RTP,,

1/1/2006,1,3393.9,3412,76.65,105.04,,
1/1/2006,2,3173.3,3202,69.20,67.67,,
1/1/2006,3,3040.0,3051,69.20,77.67,,
1/1/2006,4,2998.2,2979,67.32,69.10,,
1/1/2006,5,3005.8,2958,65.20,68.34,,

where the ',' is the separator and I tried to read it into R, but...

> y <- read.csv("Data/Data_tmp.csv", header = FALSE, skip = 1,

+               colClasses = c("character", "int", rep("double", 4)),
+               col.names = c("Date","Hour","DA_DMD","DMD","DA_RTP", "RTP"),
+               flush = TRUE)

Error in read.table(file = file, header = header, sep = sep, quote = quote, :   more columns than column names

count.fields() gives me 8 fields per line, so I tried other variations, like the following, with two fictitious extra fields, but...

> y <- read.csv("Data/Data_tmp.csv", header = FALSE, skip = 1,

+               colClasses = c("character", "int", rep("double", 6)),
+               col.names = c("Date","Hour","DA_DMD","DMD","DA_RTP",
+               "RTP", "XXX", "YYY"))

Error in methods::as(data[[i]], colClasses[i]) :   no method or default for coercing "character" to "int"

Could anybody please tell me what I am doing wrong and how I could read my data into R?

Thanks in advance,
Giovanni

-- 

Giovanni Petris  <GPetris_at_uark.edu>
Associate Professor
Department of Mathematical Sciences
University of Arkansas - Fayetteville, AR 72701
Ph: (479) 575-6324, 575-8630 (fax)
http://definetti.uark.edu/~gpetris/

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed 09 Mar 2011 - 22:52:03 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 10 Mar 2011 - 06:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive