I have an object, which I pull in from a csv file here
http://r.789695.n4.nabble.com/file/n4638691/jan_2011.csv jan_2011.csv
mydata <- read.csv("jan_2011.csv", header=TRUE, sep=",")
> head(mydata)
Delivery.Date Hour.Ending Repeated.Hour.Flag Settlement.Point
Settlement.Point.Price
1 01/01/2011 01:00 N HB_BUSAVG
25.18
2 01/01/2011 01:00 N HB_HOUSTON
25.36
3 01/01/2011 01:00 N HB_HUBAVG
25.07
4 01/01/2011 01:00 N HB_NORTH
25.33
5 01/01/2011 01:00 N HB_SOUTH
25.12
6 01/01/2011 01:00 N HB_WEST
24.49
> str(mydata)
'data.frame': 10416 obs. of 5 variables:
$ Delivery.Date : Factor w/ 31 levels "01/01/2011","01/02/2011",..:
1 1 1 1 1 1 1 1 1 1 ...
$ Hour.Ending : Factor w/ 24 levels "01:00","02:00",..: 1 1 1 1 1
1 1 1 1 1 ...
$ Repeated.Hour.Flag : Factor w/ 1 level "N": 1 1 1 1 1 1 1 1 1 1 ...
$ Settlement.Point : Factor w/ 14 levels "HB_BUSAVG","HB_HOUSTON",..:
1 2 3 4 5 6 7 8 9 10 ...
$ Settlement.Point.Price: num 25.2 25.4 25.1 25.3 25.1 ...
I want to convert the Delivery.Date field to a date object. I tried various
attempts but failed with the following:
> as.Date(mydata[1], "%m/%d/%Y")
Error in as.Date.default(ercot[1], "%m/%d/%Y") :
do not know how to convert 'ercot[1]' to class "Date"
I even tried to save the first column to a separate object and tried the
same but got the same result. At this point I'm not sure how to move
forward. Appreciate the help.
--
View this message in context:
http://r.789695.n4.nabble.com/as-date-do-not-know-how-to-convert-test-1-to-class-Date-tp4638691.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
