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

Test

@kaggle.threnjen_2019_airline_delays_and_cancellations.test

43 MB
1946719 rows
30 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	prcp PRCP	tmax TMAX	awnd AWND	carrier_historical CARRIER HISTORICAL	dep_airport_hist DEP AIRPORT HIST	day_historical DAY HISTORICAL	dep_block_hist DEP BLOCK HIST
4	6		1000-1059	3	3	5	110	Delta Air Lines Inc.	6837	81803	180	819756	12460183	0.0001441658849878	0.0001486602009422	18	Chicago Midway International	41.785	-87.752	Atlanta Municipal		64	13.87	0.1395575856924465	0.1803071285228165	0.1771240234375	0.1477731018762055
3	2		1000-1059	2	2	31	50	Endeavor Air Inc.	14450	22191	1956	1208249	1212846		0.00009351277617445625	15	LaGuardia	40.779	-73.876	Bangor International		48	12.08	0.1555712381400454	0.1878828898345793	0.1328682322884936	0.1560448049439938
2	5		1000-1059	8	2	37	173	United Air Lines Inc.	16530	43512	4679	2743323	8501631	0.0002538042406215	0.0002289854734932	7	Stapleton International	39.774	-104.88	Los Angeles International		54	10.07	0.1894957549926099	0.2403156384505021	0.2369646851209652	0.1874841523403823
4	6		0900-0959	11	2	37	181	Alaska Airlines Inc.	17522	21136	1629	2780593	2884187	0.00003233146156611231	0.0001746014497265	3	Los Angeles International	33.942	-118.408	Portland International		64	7.38	0.1323262401045827	0.11284046692607	0.1771240234375	0.135373513296806
8	7		0900-0959	1	2	27	143	Southwest Airlines Co.	14220	114987	6116	1903352	13382999	0.00006178236301460919	0.0000988941230999822	20	McCarran International	36.08	-115.152	Spokane International		104	4.92	0.1925497296681312	0.1234866828087167	0.1965191617107788	0.1380665959036049
6	3	1	0700-0759	6	2	45	143	Southwest Airlines Co.	21878	112879	5954	2743323	13382999	0.00006178236301460919	0.0000988941230999822	13	Stapleton International	39.774	-104.88	Eppley Airfield		83	7.83	0.2597746164719308	0.2018052869116698	0.2371748183838497	0.1107876187557462
1	2		1700-1759	6	3	28	173	United Air Lines Inc.	17725	46218	2105	2780593	8501631	0.0002538042406215	0.0002289854734932	10	Los Angeles International	33.942	-118.408	Stapleton International	0.69	59	8.5	0.1818824058315404	0.1887233876627934	0.1594894344257917	0.2295388261028071
5	1		1000-1059	6	3	38	143	Southwest Airlines Co.	14585	113709	5100	1827202	13382999	0.00006178236301460919	0.0000988941230999822	13	Phoenix Sky Harbor International	33.436	-112.009	Hollywood-Burbank Midpoint		91	6.04	0.2486199958728848	0.1909845788849347	0.1936678887870455	0.1560421052631579
12	7		1100-1159	1	3	25	143	Southwest Airlines Co.	13152	113248	5142	1903352	13382999	0.00006178236301460919	0.0000988941230999822	11	McCarran International	36.08	-115.152	Will Rogers World		47	2.24	0.2640381080591296	0.1631504922644163	0.226980167528948	0.1938883930468783
11	2		0800-0859	5	1	92	180	Delta Air Lines Inc.	31151	79989	19506	4365661	12460183	0.0001441658849878	0.0001486602009422	4	Atlanta Municipal	33.641	-84.427	NONE		63	6.71	0.1008823196712039	0.1878828898345793	0.1531299719117675	0.0943169948547332


CREATE TABLE test (
  "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,
  "carrier_historical" DOUBLE,
  "dep_airport_hist" DOUBLE,
  "day_historical" DOUBLE,
  "dep_block_hist" DOUBLE
);