R tick data : merging date and time into a single object

r statistics time-series finance
marino89 picture marino89 · Jul 23, 2012 · Viewed 49.1k times · Source

I'm currently working in tick data with R and I would like to merge date and time into a single object as I need to get a precise time object to compute some statistics on my data. Here is how my data looks like:

               date       time      price flag    exchange
2   XXH10   2010-02-02   08:00:03   2787 1824        E
3   XXH10   2010-02-02   08:00:04   2786    3        E
4   XXH10   2010-02-02   08:00:04   2787    6        E
5   XXH10   2010-02-02   08:00:04   2787    1        E
6   XXH10   2010-02-02   08:00:04   2787    1        E

Basically, I would like to merge the columns "date" and "time" into a single one.

Answer

Andrie picture Andrie · Jul 23, 2012

Create a datetime object with as.POSIXct:

as.POSIXct(paste(x$date, x$time), format="%Y-%m-%d %H:%M:%S")
[1] "2010-02-02 08:00:03 GMT" "2010-02-02 08:00:04 GMT" "2010-02-02 08:00:04 GMT"
[4] "2010-02-02 08:00:04 GMT" "2010-02-02 08:00:04 GMT"

Related questions

Multivariate time series modelling in R

I want do fit some sort of multi-variate time series model using R. Here is a sample of my data: u cci bci cpi gdp dum1 dum2 dum3 dx 16.50 14.00 53.00 45.70 80.63 0 0 1 6.39 17.45 16.00 64.00 46.30 80.90 0 0 0 6.00 18.40 12.00 51.00 47.30 82.40 1 0 0 6.57 19.35 7.00 42.00 48.40 83.38 0 1 0 5.84 20.30 9.00 34.00 49.50 84.38 0 0 1 6.36 20.72 10.00 42.00 50.60 85.17 0 0 0 5.78 21.14 6.00 45.00 51.90 85.60 1 0 0 5.16 21.56 9.00 38.00 52.60 86.14 0 1 0 5.62 21.98 2.00 32.00 53.50 86.23 0 0 1 4.94 22.78 8.00 29.00 53.80 86.24 0 0 0 6.25 The data is quarterly, the dummy variables are for seasonality. What …

Read More
STL decomposition of time series with missing values for anomaly detection

I am trying to detect anomalous values in a time series of climatic data with some missing observations. Searching the web I found many available approaches. Of those, stl decomposition seems appealing, in the sense of removing trend and seasonal …

Read More
how to calculate all pairwise distances in two dimensions

Say I have data concerning the position of animals on a 2d plane (as determined by video monitoring from a camera directly overhead). For example a matrix with 15 rows (1 for each animal) and 2 columns (x position and y position) animal.…

Read More