bart salary groupings

_.md

[ Launch: bart salary groupings ] 6892157 by enoex

config.json

{"description":"bart salary groupings","endpoint":"","display":"svg","public":true,"require":[{"name":"crossfilter","url":"http://square.github.io/crossfilter/crossfilter.v1.min.js"},{"name":"crossfilter","url":"http://square.github.io/crossfilter/crossfilter.v1.min.js"},{"name":"simplestats","url":"http://rawgithub.com/tmcw/simple-statistics/master/src/simple_statistics.js"}],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"data.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"fullscreen":false,"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"pingpong","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"thumbnail":"http://i.imgur.com/xO0ZwbL.png"}

data.csv

inlet.js

var svg = d3.select('svg');

function round(x,place) {
  return place * Math.round(x/place)
}

var salaries = tributary.data.map(function(d) {
  return {
    job: d.Title,
    base: +d.Base,
    family: d['Job Family'],
    ot: +d.OT,
    union: d.Union,
    rounded: round(+d.Base + (+d.OT), 1000)
  };
});

var families = {};

function groupData(family,i){
  var xf = crossfilter(salaries);
  var pay = xf.dimension(function(d) { return d.rounded });
  var job = xf.dimension(function(d) { return d.job });
  var jobFamily = xf.dimension(function(d) { return d.family });

  jobFamily.filter(family);

  var data = pay.top(Infinity).map(function(d) {
    return d.rounded;
  });

  var mean = ss.mean(data);
  var median = ss.median(data);

  families[family] = {};
  families[family].mean = mean;
  families[family].median = median;
  
  d3.select('svg').append('text')
  .attr({x: 20, y: 100 + (24 * i)})
  .text('Family: ' + family + ' | median: ' + 
        d3.format(',')(median) + 
        ' | mean: ' + d3.format(',.2f')(mean));
}
 
var xf = crossfilter(salaries);
var jobFamily = xf.dimension(function(d) { return d.family })
var families = jobFamily.group().all()

// get median / mean for each group
var i=0;
families.forEach(function(d){
  groupData(d.key,i);
  i += 1;
});