Displaying 20 results from an estimated 4000 matches similar to: "handling dates in R"
2002 Sep 16
2
how to fit just a fixed effects model?
Dear all,
How can one fit just a fixed effects model in R? lme() seems to require a random component, whereas I am just looking for something like STATA's "xtreg, fe" function.
Thanks,
Pijus
----
W: 212-588-7897
F: 212-446-1955
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read
2003 Feb 10
3
non-SQL sqlQuery error
Dear all,
I've encountered a curious problem. I am trying to run an SQL query
using sqlQuery() function in RODBC.
The query works fine when run in a stand-alone SQL browser (Microsoft
Query Analyzer, in particular).
However, when I use the exact same thing from sqlQuery() function, I get
the following error:
Error in "[.data.frame"(data, , ) : not all specified columns exist
2007 Aug 15
1
getting lapply() to work for a new class
Hi,
I would like to get lapply() to work in the natural way on a class I've
defined. As far as I can tell, lapply() needs the class to be coercible
to a list. Even after I define as.list() and as.vector(x, mode="list")
methods, though, I still get an "Error in as.vector(x, "list") : cannot
coerce to vector". What am I doing wrong?
# dummy class
2002 Dec 12
1
improving ts object
Dear all,
Currently, a ts object behaves like an array, and it would be very useful to have a similar object, which would behave like a data.frame, i.e. it could be indexed, named, etc. like a data.frame. What would be the most efficient way to construct such an object? I have tried to make one on my own following the directions of class design from "S Programming" (2000) as a
2003 Jan 03
1
Interfacing R and C++ under Windows
Dear all,
My colleague, who has been helping me with wrapping some older C++ code for use in R, has been running into some issues, which he asked me to post here:
- ERROR is defined in RS.h which is included in Rdefines.h which conflicts with Visual Studio's ERROR
- TRACE is defined in Rinternals.h which conflicts with Visual Studio's TRACE
- math.h is included within extern
2005 Nov 10
4
write.table read.table with Dates
I've found several similar issues with write.table/read.table
with Dates on this list, but trying to follow this advice I still
get an error.
First, I read in data from several files, constructing several date/time
columns using ISOdatetime
> str(Tall$Begin)
'POSIXct', format: chr [1:40114] "2005-10-02 00:00:00" "2005-10-02
00:00:00" ...
> length(Tall$Begin)
2010 Oct 27
1
Regular time series with irregular start and end dates
Dear R users,
I have a quick question regarding creating an index for a zoo object. I am using R 2.12 on winxp.
I have read through the R archives searching for information on dates and time series analysis and nothing seems to cover my question.
I am extracting data from a time series of remote sensing data. The frequency of the data is 16 days which means I cant use ts (ts likes months single
2011 Aug 05
3
excel dates and times in R
Hello,
I am having some fun dealing with dates and times. My input is a excel csv
file with two columns with data in the following format:
date time
25-Jun-1961 04:00:00
i.e. day - month - year hour:min:sec
I would like to have a single object in R that combines these and converts
them into a sensible R format (e.g.
2009 Feb 10
3
ISOdatetime gives NA for a specific date
Hi all,
I am using ISOdatetime, and I just found out that when I do
ISOdatetime(1995,03,26,2,10,0) (or any other value under minutes or seconds)
I get NA
This does not happen with the same time in other dates, nor with different
hours in the same date.
Any hint why this happens?
Using R 2.8.1 under ESS/GnuEmacs under Windows XP
Pedro
--
View this message in context:
2016 Apr 18
4
as.Date
Dear All,
I have a data set containing year, month, day and counts as shown below:
data <- read.table("data.txt", col.names = c("year", "month", "day", "counts"))
Using the formula below, I converted the data to as date and plotted.
new.century <- data$year < 70
data$year <- ifelse(new.century, data$year + 2000, data$year + 1900)
2007 Oct 09
1
Read in date fomat while colClasses="character"
Hi R users,
I am using xlsReadWrite to read a particular excel file. In one of the
columns I have dates ( say col=5). Now date column is read by default as
numeric. So I used dateTimeAs= "isodatetime". This enables reading in
the date format. However in the earlier column (say col=1) I have data
which however starts from row 10. So to read data from column one I use
2011 Mar 14
4
Serial Date
Hello R Help,
I'm working in a project with a software that register date and time data in serial time format. This format is used by excel, for exemple. In this format, 40597.3911423958 is 2011/2/23 09:23:15. First part is number os days since 1900/1/1, and second part is a fraction of a day.
I need to make this transformation in R, and use it to make some algebrian operations. I found that
2008 Jan 10
2
how to calculate time offset between timezones?
#QUESTION#
Is there a way to calculate the offset between timezones, e.g. from "AST" to
"GMT"?
#DETAILS#
I am working with data files that use local time, and that indicate the
timezone by e.g. "AST" (Atlantic Standard Time, my local time) in a header.
I was guessing that
> ISOdatetime(2008,1,1,1,0,0,tz="GMT") -
>
2005 Jul 12
3
using its to import time series data with uneven dates
Good day:
I am trying to use
readcsvIts("nwr_data_qc.txt",informat=its.format("%Y%m%d%h%M
%Y"),header=TRUE,sep="",skip=0,row.names=NULL,as.is=TRUE,dec=".")
to read in a file (nwr_data_qc.txt) that looks like this:
Time Y M D H Min CO2
2000.18790 2000. 3. 9. 18. 30. 373.60
2000.20156 2000. 3. 14. 18. 30. 373.34
2005 Oct 25
2
strptime problem for 2004-10-03 02:00:00
Hello, I at first thought this was a system or locale issue, but since
it occurs on
both Windows and Linux and only for 2004 (AFAIK) I report it.
I have a problem with as.POSIXct for the hour between
"2004-10-03 02:00:00 GMT" and "2004-10-03 02:59:59 GMT".
In short, the 2 AM (GMT) hour in 2004 (but not in other years) is
interpreted as 1 AM by strptime:
(I use ISOdatetime
2009 Feb 10
2
Strange behaviour of ISOdatetime
Hi All,
I am watching a strange behaviour of ISOdatetime. In my work
computer, I get NA when I try to do
> ISOdatetime(1995,03,26,2,0,0)
[1] NA
But on other dates and/or times (hour) works OK
> ISOdatetime(1995,03,25,2,0,0)
[1] "1995-03-25 02:00:00 GMT"
In my home computer, I do not have this problem.
I am running the same version of R (2.8.1 patched) on both machines,
the
2009 Jan 19
1
maptools, sunriset, POSIX timezones
Hi ...
I wonder if anyone can provide some insight into why the first three
examples using the sunriset function (appended below, with results) give
the correct answer, but the fourth generates and error.
The first two use ISOdatetime with and without a time zone attribute,
and the sunriset function returns the correct sunset time.
The third and fourth adds 10 seconds to the ISOdatetime
2004 Apr 29
1
Entering times around the start of daylight savings time
I'm having problems entering dates and times around when daylight savings time
starts. If I type (on R 1.8.1 on Gentoo Linux)
> ISOdatetime(2004,4,4,0:4,0,0,"GMT")
[1] "2004-04-03 19:00:00 EST" "2004-04-03 20:00:00 EST"
[3] "2004-04-03 22:00:00 EST" "2004-04-03 22:00:00 EST"
[5] "2004-04-03 23:00:00 EST"
Giving the times
2012 Jan 20
2
Incorrect DateTime using ISOdatetime in R
Dear list,
I need to transform the DateTime of my GPS data from:
"666.1751" into "yyyy/mm/dd hh:mm:ss"
I have the following code:
d$Date <- ISOdatetime(2009, 1, 1, 0, 0, 0, tz = "GMT")+d$Date*(24*3600)
This gives me: 2010-10-29 04:12:09, which is wrong. It should be 2010-10-29
06:12:09
Another example:
418.3219 corresponds to: 2010-02-23 07:43:30, but it
2011 Dec 14
1
A Question Re ISOdatetime
Dear all,
I am using the ISOdatetime function like this:
test.info$TradeTime = with(test.info, mapply(FUN = ISOdatetime, Year, Month, Day, Hour, Minute, 60, "EST"))
Where Year, Month etc are all numeric.
I think ISOdatetime should return a POSIXct object. However, the result I obtained from the line above is all numeric. Could you please advise? I wish to get POSIXct.
Thank you