Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data set example, Write the code in Python, show output. The data set you will be working on is Airport Wait Time.csvd. The data set

image text in transcribed

Data set example,

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Write the code in Python, show output.

The data set you will be working on is Airport Wait Time.csvd. The data set was collected from https://awt.cbp.govl, and it shows the number of passengers processed on flights arriving in each hour based on how long it took for those passengers to clear Passport Control. Use numpy and pandas to answer the following questions 1. How many rows and columns are there in the data set? What are the column names? 2. How many different U.S. international airports are included in the data set? 3. What is the range of the dates (starting and ending date) in the data set? 4. Obtain a subset of the data that only has the Chicago O'Hare International Airport (ORD). How many different international terminals does ORD have? 5. Consider the Christmas day (12/25/2017) for ORD airport. Which hour of the day had the longest average wait time? 6. Compare between the Christmas day and New Year (1/1/2018) for ORD airport Which hour of the day had the biggest difference of the average wait time? 7. Obtain a subset for the New York John F. Kennedy International Airport (JFK). How many different international terminals does JFK have? 8. For JFK airport, report the total number of flights by date 9. Consider the New Year (1/1/2018) of JFK airport. After summing passengers from all terminals, which hour of the day had the largest number of passengers? Airport Wait Time - Notepad File Edit Format View Help Airport, Terminal,Date, Hour,All Passengers Average Wait Time,All Passengers Max Wait Time,Number of Passengers,Number of Flights, Number of Booths GUM,Main Terminal,12/14/2017,0000 - 0100,11,26,247,2,12 GUM,Main Terminal,12/14/2017,0100 e200,15,27,183,1,12 GUM,Main Terminal, 12/14/2017,020 0300, 35,68,867,4,12 GUM,Main Terminal,12/14/2017,0300 e400,52,77,355,2,12 GUM, Main Terminal,12/14/2017,0400- 0500,4,16,253,3,12 GUM,Main Terminal,12/14/2817,0700 0800,18,35,110,1,7 GUM,Main Terminal,12/14/2017,0900 - 1000,3,8,63,1,5 GUM,Main Terminal,12/14/2017,1200 1300,10,18,162,1,14 GUM,Main Terminal,12/14/2017,1400 1500,29,65,912,3,18 GUM,Main Terminal, 12/14/2017,1500 1600, 39,65,735,5,18 GUM,Main Terminal, 12/14/2017,1700 1800,7,20,160,2,10 GUM,Main Terminal,12/14/2017,2200 2300,8,28,158,1,3 GUM,Main Terminal,12/14/2017,2300 0000,22,36,188,1,10 GUM,Main Terminal,12/15/2017,0000 - 0100,22,45,374,2,10 GUM,Main Terminal,12/15/2017,0100 0200,25,50,357,2,10 GUM,Main Terminal,12/15/2017,020 0300,23,47,478,3,10 GUM,Main Terminal, 12/15/2017,0300 80480,44,76,374,2,1e GUM,Main Terminal,12/15/2017,0400 0500,21,47,206,3,1e GUM,Main Terminal,12/15/2817,0600 0700,8,19,64,1,6 GUM,Main Terminal,12/15/2017,1300 1400,12,24, 330,2,13 GUM,Main Terminal,12/15/2017,1400 1500,26,74,583,2,17 GUM,Main Terminal,12/15/2017,1500 1600,56,125,1454,7,18 GUM,Main Terminal,12/15/2017,1600 1700,43,91,71,1,12 GUM,Main Terminal, 12/15/2017,1780 1800,9,18,54,1,9 GUM,Main Terminal, 12/15/2017,2100 2200,13,34,148,1,3 GUM,Main Terminal,12/15/2817,2300 0000,29,46,195,1,10 GUM,Main Terminal,12/16/2017,0100 - 0200,16,53,427,2,10 GUM,Main Terminal,12/16/2017,0200 0300,36,63,388,2,10 GUM,Main Terminal,12/16/2017,0300 e400,11,28,445,3,10 GUM,Main Terminal,12/16/2017,0600 - 0700,8,32,240,2,7 GUM,Main Terminal, 12/16/2017,e700 0800,6,20,108,1,8 GUM,Main Terminal, 12/16/2017,0900 1000,7,18,103,1,6 GUM,Main Terminal, 12/16/2017,1300 1400,11,23,299,2,14 GUM,Main Terminal,12/16/2817,1400 1500,12,26,354,1,28 Airport_Wait_Time - Notepad File Edit Format View Help GUM,Main Terminal,12/16/2017,1690 - 1700,18,43,329,3,16 GUM,Main Terminal, 12/16/2017,1800 - 1900,4,13,158,1,11 GUM,Main Terminal,12/16/2017,2200 - 2300,2,16,168,1,5 GUM,Main Terminal,12/17/2017,0000 01ee,20,30,195,1,1:1 GUM,Main Terminal,12/17/2017,0100 0200,22,51,790,4,11 GUM,Main Terminal,12/17/2017,0200 0300,27,51,559,3,11 GUM,Main Terminal,12/17/2017,0300 0400,54,101,421,3,9 GUM,Main Terminal,12/17/2017,0400 - 0500,12,33,371,3,9 GUM,Main Terminal,12/17/2017,0700 0800,7,24,113,1,4 GUM,Main Terminal,12/17/2017,1200 - 1300,8,17,196,1,13 GUM,Main Terminal,12/17/2017,1400 150e,15,32,548,2,260 GUM,Main Terminal,12/17/2017,1500 - 1600,11,28,782,6,20 GUM,Main Terminal,12/17/2017,1600 - 1700,14,31,430,2,20 GUM,Main Terminal, 12/17/2017,2000 - 2100, 32,68,409,1,6 GUM,Main Terminal,12/17/2017,2200 - 2300,3,14,165,1,4 GUM,Main Terminal,12/18/2017,0000 010e,13,24,195,1,1:1 GUM,Main Terminal,12/18/2017,0100 0200,15,38,625,3,11 GUM,Main Terminal,12/18/2017,0200 0300,10,24,184,1,11 GUM,Main Terminal, 12/18/2017,0300 0400,42,96,783,5,10 GUM,Main Terminal,12/18/2017,0400 0500,16,44,370,3,10 GUM,Main Terminal,12/18/2017,0500 0600,12,24,107,1,7 GUM,Main Terminal,12/18/2017,1200 - 1300,12,23,192,1,11 GUM,Main Terminal, 12/18/2017,1400 - 1500,20,32,192,1,16 GUM,Main Terminal, 12/18/2017,1500 - 1600,10,24,573,5,18 GUM,Main Terminal,12/18/2017,1600 - 1700,29,54,931,4,17 GUM,Main Terminal,12/18/2017,1800 190e,12,23,182,1,140 GUM,Main Terminal,12/18/2017,2200 - 2300,4,15,157,1,5 GUM,Main Terminal,12/19/2017,0100 0200,11,23,194,1,110 GUM,Main Terminal, 12/19/2017,0200 0300,15,34,712,4,12 GUM,Main Terminal,12/19/2017,0300 0400,9,22,255,2,12 GUM,Main Terminal, 12/19/2017,0400 0500,4,13,233,2,12 GUM,Main Terminal,12/19/2017,0500 0600,43,78,184,1,6 GUM,Main Terminal,12/19/2017,0600 0700,15,40,107,1,6 GUM,Main Terminal,12/19/2017,0900 - 1000,7,18,96,1,6 GUM,Main Terminal,12/19/2017,1400 1500,15,38,602,3,19 ATL, Concourse E,12/14/2017,0500 600,19,97,1385,6,14 ATL, Concourse E,12/14/2017,0700 0800,1,18,289,1,10 ATL,Concourse E,12/14/2017,0900 - 1000,23,56,304,2,9 ATL, Concourse E,12/14/2017,1000 1100,4,19,100,2,!5 ATL, Concourse E,12/14/2017,1100 1200,4,22,187,2,6 ATL, Concourse E,12/14/2017,1200 1300,10,43,569,4,10 ATL, Concourse E,12/14/2017,1300 1400,6,35,349,2,12 ATL,Concourse E,12/14/2017,1400 1500,8,80,1383,7,18 ATL,Concourse E,12/14/2017,1500 - 1600,24,158,1420,8,14 ATL, Concourse E,12/14/2017,1600 1700,14,101,806,5,10 ATL, Concourse E,12/14/2017,1700 - 1800,14,109,1471,10,16 ATL, Concourse E,12/14/2017,1800 - 1900,16,93,2283,19,17 ATL,Concourse E,12/14/2017,1900 - 2000,15,73,553,5,17 ATL,Concourse E,12/14/2017,2000 - 2100,12,29,301,1,14 ATL, Concourse F,12/14/2017,0800 - 0900,17,53,228,1,9 ATL, Concourse F,12/14/2017,1100 1200,6,19,66,1,6 ATL, Concourse F,12/14/2017,1200 1300,4,33,102,1,6 ATL,Concourse F,12/14/2017,1700 - 1800,26,92,149,1,11 ATL,Concourse E,12/15/2017,500 0600,23,108,1408,6,14 ATL, Concourse E,12/15/2017,0600- 0700,3,34,293,1,8 ATL,Concourse E,12/15/2017,0800 e900,12,52,506,2,9 ATL, Concourse E,12/15/2017,090e - 1000,7,36,55,1,7 ATL, Concourse E,12/15/2017,1000 1100,28,80,264,3,9 ATL, Concourse E,12/15/2017,1100 - 1200,4,27,317,3,7 ATL,Concourse E,12/15/2017,1200 - 1300,12,73,809,5,11 ATL, Concourse E,12/15/2017,1300 1400,8,47,406,2,12 ATL, Concourse E,12/15/2017,1400 1500,10,33,423,3,13 ATL, Concourse E,12/15/2017,1500 1600,14,108,2505,12,15 ATL, Concourse E,12/15/2017,1600 - 1700,12,76,1061,8,9 ATL,Concourse E,12/15/2017,1700 - 1800,13,66,1127,8,15 ATL,Concourse E,12/15/2017,1800 - 1900,23,109,1949,16,17 ATL, Concourse E,12/15/2017,190e - 2000,22,101,700,6,16 ATL, Concourse E,12/15/2017,2000 - 2100,17,72,542,3,14 ATL, Concourse F,12/15/2017,1500 - 1600,42,114,249,1,11 ATL, Concourse F,12/15/2017,1600 - 1700,0,0,6,1,1 BOS, Terminal E,12/15/2617,1960 - 2000, 10, 29,1153,6, 16 BOS, Terminal E,12/15/2017,2000 - 210e,19,47,937,5,13 BOS, Terminal E,12/15/2017,2100 - 2200,9,16,93,1,13 BOS, Terminal E,12/15/2017,2200 - 2300,4,8,28,1,5 BOS, Terminal E,12/15/2017,2300 - 0000,12,28,246,1,6 BOS, Terminal E,12/16/2017,0800 090e,18,42,196,2,6 BOS, Terminal E,12/16/2017,1200 - 1300,13,47,477,3,6 BOS, Terminal E,12/16/2017,1300 - 140e, 30,105,1181,5,16 BOS, Terminal E,12/16/2017,140e - 1500,47,90,447,2,15 BOS, Terminal E,12/16/2017,1500 - 160e, 20,26,216,1,11 BOS, Terminal E,12/16/2017,1600 - 1700,10,35, 605,5,12 BOS, Terminal E,12/16/2017,1700 - 1800, 34,90,336,4,10 BOS, Terminal E,12/16/2017,1800 - 1900,18,76,1326,9,14 BOS, Terminal E,12/16/2017,1900 - 200e,15,39,1219,6,14 BOS, Terminal E,12/16/2017,2000 - 2100,13,37,759,5,14 BOS, Terminal E,12/16/2017,2100 - 220e,15,48,578,4,11 BOS, Terminal E,12/16/2017,2200 - 2300,13,20,125,1,5 BOS, Terminal E,12/17/2017,0500 0600,8,18,174,1,3 BOS, Terminal E,12/17/2017,0700 080e,21,46,199,2,6 BOS, Terminal E,12/17/2017,1100 - 120e,14,24,178,1,6 BOS, Terminal E,12/17/2017,1200 - 130e,12,30,307,2,6 BOS, Terminal E,12/17/2017,1300 - 140e,17,64,1232,5,18 BOS, Terminal E,12/17/2017,1400 - 150e,25,65,563,4,18 BOS, Terminal E,12/17/2017,1500 - 160e,11,21,120,1,10 BOS, Terminal E,12/17/2017,1600 - 170e,11,25,305,2,11 BOS, Terminal E,12/17/2017,1700 - 180e,14,35,410,2,13 BOS, Terminal E,12/17/2017,1800 - 190e,12,33,841,5,13 BOS, Terminal E,12/17/2017,1900 - 200e,18,55,827,5,12 BOS , Terminal E , 12/17/2017, 2000-2100 , 7 , 25, 483, 4 , 11 BOS, Terminal E,12/17/2017,2100 - 220e,24, 50,327,2,8 BOS, Terminal E,12/17/2017,2200 - 230e,10,27,154,2,7 BOS, Terminal E,12/18/2017,0700 080e,21,48,247,2,6 BOS, Terminal E,12/18/2017,1100 - 1200,9,25,238,2,7 BOS, Terminal E,12/18/2017,1200 - 130e,13,31,408,2,7 BOS, Terminal E,12/18/2017,130e - 1400,27,87,1289,7,17 ORD, Terminal 5,12/24/2017,1800 1900,17,50,1165,11,21 ORD, Terminal 5 . 12/24/2017, 1900-20007, 17, 80 , 1 , 8 ORD, Terminal 5,12/24/2017, 2000 - 210e,14,33,219,2,6 ORD, Terminal 5,12/24/2017,2100- 2200,7,18,127,1,6 ORD, Terminal 5,12/24/2017,2200- 2300,13,23,165,1,7 ORD, Terminal 5,12/24/2017, 2300 000e,13,32,232,2,8 ORD, Terminal 5,12/25/2017,0000 - 010e,8,24,148,2,8 ORD, Terminal 5,12/25/2017,0500 060e, 39,90,691,3,14 ORD, Terminal 5,12/25/2017,0700 0800,4,15,130,2,9 ORD, Terminal 5,12/25/2017,0900 - 1000,15,55,219,2,11 ORD, Terminal 5 . 12/25/2017, 1000-1100 , 7 . 20 , 2703, 13 ORD, Terminal 5,12/25/2017,1100 - 120e,16,35,395,3,14 ORD, Terminal 5,12/25/2017,1200 - 1300,13,32,498,5,23 ORD, Terminal 5,12/25/2017,1300 - 1400,18,40,476,3,24 ORD, Terminal 5,12/25/2017,1400 1500,27,82,1614,8,19 ORD, Terminal 5,12/25/2017,1500 - 1600, 30,87,933,7,26e ORD, Terminal 5,12/25/2017,1600 - 1700,22,78,658,6,16 ORD, Terminal 5,12/25/2017,1700 - 1800,13,51,513,5,15 ORD, Terminal 5,12/25/2017,1800 1900,15,51,966,10,16 ORD, Terminal 5,12/25/2017,1900 - 200e,9,27,311,2,15 ORD , Terminal 5 , 12/25/2017, 2100-22007, 17, 141, 1 , 2 ORD, Terminal 5,12/25/2017, 2200 - 2300,8,17,130,1,9 ORD, Terminal 5,12/25/2017, 2300 000e,9,22,387,3,11 ORD, Terminal 5,12/26/2017,0300 040e,9,20,103,1,8 ORD, Terminal 5,12/26/2017,0400 0500,17,65,159,2,4 ORD, Terminal 5,12/26/2017,0500 0600,50,89,274,1,7 ORD, Terminal 5,12/26/2017,0600 0700,7,20,85,1,8 ORD, Terminal 5,12/26/2017,0700 - 0800,11,21,75,1,9 ORD, Terminal 5,12/26/2017,0800 090e,10,27,164,1,8 ORD, Terminal 5,12/26/2017,0900 - 100e,23,42,196,1,7 ORD, Terminal 5,12/26/2017,1000 - 110e,16,33,98,1,7 ORD, Terminal 5,12/26/2017,1100 - 1200,17,54,494,4,11 ORD, Terminal 5,12/26/2017,1200 - 1300,31,86,614,6,18 ORD . Terminal 5 . 12/26/2017, 1300-1400 , 27, 71, 7995, 20 ORD . Terminal 5 . 12/26/2017, 1400-1500 . 21 , 70 , 1498 , 920 JFK, Terminal 4 (IAT),12/18/2017,1500 - 1600,26,82,1038,5,25 JFK, Terminal 4 (IAT),12/18/2017,1600 - 1700,10,27,234,2,16 JFK, Terminal 4 (IAT),12/18/2017,1700 - 1800,19,60,1104,7,19 JFK, Terminal 4 (IAT),12/18/2017,1800 - 1900,10,30,370,2,15 JFK, Terminal 4 (IAT),12/18/2017,1900 - 2000,17,54,1078,5,19 JFK, Terminal 4 (IAT),12/18/2017,2000 - 2100,9,31,742,4,26 JFK, Terminal 4 (IAT),12/18/2017,21002200,9,27,267,2,15 JFK, Terminal 4 (IAT),12/18/2017, 2200 - 2300,11,26,592,4, 21 JFK, Terminal 4 (IAT),12/18/2017,2300 - 0000,12,32,365,3,14 JFK, Terminal 5 (Jet Blue),12/18/2017,0500 - 0600,24,50,134,1,5 JFK, Terminal 5 (Jet Blue),12/18/2017,0700 - 0800,25,72,193,1,5 JFK, Terminal 5 (Jet Blue),12/18/2017,0800 - 0900, 33,75,318,2,7 JFK, Terminal 5 (Jet Blue),12/18/2017,0900 - 1000,19,53,260,2,6 JFK, Terminal 5 (Jet Blue),12/18/2017,1300 - 1490,24,62,361,2,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1400 - 1500,15,31,148,1,10 JFK, Terminal 5 (Jet Blue),12/18/2017,1500 - 1690,6,27,462,4,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1600 - 1700,4,15,168,1,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1790 - 1800,12,26,206,2,10 JFK, Terminal 5 (Jet Blue),12/18/2017,1890 - 1900,16,49,836,6,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1990 - 2000,12,56, 504, 3,9 JFK, Terminal 5 (Jet Blue),12/18/2017,2000 - 2100,16, 50,383,3,8 JFK, Terminal 5 (Jet Blue),12/18/2017,2100 - 2200,6,15,172,2,7 JFK, Terminal 7 (British),12/18/2017,0600 - 0700,18,40,89,1,6 JFK, Terminal 7 (British),12/18/2017,0800 - e900,29,62,315,2,11 JFK, Terminal 7 (British),12/18/2017,0900 - 1000,16,33,254,1,10 JFK, Terminal 7 (British),12/18/2017,1100 - 1200,18,45, 348, 2,7 JFK, Terminal 7 (British),12/18/2017,1200 - 1300,13,31,221,1,6 JFK, Terminal 7 (British),12/18/2017,1400 - 1500,15,50,449, 3,5 JFK, Terminal 7 (British),12/18/2017,1500 - 1600,18,37,311,2,8 JFK, Terminal 7 (British),12/18/2017,1700 - 1800,11,27,201,1,8 JFK, Terminal 7 (British),12/18/2017,1800 - 1900,22,48,200,1,9 JFK, Terminal 7 (British),12/18/2017,1900 - 2000,21,43,447,2,9 JFK, Terminal 7 (British),12/18/2017,2000 - 2100,20,36,449,2,8 JFK, Terminal 7 (British),12/18/2017,2100 - 2200,24,45,170,1,7 JFK, Terminal 7 (British),12/18/2017,2200 - 2300,14,43,371,3,9 The data set you will be working on is Airport Wait Time.csvd. The data set was collected from https://awt.cbp.govl, and it shows the number of passengers processed on flights arriving in each hour based on how long it took for those passengers to clear Passport Control. Use numpy and pandas to answer the following questions 1. How many rows and columns are there in the data set? What are the column names? 2. How many different U.S. international airports are included in the data set? 3. What is the range of the dates (starting and ending date) in the data set? 4. Obtain a subset of the data that only has the Chicago O'Hare International Airport (ORD). How many different international terminals does ORD have? 5. Consider the Christmas day (12/25/2017) for ORD airport. Which hour of the day had the longest average wait time? 6. Compare between the Christmas day and New Year (1/1/2018) for ORD airport Which hour of the day had the biggest difference of the average wait time? 7. Obtain a subset for the New York John F. Kennedy International Airport (JFK). How many different international terminals does JFK have? 8. For JFK airport, report the total number of flights by date 9. Consider the New Year (1/1/2018) of JFK airport. After summing passengers from all terminals, which hour of the day had the largest number of passengers? Airport Wait Time - Notepad File Edit Format View Help Airport, Terminal,Date, Hour,All Passengers Average Wait Time,All Passengers Max Wait Time,Number of Passengers,Number of Flights, Number of Booths GUM,Main Terminal,12/14/2017,0000 - 0100,11,26,247,2,12 GUM,Main Terminal,12/14/2017,0100 e200,15,27,183,1,12 GUM,Main Terminal, 12/14/2017,020 0300, 35,68,867,4,12 GUM,Main Terminal,12/14/2017,0300 e400,52,77,355,2,12 GUM, Main Terminal,12/14/2017,0400- 0500,4,16,253,3,12 GUM,Main Terminal,12/14/2817,0700 0800,18,35,110,1,7 GUM,Main Terminal,12/14/2017,0900 - 1000,3,8,63,1,5 GUM,Main Terminal,12/14/2017,1200 1300,10,18,162,1,14 GUM,Main Terminal,12/14/2017,1400 1500,29,65,912,3,18 GUM,Main Terminal, 12/14/2017,1500 1600, 39,65,735,5,18 GUM,Main Terminal, 12/14/2017,1700 1800,7,20,160,2,10 GUM,Main Terminal,12/14/2017,2200 2300,8,28,158,1,3 GUM,Main Terminal,12/14/2017,2300 0000,22,36,188,1,10 GUM,Main Terminal,12/15/2017,0000 - 0100,22,45,374,2,10 GUM,Main Terminal,12/15/2017,0100 0200,25,50,357,2,10 GUM,Main Terminal,12/15/2017,020 0300,23,47,478,3,10 GUM,Main Terminal, 12/15/2017,0300 80480,44,76,374,2,1e GUM,Main Terminal,12/15/2017,0400 0500,21,47,206,3,1e GUM,Main Terminal,12/15/2817,0600 0700,8,19,64,1,6 GUM,Main Terminal,12/15/2017,1300 1400,12,24, 330,2,13 GUM,Main Terminal,12/15/2017,1400 1500,26,74,583,2,17 GUM,Main Terminal,12/15/2017,1500 1600,56,125,1454,7,18 GUM,Main Terminal,12/15/2017,1600 1700,43,91,71,1,12 GUM,Main Terminal, 12/15/2017,1780 1800,9,18,54,1,9 GUM,Main Terminal, 12/15/2017,2100 2200,13,34,148,1,3 GUM,Main Terminal,12/15/2817,2300 0000,29,46,195,1,10 GUM,Main Terminal,12/16/2017,0100 - 0200,16,53,427,2,10 GUM,Main Terminal,12/16/2017,0200 0300,36,63,388,2,10 GUM,Main Terminal,12/16/2017,0300 e400,11,28,445,3,10 GUM,Main Terminal,12/16/2017,0600 - 0700,8,32,240,2,7 GUM,Main Terminal, 12/16/2017,e700 0800,6,20,108,1,8 GUM,Main Terminal, 12/16/2017,0900 1000,7,18,103,1,6 GUM,Main Terminal, 12/16/2017,1300 1400,11,23,299,2,14 GUM,Main Terminal,12/16/2817,1400 1500,12,26,354,1,28 Airport_Wait_Time - Notepad File Edit Format View Help GUM,Main Terminal,12/16/2017,1690 - 1700,18,43,329,3,16 GUM,Main Terminal, 12/16/2017,1800 - 1900,4,13,158,1,11 GUM,Main Terminal,12/16/2017,2200 - 2300,2,16,168,1,5 GUM,Main Terminal,12/17/2017,0000 01ee,20,30,195,1,1:1 GUM,Main Terminal,12/17/2017,0100 0200,22,51,790,4,11 GUM,Main Terminal,12/17/2017,0200 0300,27,51,559,3,11 GUM,Main Terminal,12/17/2017,0300 0400,54,101,421,3,9 GUM,Main Terminal,12/17/2017,0400 - 0500,12,33,371,3,9 GUM,Main Terminal,12/17/2017,0700 0800,7,24,113,1,4 GUM,Main Terminal,12/17/2017,1200 - 1300,8,17,196,1,13 GUM,Main Terminal,12/17/2017,1400 150e,15,32,548,2,260 GUM,Main Terminal,12/17/2017,1500 - 1600,11,28,782,6,20 GUM,Main Terminal,12/17/2017,1600 - 1700,14,31,430,2,20 GUM,Main Terminal, 12/17/2017,2000 - 2100, 32,68,409,1,6 GUM,Main Terminal,12/17/2017,2200 - 2300,3,14,165,1,4 GUM,Main Terminal,12/18/2017,0000 010e,13,24,195,1,1:1 GUM,Main Terminal,12/18/2017,0100 0200,15,38,625,3,11 GUM,Main Terminal,12/18/2017,0200 0300,10,24,184,1,11 GUM,Main Terminal, 12/18/2017,0300 0400,42,96,783,5,10 GUM,Main Terminal,12/18/2017,0400 0500,16,44,370,3,10 GUM,Main Terminal,12/18/2017,0500 0600,12,24,107,1,7 GUM,Main Terminal,12/18/2017,1200 - 1300,12,23,192,1,11 GUM,Main Terminal, 12/18/2017,1400 - 1500,20,32,192,1,16 GUM,Main Terminal, 12/18/2017,1500 - 1600,10,24,573,5,18 GUM,Main Terminal,12/18/2017,1600 - 1700,29,54,931,4,17 GUM,Main Terminal,12/18/2017,1800 190e,12,23,182,1,140 GUM,Main Terminal,12/18/2017,2200 - 2300,4,15,157,1,5 GUM,Main Terminal,12/19/2017,0100 0200,11,23,194,1,110 GUM,Main Terminal, 12/19/2017,0200 0300,15,34,712,4,12 GUM,Main Terminal,12/19/2017,0300 0400,9,22,255,2,12 GUM,Main Terminal, 12/19/2017,0400 0500,4,13,233,2,12 GUM,Main Terminal,12/19/2017,0500 0600,43,78,184,1,6 GUM,Main Terminal,12/19/2017,0600 0700,15,40,107,1,6 GUM,Main Terminal,12/19/2017,0900 - 1000,7,18,96,1,6 GUM,Main Terminal,12/19/2017,1400 1500,15,38,602,3,19 ATL, Concourse E,12/14/2017,0500 600,19,97,1385,6,14 ATL, Concourse E,12/14/2017,0700 0800,1,18,289,1,10 ATL,Concourse E,12/14/2017,0900 - 1000,23,56,304,2,9 ATL, Concourse E,12/14/2017,1000 1100,4,19,100,2,!5 ATL, Concourse E,12/14/2017,1100 1200,4,22,187,2,6 ATL, Concourse E,12/14/2017,1200 1300,10,43,569,4,10 ATL, Concourse E,12/14/2017,1300 1400,6,35,349,2,12 ATL,Concourse E,12/14/2017,1400 1500,8,80,1383,7,18 ATL,Concourse E,12/14/2017,1500 - 1600,24,158,1420,8,14 ATL, Concourse E,12/14/2017,1600 1700,14,101,806,5,10 ATL, Concourse E,12/14/2017,1700 - 1800,14,109,1471,10,16 ATL, Concourse E,12/14/2017,1800 - 1900,16,93,2283,19,17 ATL,Concourse E,12/14/2017,1900 - 2000,15,73,553,5,17 ATL,Concourse E,12/14/2017,2000 - 2100,12,29,301,1,14 ATL, Concourse F,12/14/2017,0800 - 0900,17,53,228,1,9 ATL, Concourse F,12/14/2017,1100 1200,6,19,66,1,6 ATL, Concourse F,12/14/2017,1200 1300,4,33,102,1,6 ATL,Concourse F,12/14/2017,1700 - 1800,26,92,149,1,11 ATL,Concourse E,12/15/2017,500 0600,23,108,1408,6,14 ATL, Concourse E,12/15/2017,0600- 0700,3,34,293,1,8 ATL,Concourse E,12/15/2017,0800 e900,12,52,506,2,9 ATL, Concourse E,12/15/2017,090e - 1000,7,36,55,1,7 ATL, Concourse E,12/15/2017,1000 1100,28,80,264,3,9 ATL, Concourse E,12/15/2017,1100 - 1200,4,27,317,3,7 ATL,Concourse E,12/15/2017,1200 - 1300,12,73,809,5,11 ATL, Concourse E,12/15/2017,1300 1400,8,47,406,2,12 ATL, Concourse E,12/15/2017,1400 1500,10,33,423,3,13 ATL, Concourse E,12/15/2017,1500 1600,14,108,2505,12,15 ATL, Concourse E,12/15/2017,1600 - 1700,12,76,1061,8,9 ATL,Concourse E,12/15/2017,1700 - 1800,13,66,1127,8,15 ATL,Concourse E,12/15/2017,1800 - 1900,23,109,1949,16,17 ATL, Concourse E,12/15/2017,190e - 2000,22,101,700,6,16 ATL, Concourse E,12/15/2017,2000 - 2100,17,72,542,3,14 ATL, Concourse F,12/15/2017,1500 - 1600,42,114,249,1,11 ATL, Concourse F,12/15/2017,1600 - 1700,0,0,6,1,1 BOS, Terminal E,12/15/2617,1960 - 2000, 10, 29,1153,6, 16 BOS, Terminal E,12/15/2017,2000 - 210e,19,47,937,5,13 BOS, Terminal E,12/15/2017,2100 - 2200,9,16,93,1,13 BOS, Terminal E,12/15/2017,2200 - 2300,4,8,28,1,5 BOS, Terminal E,12/15/2017,2300 - 0000,12,28,246,1,6 BOS, Terminal E,12/16/2017,0800 090e,18,42,196,2,6 BOS, Terminal E,12/16/2017,1200 - 1300,13,47,477,3,6 BOS, Terminal E,12/16/2017,1300 - 140e, 30,105,1181,5,16 BOS, Terminal E,12/16/2017,140e - 1500,47,90,447,2,15 BOS, Terminal E,12/16/2017,1500 - 160e, 20,26,216,1,11 BOS, Terminal E,12/16/2017,1600 - 1700,10,35, 605,5,12 BOS, Terminal E,12/16/2017,1700 - 1800, 34,90,336,4,10 BOS, Terminal E,12/16/2017,1800 - 1900,18,76,1326,9,14 BOS, Terminal E,12/16/2017,1900 - 200e,15,39,1219,6,14 BOS, Terminal E,12/16/2017,2000 - 2100,13,37,759,5,14 BOS, Terminal E,12/16/2017,2100 - 220e,15,48,578,4,11 BOS, Terminal E,12/16/2017,2200 - 2300,13,20,125,1,5 BOS, Terminal E,12/17/2017,0500 0600,8,18,174,1,3 BOS, Terminal E,12/17/2017,0700 080e,21,46,199,2,6 BOS, Terminal E,12/17/2017,1100 - 120e,14,24,178,1,6 BOS, Terminal E,12/17/2017,1200 - 130e,12,30,307,2,6 BOS, Terminal E,12/17/2017,1300 - 140e,17,64,1232,5,18 BOS, Terminal E,12/17/2017,1400 - 150e,25,65,563,4,18 BOS, Terminal E,12/17/2017,1500 - 160e,11,21,120,1,10 BOS, Terminal E,12/17/2017,1600 - 170e,11,25,305,2,11 BOS, Terminal E,12/17/2017,1700 - 180e,14,35,410,2,13 BOS, Terminal E,12/17/2017,1800 - 190e,12,33,841,5,13 BOS, Terminal E,12/17/2017,1900 - 200e,18,55,827,5,12 BOS , Terminal E , 12/17/2017, 2000-2100 , 7 , 25, 483, 4 , 11 BOS, Terminal E,12/17/2017,2100 - 220e,24, 50,327,2,8 BOS, Terminal E,12/17/2017,2200 - 230e,10,27,154,2,7 BOS, Terminal E,12/18/2017,0700 080e,21,48,247,2,6 BOS, Terminal E,12/18/2017,1100 - 1200,9,25,238,2,7 BOS, Terminal E,12/18/2017,1200 - 130e,13,31,408,2,7 BOS, Terminal E,12/18/2017,130e - 1400,27,87,1289,7,17 ORD, Terminal 5,12/24/2017,1800 1900,17,50,1165,11,21 ORD, Terminal 5 . 12/24/2017, 1900-20007, 17, 80 , 1 , 8 ORD, Terminal 5,12/24/2017, 2000 - 210e,14,33,219,2,6 ORD, Terminal 5,12/24/2017,2100- 2200,7,18,127,1,6 ORD, Terminal 5,12/24/2017,2200- 2300,13,23,165,1,7 ORD, Terminal 5,12/24/2017, 2300 000e,13,32,232,2,8 ORD, Terminal 5,12/25/2017,0000 - 010e,8,24,148,2,8 ORD, Terminal 5,12/25/2017,0500 060e, 39,90,691,3,14 ORD, Terminal 5,12/25/2017,0700 0800,4,15,130,2,9 ORD, Terminal 5,12/25/2017,0900 - 1000,15,55,219,2,11 ORD, Terminal 5 . 12/25/2017, 1000-1100 , 7 . 20 , 2703, 13 ORD, Terminal 5,12/25/2017,1100 - 120e,16,35,395,3,14 ORD, Terminal 5,12/25/2017,1200 - 1300,13,32,498,5,23 ORD, Terminal 5,12/25/2017,1300 - 1400,18,40,476,3,24 ORD, Terminal 5,12/25/2017,1400 1500,27,82,1614,8,19 ORD, Terminal 5,12/25/2017,1500 - 1600, 30,87,933,7,26e ORD, Terminal 5,12/25/2017,1600 - 1700,22,78,658,6,16 ORD, Terminal 5,12/25/2017,1700 - 1800,13,51,513,5,15 ORD, Terminal 5,12/25/2017,1800 1900,15,51,966,10,16 ORD, Terminal 5,12/25/2017,1900 - 200e,9,27,311,2,15 ORD , Terminal 5 , 12/25/2017, 2100-22007, 17, 141, 1 , 2 ORD, Terminal 5,12/25/2017, 2200 - 2300,8,17,130,1,9 ORD, Terminal 5,12/25/2017, 2300 000e,9,22,387,3,11 ORD, Terminal 5,12/26/2017,0300 040e,9,20,103,1,8 ORD, Terminal 5,12/26/2017,0400 0500,17,65,159,2,4 ORD, Terminal 5,12/26/2017,0500 0600,50,89,274,1,7 ORD, Terminal 5,12/26/2017,0600 0700,7,20,85,1,8 ORD, Terminal 5,12/26/2017,0700 - 0800,11,21,75,1,9 ORD, Terminal 5,12/26/2017,0800 090e,10,27,164,1,8 ORD, Terminal 5,12/26/2017,0900 - 100e,23,42,196,1,7 ORD, Terminal 5,12/26/2017,1000 - 110e,16,33,98,1,7 ORD, Terminal 5,12/26/2017,1100 - 1200,17,54,494,4,11 ORD, Terminal 5,12/26/2017,1200 - 1300,31,86,614,6,18 ORD . Terminal 5 . 12/26/2017, 1300-1400 , 27, 71, 7995, 20 ORD . Terminal 5 . 12/26/2017, 1400-1500 . 21 , 70 , 1498 , 920 JFK, Terminal 4 (IAT),12/18/2017,1500 - 1600,26,82,1038,5,25 JFK, Terminal 4 (IAT),12/18/2017,1600 - 1700,10,27,234,2,16 JFK, Terminal 4 (IAT),12/18/2017,1700 - 1800,19,60,1104,7,19 JFK, Terminal 4 (IAT),12/18/2017,1800 - 1900,10,30,370,2,15 JFK, Terminal 4 (IAT),12/18/2017,1900 - 2000,17,54,1078,5,19 JFK, Terminal 4 (IAT),12/18/2017,2000 - 2100,9,31,742,4,26 JFK, Terminal 4 (IAT),12/18/2017,21002200,9,27,267,2,15 JFK, Terminal 4 (IAT),12/18/2017, 2200 - 2300,11,26,592,4, 21 JFK, Terminal 4 (IAT),12/18/2017,2300 - 0000,12,32,365,3,14 JFK, Terminal 5 (Jet Blue),12/18/2017,0500 - 0600,24,50,134,1,5 JFK, Terminal 5 (Jet Blue),12/18/2017,0700 - 0800,25,72,193,1,5 JFK, Terminal 5 (Jet Blue),12/18/2017,0800 - 0900, 33,75,318,2,7 JFK, Terminal 5 (Jet Blue),12/18/2017,0900 - 1000,19,53,260,2,6 JFK, Terminal 5 (Jet Blue),12/18/2017,1300 - 1490,24,62,361,2,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1400 - 1500,15,31,148,1,10 JFK, Terminal 5 (Jet Blue),12/18/2017,1500 - 1690,6,27,462,4,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1600 - 1700,4,15,168,1,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1790 - 1800,12,26,206,2,10 JFK, Terminal 5 (Jet Blue),12/18/2017,1890 - 1900,16,49,836,6,9 JFK, Terminal 5 (Jet Blue),12/18/2017,1990 - 2000,12,56, 504, 3,9 JFK, Terminal 5 (Jet Blue),12/18/2017,2000 - 2100,16, 50,383,3,8 JFK, Terminal 5 (Jet Blue),12/18/2017,2100 - 2200,6,15,172,2,7 JFK, Terminal 7 (British),12/18/2017,0600 - 0700,18,40,89,1,6 JFK, Terminal 7 (British),12/18/2017,0800 - e900,29,62,315,2,11 JFK, Terminal 7 (British),12/18/2017,0900 - 1000,16,33,254,1,10 JFK, Terminal 7 (British),12/18/2017,1100 - 1200,18,45, 348, 2,7 JFK, Terminal 7 (British),12/18/2017,1200 - 1300,13,31,221,1,6 JFK, Terminal 7 (British),12/18/2017,1400 - 1500,15,50,449, 3,5 JFK, Terminal 7 (British),12/18/2017,1500 - 1600,18,37,311,2,8 JFK, Terminal 7 (British),12/18/2017,1700 - 1800,11,27,201,1,8 JFK, Terminal 7 (British),12/18/2017,1800 - 1900,22,48,200,1,9 JFK, Terminal 7 (British),12/18/2017,1900 - 2000,21,43,447,2,9 JFK, Terminal 7 (British),12/18/2017,2000 - 2100,20,36,449,2,8 JFK, Terminal 7 (British),12/18/2017,2100 - 2200,24,45,170,1,7 JFK, Terminal 7 (British),12/18/2017,2200 - 2300,14,43,371,3,9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

Explain the Unit load concept. AppendixLO1

Answered: 1 week ago