Price Prediction -Multiple Linear Regression

Multiple Linear Regression - Cleanin, Correlation,Dummies,Multicollinearity,OLS

@kaggle.erolmasimov_price_prediction_multiple_linear_regression

Table List

1 table(26.69 KB)

Scrap Price

@kaggle.erolmasimov_price_prediction_multiple_linear_regression.scrap_price

26.69 KB
205 rows
26 columns

id ID	symboling Symboling	name Name	fueltypes Fueltypes	aspiration Aspiration	doornumbers Doornumbers	carbody Carbody	drivewheels Drivewheels	enginelocation Enginelocation	wheelbase Wheelbase	carlength Carlength	carwidth Carwidth	carheight Carheight	curbweight Curbweight	enginetype Enginetype	cylindernumber Cylindernumber	enginesize Enginesize	fuelsystem Fuelsystem	boreratio Boreratio	stroke Stroke	compressionratio Compressionratio	horsepower Horsepower	peakrpm Peakrpm	citympg Citympg	highwaympg Highwaympg	price Price
1	3	alfa-romero giulia	gas	std	two	convertible	rwd	front	88.6	168.8	64.1	48.8	2548	dohc	four	130	mpfi	3.47	2.68	9	111	5000	21	27	13495
2	3	alfa-romero stelvio	gas	std	two	convertible	rwd	front	88.6	168.8	64.1	48.8	2548	dohc	four	130	mpfi	3.47	2.68	9	111	5000	21	27	16500
3	1	alfa-romero Quadrifoglio	gas	std	two	hatchback	rwd	front	94.5	171.2	65.5	52.4	2823	ohcv	six	152	mpfi	2.68	3.47	9	154	5000	19	26	16500
4	2	audi 100 ls	gas	std	four	sedan	fwd	front	99.8	176.6	66.2	54.3	2337	ohc	four	109	mpfi	3.19	3.4	10	102	5500	24	30	13950
5	2	audi 100ls	gas	std	four	sedan	4wd	front	99.4	176.6	66.4	54.3	2824	ohc	five	136	mpfi	3.19	3.4	8	115	5500	18	22	17450
6	2	audi fox	gas	std	two	sedan	fwd	front	99.8	177.3	66.3	53.1	2507	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	15250
7	1	audi 100ls	gas	std	four	sedan	fwd	front	105.8	192.7	71.4	55.7	2844	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	17710
8	1	audi 5000	gas	std	four	wagon	fwd	front	105.8	192.7	71.4	55.7	2954	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	18920
9	1	audi 4000	gas	turbo	four	sedan	fwd	front	105.8	192.7	71.4	55.9	3086	ohc	five	131	mpfi	3.13	3.4	8.3	140	5500	17	20	23875
10		audi 5000s (diesel)	gas	turbo	two	hatchback	4wd	front	99.5	178.2	67.9	52	3053	ohc	five	131	mpfi	3.13	3.4	7	160	5500	16	22	17859.167


CREATE TABLE scrap_price (
  "id" BIGINT,
  "symboling" BIGINT,
  "name" VARCHAR,
  "fueltypes" VARCHAR,
  "aspiration" VARCHAR,
  "doornumbers" VARCHAR,
  "carbody" VARCHAR,
  "drivewheels" VARCHAR,
  "enginelocation" VARCHAR,
  "wheelbase" DOUBLE,
  "carlength" DOUBLE,
  "carwidth" DOUBLE,
  "carheight" DOUBLE,
  "curbweight" BIGINT,
  "enginetype" VARCHAR,
  "cylindernumber" VARCHAR,
  "enginesize" BIGINT,
  "fuelsystem" VARCHAR,
  "boreratio" DOUBLE,
  "stroke" DOUBLE,
  "compressionratio" DOUBLE,
  "horsepower" BIGINT,
  "peakrpm" BIGINT,
  "citympg" BIGINT,
  "highwaympg" BIGINT,
  "price" DOUBLE
);