data.js

/* global d3 */
"use strict";

/* ------------------- LOAD THE DATA ---------------------------------------- */

var all_data = {};
var dataSource = "data/MSY.csv";

d3.csv(dataSource, function (d) {
    dataSource = d;
    process_data();
    init();
});

function process_data() {
    var agg_year = d3.nest().rollup(function (d){return aggregate(d);})
            .key(function (d) {return d.Year;});
    var agg_month = d3.nest().rollup(function (d){return aggregate(d);})
            .key(function (d) {return [d.Year,d.Month];});
    var agg_day = d3.nest().rollup(function (d){return aggregate(d);})
            .key(function (d) {return [d.Year,d.Month,d.Day];});
    
    all_data["year"] = agg_year.entries(dataSource);
    all_data["month"] = agg_month.entries(dataSource);
    all_data["day"] = agg_day.entries(dataSource);
}

function aggregate(d){
    var r = {};
    
    r.out_Flights = d3.sum(d, function(g){return g.out_Flights;});
    r.out_Total_Cancelled = d3.sum(d, function(g){return g.out_Cancelled;});
    r.out_Total_Diverted = d3.sum(d, function(g){return g.out_Diverted;});
    r.out_Total_Delayed = d3.sum(d, function(g){return g.out_Delayed;});
    r.out_Total_DivCan = r.out_Total_Cancelled + r.out_Total_Diverted;
    
    r.out_Perc_Cancelled = r.out_Total_Cancelled / r.out_Flights * 100;
    r.out_Perc_Diverted = r.out_Total_Diverted / r.out_Flights * 100;
    r.out_Perc_Delayed = r.out_Total_Delayed / r.out_Flights * 100;
    r.out_Perc_DivCan = r.out_Total_DivCan / r.out_Flights * 100;
    
    
    r.in_Flights = d3.sum(d, function(g){return g.in_Flights;});
    r.in_Total_Cancelled = d3.sum(d, function(g){return g.in_Cancelled;});
    r.in_Total_Diverted = d3.sum(d, function(g){return g.in_Diverted;});
    r.in_Total_Delayed = d3.sum(d, function(g){return g.in_Delayed;});
    r.in_Total_DivCan = r.in_Total_Cancelled + r.in_Total_Diverted;
    
    r.in_Perc_Cancelled = r.in_Total_Cancelled / r.in_Flights * 100;
    r.in_Perc_Diverted = r.in_Total_Diverted / r.in_Flights * 100;
    r.in_Perc_Delayed = r.in_Total_Delayed / r.in_Flights * 100;
    r.in_Perc_DivCan = r.in_Total_DivCan / r.in_Flights * 100;
    
    
//    r.Days_Fog = d3.sum(d, function(g){return g.Fog;});
//    r.Days_Mist = d3.sum(d, function(g){return g.Mist;});
//    r.Days_Rain = d3.sum(d, function(g){return g.Rain;});
//    r.Days_Hail = d3.sum(d, function(g){return g.Hail;});
//    r.Days_Thunder = d3.sum(d, function(g){return g.Thunder;});
//    r.Days_Tornado = d3.sum(d, function(g){return g.Tornado;});
    
    r.Avrg_Precipitation = d3.mean(d, function(g){return g.PRCP;});
    r.Avrg_MaxTemperature = d3.mean(d, function(g){return g.TMAX;});
    r.Avrg_MinTemperature = d3.mean(d, function(g){return g.TMIN;});
    r.Avrg_WindSpeed = d3.mean(d, function(g){return g.AWND;});
    
    return r;
}

function get_default(val, def){
    if(val === null || val === undefined)
        return def;
    return val;
}

function get_data(mode,year,month){
    var data = all_data[mode];
    if(mode === "year")
        return data;
    if(mode === "month")
        return data.filter(function(d){return d.key.split(",")[0]===year;});
    if(mode === "day")
        return data.filter(function(d){
            var YMD = d.key.split(",");
            return YMD[0] === year && YMD[1] === month;
        });
    return ["nada"];
}

var xValue_funs = {
    year: function(d){return +d.key;},
    month:function(d){return +d.key.split(",")[1];},
    day: function(d){return +d.key.split(",")[2];}
};

var flight_features = {
    Flights: ["Number of Flights",15],
    Total_Cancelled:["Flights Cancelled",30],
    Total_Diverted: ["Flights Diverted",30],
    Total_Delayed: ["Flights Delayed",30],
    Total_DivCan: ["Flights Diverted or Cancelled",30],
    
    Perc_Cancelled: ["Percent of Cancelled Flights",30],
    Perc_Diverted: ["Percent of Diverted Flights",30],
    Perc_Delayed: ["Percent of Delayed Flights",30],
    Perc_DivCan: ["Percent of Diverted and Cancelled Flights",30]
};
var weather_features = {
//    Days_Fog: ["Days with Fog or Smoke",20],
//    Days_Mist:["Days with Mist or Haze",30],
//    Days_Rain: ["Days with Rain",30],
//    Days_Hail: ["Days with Hail or Sleet",30],
//    Days_Thunder: ["Days with Thunder",30],
//    Days_Tornado: ["Days with Tornado, or Damaging Wind",30],

    Avrg_Precipitation: ["Average Precipitation (in Millimeters)",20],
    Avrg_WindSpeed: ["Average Windspeed (in Meters per Second)",30],
    Avrg_MinTemperature: ["Average Lowest Temperature (in Celcius)",30],
    Avrg_MaxTemperature:["Average Highest Temperature (in Celcius)",30]
};
var colorSets = [
    ['#fbb4ae','#b3cde3','#ccebc5','#decbe4','#fed9a6'
        ,'#78c679','#e5d8bd','#fddaec','#f2f2f2'],
    ['#e41a1c','#377eb8','#4daf4a','#984ea3','#ff7f00'
        ,'#006837','#a65628','#f781bf','#999999'],
    ['#e41a1c','#377eb8','#4daf4a','#984ea3']
    ];
    

for(var key in flight_features){
    flight_features[key].push(colorSets[0].pop());
    flight_features[key].push(colorSets[1].pop());
}

for(var key in weather_features){
    weather_features[key].push(colorSets[2].pop());
}


var month_names = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", 
    "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; 

var month_fullnames = ["January", "February", "March", "April", "May", "June", 
    "July", "August", "September", "October", "November", "December"];  
    
 function log(msg){console.log(msg);}