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.

This report is prepared by

• Kari Santos
• Heather Witte
• Zachary Lamb
• Fadhil Suhendi
• Denis Kazakov

which airlines have the worst luck with birdstrikes in terms of damage caused?

var groups = _.groupBy(data, function(n){
	return n['Aircraft: Airline/Operator']
})
var i = 0
var costs = _.mapValues(groups, function(d){
	var total = _.reduce(d, function(total, e){
		var cost = e['Cost: Total $']
		if (_.isString(cost)){
			var temp1 = cost.replace(/,/g,'')
			var temp2 = _.parseInt(temp1)
			cost = temp2
		}
		return total+cost
	},0)
	return total
})
var sorted = _.sortBy(_.pairs(costs), function(d){
	return d[1]
})

return _.slice(_(sorted).reverse().value(), 0,10)

what is the most common flight phase where a birdstrike occurred?

var groups = _.groupBy(data, function(n) {
    return n['When: Phase of flight']
})

var counts = _.mapValues(groups, function(d){
    return d.length
})
var sorted = _.sortBy(_.pairs(counts), function(d) {
    return d[1]
})

return _.slice(_(sorted).reverse().value(), 0,10)

Which plane strikes the most birds?

var groups = _.groupBy(data, function(n) {
    return n['Aircraft: Make/Model']
})

var counts = _.mapValues(groups, function(d){
    return d.length
})

var sorted = _.sortBy(_.pairs(counts), function(d) {
    return d[1]
})

return _.slice(_(sorted).reverse().value(), 0,10)

what airports have the most expensive average accident?

var groups = _.groupBy(data, function(n) {
    return n['Airport: Name']
})
var i = 0
var costs = _.mapValues(groups, function(d){
	var avg = _.reduce(d, function(total,e){
		var cost = e['Cost: Total $']
		if (_.isString(cost)){
			var temp1 = cost.replace(/,/g,'')
			cost = _.parseInt(temp1)	
		}
		return total+cost
	},0)/_.size(d)
	return avg
})
var sorted = _.sortBy(_.pairs(costs), function(d) {
    return d[1]
})

return _.slice(_(sorted).reverse().value(), 0,10)

what state had the highest number of bird strikes?

var grps = _.groupBy(data, 'Origin State')

var map = _.mapValues(grps, function(d){
    return d.length
})

var newvar = _.map(map, function(v,k){
	return {"state": k, "count":v}
})

_.remove(newvar, function(n){
 	return n.state == 'N/A'	
})

return _.sortBy(newvar, "count").reverse()