r - dplyr Time Diff between rows -


i have data frame in below format , i'm trying find difference in time between event 'assigned' , last time event 'created' comes before it. 

**accountid**              **time**                    **event** 1                      2016-11-08t01:54:15.000z        created 1                      2016-11-09t01:54:15.000z        assigned 1                      2016-11-10t01:54:15.000z        created 1                      2016-11-11t01:54:15.000z        called 1                      2016-11-12t01:54:15.000z        assigned 1                      2016-11-12t01:54:15.000z        sleep

currently code follows, difficulty selecting created comes before assigned event

test <- timetable.filter %>%   group_by(accountid) %>%   mutate(timetoassign = ifelse(event == 'assigned',                                  interval(ymd_hms(time), max(ymd_hms(time[event == 'created']))) %/% hours(1), na))

i'm looking output be

**accountid**              **time**                    **event**        **timetoassign** 1                      2016-11-08t01:54:15.000z        created         na 1                      2016-11-09t01:54:15.000z        assigned         12 1                      2016-11-10t01:54:15.000z        created         na 1                      2016-11-11t01:54:15.000z        called         na 1                      2016-11-12t01:54:15.000z        assigned         24 1                      2016-11-12t01:54:15.000z        sleep         na

with dplyr , tidyr:

library(dplyr); library(tidyr); library(anytime)  df %>%      group_by(accountid) %>%      mutate(created_index = if_else(event == 'created', row_number(), na_integer_),            time = anytime(time)) %>%      fill(created_index) %>%      mutate(timetoassign = if_else(event == 'assigned',                                    as.numeric(time - time[created_index], units = 'hours'),                                    na_real_)) %>%      select(-created_index)  # tibble: 6 x 4 # groups:   accountid [1] #  accountid                time    event timetoassign #      <int>              <dttm>   <fctr>        <dbl> #1         1 2016-11-08 01:54:15  created           na #2         1 2016-11-09 01:54:15 assigned           24 #3         1 2016-11-10 01:54:15  created           na #4         1 2016-11-11 01:54:15   called           na #5         1 2016-11-12 01:54:15 assigned           48 #6         1 2016-11-12 01:54:15    sleep           na

Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more