Airplane Price Prediction

Predict Price of Different Airplanes Using Plane Specification

@kaggle.rafsunahmad_plane_price_prediction

Table List

1 table(37.48 KB)

Plane Price

@kaggle.rafsunahmad_plane_price_prediction.plane_price

37.48 KB
517 rows
16 columns

model_name Model Name	engine_type Engine Type	hp_or_lbs_thr_ea_engine HP Or Lbs Thr Ea Engine	max_speed_knots Max Speed Knots	rcmnd_cruise_knots Rcmnd Cruise Knots	stall_knots_dirty Stall Knots Dirty	fuel_gal_lbs Fuel Gal/lbs	all_eng_rate_of_climb All Eng Rate Of Climb	eng_out_rate_of_climb Eng Out Rate Of Climb	takeoff_over_50ft Takeoff Over 50ft	landing_over_50ft Landing Over 50ft	empty_weight_lbs Empty Weight Lbs	length_ft_in Length Ft/in	wing_span_ft_in Wing Span Ft/in	range_n_m Range N.M.	price Price
100 Darter (S.L. Industries)	Piston	145	104	91	46	36	450	900	1300	2,050	1180	25/3	37/5	370	1300000
7 CCM Champ	Piston	85	89	83	44	15	600	720	800	1,350	820	20/7	36/1	190	1230000
100 Darter (S.L. Industries)	Piston	90	90	78	37	19	650	475	850	1,300	810	21/5	35/0	210	1600000
7 AC Champ	Piston	85	88	78	37	19	620	500	850	1,300	800	21/5	35/0	210	1300000
100 Darter (S.L. Industries)	Piston	65	83	74	33	14	370	632	885	1,220	740	21/5	35/0	175	1250000
PA-60-700P Aerostar (preliminary)	Piston	65	78	72	33	15	360	583	880	1,250	786	20/4	36/1	180	1100000
PA-601P pressurized Aerostar ('77 service ceiling=26,350)	Piston	350	264	230	80	165	1,820	3080	2100	6,315	4275	34/10	36/8	868	2500000
100 Darter (S.L. Industries)	Piston	290	262	247	77	165	1,755	2250	2076	6,000	4125	34/9	36/7	1020	2800000
PA-601, 601A, turbochg Aerostar	Piston	290	257	235	77	165	1,460	2490	2030	6,000	4056	34/10	36/8	1101	2500000
100 Darter (S.L. Industries)	Piston	290	257	237	77	165	1,460	2490	2030	6,000	3958	34/10	36/8	1174	3000000


CREATE TABLE plane_price (
  "model_name" VARCHAR,
  "engine_type" VARCHAR,
  "hp_or_lbs_thr_ea_engine" VARCHAR,
  "max_speed_knots" VARCHAR,
  "rcmnd_cruise_knots" DOUBLE,
  "stall_knots_dirty" DOUBLE,
  "fuel_gal_lbs" BIGINT,
  "all_eng_rate_of_climb" VARCHAR,
  "eng_out_rate_of_climb" DOUBLE,
  "takeoff_over_50ft" DOUBLE,
  "landing_over_50ft" VARCHAR,
  "empty_weight_lbs" DOUBLE,
  "length_ft_in" VARCHAR,
  "wing_span_ft_in" VARCHAR,
  "range_n_m" DOUBLE,
  "price" DOUBLE
);