[R] Questions about doing analysis based on time

APOCooter mikeedinger16 at gmail.com
Fri Jun 22 22:45:18 CEST 2012


Here is a part of the data for the first two questions:

> head(Sunday,100)
            SunDate SunTime SunScore
1     5/9/2010 0:00    0:00      127
2    6/12/2011 0:00    0:00      125
3    6/15/2008 0:04    0:04       98
4     8/3/2008 0:07    0:07      118
5    7/24/2011 0:07    0:07      122
6    5/25/2008 0:09    0:09      104
7    5/20/2012 0:11    0:11      124
8   10/18/2009 0:12    0:12      121
9    3/14/2010 0:12    0:12      117
10    1/2/2011 0:12    0:12      131
11    8/1/2010 0:13    0:13      142
12   6/26/2011 0:14    0:14      102
13   12/4/2011 0:14    0:14      136
14   2/13/2011 0:18    0:18      200
15   9/21/2008 0:19    0:19       88
16   9/20/2009 0:19    0:19      142
17   8/17/2008 0:20    0:20       84
18   2/12/2012 0:21    0:21       23
19  11/21/2010 0:22    0:22      103
20  10/26/2008 0:23    0:23      167
21   8/10/2008 0:27    0:27      116
22   3/28/2010 0:27    0:27      168
23   11/8/2009 0:28    0:28      151
24  11/27/2011 0:28    0:28      105
25   6/22/2008 0:29    0:29       95
26   7/31/2011 0:29    0:29      180
27   12/6/2009 0:30    0:30       55
28  11/30/2008 0:31    0:31      105
29    9/4/2011 0:31    0:31      144
30    8/8/2010 0:32    0:32      155
31    5/2/2010 0:36    0:36      174
32  10/26/2008 0:37    0:37      141
33   5/30/2010 0:37    0:37      153
34    7/5/2009 0:41    0:41      130
35   4/10/2011 0:41    0:41      112
36    2/8/2009 0:43    0:43      116
37   5/15/2011 0:43    0:43      147
38   1/18/2009 0:45    0:45      143
39   5/24/2009 0:45    0:45      165
40   9/19/2010 0:45    0:45      183
41   7/12/2009 0:46    0:46      161
42    2/7/2010 0:46    0:46      140
43   5/16/2010 0:46    0:46      134
44   7/10/2011 0:46    0:46      113
45   11/9/2008 0:47    0:47      151
46    4/4/2010 0:47    0:47      138
47   2/26/2012 0:48    0:48      200
48   9/28/2008 0:50    0:50      116
49   7/17/2011 0:50    0:50      146
50  12/18/2011 0:50    0:50      200
51   5/17/2009 0:51    0:51      152
52    5/6/2012 0:51    0:51      151
53   8/29/2010 0:52    0:52      117
54   12/5/2010 0:52    0:52      156
55  12/18/2011 0:53    0:53       82
56    3/4/2012 0:53    0:53       68
57   2/27/2011 0:55    0:55      200
58   6/12/2011 0:55    0:55      129
59    3/8/2009 0:58    0:58       81
60   2/27/2011 0:58    0:58      114
61    2/1/2009 1:03    1:03      144
62   7/25/2010 1:04    1:04      110
63  12/28/2008 1:05    1:05      132
64   6/15/2008 1:06    1:06       53
65   8/30/2009 1:06    1:06       42
66    7/6/2008 1:07    1:07      117
67    5/1/2011 1:07    1:07       65
68   11/6/2011 1:08    1:08      127
69    3/6/2011 1:09    1:09      106
70  10/10/2010 1:13    1:13      129
71    2/6/2011 1:13    1:13      159
72    2/6/2011 1:13    1:13      159
73  11/13/2011 1:13    1:13      110
74  12/13/2009 1:16    1:16      120
75    9/4/2011 1:17    1:17      114
76  10/17/2010 1:18    1:18      129
77  12/12/2010 1:20    1:20       54
78   4/17/2011 1:20    1:20       81
79    6/5/2011 1:20    1:20      154
80   7/11/2010 1:22    1:22      139
81   3/29/2009 1:23    1:23      132
82    6/8/2008 1:24    1:24       69
83   1/11/2009 1:25    1:25       32
84   9/27/2009 1:25    1:25       60
85   7/24/2011 1:25    1:25       74
86   1/16/2011 1:26    1:26       82
87   8/31/2008 1:27    1:27      135
88   2/13/2011 1:29    1:29      161
89   3/20/2011 1:30    1:30      106
90   5/10/2009 1:34    1:34      114
91   11/2/2008 1:35    1:35       71
92   3/21/2010 1:38    1:38       60
93    9/5/2010 1:39    1:39      120
94   6/14/2009 1:42    1:42       81
95   6/21/2009 1:43    1:43      121
96  11/14/2010 1:43    1:43       59
97    3/1/2009 1:47    1:47      130
98   8/22/2010 1:48    1:48      128
99   7/18/2010 1:49    1:49      200
100  7/18/2010 1:49    1:49      155



And here is part of the data for the last three questions:

> head(Overall, 100)
    DayOfWeek            Date  Time Score
