Flight Price Prediction

Predict Fllight Price, practise feature engineering, implement ensemble models

@kaggle.shubhambathwal_flight_price_prediction

Table List

3 tables(4.29 MB)

Business

Clean Dataset

Economy

Clean Dataset

@kaggle.shubhambathwal_flight_price_prediction.clean_dataset

2.7 MB
300153 rows
12 columns

unnamed_0 Unnamed: 0	airline Airline	flight Flight	source_city Source City	departure_time Departure Time	stops Stops	arrival_time Arrival Time	destination_city Destination City	class Class	duration Duration	days_left Days Left	price Price
	SpiceJet	SG-8709	Delhi	Evening	zero	Night	Mumbai	Economy	2.17	1	5953
1	SpiceJet	SG-8157	Delhi	Early_Morning	zero	Morning	Mumbai	Economy	2.33	1	5953
2	AirAsia	I5-764	Delhi	Early_Morning	zero	Early_Morning	Mumbai	Economy	2.17	1	5956
3	Vistara	UK-995	Delhi	Morning	zero	Afternoon	Mumbai	Economy	2.25	1	5955
4	Vistara	UK-963	Delhi	Morning	zero	Morning	Mumbai	Economy	2.33	1	5955
5	Vistara	UK-945	Delhi	Morning	zero	Afternoon	Mumbai	Economy	2.33	1	5955
6	Vistara	UK-927	Delhi	Morning	zero	Morning	Mumbai	Economy	2.08	1	6060
7	Vistara	UK-951	Delhi	Afternoon	zero	Evening	Mumbai	Economy	2.17	1	6060
8	GO_FIRST	G8-334	Delhi	Early_Morning	zero	Morning	Mumbai	Economy	2.17	1	5954
9	GO_FIRST	G8-336	Delhi	Afternoon	zero	Evening	Mumbai	Economy	2.25	1	5954


CREATE TABLE clean_dataset (
  "unnamed_0" BIGINT,
  "airline" VARCHAR,
  "flight" VARCHAR,
  "source_city" VARCHAR,
  "departure_time" VARCHAR,
  "stops" VARCHAR,
  "arrival_time" VARCHAR,
  "destination_city" VARCHAR,
  "class" VARCHAR,
  "duration" DOUBLE,
  "days_left" BIGINT,
  "price" BIGINT
);