[R] help working with date values
Steve_Friedman at nps.gov
Steve_Friedman at nps.gov
Tue Apr 28 15:04:01 CEST 2009
My data contains a variable "observation_date" and it contains values as:
1985-09-02
1985-09-15
1985-07-31
1985-09-02
I need to process data annually rather than daily, therefore I'm trying to
1) either extract the first 4 digits from this field and use them as a new
variable "year" or 2) keep the variable as it is and process the analysis
using the first 4 digits of the observation_date field.
I'm not sure how to do either one of these approaches. I've looked in the
R-archive help pages, date, strsplit and a few others
> attach(gator)
> observation_date[1:10]
[1] 1985-09-02 1985-09-16 1985-07-31 1985-07-31 1985-09-02 1985-08-26
1985-07-31 1985-08-26 1985-09-02 1985-09-16
> as.date(observation_date)
Error in as.date(observation_date) : Cannot coerce to date format
> mode(observation_date)
"numeric"
> y <- as.character(observation_date)
[1] "1985-09-02" "1985-09-16" "1985-07-31" "1985-07-31" "1985-09-02"
"1985-08-26" "1985-07-31" "1985-08-26" "1985-09-02" "1985-09-16"
< y.date <- as.date(y)
[1] <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> on and on
and on ...
> x <- strsplit(observation_date, "-")
Error in strsplit(observation_date, "-") : non-character argument
All help is greatly appreciated.
Thanks
Steve
Steve Friedman Ph. D.
Spatial Statistical Analyst
Everglades and Dry Tortugas National Park
950 N Krome Ave (3rd Floor)
Homestead, Florida 33034
Steve_Friedman at nps.gov
Office (305) 224 - 4282
Fax (305) 224 - 4147
More information about the R-help
mailing list