1         Thu   5/1/2008 2:58  2:58    80
2         Thu   5/1/2008 7:31  7:31    11
3         Thu  5/1/2008 10:35 10:35    81
4         Thu  5/1/2008 17:20 17:20   152
5         Thu  5/1/2008 19:01 19:01   130
6         Thu  5/1/2008 21:35 21:35   122
7         Fri   5/2/2008 1:43  1:43   142
8         Fri   5/2/2008 6:03  6:03    20
9         Fri   5/2/2008 7:05  7:05     1
10        Fri  5/2/2008 10:47 10:47    31
11        Fri  5/2/2008 17:13 17:13    93
12        Fri  5/2/2008 18:02 18:02   136
13        Fri  5/2/2008 19:22 19:22   128
14        Sat   5/3/2008 1:04  1:04   112
15        Sat   5/3/2008 7:03  7:03    48
16        Sat  5/3/2008 11:52 11:52    57
17        Sat  5/3/2008 13:53 13:53    92
18        Sat  5/3/2008 16:56 16:56   108
19        Sat  5/3/2008 18:44 18:44   100
20        Sat  5/3/2008 20:04 20:04   107
21        Sat  5/3/2008 23:13 23:13    81
22        Sun   5/4/2008 3:56  3:56    37
23        Sun   5/4/2008 7:38  7:38    47
24        Sun  5/4/2008 13:21 13:21    70
25        Sun  5/4/2008 15:28 15:28   114
26        Sun  5/4/2008 20:00 20:00   125
27        Sun  5/4/2008 23:14 23:14    99
28        Mon   5/5/2008 5:38  5:38    46
29        Mon  5/5/2008 11:36 11:36   108
30        Mon  5/5/2008 15:50 15:50   106
31        Mon  5/5/2008 16:59 16:59   111
32        Mon  5/5/2008 20:47 20:47    75
33        Mon  5/5/2008 23:00 23:00    75
34        Tue   5/6/2008 0:43  0:43   136
35        Tue   5/6/2008 4:12  4:12    36
36        Tue   5/6/2008 7:48  7:48    13
37        Tue   5/6/2008 9:40  9:40    35
38        Tue  5/6/2008 11:55 11:55    71
39        Tue  5/6/2008 13:46 13:46   105
40        Tue  5/6/2008 16:02 16:02   113
41        Tue  5/6/2008 17:55 17:55   116
42        Tue  5/6/2008 17:55 17:55   116
43        Tue  5/6/2008 20:00 20:00    94
44        Tue  5/6/2008 22:23 22:23   130
45        Wed   5/7/2008 0:23  0:23   102
46        Wed   5/7/2008 2:44  2:44    19
47        Wed   5/7/2008 6:28  6:28     1
48        Wed   5/7/2008 8:43  8:43    33
49        Wed  5/7/2008 12:14 12:14    78
50        Wed  5/7/2008 14:09 14:09    89
51        Wed  5/7/2008 17:47 17:47   115
52        Wed  5/7/2008 19:20 19:20   130
53        Wed  5/7/2008 23:35 23:35   117
54        Thu   5/8/2008 2:48  2:48   105
55        Thu   5/8/2008 5:18  5:18     0
56        Thu  5/8/2008 11:12 11:12    36
57        Thu  5/8/2008 15:15 15:15    80
58        Thu  5/8/2008 17:45 17:45   130
59        Thu  5/8/2008 20:06 20:06   124
60        Thu  5/8/2008 20:07 20:07   124
61        Fri   5/9/2008 1:01  1:01    66
62        Fri   5/9/2008 7:44  7:44    75
63        Fri  5/9/2008 12:12 12:12    57
64        Fri  5/9/2008 15:14 15:14    94
65        Fri  5/9/2008 19:43 19:43   124
66        Fri  5/9/2008 21:22 21:22   165
67        Fri  5/9/2008 23:26 23:26   170
68        Sat  5/10/2008 1:44  1:44   158
69        Sat  5/10/2008 4:03  4:03   127
70        Sat  5/10/2008 5:54  5:54   116
71        Sat 5/10/2008 13:07 13:07   107
72        Sat 5/10/2008 14:40 14:40   118
73        Sat 5/10/2008 16:59 16:59   150
74        Sat 5/10/2008 19:25 19:25    96
75        Sat 5/10/2008 20:51 20:51   101
76        Sat 5/10/2008 23:06 23:06    59
77        Sun  5/11/2008 2:55  2:55    38
78        Sun  5/11/2008 6:00  6:00    46
79        Sun  5/11/2008 7:23  7:23    77
80        Sun  5/11/2008 9:33  9:33    83
81        Sun 5/11/2008 12:37 12:37    54
82        Sun 5/11/2008 14:35 14:35    61
83        Sun 5/11/2008 18:19 18:19    60
84        Sun 5/11/2008 21:30 21:30    55
85        Sun 5/11/2008 23:32 23:32   110
86        Mon  5/12/2008 0:03  0:03   127
87        Mon  5/12/2008 2:10  2:10   129
88        Mon  5/12/2008 5:47  5:47    87
89        Mon  5/12/2008 8:32  8:32    61
90        Mon 5/12/2008 10:34 10:34    70
91        Mon 5/12/2008 13:37 13:37    85
92        Mon 5/12/2008 14:50 14:50   110
93        Mon 5/12/2008 19:01 19:01   131
94        Mon 5/12/2008 21:09 21:09   151
95        Mon 5/12/2008 23:44 23:44   123
96        Tue  5/13/2008 3:26  3:26    50
97        Tue  5/13/2008 7:21  7:21    77
98        Tue  5/13/2008 9:56  9:56   100
99        Tue 5/13/2008 12:14 12:14   135
100       Tue 5/13/2008 15:03 15:03   151




I thought that's what I was doing with as.POSIXlt?


> try to put your data in a proper time series class (zoo/xts if I 
>might give a personal-ish plug) which will make all these calculations 
>much easier. 



--
View this message in context: http://r.789695.n4.nabble.com/Questions-about-doing-analysis-based-on-time-tp4634230p4634246.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list