2019 Airline Delays W/Weather And Airport Detail

Classification dataset which includes aircraft, weather, airport, and employment

@kaggle.threnjen_2019_airline_delays_and_cancellations

Table List

3 tables(190.81 MB)

Full Data Flightdelay

Test

Train

Full Data Flightdelay

@kaggle.threnjen_2019_airline_delays_and_cancellations.full_data_flightdelay

47.55 MB
6489062 rows
26 columns

month MONTH	day_of_week DAY OF WEEK	dep_del15 DEP DEL15	dep_time_blk DEP TIME BLK	distance_group DISTANCE GROUP	segment_number SEGMENT NUMBER	concurrent_flights CONCURRENT FLIGHTS	number_of_seats NUMBER OF SEATS	carrier_name CARRIER NAME	airport_flights_month AIRPORT FLIGHTS MONTH	airline_flights_month AIRLINE FLIGHTS MONTH	airline_airport_flights_month AIRLINE AIRPORT FLIGHTS MONTH	avg_monthly_pass_airport AVG MONTHLY PASS AIRPORT	avg_monthly_pass_airline AVG MONTHLY PASS AIRLINE	flt_attendants_per_pass FLT ATTENDANTS PER PASS	ground_serv_per_pass GROUND SERV PER PASS	plane_age PLANE AGE	departing_airport DEPARTING AIRPORT	latitude LATITUDE	longitude LONGITUDE	previous_airport PREVIOUS AIRPORT	tmax TMAX	awnd AWND
1	7		0800-0859	2	1	25	143	Southwest Airlines Co.	13056	107363	5873	1903352	13382999	0.00006178236301460919	0.0000988941230999822	8	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0700-0759	7	1	29	191	Delta Air Lines Inc.	13056	73508	1174	1903352	12460183	0.0001441658849878	0.0001486602009422	3	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0600-0659	7	1	27	199	Delta Air Lines Inc.	13056	73508	1174	1903352	12460183	0.0001441658849878	0.0001486602009422	18	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0600-0659	9	1	27	180	Delta Air Lines Inc.	13056	73508	1174	1903352	12460183	0.0001441658849878	0.0001486602009422	2	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0001-0559	7	1	10	182	Spirit Air Lines	13056	15023	1257	1903352	2688839	0.000009173723925704242	0.0001246510730715	1	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0001-0559	3	1	10	180	Frontier Airlines Inc.	13056	9496	581	1903352	1857122	0.0001157256482767	0.000007134694872433899	5	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0700-0759	6	1	29	186	Frontier Airlines Inc.	13056	9496	581	1903352	1857122	0.0001157256482767	0.000007134694872433899	2	McCarran International	36.08	-115.152	NONE	65	2.91
1	7	1	0001-0559	7	1	10	186	Frontier Airlines Inc.	13056	9496	581	1903352	1857122	0.0001157256482767	0.000007134694872433899	3	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0001-0559	7	1	10	180	Frontier Airlines Inc.	13056	9496	581	1903352	1857122	0.0001157256482767	0.000007134694872433899	3	McCarran International	36.08	-115.152	NONE	65	2.91
1	7		0600-0659	8	1	27	186	Frontier Airlines Inc.	13056	9496	581	1903352	1857122	0.0001157256482767	0.000007134694872433899	1	McCarran International	36.08	-115.152	NONE	65	2.91


CREATE TABLE full_data_flightdelay (
  "month" BIGINT,
  "day_of_week" BIGINT,
  "dep_del15" BIGINT,
  "dep_time_blk" VARCHAR,
  "distance_group" BIGINT,
  "segment_number" BIGINT,
  "concurrent_flights" BIGINT,
  "number_of_seats" BIGINT,
  "carrier_name" VARCHAR,
  "airport_flights_month" BIGINT,
  "airline_flights_month" BIGINT,
  "airline_airport_flights_month" BIGINT,
  "avg_monthly_pass_airport" BIGINT,
  "avg_monthly_pass_airline" BIGINT,
  "flt_attendants_per_pass" DOUBLE,
  "ground_serv_per_pass" DOUBLE,
  "plane_age" BIGINT,
  "departing_airport" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "previous_airport" VARCHAR,
  "prcp" DOUBLE,
  "snow" DOUBLE,
  "snwd" DOUBLE,
  "tmax" DOUBLE,
  "awnd" DOUBLE
);