Dear List:
I encountered this strange problem. I want to read dates in a R program.
This is a sample data:
Dates
12/12/08
14/12/08
18/01/08
28/02/08
16/06/08
19/07/08
28/09/08
If I save these dates in a .csv file, and read it in R using "read.csv", I
can perfectly read the data, and the commands "months(Dates)", "days(Dates)"
work perfectly fine. On the other hand, if I save this data as an .xls file,
and then read it in R using the "gdata" package using the command
"read.xls("/.../.../Dates.xls",sheet=1,header=T)", and then attempt to read
the months using months(Dates), this is the output that I get:
> months(Dates)
[1] Dec Dec Jan Mar Jun Jul Sep
12 Levels: Jan < Feb < Mar < Apr < May < Jun < Jul < Aug < Sep < ... < Dec
The fourth observation is wrongly read as "Mar" whereas it should be read as
"Feb". I am not able to make out the error. Am I making a mistake in reading
the dates from the read.xls command?
Thanks.
--
Prabhanjan N. Tattar
Bangalore
--
Prabhanjan N. Tattar
Lead Statistician
CustomerXPS
Bangalore
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
