Re: [R] How to combine Date and time in one column

2010-11-23 Thread Nikos Rachmanis
Hi Gabor, Thanks very much for the suggestion. It worked well until the point that i tried to plot the xts object. here is my code and the error message. lines-data.frame(date,time,open,high, low,close) #create a dataframe with all the variables z - read.zoo(lines, header = TRUE, index = list(1,

Re: [R] How to combine Date and time in one column

2010-11-23 Thread Gabor Grothendieck
On Tue, Nov 23, 2010 at 7:56 PM, Nikos Rachmanis nikos.rachma...@gmail.com wrote: Hi Gabor, Thanks very much for the suggestion. It worked well until the point that i tried to plot the xts object. here is my code and the error message. lines-data.frame(date,time,open,high, low,close) #create a

Re: [R] How to combine Date and time in one column

2010-11-23 Thread Nikos Rachmanis
Thanks Gabor! Work perfectly! This is the code i used. z - read.zoo(lines, header = TRUE, index = list(1, 2), FUN = function(d,t) as.POSIXct(paste(date,time), format = %m/%d/%Y %H:%M)) On Tue, Nov 23, 2010 at 8:07 PM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Tue, Nov 23, 2010 at

Re: [R] How to combine Date and time in one column

2010-11-22 Thread Uwe Ligges
On 22.11.2010 08:24, rnick wrote: Hello everyone, I am trying to built an xts object and i have run into some problems on the data handling. I would really appreciate if someone could help me with the following: 1) I have a OHLC dataset with Time and date in different columns. How could i

Re: [R] How to combine Date and time in one column

2010-11-22 Thread Gabor Grothendieck
On Mon, Nov 22, 2010 at 2:24 AM, rnick nikos.rachma...@gmail.com wrote: Hello everyone, I am trying to built an xts object and i have run into some problems on the data handling. I would really appreciate if someone could help me with the following: 1) I have a OHLC dataset with Time and