House-Price-Prediction Cleaned Dataset

Ready to use House Price Prediction Cleaned Dataset

@kaggle.aneelaabdullah_housepriceprediction_cleaned_dataset

Table List

1 table(88.94 KB)

House Price Prediction Clean

@kaggle.aneelaabdullah_housepriceprediction_cleaned_dataset.house_price_prediction_clean

88.94 KB
1460 rows
32 columns

id Id	mssubclass MSSubClass	lotarea LotArea	overallqual OverallQual	overallcond OverallCond	yearbuilt YearBuilt	yearremodadd YearRemodAdd	bsmtfinsf1 BsmtFinSF1	bsmtunfsf BsmtUnfSF	totalbsmtsf TotalBsmtSF	n_1stflrsf 1stFlrSF	n_2ndflrsf 2ndFlrSF	grlivarea GrLivArea	bsmtfullbath BsmtFullBath	fullbath FullBath	halfbath HalfBath	bedroomabvgr BedroomAbvGr	kitchenabvgr KitchenAbvGr	totrmsabvgrd TotRmsAbvGrd	fireplaces Fireplaces	garagecars GarageCars	garagearea GarageArea	wooddecksf WoodDeckSF	openporchsf OpenPorchSF	enclosedporch EnclosedPorch	n_3ssnporch 3SsnPorch	miscval MiscVal	mosold MoSold	yrsold YrSold	saleprice SalePrice
1	60	8450	7	5	2003	2003	706	150	856	856	854	1710	1	2	1	3	1	8		2	548		61				2	2008	208500
2	20	9600	6	8	1976	1976	978	284	1262	1262		1262		2		3	1	6	1	2	460	298					5	2007	181500
3	60	11250	7	5	2001	2002	486	434	920	920	866	1786	1	2	1	3	1	6	1	2	608		42				9	2008	223500
4	70	9550	7	5	1915	1970	216	540	756	961	756	1717	1	1		3	1	7	1	3	642		35	272			2	2006	140000
5	60	14260	8	5	2000	2000	655	490	1145	1145	1053	2198	1	2	1	4	1	9	1	3	836	192	84				12	2008	250000
6	50	14115	5	5	1993	1995	732	64	796	796	566	1362	1	1	1	1	1	5		2	480	40	30		320	700	10	2009	143000
7	20	10084	8	5	2004	2005	1369	317	1686	1694		1694	1	2		3	1	7	1	2	636	255	57				8	2007	307000
8	60	10382	7	6	1973	1973	859	216	1107	1107	983	2090	1	2	1	3	1	7	2	2	484	235	204	228		350	11	2009	200000
9	50	6120	7	5	1931	1950		952	952	1022	752	1774		2		2	2	8	2	2	468	90		205			4	2008	129900
10	190	7420	5	6	1939	1950	851	140	991	1077		1077	1	1		2	2	5	2	1	205		4				1	2008	118000


CREATE TABLE house_price_prediction_clean (
  "id" BIGINT,
  "mssubclass" BIGINT,
  "lotarea" BIGINT,
  "overallqual" BIGINT,
  "overallcond" BIGINT,
  "yearbuilt" BIGINT,
  "yearremodadd" BIGINT,
  "bsmtfinsf1" BIGINT,
  "bsmtunfsf" BIGINT,
  "totalbsmtsf" BIGINT,
  "n_1stflrsf" BIGINT,
  "n_2ndflrsf" BIGINT,
  "grlivarea" BIGINT,
  "bsmtfullbath" BIGINT,
  "fullbath" BIGINT,
  "halfbath" BIGINT,
  "bedroomabvgr" BIGINT,
  "kitchenabvgr" BIGINT,
  "totrmsabvgrd" BIGINT,
  "fireplaces" BIGINT,
  "garagecars" BIGINT,
  "garagearea" BIGINT,
  "wooddecksf" BIGINT,
  "openporchsf" BIGINT,
  "enclosedporch" BIGINT,
  "n_3ssnporch" BIGINT,
  "screenporch" BIGINT,
  "poolarea" BIGINT,
  "miscval" BIGINT,
  "mosold" BIGINT,
  "yrsold" BIGINT,
  "saleprice" BIGINT
);