February Flight Delay Prediction
US Flight Data for the month of Feb 2019 and Feb 2020
@kaggle.divyansh22_february_flight_delay_prediction
Feb 2019 Ontime
@kaggle.divyansh22_february_flight_delay_prediction.feb_2019_ontime
- 7.59 MB
- 533175 rows
- 22 columns
day_of_monthDAY OF MONTH | day_of_weekDAY OF WEEK | op_unique_carrierOP UNIQUE CARRIER | op_carrier_airline_idOP CARRIER AIRLINE ID | op_carrierOP CARRIER | tail_numTAIL NUM | op_carrier_fl_numOP CARRIER FL NUM | origin_airport_idORIGIN AIRPORT ID | origin_airport_seq_idORIGIN AIRPORT SEQ ID | originORIGIN | dest_airport_idDEST AIRPORT ID | dest_airport_seq_idDEST AIRPORT SEQ ID | destDEST | dep_timeDEP TIME | dep_del15DEP DEL15 | dep_time_blkDEP TIME BLK | arr_timeARR TIME | arr_del15ARR DEL15 | cancelledCANCELLED | divertedDIVERTED | distanceDISTANCE | unnamed_21Unnamed: 21 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5 | AA | 19805 | AA | N812NN | 1424 | 13204 | 1320402 | MCO | 12478 | 1247805 | JFK | 933 | 0900-0959 | 1148 | 944 | |||||
| 1 | 5 | AA | 19805 | AA | N843NN | 1425 | 11298 | 1129806 | DFW | 10529 | 1052906 | BDL | 2021 | 2000-2059 | 47 | 1471 | |||||
| 1 | 5 | AA | 19805 | AA | N949AN | 1426 | 14122 | 1412202 | PIT | 13930 | 1393007 | ORD | 754 | 0800-0859 | 921 | 1 | 413 | ||||
| 1 | 5 | AA | 19805 | AA | N306NY | 1427 | 10721 | 1072102 | BOS | 13930 | 1393007 | ORD | 505 | 0001-0559 | 725 | 1 | 867 | ||||
| 1 | 5 | AA | 19805 | AA | N163AA | 1430 | 11298 | 1129806 | DFW | 14771 | 1477104 | SFO | 1938 | 1 | 1800-1859 | 2130 | 1 | 1464 | |||
| 1 | 5 | AA | 19805 | AA | N969NN | 1432 | 14908 | 1490803 | SNA | 11298 | 1129806 | DFW | 642 | 0600-0659 | 1146 | 1205 | |||||
| 1 | 5 | AA | 19805 | AA | N936AN | 1433 | 15370 | 1537002 | TUL | 11057 | 1105703 | CLT | 653 | 0600-0659 | 1022 | 842 | |||||
| 1 | 5 | AA | 19805 | AA | N137AA | 1435 | 11298 | 1129806 | DFW | 10423 | 1042302 | AUS | 2102 | 1 | 2000-2059 | 2156 | 1 | 190 | |||
| 1 | 5 | AA | 19805 | AA | N906NN | 1437 | 14107 | 1410702 | PHX | 14057 | 1405702 | PDX | 1101 | 1100-1159 | 1302 | 1009 | |||||
| 1 | 5 | AA | 19805 | AA | N973NN | 1438 | 13930 | 1393007 | ORD | 13303 | 1330303 | MIA | 840 | 0800-0859 | 1239 | 1197 |
CREATE TABLE feb_2019_ontime (
"day_of_month" BIGINT,
"day_of_week" BIGINT,
"op_unique_carrier" VARCHAR,
"op_carrier_airline_id" BIGINT,
"op_carrier" VARCHAR,
"tail_num" VARCHAR,
"op_carrier_fl_num" BIGINT,
"origin_airport_id" BIGINT,
"origin_airport_seq_id" BIGINT,
"origin" VARCHAR,
"dest_airport_id" BIGINT,
"dest_airport_seq_id" BIGINT,
"dest" VARCHAR,
"dep_time" DOUBLE,
"dep_del15" DOUBLE,
"dep_time_blk" VARCHAR,
"arr_time" DOUBLE,
"arr_del15" DOUBLE,
"cancelled" DOUBLE,
"diverted" DOUBLE,
"distance" DOUBLE,
"unnamed_21" VARCHAR
);