r - Using dplyr summary function on yearmon from zoo -


i have data frame values associated year , month. use yearmon class zoo package store year-month info.

my aim count average of values same year-month. however, using dplyr seems give me error.

the variable tst below reproduction

> str(tst) 'data.frame':   20 obs. of  2 variables:  $ n : int  23 24 26 27 26 23 19 19 22 22 ...  $ ym:class 'yearmon'  num [1:20] 2004 2004 2004 2004 2004 ... > dput(tst) structure(list(n = c(23l, 24l, 26l, 27l, 26l, 23l, 19l, 19l,  22l, 22l, 22l, 22l, 26l, 26l, 19l, 22l, 26l, 25l, 22l, 18l),      ym = structure(c(2004, 2004, 2004, 2004, 2004.08333333333,      2004.08333333333, 2004.08333333333, 2004.08333333333, 2004.08333333333,      2004.16666666667, 2004.16666666667, 2004.16666666667, 2004.16666666667,      2004.25, 2004.25, 2004.25, 2004.25, 2004.33333333333, 2004.33333333333,      2004.33333333333), class = "yearmon")), .names = c("n", "ym" ), row.names = c(na, 20l), class = "data.frame")

and error was

> tst %>% group_by(ym) %>% summarize(ave=mean(n)) error: column 'ym' has unsupported type : yearmon

is there way make work both zoo , dplyr, or i'll have encode year-month separately?

as error says, class not supported in dplyr. can change ym to class dplyr supports , work

library(dplyr) tst %>%         group_by(ym = as.numeric(ym)) %>%        summarise(ave = mean(n)) #        ym      ave #1 2004.000 25.00000 #2 2004.083 21.80000 #3 2004.167 23.00000 #4 2004.250 23.25000 #5 2004.333 21.66667

or @g.grothendieck mentioned in comments, can replace group_by group_by(ym = as.date(ym) or group_by(ym = format(ym, "%y-%m"))


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more