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 type of aircraft has the most instances of damaged caused by bird strikes? by (nicolele)

var filter=_.filter(data, function(air){
	return air['Effect: Indicated Damage'] == "Caused damage"
})
var groups=_.groupBy(filter, function(air){
	return air['Aircraft: Type']
})
var maxGroups=_.mapValues(groups, function(g){
	return _.size(g)
})
var maxType=_.pick(maxGroups, function(g){
	return g == _.max(maxGroups)
})
return maxType

{
 "Airplane": 7196
}

What are the top 5 bird species that are involved? (ZachLamb)

/*var filter=_.filter(data, function(air){
	return !_.includes(air['Wildlife: Species'], "Unknown bird")
})*/
var groups=_.groupBy(data, function(air){
	return air['Wildlife: Species']
})
var countGroup=_.mapValues(groups, function(g){
	return _.size(g)
})
var keys=_.keys(countGroup)
var list=_.map(keys, function(key){
	return {"name": key, "count": countGroup[key]}
})

return _.sortBy(list, function(e){
	return e["count"]
}).reverse()

What is the most common flight phase where a birdstrike occurred? by (KevinKGifford)

var groups=_.groupBy(data, function(air){
	return air['When: Phase of flight']
})
var countGroup=_.mapValues(groups, function(g){
	return _.size(g)
})
var keys=_.keys(countGroup)
var list=_.map(keys, function(key){
	return {"Phase": key, "Count": countGroup[key]}
})
return list

How many flights have been cancelled by birdstrikes? by (pail4944)

var filter=_.filter(data, function(air){
	return air['Effect: Impact to flight'] != "None" && air['Effect: Impact to flight'] != ""
})
var groups=_.groupBy(filter, function(air){
	return air['Effect: Impact to flight']
})
var countGroup=_.mapValues(groups, function(g){
	return _.size(g)
})
var keys=_.keys(countGroup)
var list=_.map(keys, function(key){
	return {"Impact": key, "Count": countGroup[key]}
})
return list

What states cost the airlines the most money?(Cost and location) by willzfarmer

var groups=_.groupBy(data, function(air){
	return air['Origin State']
})
var sumGroup=_.mapValues(groups, function(g){
	return _.sum(g, function(e){
		return e['Cost: Total $']
	})
})
var keys=_.keys(sumGroup)
var list=_.map(keys, function(key){
	return {"State": key, "Total cost $": sumGroup[key]}
})
return _.sortBy(list, function(e){
	return e["Total cost $"]
}).reverse()