[R] How to get a subset with a date such as Date=11/03/2013 HE=02*?

jcrosbie james at crosb.ie
Tue Mar 25 15:34:34 CET 2014


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.




More information about the R-help mailing list