similar to: Skip file

Hi Gabor and everybody; Thanks Gabor, with the alternative step you've told me the problem is resolved. Comparing the two procedures: Extract from the source 'character' data: > rain$ts[2039:2046] [1] "25/03/2000 22:00:00 UTC" "25/03/2000 23:00:00 UTC" [3] "26/03/2000 00:00:00 UTC" "26/03/2000 01:00:00 UTC" [5] "26/03/2000 02:00:00

Hi list, I have some questions regarding 1) conversion of date + time characters to chron 2) formatting chron object printing Regarding (1), Gabor's Rnews 2004 4/1 article has been indispensible, but I often work with files where dates and times are contained in a single field. In this case, I would like to control input/output of chron objects when each observation of date and time is

Hi. I frequently convert date and time data to and from character representations. I'm frustrated with chron, because 'seconds' are required to create a time object (my input data never has seconds). More importantly, I cannot make chron print the format 12/30/2006 (which my output data requires). I really like the format flexibility of strftime() and strptime(), but of course

Hi all, I'm having difficulty converting a 'dates' object to a POSIXct object: testDATES<-c(35947,35971,36004,36008,36053,36066) testDATES<-chron(dates=testDATES, format = c(dates = "m/d/y"), origin=c(month = 12, day = 30, year = 1899)) >[1] 06/01/98 06/25/98 07/28/98 08/01/98 09/15/98 09/28/98 > as.POSIXct(testDATES) [1] NA NA NA NA NA NA

Hi All, I am attempting to work with some data from loggers. I have read in a .csv exported from MS Access that already has my dates and times (in 24 clock format), (with StringsAsFactors=FALSE). > head(tdata) LogData date time 1 77.16 2008/04/24 02:00 2 61.78 2008/04/24 04:00 3 75.44 2008/04/24 06:00 4 89.43 2008/04/24

I am trying to use POSIX datetime objects rather than chron datetime objects but am having difficulty with POSIX in a time series. My question: Once a POSIXct vector is bound to a time series, is there a function to convert back to POSIXct? The following code demonstrates what I am trying to do. > ts(as.POSIXct(strptime(tmp,"%m/%d/%Y %H:%M:%S")),freq=1440) Time Series: Start =

I am wrestling with time and date data. I came up with a way to plot and label a histogram with "time of day" on the x-axis, but it seemed like a lot more work than should be necessary. Is there a better way to do what I am trying to do? require(chron) # read input data data = read.table("input.dat", header=T) # Create date-time and chron objects datetime =

R-devel, The performance of as.Date differs by a large degree between one of my machines with glibc 2.3.2: > system.time(x <- as.Date(rep("01-01-2005", 100000), format = "%m-%d-%Y")) [1] 1.17 0.00 1.18 0.00 0.00 and a comparable machine with glibc 2.3.3: > system.time(x <- as.Date(rep("01-01-2005", 100000), format = "%m-%d-%Y")) [1] 31.20

hi again I will try this time to explain my problem clearly I have the following data from the file skiing.csv (3 first rows) protokollid date start end 1 4 2/23/2009 8:50:10 15:17:30 2 4 2/24/2009 9:47:00 13:52:25 3 5 3/22/2009 8:51:25 12:00:05 I have the following script library(chron) skiers=read.csv("skiing.csv")

Hi all; I've already send a similar e-mail to the list and Prof. Brian Ripley answered me but my doubts remain unresolved. Thanks for the clarification, but perhaps I wasn't clear enough in posting my questions. I've got a postgres database which I read into R. The first column is Timestamp with timezone, and my data are already in UTC format. An 'printed' extract of R

(R-1.6.0 and chron 2.2, linux) I have to work with date/time values from another LOCALE on my machine. My normal locale is "de DE at euro" and the data I have to handle use AM/PM specifications for the times. dstring <- "Nov 12 2001 4:31PM" The problem now is, that strptime(dstring, "%b %d %Y %I:%M%p") [1] "2001-11-12 04:31:00" just ignores my

Full_Name: Xiao Gang FAN Version: 2.4.0 OS: Windows Submission from: (NULL) (159.50.101.9) > library(chron) > as.Date(as.POSIXct(strptime("1994-01-24","%Y-%m-%d"))) [1] "1994-01-23"

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.

I need to write an if/then statement saying something along the lines of: if (VALUE is in list) {... How do I write that in R's language. Thanks! -- View this message in context: http://r.789695.n4.nabble.com/If-then-statement-if-in-a-list-then-tp4638346.html Sent from the R help mailing list archive at Nabble.com.

Hi all, I need to compare time series data files of different time formats. I had no problems with text format using strptime. But how can I convert datetime numbers from Excel (days since 30.12.1899 00:00:00) into POSIXt objects? For example 29770.375 should be converted to "03.07.1981 09:00:00" I tried the following code and encountered strange results: t1-t0 gives 29770.33

Hi, I keep on trying to write some small scripts in order to learn R but even with basic scripts I have problems ... I start with the name of a file which is in fact the time the file has been generated (I cannot change the format). Then I convert namefile with strptime. The problem occurs when I add another time from another file with append. It displays some informations I don't want. I

R offers a bewildering array of options when it comes to representing dates and times (e.g, as.Date, chron, strptime, zoo, etc). Can anybody recommend a document that compares the relative merit of each method? I'm not looking for help with any one method, but rather a guide that describes which method is best for a particular data analysis/plotting goal. Thanks, Jake [[alternative

Hi, I'm experiencing a problem with strptime. (R 1.9.1 on a Win2000 machine) I have a large list containing 6 columns and 161800 rows. One column contains dates that I want to convert in order to compare the different dates. Some dates work just fine while others become NA. I don't see any difference between the dates. I've attached an example from my code. Hope this explains my

I'm stuck, but am sure it can be done I just don't understand how. I have data in an irregular timeseries. I want to be able to use stl to visualise the data (see seasonal parts etc), so I need to change to regular series of class ts (I think). I am using 2 zoo objects one is regular and the other is my irregular data. I am then merging to create the object I want but when I try to change

I have a set of timestamp data that I have in a text file that I would like to import into R for analysis. The timestamps are formated as follows: DT_1,DT_2 [2006/08/10 21:12:14 ],[2006/08/10 21:54:00 ] [2006/08/10 20:42:00 ],[2006/08/10 22:48:00 ] [2006/08/10 20:58:00 ],[2006/08/10 21:39:00 ] [2006/08/04 12:15:24 ],[2006/08/04 12:20:00 ] [2006/08/04 12:02:00 ],[2006/08/04 14:20:00 ] I can get