[R] Difficulty creating Julian day in data frame
David Winsemius
dwinsemius at comcast.net
Wed Sep 15 18:27:08 CEST 2010
On Sep 15, 2010, at 12:23 PM, David Winsemius wrote:
>
> On Sep 15, 2010, at 12:05 PM, Sean Parks wrote:
>
>> Hi,
>>
>> I'm attempting to add a "Julian Day" column to a data frame.
>>
>> Here is my code and the resulting data frame:
>>
>> vic.data <- read.table("C:/VIC/data/vic.data.csv", header=F)
>> names(vic.data) <- c("year", "month", "day", "precip", "evap",
>> "runoff", "baseflow", "Tsup", "SM1", "SM2", "SM3", "SWE")
>>
>>
>
>
>> vic.data$julian.day <- julian(vic.data$temp.date, origin =
>> as.Date("1900-01-01"))[1]
>
> There's one problem. Why are you appending the "[1]? to the as.Date
> function.
Er, ... that would be the julian function. (But same import.)
-- David
> It's just going to give you the first date.
> --
> David.
>
>> head(vic.data)
>>
>> year month day precip evap runoff baseflow Tsup SM1 SM2
>> SM3 SWE temp.date julian.day
>> 1 1916 1 1 0.00 0.0789 0 0.5037 -15.9907 20.2285
>> 63.4011
>> 296.9437 214.7537 1916-01-01 5843
>> 2 1916 1 2 0.00 0.1135 0 0.5030 -14.1946 20.1619
>> 63.3425
>> 296.5659 214.7009 1916-01-02 5843
>> 3 1916 1 3 29.74 0.1584 0 0.5024 -11.1894 20.0998
>> 63.2817
>> 296.1864 244.0971 1916-01-03 5843
>> 4 1916 1 4 11.37 0.2056 0 0.5017 -12.9745 20.0416
>> 63.2194
>> 295.8052 255.3145 1916-01-04 5843
>> 5 1916 1 5 0.00 0.1467 0 0.5011 -15.1542 19.9866
>> 63.1561
>> 295.4224 255.2361 1916-01-05 5843
>> 6 1916 1 6 0.00 0.0939 0 0.5004 -12.5409 19.9345
>> 63.0922
>> 295.0379 255.2084 1916-01-06 5843
>>
>>
>> As you can see, the "temp.date" column behaves as expected, but the
>> "julian.day" column is populated with the Julian day value from
>> 1/1/1916.
>>
>> Please help me out if you have some ideas.
>>
>> Thanks,
>> Sean
>>
>>
>>
>>
>> *************************
>> Sean Parks
>> Ecologist | Geospatial Analyst
>> Aldo Leopold Wilderness Research Institute
>> Rocky Mountain Research Station
>> (406) 542-4182
>> http://leopold.wilderness.net/
>> *************************
>> [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at 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.
>
> David Winsemius, MD
> West Hartford, CT
>
> ______________________________________________
> R-help at 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.
David Winsemius, MD
West Hartford, CT
More information about the R-help
mailing list