similar to: moving average with gaps in time series

Hello: I am developing a web application to book machines for an event. so I have an event model class Event < ActiveRecord::Base has_many :datetimes ... end and a datetime model class Datetime < ActiveRecord::Base belongs_to :event ... end I have developed a view with the event information and information for the datetimes. and in the event_controller when I capture a datetime I

Hi! These days I have been having trouble with a test that tried to test DateTime functionality. I have discovered that a NULL DateTime is auto-type casted to NIL by Rails. My problem here is that I have a field :datetime and I want to allow NULL datetimes but not wrong datetimes. With this validation if deadline is wrong or if is is blank it returns true. How I can accomplish this? protected def

Hi all - I have written an XML-RPC app using action-web-service. Mostly works well. Except I just noticed that my :datetime types are coming back as :date types. That is, when in the console I query the record via Foo.find_by_id(123) I get back actual datetimes. If I then do it via XML-RPC, fetching that same record I get back dates (ie. hour/minute/second are set to 00:00:00) Any ideas?

I want to obtain datetime differences in mins in an other column, in front of my datetimes. I have tried this : T1 <- c("12/31/03 23:49","1/1/04 1:14","1/1/04 0:02") T2 <- c("1/1/04 0:58","1/1/04 1:16","") toto <- data.frame(T1,T2) toto y <- strptime(T1,"%m/%d/%y %H:%M") x <- strptime(T2,"%m/%d/%y

This is a follow-up to the thread ending with: http://rubyforge.org/pipermail/vpim-talk/2008/000120.html I too am in search of some ruby parser for icalendar which properly handles timezones on the datetimes in the icalendar RFC. As I understand it there are actually three types of times. 1) UTC times with a string form of yyyymmddThhmmssZ note the trailing Z indicates zulu time aka utc. 2)

Does anyone know a good way to hook into the AR to_xml() method to allow for adjusting datetimes to a user''s timezone? Basically I want a user to be able dump all their data before cancelling an account. I store all datetime info as UTC as per the recommendations of Jamis Buck and Scott Barron in the Rails Recipe article "Dealing with Timezones". Come to think of it I bet

Hi experts, I have a problem in Write.foreign command (SAS). I have a data frame called d. >d Datetime 2006-12-01 00:00:00 2006-12-01 00:10:00 2006-12-01 00:20:00 2006-12-01 00:30:00 2006-12-01 00:40:00 >class(d$Datetime) [1] "POSIXt" "POSIXct" Then I tried with, write.foreign(d,"Z:\\try_i.sas7bdat"," Z:\\try_i.sas

An application that run without flaw last week has been reported to crash with an error that says that a conversion from char to datetime has given a date outside range. This very application runs OK today in production (fortunately :-), and the difference in both SQL Servers is just that the one where the exception has started to appear has Spanish conventions. I can''t give

Date-Time-Stamp input method to correctly interpret user-specific formats:coding is 90% there - based on exmple at http://tolstoy.newcastle.edu.au/R/help/05/02/12003.html ...anyone got the last 10% please? CONTEXT: Data is received where one of the columns is a datetimestamp. At midnight, the value represented as text in this column consists of just the date part, e.g.

Dear List, I am trying to plot date vs. time, but am having problems getting my y-axis labels how I want them.? When left on its own R plots time at 6 hour intervals from 03:00 to 23:00.? I am wanting 6 hour intervals from 2:00 to 22:00.? I realize yaxp doesn't work in plot(), so I am trying to get it to work in par().? However, now I get the ticks where I want them but the time is output

Hi R experts, I have a problem in Write.foreign command (SAS). I have a data frame called d. >d Datetime 2006-12-01 00:00:00 2006-12-01 00:10:00 2006-12-01 00:20:00 2006-12-01 00:30:00 2006-12-01 00:40:00 >class(d$Datetime) [1] "POSIXt" "POSIXct" Then I tried with, write.foreign(d,"Z:\\try_i.sas7bdat"," Z:\\try_i.sas

Dear R users, I am experiencing a problem, I am trying to merge two matrices composed like this: Matrix1 : Col1 datetime // Col2 Data1 Matrix2: Col1 datetime // Col2 Data2 The datetime are matching most of the time, but on both matrices, there are some values missing, and this generates a gap, so the two matrices don't match. Do you know which function I could use/create in order to

Dear R-devel, I've made some potential extensions to writeForeignSAS in 'foreign' that I wanted to pass along if anyone is interested. I've attached the diff -u output against the version found in foreign_0.8-15 and an .R file with my changes. (In this .R file, the function is named writeForeignSAS7 to simplify testing/comparisons.) I've tried to alter the current

this is probably not really a R specific question, if so apologies for off-topic posting: I'm interested in the probability density function of the maximum values from repeated samples of size N from a normal distribution: smp <- rnorm(N, meanval, stdev) with some mean 'meanval' and standard deviation 'stdev'. I would like to know what is the frequency distribution of

Hi, I have a whole bunch of data, which looks like: 15/03/2003 10:20 1 15/03/2003 10:21 0 15/03/2003 12:02 0 16/03/2003 06:10 0 16/03/2003 06:20 0.5 16/03/2003 06:30 0 16/03/2003 06:40 0 16/03/2003 06:50 0 18/03/2003 20:10 0.5 etc. (times given on a 24 hour clock) and goes on for years. I have some code:

Dear R-Users, I have a data file with timestamps and I wanted to use POSIXct time data type to represent the respective column. I played around with the type and found a couple of issues: * there seems to be no direct way of reading datetimes into a variable. Let's say this is my file "1992-02-27 23:03:20 PST" "1992-02-27 22:29:56 PST" "1992-01-14 01:03:30 PST"

I'm trying to plot some temporal data that have some gaps in them. You can see the plot here: http://www.tiikoni.com/tis/view/?id=da222e2. The problem is that during the time gaps in the TS the line plot is interpolated over the gap and I don't want it to. I've tried interleaving the gaps with an NA flag, but there are around 10000 data-points sorted from multiple files, that makes it

I have a SQL Server column named StartTime of (SQL Server) type datetime If I attempt to set the attribute using public def StartTime=(time) write_attribute(:StartTime, "{ts ''1899-12-30 #{time.hour}:#{time.min}:#{time.sec}''}") end it''s inserting a NULL value. Anyone else able to successfully insert a date time value into a SQL Server table using

Hi everybody, I have a small question about the function "na.locf" from the package "zoo". I saw in the help that this function is able to fill NA gaps with the last value before the NA gap (or with the next value). But it is possible to fill my NA gaps according to the last AND the next value at the same time? Actually, I want R to fill my gaps with the method of

Hi everybody, I'm a new R french user. Sorry if my english is not perfect. Hope you'll understand my problem ;) I have to work on temperature data (35000 lines in one file) containing some missing data (N/A). Sometimes I have only 2 or 3 N/A following each other, but I have also sometimes 100 or 200 N/A following each other. Here's an example of my data, when I have only small gaps