[datatable-help] datatable and function "which.max"

Dominic Roye dominic.roye at gmail.com
Sat Nov 24 21:52:00 CET 2012


Hello,

I hope you can help me with the datatable. My aim is to know the
position of the daily maximum temperature (Ta).

str(y)
Classes ‘data.table’ and 'data.frame':  17135 obs. of  6 variables:
 $ X  : chr  "01/01/2010" "01/01/2010" "01/01/2010" "01/01/2010" ...
 $ X.1: chr  "0:10:00" "0:20:00" "0:30:00" "0:40:00" ...
 $ Ta : num  5.28 5.45 5.54 5.54 5.51 5.51 5.5 5.56 5.58 5.63 ...
 $ HR : int  100 100 100 100 100 100 100 100 100 100 ...
 $ RS : int  0 0 0 0 0 0 0 0 0 0 ...
 $ v  : num  2.3 2.5 1.1 2.3 2.2 2.1 2.2 2.9 2.4 2.6 ...
 - attr(*, ".internal.selfref")=<externalptr>

For this i made the datatable and than:

> z <- y[,which.max(Ta),by=X]
> z
              X  V1
  1: 01/01/2010  84
  2: 02/01/2010 132
  3: 03/01/2010  84
  4: 04/01/2010  92
  5: 05/01/2010   1
 ---
115: 25/04/2010  92
116: 26/04/2010  96
117: 27/04/2010  86
118: 28/04/2010  90
119: 29/04/2010  88


it works well, but the index don´t correspond with the index of the
original table. Have you any idea?

When i try it with z <- y[,max(Ta),by=X] it works perfect, but so I
don`t know the time,

Thanks for your help.

Best regards,

Dominic


More information about the datatable-help mailing list