Sorry I thought I was being clear.
These is how the time values in columns are downloaded from online
(http://ets.aeso.ca/). When there is an extra hour in the date there are two
hour ending twos in the that day (HE02 and HE02*). I did not create the data
this way.
What is a good way of dealing with data in this format?
Col1<-c("11/02/2008", "11/02/2008", "11/02/2008", "11/02/2008")
Col2<-c("02*", "02", "03", "04")
Col3SomeMadeupnumbers<-seq(1, 4, by=1)
df1 = data.frame(Col1, Col2,Col3SomeMadeupnumbers)
Col1<-c("11/02/2008 02*", "11/02/2008 02", "11/02/2008 03", "11/02/2008 04")
df2 = data.frame(Col1, Col3SomeMadeupnumbers)
Also, Nov. 2, 2008 02 is when there was a time change.
David Winsemius wrote
> On Mar 24, 2014, at 3:35 PM, jcrosbie wrote:
>
>> I'm having a problem working with daylight savings dates in R.
>>
>> I'm downloading data in two formats.
>>
>> Format One Col 1: a date such as "11/03/2013" col 2: Hour ending = 02*
>> Col1<-c("11/02/2008*", "11/02/2008", "11/02/2008", "11/02/2008")
>> Col1<-c("02*", "02", "03", "04")
>>
>> Another data set is something like this: "11/03/2013 02*"
>> Col1<-c("11/02/2008 02*", "11/02/2008 02", "11/02/2008 03", "11/02/2008
>> 04")
>>
>> These data frames are very big and over multiple years with multiple
>> values
>> for each hour ending.
>>
>> I'm trying to build subsets, filter, merge tables, lookup values with
>> dates
>> like these. How do I go about working with the "02*"?
>>
>
> If you are adding those asterisks to that example (as I suspect) then you
> are just creating problems in understanding what is really in your data.
> Instead post output from dput(dat) for a section of an object named 'dat'.
>
>
>> View this message in context:
>> http://r.789695.n4.nabble.com/How-to-get-a-subset-with-a-date-such-as-Date-11-03-2013-HE-02-tp4687488.html
>> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@
> 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.
>
> --
> David Winsemius
> Alameda, CA, USA
>
> ______________________________________________
> R-help@
> 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.
--
View this message in context:
http://r.789695.n4.nabble.com/How-to-get-a-subset-with-a-date-such-as-Date-11-03-2013-HE-02-tp4687488p4687517.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.
