calculate median from data.table columns in R -


i trying calculate median value across number of columns, data bit funky. looks following example.

library(data.table)  dt <- data.table("id" = c(1,2,3,4),"none" = c(0,5,5,3),                   "ten" = c(3,2,5,4),"twenty" = c(0,2,3,1))      id none ten twenty 1:  1    0   3      0 2:  2    5   2      2 3:  3    5   5      3 4:  4    3   4      1

in table column represents number of occurrences of value. wanting calculate median occurrence.

for example id = 1

median(c(10, 10, 10))

is calculation wanting create.

for id = 2

median(c(0, 0, 0, 0, 0, 10, 10, 20, 20))

i have tried using rep() , lapply() limited success , after clear guidance on how might achieved. understand likes of rep() having hard code value repeated (e.g. rep(0,2) or rep(10,2)) , expect. struggling create list or vector repetitions each column.

here's data.table way (assuming unique id):

dt[, median(rep(c(0, 10, 20), c(none, ten, twenty))), by=id] #    id v1 # 1:  1 10 # 2:  2  0 # 3:  3 10 # 4:  4 10

this attempt @eddi's answer without reshaping (which tend use last resort).


-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more