r - Sum of a non-uniform subset -


in project, have bunch of information bus company. separate subset date, see required bus lines (which in "linha" column) barplot.

->e.g. of subset:

data.date[[1]] equivalent of subset of rows have date "2013-03-10".

for accomplished, tried sum values in dim "catraca"(ticket gate) in vector different "linhas" (bus lines). and, i'm struggling hard.

this logic used

linha.sum <- with(data.date[[1]], data.date[[1]] == linha.unique, sum(data.date[[1]]$catraca))

the output logical vector. not desired.

this pictures might understand situation

 view(data.date[[1]])

picture of sample

the values want sum "catraca" of different "linha"

sample of data:

data.dates <- list(read.table(text = "linha     dsaida hsaida   dchegada hchegada sentido catraca embarcado                                           3 2016-01-01  04:05 2016-01-01    04:15       0       0         0                                           3 2016-01-01  04:23 2016-01-01    23:57       0      37         0                                           3 2016-01-01  04:05 2016-01-01    04:15       0       0         0                                           3 2016-01-01  04:22 2016-01-01    23:58       0      83         0                                           3 2016-01-01  04:04 2016-01-01    04:15       0       0         0                                           3 2016-01-01  04:23 2016-01-01    23:58       0      43         0                                           6 2016-01-01  03:49 2016-01-01    13:41       0      82         0                                           6 2016-01-01  13:43 2016-01-01    23:09       0      98         0                                           7 2016-01-01  03:54 2016-01-01    14:49       0      61         0                                           7 2016-01-01  14:51 2016-01-01    23:10       0      46         0", header = t))

since data.dates seems list of data.frames (probably created split()), sums of column within each of these data sets can acquired lapply.

here reproducible data: 

data.dates <- list(data.frame(   linha = c(3,3,1201,1201),    catraca = c(0,37,2,22) ))

with dplyr

library(dplyr) lapply(data.dates, function(x) {          x %>% group_by(linha) %>% summarize(catsum = sum(catraca)) }) # [[1]] # # tibble: 2 x 2 #    linha         catsum #    <dbl>          <dbl> # 1     3             37 # 2  1201             24

this add column each data.frame within list containing sum per each group (by date , linha)

with base r

from @sagars comment use aggregate in lapply:

lapply(data.dates, function(x) {   aggregate(x$catraca, = list(linha = x$linha), fun = sum) }) # [[1]] #   linha  x # 1     3 37 # 2  1201 24

benchmarking

in fact, microbenchmark() reveals, base solution (as often) faster in case. however, tested small subset given in op. 

# unit: microseconds #   expr      min       lq      mean    median        uq      max neval cld #  dplyr 1803.553 1878.499 1994.4945 1918.8880 2016.8730 6495.747   100   b #   base  481.535  513.818  543.4041  538.1365  560.4635  803.222   100

Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj...
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer ...
Read more

c# - Asp.net web api : redirect unauthorized requst to forbidden page -

im trying redirect unauthorized request forbidden page instead i'm getting forbidden page in response body , how can fix ? here's startup class : app.createperowincontext(storecontext.create); app.createperowincontext<applicationusermanager>(applicationusermanager.create); app.createperowincontext<applicationsigninmanager>(applicationsigninmanager.create); app.usecookieauthentication(new cookieauthenticationoptions { authenticationtype = defaultauthenticationtypes.applicationcookie, expiretimespan = timespan.fromdays(30), }); app.useexternalsignincookie(defaultauthenticationtypes.externalcookie); app.usetwofactorsignincookie(defaultauthenticationtypes.twofactorcookie, timespan.fromminutes(5)); app.usetwofactorrememberbrowsercookie(defaultauthenticationtypes.twofactorrememberbrowsercookie); the method im trying reach : [httpget] [authorize(roles = "admin")] public string getcurrentusername() { return userman...
Read more