Feature Engineering on Time Series Dataset (Flight Price Prediction)
Airline Source Destination Route Dep_Time Arrival_Time Duration Total_Stops Additional_Info Price Date Month Year 0 IndiGo Banglore New Delhi BLR → DEL 22:20 01:10 22 Mar 2h 50m non-stop No info 3897.0 24 3 2019 1 Air India Kolkata Banglore CCU → IXR → BBI → BLR 05:50 13:15 7h 25m 2 stops No info 7662.0 1 5 2019 2 Jet Airways Delhi Cochin DEL → LKO → BOM → COK 09:25 04:25 10 Jun 19h 2 stops No info 13882.0 9 6 2019 3 IndiGo Kolkata Banglore CCU → NAG → BLR 18:05 23:30 5h 25m 1 stop No info 6218.0 12 5 2019 4 IndiGo Banglore New Delhi BLR → NAG → DEL 16:50 21:35 4h 45m 1 stop No info 13302.0 1 3 2019 5 SpiceJet Kolkata Banglore CCU → BLR 09:00 11:25 2h 25m non-stop No info 3873.0 24 6 2019 6 Jet Airways Banglore New Delhi BLR → BOM → DEL 18:55 10:25 13 Mar 15h 30m 1 stop In-flight meal not included 11087.0 12 3 2019 7 Jet Airways Banglore New Delhi BLR → BOM → DEL 08:00 05:05 02 Mar 21h 5m 1 stop No info 22270.0 1 3 2019 8 Jet Airways Banglore New Delhi BLR → BOM → DEL 08:55 10:25 13 Mar 25h 30m 1 stop In-flight meal not included 11087.0 12 3 2019 9 Multiple carriers Delhi Cochin DEL → BOM → COK 11:25 19:15 7h 50m 1 stop No info 8625.0 27 5 2019