Dear R-users,
I'm working on datasets which contain data from the years 1960 to 2100 with a
timestep of one hour. Every year has 365 days, leap years are ignored.
After reading the dataset with R I convert the column which contains date/time
to POSIXct:
as.POSIXct(strptime(MyData [,1], format="%d.%m.%Y : %H"))
After that, I divide the data with split() into parts of one year each. Then I
recognized, that the years for some rows are obviously converted wrong: They
show years larger than 2100 (see example below).
I've controlled my original dataset, but the dates are correct there.
I also produced a date/time-sequence in R, which showed the same mistakes (see
example below). The mistakes occur at the same dates like in my datasets. It's
always at the end of march.
> datetimesequenz <- seq.POSIXt(from=as.POSIXct("1960-01-01 00:00"),
> to=as.POSIXct("2100-01-01 00:00"), by="1 hour")
> levels(as.factor(strftime(datetimesequenz, format="%Y")))
[1] "1960" "1961" "1962" "1963" "1964" "1965" "1966" "1967" "1968" "1969"
"1970" "1971" "1972" "1973" "1974" "1975" "1976" "1977"
[19] "1978" "1979" "1980" "1981" "1982" "1983" "1984" "1985" "1986" "1987"
"1988" "1989" "1990" "1991" "1992" "1993" "1994" "1995"
[37] "1996" "1997" "1998" "1999" "2000" "2001" "2002" "2003" "2004" "2005"
"2006" "2007" "2008" "2009" "2010" "2011" "2012" "2013"
[55] "2014" "2015" "2016" "2017" "2018" "2019" "2020" "2021" "2022" "2023"
"2024" "2025" "2026" "2027" "2028" "2029" "2030" "2031"
[73] "2032" "2033" "2034" "2035" "2036" "2037" "2038" "2039" "2040" "2041"
"2042" "2043" "2044" "2045" "2046" "2047" "2048" "2049"
[91] "2050" "2051" "2052" "2053" "2054" "2055" "2056" "2057" "2058" "2059"
"2060" "2061" "2062" "2063" "2064" "2065" "2066" "2067"
[109] "2068" "2069" "2070" "2071" "2072" "2073" "2074" "2075" "2076" "2077"
"2078" "2079" "2080" "2081" "2082" "2083" "2084" "2085"
[127] "2086" "2087" "2088" "2089" "2090" "2091" "2092" "2093" "2094" "2095"
"2096" "2097" "2098" "2099" "2100" "2101" "2102" "2103"
[145] "2105" "2107" "2109" "2110" "2111" "2112" "2113" "2114" "2115" "2117"
"2118" "2120" "2121" "2122" "2124" "2125" "2126" "2128"
[163] "2129" "2130" "2131" "2132" "2133" "2135" "2137" "2138" "2139" "2140"
"2141" "2142" "2143" "2145" "2146" "2148" "2149" "2150"
[181] "2152" "2153" "2154" "2156" "2157" "2158" "2159" "2160" "2161" "2166"
Has anybody experienced the same problem and knows a workaround?
I'm using R 3.0.1 under Windows 7 64bit. I also tried this with R 3.0.3, it
showed the same problem.
Thank you for your help!
Kind regards,
Matthias
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
