timetable analysis
#1
Original Poster




Join Date: Dec 2009
Location: New York, NY
Programs: Hyatt GLOB, Marriott Lifetime PLT, UA 1K 1MM.
Posts: 1,752
timetable analysis
so i was looking for a pet project to practice my programming on as i try to do side tasks so my programming doesn't get rusty, and i was looking at FT and ran across some thread asking which UA RJ flight is the longest.
hey, i figured, this sounds like something i could figure out without reading the entire timetable!
so i took a day and wrote a python script that parsed the july pdf timetable for UA and loaded it into the analytics tool that i used... and came up with this.
https://cloud.saplumira.com/open?key...type=HANALYTIC
according to the data, it looks like the longest RJ flight that UA has is... IAH-YUL at (holy ....) 4h5m on an E70, and lo and behold, i found that flight on united.com... for $771 one way.
jeez.
anyway, if you want to play around with the data i did make the dataset public, but there's something happening that's not letting people access it via the link, so if you want to actually play with the data and poke around, just create an account and pm me and i'll invite you over (below is what it looks like).

i'm working in my spare time to get something cool going since it's actually a big interest of mine, but thought i'd share. the data is pretty interesting (i also didn't know that the 777 is actually being flown further than the 788, although since it's new i guess it makes sense).
and jeez, my programming skills are rusty.
hey, i figured, this sounds like something i could figure out without reading the entire timetable!
so i took a day and wrote a python script that parsed the july pdf timetable for UA and loaded it into the analytics tool that i used... and came up with this.
https://cloud.saplumira.com/open?key...type=HANALYTIC
according to the data, it looks like the longest RJ flight that UA has is... IAH-YUL at (holy ....) 4h5m on an E70, and lo and behold, i found that flight on united.com... for $771 one way.
jeez.
anyway, if you want to play around with the data i did make the dataset public, but there's something happening that's not letting people access it via the link, so if you want to actually play with the data and poke around, just create an account and pm me and i'll invite you over (below is what it looks like).

i'm working in my spare time to get something cool going since it's actually a big interest of mine, but thought i'd share. the data is pretty interesting (i also didn't know that the 777 is actually being flown further than the 788, although since it's new i guess it makes sense).
and jeez, my programming skills are rusty.
Last edited by bob_the_d; Jul 7, 2014 at 8:11 pm Reason: wrong plane
#3
FlyerTalk Evangelist



Join Date: May 2007
Location: Houston
Programs: UA Plat, Marriott Plat
Posts: 13,342
i'm working in my spare time to get something cool going since it's actually a big interest of mine, but thought i'd share. the data is pretty interesting (i also didn't know that the 777 is actually being flown further than the 788, although since it's new i guess it makes sense).
#4
Original Poster




Join Date: Dec 2009
Location: New York, NY
Programs: Hyatt GLOB, Marriott Lifetime PLT, UA 1K 1MM.
Posts: 1,752
#5
Join Date: Oct 2012
Location: ORD/IND
Programs: UA Platinum, Avis Preferred, Hertz PC, Hyatt Discoverist , Marriott Titanium
Posts: 742
#6
FlyerTalk Evangelist



Join Date: May 2007
Location: Houston
Programs: UA Plat, Marriott Plat
Posts: 13,342
I don't think the early builds like UA took have quite that range; this article references ranges as short as 7600nm which is what I was recalling.

