Flight Price Predict (competition Format)

filght price regression problem

@kaggle.kukuroo3_flight_price_predict_competition_format

Table List

4 tables(194.66 KB)

X Test

X Train

Y Test

Y Train

X Train

@kaggle.kukuroo3_flight_price_predict_competition_format.x_train

72.37 KB
5698 rows
10 columns

filghtid FilghtId	airline Airline	flight Flight	source_city Source City	departure_time Departure Time	stops Stops	arrival_time Arrival Time	destination_city Destination City	duration Duration	days_left Days Left
252589	Vistara	UK-808	Bangalore	Early_Morning	one	Night	Mumbai	13.25	46
223754	Vistara	UK-927	Delhi	Morning	one	Evening	Chennai	10.42	31
243398	Vistara	UK-988	Mumbai	Night	one	Morning	Chennai	13	28
208360	Vistara	UK-815	Delhi	Morning	one	Night	Mumbai	12.67	17
247226	Vistara	UK-854	Bangalore	Evening	one	Morning	Delhi	13.67	32
293881	Vistara	UK-822	Chennai	Morning	one	Morning	Bangalore	23.08	11
254119	Vistara	UK-814	Bangalore	Night	one	Evening	Kolkata	22.42	21
272356	Vistara	UK-772	Kolkata	Morning	one	Early_Morning	Hyderabad	21.42	45
271143	Vistara	UK-778	Kolkata	Afternoon	one	Afternoon	Hyderabad	21.25	20
256513	Vistara	UK-850	Bangalore	Evening	one	Night	Hyderabad	25	11


CREATE TABLE x_train (
  "filghtid" BIGINT,
  "airline" VARCHAR,
  "flight" VARCHAR,
  "source_city" VARCHAR,
  "departure_time" VARCHAR,
  "stops" VARCHAR,
  "arrival_time" VARCHAR,
  "destination_city" VARCHAR,
  "duration" DOUBLE,
  "days_left" BIGINT
);