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 <gpet...@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@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.