The only thing I think is missing here boarding times for the different carriers. I was reading somewhere (I can't find the link) that southwest has the best method right now. I did find a link to another site that seems to have similar content but doesn't mention Southwests boarding style (because it isn't random it is based on least resistance boarding). http://menkes76.com/projects/boarding/boarding.htm
I'd argue that boarding times are generally irrelevant, despite being annoying. If you walk up to the gate a minute before they close it, you'll walk right on. So waiting in that long line for slow boarding is essentially a choice.
Except for Southwest, since they don't have assigned seats.
Unfortunately, it's fairly difficult to make any concrete conclusions from flight time, especially at a time resolution of one minute. The jet stream and other weather processes affect flight time by more than a minute. This also holds for mechanical reasons as well, since airplanes that have squawked 7700 will almost certainly be given landing priority, leaving other airplanes in the air for longer while they wait their turn.
I agree. I did the best I can by using the median over all flights from the past 12 months.
But yes, there are a lot of irregular operations which can throw any conclusions to the wind. That said, when I was exploring this data I found that delays etc were much less frequent that I perceived.
I'm pretty sure UA has more than 48 flights a week to the NY area as well if you're aggregating JFK, LGA and EWR,the number should be closer to 20 per day. I just arbitrarily picked Friday, 10/17 from SFO => NYC and there are 23 flights. Your number might be right if excluding EWR, which like SFO is a major UA hub.
Most cities actually have an airport code as well, ie CHI for Chicago and NYC for New York. It might be worthwhile to piggyback off of that for consistencies sake.
Nice job, I especially like the "Route Facts" in the bottom-left. Last year I made a video tutorial using the same BTS data showing how to extract similar flight insights using Excel: https://pjw.me/data-analysis-and-dashboards-with-excel.htm
Appears to be missing data from Alaska Airlines. A lot of flights in the NW are handled by Alaska, so there's a number of missing connections from my local airport.
[EDIT] Not quite correct, just missing all the Alaska airlines flights out of Bozeman. Perhaps missing the turboprop data?
Hmmm. So sometimes these smaller regional flights are subcontracted out to small carriers who don't have $20m of revenue. In that case, I don't have the data since it costs $$$.
I will look into it to figure out the reason. And those beers are still yours.
Very interesting visualization. One thing I want to point out however is the rearrangement of the widgets should not be based on its size, but on relatedness instead. An for that to happen, you need to design the layout instead of using auto re-arrangement based on screen size.
Good point, the tradeoffs between making something visually interesting vs relevant from a visualization point of view were really tough on this project. I will look into some kind of compromise. Related data does not always look good next to each other.
More broadly, when I visualize a set of data I follow Alberto Cairo's guidelines of Organize, Compare, and Correlate. In this project, I moved away from that quite a bit because I was seeking to make something interesting as opposed to useful.
I was scratching an existential need I had to make this data accessible and interesting. :)
38 comments
[ 3.0 ms ] story [ 60.5 ms ] threadEdit: Note Dewey found the right article below.
Discussion here: https://news.ycombinator.com/item?id=7649026
Except for Southwest, since they don't have assigned seats.
http://www.transtats.bts.gov/Fields.asp?Table_ID=236
I did use d3 for the charts. Some were in SVG and some were in html. D3 is good for manipulating any kind of dom tree.
[1] http://nickqizhu.github.io/dc.js/
I invest in equities and I find I never have the correct information in the right format.
But yes, there are a lot of irregular operations which can throw any conclusions to the wind. That said, when I was exploring this data I found that delays etc were much less frequent that I perceived.
Riddle me this: http://flightsphere.com/flight-time/from/atlanta/to/chicago
It says United has 6 flights per week from Atlanta to Chicago. They have 6 or 7 per day in reality.
How are airports in metro areas consolidated? Are you using MDW instead of ORD for "Chicago"?
It is probably a bug in my data pipeline. I will look into this.
I consolidate all airports in a metro area, MDW and ORD for Chicago.
http://flightsphere.com/flight-time/from/newark/to/san-franc...
What is the data source?
just contact me at nikhilb at ml1.net and you've got your beers.
[EDIT] Not quite correct, just missing all the Alaska airlines flights out of Bozeman. Perhaps missing the turboprop data?
I only have data for airlines with revenues > $20m, but I'm pretty sure Alaska falls into this group.
http://www.alaskaair.com/ - search BZN to SEA, there's an average of 2 flights per day
I will look into it to figure out the reason. And those beers are still yours.
More broadly, when I visualize a set of data I follow Alberto Cairo's guidelines of Organize, Compare, and Correlate. In this project, I moved away from that quite a bit because I was seeking to make something interesting as opposed to useful.
I was scratching an existential need I had to make this data accessible and interesting. :)
- Flight Time By Airline, .. by Time of Day, Average Timeline
- Flights By Month, .. by Day of Week, .. by Time of Day
But they are not, when I adjust from screen wide from all sizes from 860 to 2740.
I've added it to my basecamp.
For instance, look at this one: http://flightsphere.com/flight-time/from/hartford/to/las-veg...
It's clearly a daily flight, based on the per-day chart, but it says it is 5 days a week, because they don't run it year-round.
Two beers payable in the bay area!!
Should mention that it's US only.
London / Edinburgh or Mumbai / New Delhi are still "Domestic" flights.
/PEDANT