Airline Flight Dataset: Schedule, Performance Etc

"Navigating the Skies: An In-Depth Airline Flight Dataset Analysis"

@kaggle.arunjangir245_airline_flight_dataset_schedule_performance_etc

Table List

1 table(2.7 MB)

Hflights

@kaggle.arunjangir245_airline_flight_dataset_schedule_performance_etc.hflights

2.7 MB
227496 rows
21 columns

year Year	month Month	dayofmonth DayofMonth	dayofweek DayOfWeek	deptime DepTime	arrtime ArrTime	uniquecarrier UniqueCarrier	flightnum FlightNum	tailnum TailNum	actualelapsedtime ActualElapsedTime	airtime AirTime	arrdelay ArrDelay	depdelay DepDelay	origin Origin	dest Dest	distance Distance	taxiin TaxiIn	taxiout TaxiOut	cancellationcode CancellationCode
2011	1	1	6	1400	1500	AA	428	N576AA	60	40	-10		IAH	DFW	224	7	13	nan
2011	1	2	7	1401	1501	AA	428	N557AA	60	45	-9	1	IAH	DFW	224	6	9	nan
2011	1	3	1	1352	1502	AA	428	N541AA	70	48	-8	-8	IAH	DFW	224	5	17	nan
2011	1	4	2	1403	1513	AA	428	N403AA	70	39	3	3	IAH	DFW	224	9	22	nan
2011	1	5	3	1405	1507	AA	428	N492AA	62	44	-3	5	IAH	DFW	224	9	9	nan
2011	1	6	4	1359	1503	AA	428	N262AA	64	45	-7	-1	IAH	DFW	224	6	13	nan
2011	1	7	5	1359	1509	AA	428	N493AA	70	43	-1	-1	IAH	DFW	224	12	15	nan
2011	1	8	6	1355	1454	AA	428	N477AA	59	40	-16	-5	IAH	DFW	224	7	12	nan
2011	1	9	7	1443	1554	AA	428	N476AA	71	41	44	43	IAH	DFW	224	8	22	nan
2011	1	10	1	1443	1553	AA	428	N504AA	70	45	43	43	IAH	DFW	224	6	19	nan


CREATE TABLE hflights (
  "year" BIGINT,
  "month" BIGINT,
  "dayofmonth" BIGINT,
  "dayofweek" BIGINT,
  "deptime" DOUBLE,
  "arrtime" DOUBLE,
  "uniquecarrier" VARCHAR,
  "flightnum" BIGINT,
  "tailnum" VARCHAR,
  "actualelapsedtime" DOUBLE,
  "airtime" DOUBLE,
  "arrdelay" DOUBLE,
  "depdelay" DOUBLE,
  "origin" VARCHAR,
  "dest" VARCHAR,
  "distance" BIGINT,
  "taxiin" DOUBLE,
  "taxiout" DOUBLE,
  "cancelled" BIGINT,
  "cancellationcode" VARCHAR,
  "diverted" BIGINT
);