Dear Gurus,
I am so happy to thank you all for your great help!!!
Jim's code first did it.
Thanks again to everyone.
Warmest regards
Ogbos
On Thu, Jan 23, 2020 at 10:42 AM Jim Lemon wrote:
>
> Hi Ogbos,
> Try this:
>
> oodates<-read.table(text="1963 335 0
> 1963 335 1
> 1963 335 2
> 1963 335 3
> 1
Jim's (and Petr's) solution wins
-pd
> On 23 Jan 2020, at 10:56 , peter dalgaard wrote:
>
> Here's an idea:
>
>> as.POSIXct(paste0("1963","-1-1"))+as.difftime(335,units="days") +
>> as.difftime(3, units="hours")
> [1] "1963-12-02 03:00:00 CET"
>
> However, 2 caveats
>
> (a) I think you
Here's an idea:
> as.POSIXct(paste0("1963","-1-1"))+as.difftime(335,units="days") +
> as.difftime(3, units="hours")
[1] "1963-12-02 03:00:00 CET"
However, 2 caveats
(a) I think you need to subtract 1 from the DOY (1 should be Jan 1, right?)
(b) Beware Daylight Savings time:
> as.POSIXct(paste0
does not need to do it one by one, but exact way depends on
how does the object look like in R.
Cheers
Petr
> -Original Message-
> From: R-help On Behalf Of Ogbos Okike
> Sent: Thursday, January 23, 2020 10:24 AM
> To: r-help
> Subject: [R] Convert Long DOY time format to
Hi Ogbos,
Try this:
oodates<-read.table(text="1963 335 0
1963 335 1
1963 335 2
1963 335 3
1963 335 4
1963 335 5
1963 335 6
1963 335 7
1963 335 8
1963 335 9
1996 202 20
1996 202 21
1996 202 22
1996 202 23
1996 203 0
1996 203 1
1996 203 2
1996 203 3
2018 365 20
2018 365 21
2018 365 22
2018 365 23")
Quoting Ogbos Okike :
Dear Experts,
I have a data spanning 56 years from 1963 to 2018.
The datetime format is in DOY hour:
1963 335 0
1963 335 1
1963 335 2
1963 335 3
1963 335 4
1963 335 5
1963 335 6
1963 335 7
1963 335 8
1963 335 9
1996 202 20
1996 202 21
1996 202 22
1996 202 23
1996 203 0
19
Dear Experts,
I have a data spanning 56 years from 1963 to 2018.
The datetime format is in DOY hour:
1963 335 0
1963 335 1
1963 335 2
1963 335 3
1963 335 4
1963 335 5
1963 335 6
1963 335 7
1963 335 8
1963 335 9
1996 202 20
1996 202 21
1996 202 22
1996 202 23
1996 203 0
1996 203 1
1996 203 2
1996 20
7 matches
Mail list logo