The Migrant Files: Money by enjalot

index.html

<!DOCTYPE html>
<head>
  
  <meta charset="utf-8">
  <script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
  <style>
    body { margin:0;position:fixed;top:0;right:0;bottom:0;left:0; }
    pre { width: 100%; height: 100%; font-size: 10px; overflow-y: scroll; }
  </style>
</head>

<body>
  <pre id="json">
  </pre>
  <script>
    
 		function toNumber(s) {
      // convert strings with spaces instead of commas into numbers
      var n = s.replace(/[w]/g, "") //remove any whitespace
        .replace(/ /g, "") //utf8 space?
      return +n; //convert to number
    }
    function process(d) {
      var processed = {

        start: d.Start,
        end: d.End,
        year: +d.Year,
        // we just deal with the price in Euros adjusted for inflation
        price: toNumber(d["Price EUR 2014"]),
        service: d.Service,
        route: d.route,
        author: d.author,
        comment: d.Comment,
        source: d.Source,
      }
      return processed;
    }
    
    d3.csv("//enjalot.github.io/migrants/money.csv", function(err, rawdata) {
      console.log("rawdata", rawdata);

      var data = rawdata.map(process);
      console.log("data", data);
      
      d3.select("#json").text(JSON.stringify(data, null, 2));
      
      // I want to see how many distinct routes there are
      var routes = d3.nest()
        .key(function(d) { return d.route })
        .rollup(function(leaves) { return leaves.length })
        .entries(data);

      console.log("routes");
      console.table(routes.sort(function(a,b) { return b.values - a.values }));
      
      var ends = d3.nest()
      	.key(function(d) { return d.end })
        .rollup(function(leaves) { return leaves.length })
        .entries(data);
      
      console.log("destinations")
      console.table(ends.sort(function(a,b) { return b.values - a.values }));
      
      var starts = d3.nest()
      	.key(function(d) { return d.start })
        .rollup(function(leaves) { return leaves.length })
        .entries(data);
      
      console.log("origins")
      console.table(starts.sort(function(a,b) { return b.values - a.values }));
      
      
    });
  </script>
</body>