Report

As a team, answer a subset of the questions submitted during the hackathon. But instead of using Tableau, you will need to write Javascript/Lodash code to derive your answers. Similar to before, each team member is responsible for one question. But everyone should work together to come up with a good solution. Your answer should consist of Lodash code and a brief writeup. Utilize _.map, _.filter, _.group ...etc. Do not se any for loop.

This time, the data is not already prepared for you in a nice JSON format. You will need to do it on your own, replacing the placeholder birdstrike.json with real data.

What are the top 5 bird species that are involved? by Nicole Woytarowicz

var clean = _.reject(data, function(n){
    return _.includes(n['Wildlife: Species'], 'Unknown')
})

var groups = _.groupBy(clean, function(d){
    return d['Wildlife: Species']   
})

var birds = _.pairs(_.mapValues(groups, function(value){
    return value.length
}))

var top = _.sortBy(birds, function(n) {
    return n[1]
}).reverse()

return _.slice(top, [start=0], [end=5])

[
 [
  "Gulls",
  251
 ],
 [
  "Mourning dove",
  163
 ],
 [
  "European starling",
  121
 ],
 [
  "Sparrows",
  98
 ],
 [
  "Rock pigeon",
  95
 ]
]

What is the frequency of bird strikes at various height ranges? by Sushant Mittal

var data_poistive=_.filter(data,function(r){return parseInt(r['Feet above ground'])> 0})
var grps =_.groupBy(data_poistive,function(d){return d['Feet above ground']})
var result=_.mapValues(grps,function(t){return t.length})
var sorted = _.sortBy(_.pairs(result), function(d) {
return parseInt(d[0].replace(',', ''));
});
var desc = _(sorted).value()
return desc
//return result

What states cost the airlines the most money? by Satchel Spencer

return _.chain(data).groupBy('Origin State').mapValues(function(state){
    return _.reduce(state, function(sum, incident){
        return sum+parseInt(incident['Cost: Total $'].toString().replace(',', ''));
}, 0);
}).pairs().sortByOrder('1', 1).object().value();

[object Object]

Which airport has the highest number struck? by Tristan Wagar

var groups = _.groupBy(data, function(n){
return n['Airport: Name']
})

var valuedGroups = _.values(groups)
var result = _.chain(valuedGroups)
.map(function(arr){
return [arr[0]["Airport: Name"], arr.length]
})
.reduce(function(n, p){
if ((n[1] > p[1]) && (n[0] != "UNKNOWN")) { return n; } else {return p; }
}).value()

return result

DENVER INTL AIRPORT,156

What Airline loses the most money to bird strikes every year? by John Murphy

var groups = _.groupBy(data, function(n){
return n['Aircraft: Airline/Operator']
})
var pairs =  _.pairs(_.mapValues(groups, function(item){
var costs =   _.map(item, function(value){ 		
return parseInt(value['Cost: Total $'].toString().replace(',', ''))		})
return _.sum(costs)

}))
var top = _.sortBy(pairs, function(n){
return n[1] 
}).reverse()
top = _.slice(top, [start =0], [end=10])

return top

BUSINESS,3528807,MILITARY,1748247,NORTHWEST AIRLINES,840942,AMERICAN EAGLE AIRLINES,801820,FEDEX EXPRESS,711967,SOUTHWEST AIRLINES,669519,KLM ROYAL DUTCH AIRLINES,534547,AMERICAN AIRLINES,511087,EXECUTIVE JET AVIATION,492513,CONTINENTAL AIRLINES,490932