[R] Question on creating Date variable
David Winsemius
dwinsemius at comcast.net
Mon Dec 31 20:44:53 CET 2012
On Dec 31, 2012, at 11:35 AM, Christofer Bogaso wrote:
> On 01 January 2013 00:17:50, David Winsemius wrote:
>>
>> On Dec 31, 2012, at 9:12 AM, Christofer Bogaso wrote:
>>
>>> Hello all,
>>>
>>> Let say I have following (numeric) vector:
>>>
>>> > x
>>> [1] 11.00 11.25 11.35 12.01 11.14 13.00 13.25 13.35 14.01 13.14
>>> 14.50
>>> 14.75 14.85 15.51 14.64
>>>
>>> Now, I want to create a 'Date' variable (i.e. I should be able to do
>>> all calculations pertaining to date/time and also time-series
>>> plotting etc.) like
>>>
>>> 2012-12-31 11:00:00 AM, 2012-12-31 11:25:00 AM, 2012-12-31 11:35:00
>>> AM, 2012-12-31 12:01:00 PM, . . . .
>>>
>>
>> Those _times_ ( _not_ Dates) cannot possibly be in %M.%S" format,
>> given the number of items to the right of the decimal point that are
>> greater than 60. So will proceed on the arguably more likely
>> assumption that they are in fractional minutes. To recover from that
>> problem, one might consider:
>>
>> > as.POSIXct(paste( floor(x), round(60*(x-floor(x))) ), format="%M
>> %S")
>> [1] "2012-12-31 00:11:00 PST" "2012-12-31 00:11:15 PST"
>> [3] "2012-12-31 00:11:21 PST" "2012-12-31 00:12:01 PST"
>> [5] "2012-12-31 00:11:08 PST" "2012-12-31 00:13:00 PST"
>> [7] "2012-12-31 00:13:15 PST" "2012-12-31 00:13:21 PST"
>> [9] "2012-12-31 00:14:01 PST" "2012-12-31 00:13:08 PST"
>> [11] "2012-12-31 00:14:30 PST" "2012-12-31 00:14:45 PST"
>> [13] "2012-12-31 00:14:51 PST" "2012-12-31 00:15:31 PST"
>> [15] "2012-12-31 00:14:38 PST"
>>
>
> I understand that some of those elements are not "dates". However
> what I want is the ***"PM/AM" suffix*** on those elements which are
> considered as Dates.
>
> ***Getting those suffix*** and doing calculations on those changed
> variables is my primary concern.
That's the first time that AM/PM has bee mentioned and I suppose if
those were fractional hours rather than my guess of fractional minutes
that there might be representatives of both in the numeric data you
offered. Why don't you clarify what these number do in fact represent?
And what problem you are trying to solve?
--
David Winsemius, MD
Alameda, CA, USA
More information about the R-help
mailing list