[R] order a data frame by date with order
Benedikt Gehr
benedikt.gehr at ieu.uzh.ch
Wed May 16 09:27:53 CEST 2012
Hi
I have a rather large data frame (>7000 rows with 28 columns) which I want
to sort by date. Below I have a example of the data frame. The Date column
is called DT, is a factor and looks like this:
class(res.merge$DT)
[1] "factor"
head(res.merge$DT)
[1] 17.3.2012 13:54:02 17.3.2012 14:00:07 17.3.2012 14:30:25 17.3.2012
15:01:15
[5] 17.3.2012 15:32:14 17.3.2012 16:01:29
2530 Levels: 1.4.2012 00:00:52 1.4.2012 00:30:29 ... 9.5.2012 15:30:50
res.merge is the data frame unordered. Now I want to order the data frame
with:
res.ordered<-res.merge[order(as.POSIXct(as.character(res.merge$DT),format="%d.%m.%Y
%H:%M:%S")),]
This works in fact, however for some reason there are always two entires
that go at the end of the data frame for no obvious reason (see below,
09.05.2012 ist the most recent date). And this is the case for different
data.frames. The two entries at the end are always 25.3.2012 02:00:xx and
25.3.2012 02.30.xx.
Can anybody tell me what the problem is? Any help is most appreciated.
Best Benedikt
res.ordered[2545:2549,]
DT Typ NOD Day_s DOW_s Time_s Long Lat
2547 9.5.2012 14:30:56 GPS 1893 9.5.2012 We 14:30:00 7.452218 46.43579
2548 9.5.2012 15:02:09 GPS 1893 9.5.2012 We 15:00:35 7.451983 46.43583
2549 9.5.2012 15:30:50 GPS 1893 9.5.2012 We 15:30:00 7.451973 46.43597
1845 25.3.2012 02:00:18 GPS 1848 25.3.2012 So 02:00:01 7.454266 46.45414
1846 25.3.2012 02:30:16 GPS 1848 25.3.2012 So 02:30:00 7.454413 46.45437
Height TOF Status FO_GPS GPS_N AOT Day_e DOW_e Time_e BV Temp
SOG
2547 1182.8 3 A 1 143 55 9.5.2012 We 14:30:56 3735 31
0.09
2548 1182.8 3 A 1 143 94 9.5.2012 We 15:02:09 3637 32
0.02
2549 1176.5 3 A 1 143 50 9.5.2012 We 15:30:50 3730 29
0.17
1845 1295.2 3 A 1 151 17 25.3.2012 So 02:00:18 3715 7
0.18
1846 1287.3 3 A 1 144 16 25.3.2012 So 02:30:16 3720 8
0.14
Heading SAE HAE BW_2 BW_3 X..
2547 24.90 3.81 9.47 3666 3625 9.08
2548 7.86 0.51 7.17 3593 3586 9.11
2549 344.72 2.86 4.10 3662 3623 9.12
1845 335.54 3.53 5.63 3618 3618 0.81
1846 75.37 5.44 8.96 3618 3618 0.81
--
View this message in context: http://r.789695.n4.nabble.com/order-a-data-frame-by-date-with-order-tp4630225.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list