r - Averages based on elements from other columns -


so, i’ve been trying working reason, i’m not making progress on this. , hoping if guys me. pretty much, have data frame average of specific range of values, these values other columns within same data frame, each user.

so, let’s have data frame. 

a<-data.frame(user=c(rep(1,10),rep(2,10),rep(3,10)), values=c(1:30),toot=c(rep(4,10),rep(5,10),rep(3,10)))  user    values  toot     1       1       4     1       2       4     1       3       4     1       4       4     1       5       4     1       6       4     1       7       4     1       8       4     1       9       4     1       10      4     2       11      5     2       12      5     2       13      5     2       14      5     2       15      5     2       16      5     2       17      5     2       18      5     2       19      5     2       20      5     3       21      3     3       22      3     3       23      3     3       24      3     3       25      3     3       26      3     3       27      3     3       28      3     3       29      3     3       30      3

so, take average of values between 2 elements prior of toot element through toot element.

here's i'm looking for: 

user    values  toot        deck     1       1       4       3     1       2       4       3     1       3       4       3     1       4       4       3     1       5       4       3     1       6       4       3     1       7       4       3     1       8       4       3     1       9       4       3     1       10      4       3     2       11      5       14     2       12      5       14     2       13      5       14     2       14      5       14     2       15      5       14     2       16      5       14     2       17      5       14     2       18      5       14     2       19      5       14     2       20      5       14     3       21      3       22     3       22      3       22     3       23      3       22     3       24      3       22     3       25      3       22     3       26      3       22     3       27      3       22     3       28      3       22     3       29      3       22     3       30      3       22

as see, user 1, user’s toot value 4, want take average of user’s 1 values @ 4th element , average 2 elements before it.

this have far (with many variations of , function): 

a$deck<-ave(a$values,a$user,fun=function(x) {   z<-a$toot   y<-z-2 mean(x[y:z]) })

but problem it’s not using toot value it’s starting position. here warning messages: 

> warning messages: 1: in y:z : numerical expression has 30 elements: first used 2: in y:z : numerical expression has 30 elements: first used error in mean(x[y:z]) :  error in evaluating argument 'x' in selecting method function 'mean': error in x[y:z] : 0's may mixed negative subscripts

anything welcomed , appreciated, thanks. 

library(plyr) ddply(a,.(user),function(df) {        df$deck <- mean(df$values[(df$toot[1]-2):df$toot[1]])         df })

Comments

Post a Comment

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

what i'm trying this: i've php global variable $currentid , simple jquery script check if there "id" (page) in hash of url , if yes wanted give value $currentid . i've been reading lot , notice shall use ajax i'm not managing it. my code is: <script type="text/javascript"> $(document).ready(function(){ if (parent.location.hash != '' ) { var thecurrentid = parent.location.hash.split('#')[1]; $.ajax({ url: 'my.php', //current page type: 'post', data: {theid: thecurrentid }, datatype: 'json', success: function () { } }); } // code here }); </script> could me please? thank in advance. php server side language, meaning once has sent data browser, php variables , data cannot changed... however, using ajax, can send request php page , change data in dom based on result. consider th...
Read more

Pull out data related to my apps from Android Play Store and iOS App Store -

i want pull out data related apps (ratings, reviews, etc) google play store , apple app store ? how can accomplish ? i have found open source apis google mentioned not reliable. also there paid apis (e.g. appfigures) available. has idea how able pull data these play stores ?? i looking direction on how can accomplish this. can suggest ? we (appfigures) have been working on developing infrastructure give ability reviews , bunch of other data points major app stores several years :] we make available via our api though may want check out.
Read more

How can I fetch data from a web server in an android application? -

i want retrieve data web server in android application, , don't know begin. should use web services? i recommend these tutorials: connect android php , mysql , json in android , php , mysqli i used these tutorials , managed trying working without difficulty. between them describe each step in how attempting @ each stage, android application, database , web server side , has information included can process , use received information the thing add connect android php , mysql tutorial makes use of mysql_ in php deprecated. better use mysqli why included third link. the basic outline of want this: 1) in android app make request server php script using class this: import java.io.bufferedreader; import java.io.ioexception; import java.io.inputstream; import java.io.inputstreamreader; import java.io.unsupportedencodingexception; import java.util.list; import org.apache.http.httpentity; import org.apache.http.httpresponse; import org.apache.http.namevaluepair...
Read more