Displaying 4 results from an estimated 4 matches for "basistim".
Did you mean:
basistime
2017 Oct 26
0
Help needed with aggregate or other solution
...problems...
>
> (1) there are now 3 date columns (it looks like 2 cols are merged into 1
> col)
No, there are two date columns. Result2 includes the grouping value as a
row name (pulled from the names of the dta2list items by rbind).
> (2) the output rows should not have any of the basistime dates repeated
> (maybe I misstated the problem); I need the max fcst value by basistime, but
> also list the date value for that row; for example:
Then try out my code replacing
dta2list <- split( dta2, dta2$date )
with
dta2list <- split( dta2, dta2$basistime )
and
%>% group_...
2017 Oct 26
3
Help needed with aggregate or other solution
Hi Jeff,
Thank you for the suggestions -- I appreciate your help. Unfortunately, the
result2 has two problems...
(1) there are now 3 date columns (it looks like 2 cols are merged into 1
col)
(2) the output rows should not have any of the basistime dates repeated
(maybe I misstated the problem); I need the max fcst value by basistime,
but also list the date value for that row; for example:
basistime fcst
1 2012-01-25 15:02:00 47.9
2 2012-01-26 15:11:00 50.4
3 2012-01-27 01:41:00 46.0
4 2012-01-27 10:15:00 47.3
5 2012-...
2017 Oct 26
0
Help needed with aggregate or other solution
...uot;, "2012-05-27 18:00:00",
"2012-05-28 00:00:00", "2012-05-28 06:00:00", "2012-05-28 12:00:00",
"2012-05-28 18:00:00", "2012-05-29 00:00:00", "2012-05-29 06:00:00",
"2012-05-29 12:00:00"), class = "factor"), basistime = structure(c(1L,
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L,
1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L,
2L, 2L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L,
3L), .Label = c("2012-01-25 15:02:00", "2012-01-26 15:11:00",
"...
2017 Oct 26
2
Help needed with aggregate or other solution
...uot;, "2012-05-27 18:00:00",
"2012-05-28 00:00:00", "2012-05-28 06:00:00", "2012-05-28 12:00:00",
"2012-05-28 18:00:00", "2012-05-29 00:00:00", "2012-05-29 06:00:00",
"2012-05-29 12:00:00"), class = "factor"), basistime = structure(c(1L,
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L,
1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L,
2L, 2L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L,
3L), .Label = c("2012-01-25 15:02:00", "2012-01-26 15:11:00",
"...