Airline Flight Dataset: Schedule, Performance Etc
"Navigating the Skies: An In-Depth Airline Flight Dataset Analysis"
@kaggle.arunjangir245_airline_flight_dataset_schedule_performance_etc
"Navigating the Skies: An In-Depth Airline Flight Dataset Analysis"
@kaggle.arunjangir245_airline_flight_dataset_schedule_performance_etc
Explanation of Features:
Year: The year in which the flight took place.
Month: The month in which the flight took place.
Day of Month: The specific day of the month on which the flight occurred.
Day of Week: The day of the week on which the flight took place (e.g., Monday, Tuesday, etc.).
Departure Time: The scheduled departure time of the flight.
Arrival Time: The scheduled arrival time of the flight.
Unique Carrier: A code representing the unique airline carrier operating the flight.
Flight Number: The unique identifier assigned to the flight.
Tail Number: The unique identifier for the aircraft operating the flight.
Actual Elapsed Time: The total time taken for the flight, including both air time and any ground time.
Air Time: The time spent in the air during the flight.
Arrival Delay: The difference between the scheduled arrival time and the actual arrival time of the flight.
Origin: The airport code or location from which the flight departed.
Destination (Dest): The airport code or location to which the flight was headed.
Distance: The distance between the origin and destination airport
Taxi In: The time taken by the aircraft to taxi from the runway to the gate upon arrival.
Taxi Out: The time taken by the aircraft to taxi from the gate to the runway for departure.
Cancelled: Indicates whether the flight was cancelled (1) or not (0).
Cancellation Code: A code indicating the reason for flight cancellation (if applicable).
Diverted: Indicates whether the flight was diverted to a different airport (1) or not (0).
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
);
Anyone who has the link will be able to view this.