Baselight

Flight Price Prediction

Predict Fllight Price, practise feature engineering, implement ensemble models

@kaggle.shubhambathwal_flight_price_prediction

Economy
@kaggle.shubhambathwal_flight_price_prediction.economy

  • 1.23 MB
  • 206774 rows
  • 11 columns
date

Date

airline

Airline

ch_code

Ch Code

num_code

Num Code

dep_time

Dep Time

from

From

time_taken

Time Taken

stop

Stop

arr_time

Arr Time

to

To

price

Price

11-02-2022SpiceJetSG870918:55Delhi02h 10mnon-stop 21:05Mumbai5953
11-02-2022SpiceJetSG815706:20Delhi02h 20mnon-stop 08:40Mumbai5953
11-02-2022AirAsiaI576404:25Delhi02h 10mnon-stop 06:35Mumbai5956
11-02-2022VistaraUK99510:20Delhi02h 15mnon-stop 12:35Mumbai5955
11-02-2022VistaraUK96308:50Delhi02h 20mnon-stop 11:10Mumbai5955
11-02-2022VistaraUK94511:40Delhi02h 20mnon-stop 14:00Mumbai5955
11-02-2022VistaraUK92709:30Delhi02h 05mnon-stop 11:35Mumbai6060
11-02-2022VistaraUK95114:20Delhi02h 10mnon-stop 16:30Mumbai6060
11-02-2022GO FIRSTG833408:00Delhi02h 10mnon-stop 10:10Mumbai5954
11-02-2022GO FIRSTG833614:20Delhi02h 15mnon-stop 16:35Mumbai5954

CREATE TABLE economy (
  "date" VARCHAR,
  "airline" VARCHAR,
  "ch_code" VARCHAR,
  "num_code" BIGINT,
  "dep_time" VARCHAR,
  "from" VARCHAR,
  "time_taken" VARCHAR,
  "stop" VARCHAR,
  "arr_time" VARCHAR,
  "to" VARCHAR,
  "price" BIGINT
);

Share link

Anyone who has the link will be able to view this.