[R] Troubles with the format of dates
Kathi
kathi at dropnet.ch
Thu Nov 27 14:20:17 CET 2008
Dear useRs,
I'm struggling again with date-related stuff: I am using R to draw water levels at certain measuring
stations. My data comes as a tab-delimited text file and looks like this:
DATUM P1 P2
...
2006-11-16 425.21 423.99
2006-12-15 425.12 423.97
2007-01-16 425.16 424.06
...
(measurements started in July 2004 and still continue on a monthly or bi-weekly basis)
This is then plotted using this code:
a<-read.table("dummy_data.tab", sep="\t", header=TRUE, na.strings=c(0))
x<-as.Date(a$DATUM)
plot(x, a$P1, axes=FALSE, xlim=c(as.Date("2004-07-01"), as.Date("2009-01-01")),
ylim=c(423,428), col="red", pch=15, type="o", ylab="Kote [m a.s.l.]",
main="Dummy Plot")
points(x, a$P2, col="red", pch=17, type="o", lty="dotted")
axis(2, at=423:428, tck=1, col="gray60")
axis.Date(1, at=seq(as.Date("2004-07-01"), as.Date("2009-01-01"),
by="month"), labels=seq(as.Date("2004-07-01"), as.Date("2009-01-01"),
by="month"), tck=1, col="gray60")
So far, I've been using this type of date format (yyyy-mm-dd) because that was the only way I could
get the whole thing to work when I started using R. However, living in Switzerland, I would prefer
the dates to read 16.11.2006 i.e. dd.mm.yyyy or 16. Nov. 2006 (preferably using German names for
the months, if possible).
I've used the chron package to convert my dates to day mon year (16 Nov 2006, with or without
spaces), i.e. I replaced the second line of code with:
x<-format(chron(as.character(a$DATUM), format="y-m-d", out.format="day mon year"))
but then I can't plot them any more, because as.Date() no longer is the correct function and R gives
me an error saying there is an invalid xlim-value. Can someone please point me in the right
direction?
I could easily change the input data to be in dd.mm.yyyy format, if that helps.
Thanks for your help,
Kathi
--
DropNet AG - Das Unternehmen fuer Ihren Internet-Auftritt!
More information about the R-help
mailing list