2015 Flight Delays And Cancellations

Which airline should you fly on to avoid significant delays?

@kaggle.usdot_flight_delays

Table List

3 tables(135.54 MB)

Airlines

Airports

Flights

Flights

@kaggle.usdot_flight_delays.flights

135.51 MB
5819079 rows
31 columns

year YEAR	month MONTH	day DAY	day_of_week DAY OF WEEK	airline AIRLINE	flight_number FLIGHT NUMBER	tail_number TAIL NUMBER	origin_airport ORIGIN AIRPORT	destination_airport DESTINATION AIRPORT	scheduled_departure SCHEDULED DEPARTURE	departure_time DEPARTURE TIME	departure_delay DEPARTURE DELAY	taxi_out TAXI OUT	wheels_off WHEELS OFF	scheduled_time SCHEDULED TIME	elapsed_time ELAPSED TIME	air_time AIR TIME	distance DISTANCE	wheels_on WHEELS ON	taxi_in TAXI IN	scheduled_arrival SCHEDULED ARRIVAL	arrival_time ARRIVAL TIME	arrival_delay ARRIVAL DELAY	cancellation_reason CANCELLATION REASON
2015	1	1	4	AS	98	N407AS	ANC	SEA	5	2354	-11	21	15	205	194	169	1448	404	4	430	408	-22	nan
2015	1	1	4	AA	2336	N3KUAA	LAX	PBI	10	2	-8	12	14	280	279	263	2330	737	4	750	741	-9	nan
2015	1	1	4	US	840	N171US	SFO	CLT	20	18	-2	16	34	286	293	266	2296	800	11	806	811	5	nan
2015	1	1	4	AA	258	N3HYAA	LAX	MIA	20	15	-5	15	30	285	281	258	2342	748	8	805	756	-9	nan
2015	1	1	4	AS	135	N527AS	SEA	ANC	25	24	-1	11	35	235	215	199	1448	254	5	320	259	-21	nan
2015	1	1	4	DL	806	N3730B	SFO	MSP	25	20	-5	18	38	217	230	206	1589	604	6	602	610	8	nan
2015	1	1	4	NK	612	N635NK	LAS	MSP	25	19	-6	11	30	181	170	154	1299	504	5	526	509	-17	nan
2015	1	1	4	US	2013	N584UW	LAX	CLT	30	44	14	13	57	273	249	228	2125	745	8	803	753	-10	nan
2015	1	1	4	AA	1112	N3LAAA	SFO	DFW	30	19	-11	17	36	195	193	173	1464	529	3	545	532	-13	nan
2015	1	1	4	DL	1173	N826DN	LAS	ATL	30	33	3	12	45	221	203	186	1747	651	5	711	656	-15	nan


CREATE TABLE flights (
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "day_of_week" BIGINT,
  "airline" VARCHAR,
  "flight_number" BIGINT,
  "tail_number" VARCHAR,
  "origin_airport" VARCHAR,
  "destination_airport" VARCHAR,
  "scheduled_departure" BIGINT,
  "departure_time" DOUBLE,
  "departure_delay" DOUBLE,
  "taxi_out" DOUBLE,
  "wheels_off" DOUBLE,
  "scheduled_time" DOUBLE,
  "elapsed_time" DOUBLE,
  "air_time" DOUBLE,
  "distance" BIGINT,
  "wheels_on" DOUBLE,
  "taxi_in" DOUBLE,
  "scheduled_arrival" BIGINT,
  "arrival_time" DOUBLE,
  "arrival_delay" DOUBLE,
  "diverted" BIGINT,
  "cancelled" BIGINT,
  "cancellation_reason" VARCHAR,
  "air_system_delay" DOUBLE,
  "security_delay" DOUBLE,
  "airline_delay" DOUBLE,
  "late_aircraft_delay" DOUBLE,
  "weather_delay" DOUBLE
);