Airplane Price Prediction
Predict Price of Different Airplanes Using Plane Specification
@kaggle.rafsunahmad_plane_price_prediction
Plane Price
@kaggle.rafsunahmad_plane_price_prediction.plane_price
- 37.48 KB
- 517 rows
- 16 columns
model_nameModel Name | engine_typeEngine Type | hp_or_lbs_thr_ea_engineHP Or Lbs Thr Ea Engine | max_speed_knotsMax Speed Knots | rcmnd_cruise_knotsRcmnd Cruise Knots | stall_knots_dirtyStall Knots Dirty | fuel_gal_lbsFuel Gal/lbs | all_eng_rate_of_climbAll Eng Rate Of Climb | eng_out_rate_of_climbEng Out Rate Of Climb | takeoff_over_50ftTakeoff Over 50ft | landing_over_50ftLanding Over 50ft | empty_weight_lbsEmpty Weight Lbs | length_ft_inLength Ft/in | wing_span_ft_inWing Span Ft/in | range_n_mRange N.M. | pricePrice |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);