Displaying 20 results from an estimated 500 matches similar to: "Overriding date helpers in a logical way"
2009 Jul 11
2
Date conversions
Hi all,
I'm having a little bit of trouble with some date conversions and
am hoping someone can help me out. Thanks in advance.
OK, I have two sources of data that provide date info in a csv file
differently. I've attached a small zipped file with two text files
that illustrate both. (Is it ok to send attachments to this list? Not
sure. It's very small.) I need to be able to
2015 Nov 06
0
Puzzled by eval
On 06/11/2015 7:36 AM, Therneau, Terry M., Ph.D. wrote:
> I am currently puzzled by a seach path behavior. I have a library of a dozen routines
> getlabs(), getssn(), getecg(), ... that interface to local repositories and pull back
> patient information. All have a the first 6 arguments in common, and immediately call a
> second routine to do initial processing of these 6. The
2012 Nov 10
4
help on date dataset
Hi everybody,
I am beginer in R and I need your precious help.
I want to create a small function in R as in sas to retrieve date.
I have a file with data that import in R.
DATE PAYS nb_pays.ILI.
1 24/04/2009 usa 0
2 24/04/2009 usa 0
3 24/04/2009 Mexique 0
4 24/04/2009
2008 Jan 02
3
Find missing days
Hi,
I have a data.frame like this:
y <- rnorm(60)
lev <- gl(3,20, labels=paste("lev", 1:3, sep=""))
date1 <- as.Date(seq(ISOdate(2007,9,1), ISOdate(2007,11,5),
by=60*60*24))
date1 <- date1[-c(3,4,15,34,38,40)]
df <- data.frame(lev=lev, date1=date1, y=y)
I would like to produce a new data.frame with missing days in df$date1
in each df$lev, like this:
lev
2005 Feb 24
2
Row median of Date class variables in a data frame
I am trying to calculate the median of each row of a
data frame where the data frame consist of
columns of class Date.
Below are my test data and best attempt at using apply.
I didn't see a solution via Google or the Baron search
site.
I'd be grateful for any suggestions or solutions.
I'm using R 2.0.0 on Mac OS X.
Thank you,
Stephen Weigand
### Test data
date1 <- c(1000,
2006 Apr 19
0
Function for computing the difference between 2 dates inmonths
not without knowing what dados is.
Remember that num.months works only on objects that can be converted to Date objects. Make sure that all of your date-like objects can be converted.
(The error message seems to indicate that something you think should look like a date doesn't.)
David L. Reiner
Rho Trading Securities, LLC
Chicago IL 60605
312-362-4963
-----Original Message-----
From:
2009 Jan 21
3
Error as.Date on Invalid Dates
Hi All,
I have an script in R which accepts user inputs for certain parameters,
particularly dates, which the user inputs as character strings.
eg:
> date1 <- "2009-01-21"
The script later parses the input via the as.Date function:
> as.Date(date1)
However, as.Date encounters an error when the string does not represent an
actual date.
eg:
> date1 <-
2015 Nov 06
4
Puzzled by eval
I am currently puzzled by a seach path behavior. I have a library of a dozen routines
getlabs(), getssn(), getecg(), ... that interface to local repositories and pull back
patient information. All have a the first 6 arguments in common, and immediately call a
second routine to do initial processing of these 6. The functions "joe" and "fred" below
capture the relevant
2013 Feb 19
1
data format
Hi,
Try this:
el<- read.csv("el.csv",header=TRUE,sep="\t",stringsAsFactors=FALSE)
?elsplit<- split(el,el$st)
?
datetrial<-data.frame(date1=seq.Date(as.Date("1930.1.1",format="%Y.%m.%d"),as.Date("2010.12.31",format="%Y.%m.%d"),by="day"))
elsplit1<- lapply(elsplit,function(x)
2012 May 12
1
Query regarding date as argument in functions - and about sqldf
Hi,
I have a query about sqldf, and dates in general. I couldnt find much on
the net or on the forums, hence I am here. Here is the issue:
I want to write a function that accepts 3 arguments: date1, date2 and a
dataframe, say 'df'. Within the function, I want to populate a temp
dataframe which essentially contains the output of the query "select * from
df where DATE between date1
2009 Dec 04
0
simple reshape of a large data frame (reshape() runs out of memory)
Hello everyone,
I'm having a problem performing reshape() on a large data frame. The
operation is fairly trivial but it makes R run out of memory.
The data frame has the following structure:
ID DATE1 DATE2 VALTYPE
VALUE
'abcd1233' 2009-11-12 2009-12-23 'TYPE1'
123.45
...
VALTYPE is a string and is a factor with
2009 Dec 09
1
reshape() makes R run out of memory (PR#14121)
Full_Name: Alexander L. Belikoff
Version: 2.8.1
OS: Ubuntu 9.04 (x86_64)
Submission from: (NULL) (67.244.71.200)
I'm trying to reshape the following data frame:
ID DATE1 DATE2 VALUE_TYPE VALUE
'abcd1233' 2009-11-12 2009-12-23 'TYPE1' 123.45
...
VALUE_TYPE is a string and is a factor with only 2 values
2008 Jun 29
1
Calculating quarterly statistics for time series object
I have time series observation on daily frequencies :
library(zoo)
SD=1
date1 = seq(as.Date("01/01/01", format = "%m/%d/%y"), as.Date("12/31/02", format = "%m/%d/%y"), by = 1)
len1 = length(date1); data1 = zoo(matrix(rnorm(len1, mean=0, sd=SD*0.5), nrow = len1), date1)
plot(data1)
Now I want to calculate 1. Quarterly statistics like mean, variance etc
2005 Sep 22
1
problem with dates
I Have been trying to convert a vector of dates into julian dates using the following commands: as.date & as.numeric. I can convert a date no problem by doing the following:
as.numeric (as.date ("9/21/2004"))
but as soon as I try to do an entire vector I am given the following:
as.numeric (as.date(date1))
Error in as.date(date1) : Cannot coerce to date format
I have tried
2012 Mar 07
1
date columns chooser
i have a data frame with 2 columns of dates.
with str(dataframe) i have ensured myself that they were indeed formatted
as dates.
one column has NA's in it.
the aim is now to make a third column that chooses date1 if it is a date,
and choose date2 if it is a NA.
i am trying
df$date3=ifelse(is.na(df$date1), df$date2, df$date1).
this leads to unexpected behaviour: the resulting column is
2011 Aug 07
1
all.equal doesn't work for POSIXlt objects
Hi all,
following sample code illustrates the problem :
Date1 <- Date2 <-
as.POSIXlt(seq.Date(as.Date("2010-04-01"),as.Date("2011-04-01"),by='day'))
identical(Date1,Date2)
all.equal(Date1,Date2)
identical() gives the correct answer. As there is no all.equal method
for POSIXlt objects, all.equal.list is used instead. Subsetting using
[[]] doesn't work
2005 Oct 04
2
Joining Dataframes
I am attempting to join several dataframes that summarize sampling effort
for different samples into one large data.frame/table.
I have looked at the merge command, but have not been clever enough to
figure out how to get it to do what I want.
A simplified example of what I am trying to do:
The dataframes I have look like this (they were generated using the table
command)
species1.effort
2013 Oct 15
2
Data handling
Hello all,
I'm having a problem with data handling. My input data is (dput in the
after the signature):
Date Time Fraction
06/19/13 22:15:39 0.3205
06/19/13 22:15:44 0.3205
06/19/13 22:15:49 0.3205
06/19/13 22:15:54 0.3205
06/19/13 22:15:59 0.3205
06/19/13 22:16:09 0.3205
Date in format month/day/year, Time in HH:MM:SS and fraction represents the
fractions of
2008 Mar 10
1
Error in extracting monthly observation from a daily time series data
Hi all,
Suppose I have following dataset :
library(zoo)
SD = 1
date1 = seq(as.Date("01/01/90", format = "%m/%d/%y"), as.Date("12/31/08", format = "%m/%d/%y"), by = 1)
len1 = length(date1); data1 = zoo(matrix(rnorm(len1, mean=0, sd=SD*0.5), nrow = len1), date1)
Now I want to extract monthly observation.
obs =
2008 Mar 07
0
How to do a time-stratified case-crossover analysis for air pollution data?
Dear Experts,
I am trying to do a time-stratified case-crossover analysis on air
pollution data and number of myocardial infarctions. In order to avoid
model selection bias, I started with a simple simulation.
I'm still not sure if my simulation is right. But the results I get from
the "ts-case-crossover" are much more variable than those from a glm.
Is this:
a. Due to