Baselight

Flight Price Prediction

Predict Fllight Price, practise feature engineering, implement ensemble models

@kaggle.shubhambathwal_flight_price_prediction

Business
@kaggle.shubhambathwal_flight_price_prediction.business

  • 357.79 KB
  • 93487 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-2022Air IndiaAI86818:00Delhi02h 00mnon-stop 20:00Mumbai25612
11-02-2022Air IndiaAI62419:00Delhi02h 15mnon-stop 21:15Mumbai25612
11-02-2022Air IndiaAI53120:00Delhi24h 45m1-stop 20:45Mumbai42220
11-02-2022Air IndiaAI83921:25Delhi26h 30m1-stop 23:55Mumbai44450
11-02-2022Air IndiaAI54417:15Delhi06h 40m1-stop 23:55Mumbai46690
11-02-2022VistaraUK98519:50Delhi02h 10mnon-stop 22:00Mumbai50264
11-02-2022Air IndiaAI47921:15Delhi17h 45m1-stop 15:00Mumbai50669
11-02-2022Air IndiaAI47318:40Delhi22h 45m1-stop 17:25Mumbai51059
11-02-2022VistaraUK87120:35Delhi17h 55m1-stop 14:30Mumbai51731
11-02-2022VistaraUK97719:00Delhi02h 15mnon-stop 21:15Mumbai53288

CREATE TABLE business (
  "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.