| \n", " | date | \n", "quarter | \n", "house_id | \n", "house_type | \n", "sales_type | \n", "year_build | \n", "purchase_price | \n", "%_change_between_offer_and_purchase | \n", "no_rooms | \n", "sqm | \n", "sqm_price | \n", "address | \n", "zip_code | \n", "city | \n", "area | \n", "region | \n", "nom_interest_rate% | \n", "dk_ann_infl_rate% | \n", "yield_on_mortgage_credit_bonds% | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2024-10-24 | \n", "2024Q4 | \n", "16 | \n", "Villa | \n", "regular_sale | \n", "1997 | \n", "6500000 | \n", "-3.0 | \n", "5 | \n", "142.0 | \n", "45774.650 | \n", "Spættevej 16 | \n", "2680 | \n", "Solrød Strand | \n", "Capital, Copenhagen | \n", "Zealand | \n", "3.1 | \n", "NaN | \n", "NaN | \n", "
| 1 | \n", "2024-10-24 | \n", "2024Q4 | \n", "13 | \n", "Apartment | \n", "regular_sale | \n", "1885 | \n", "3400000 | \n", "0.0 | \n", "2 | \n", "46.0 | \n", "73913.050 | \n", "Jakob Dannefærds Vej 10B, 4. th | \n", "1973 | \n", "Frederiksberg C | \n", "Capital, Copenhagen | \n", "Zealand | \n", "3.1 | \n", "NaN | \n", "NaN | \n", "
| 2 | \n", "2024-10-23 | \n", "2024Q4 | \n", "60 | \n", "Villa | \n", "regular_sale | \n", "1949 | \n", "4550000 | \n", "-4.0 | \n", "4 | \n", "112.0 | \n", "40625.000 | \n", "Vestre Plantagevej 3 | \n", "2680 | \n", "Solrød Strand | \n", "Capital, Copenhagen | \n", "Zealand | \n", "3.1 | \n", "NaN | \n", "NaN | \n", "
| 3 | \n", "2024-10-23 | \n", "2024Q4 | \n", "29 | \n", "Villa | \n", "regular_sale | \n", "2001 | \n", "1630000 | \n", "-12.0 | \n", "4 | \n", "186.0 | \n", "8763.440 | \n", "Toftebjerg 3 | \n", "4400 | \n", "Kalundborg | \n", "Other islands | \n", "Zealand | \n", "3.1 | \n", "NaN | \n", "NaN | \n", "
| 4 | \n", "2024-10-22 | \n", "2024Q4 | \n", "92 | \n", "Apartment | \n", "regular_sale | \n", "1965 | \n", "1975000 | \n", "-10.0 | \n", "3 | \n", "82.0 | \n", "24085.365 | \n", "Ryttergårdsvej 20, 1. 113 | \n", "3520 | \n", "Farum | \n", "North Zealand | \n", "Zealand | \n", "3.1 | \n", "NaN | \n", "NaN | \n", "
| \n", " | 0 | \n", "
|---|---|
| date | \n", "0 | \n", "
| quarter | \n", "0 | \n", "
| house_id | \n", "0 | \n", "
| house_type | \n", "0 | \n", "
| sales_type | \n", "0 | \n", "
| year_build | \n", "0 | \n", "
| purchase_price | \n", "0 | \n", "
| %_change_between_offer_and_purchase | \n", "0 | \n", "
| no_rooms | \n", "0 | \n", "
| sqm | \n", "0 | \n", "
| sqm_price | \n", "0 | \n", "
| address | \n", "0 | \n", "
| zip_code | \n", "0 | \n", "
| city | \n", "11 | \n", "
| area | \n", "0 | \n", "
| region | \n", "0 | \n", "
| nom_interest_rate% | \n", "0 | \n", "
| dk_ann_infl_rate% | \n", "77 | \n", "
| yield_on_mortgage_credit_bonds% | \n", "77 | \n", "
| \n", " | year_build | \n", "purchase_price | \n", "%_change_between_offer_and_purchase | \n", "no_rooms | \n", "sqm | \n", "sqm_price | \n", "zip_code | \n", "nom_interest_rate% | \n", "dk_ann_infl_rate% | \n", "yield_on_mortgage_credit_bonds% | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "99501.000000 | \n", "9.950100e+04 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "99501.000000 | \n", "
| mean | \n", "1955.306228 | \n", "1.928668e+06 | \n", "-1.977950 | \n", "4.374519 | \n", "129.317997 | \n", "16434.601812 | \n", "5948.892242 | \n", "1.681739 | \n", "1.927748 | \n", "4.110675 | \n", "
| std | \n", "44.147258 | \n", "1.775411e+06 | \n", "4.262969 | \n", "1.659359 | \n", "56.977603 | \n", "13656.910143 | \n", "2370.691520 | \n", "2.050171 | \n", "1.637891 | \n", "2.196504 | \n", "
| min | \n", "1600.000000 | \n", "2.502000e+05 | \n", "-30.000000 | \n", "1.000000 | \n", "26.000000 | \n", "374.549800 | \n", "1051.000000 | \n", "0.000000 | \n", "0.250000 | \n", "1.100000 | \n", "
| 25% | \n", "1931.000000 | \n", "8.000000e+05 | \n", "-3.000000 | \n", "3.000000 | \n", "89.000000 | \n", "6818.181600 | \n", "4000.000000 | \n", "0.000000 | \n", "0.790000 | \n", "2.120000 | \n", "
| 50% | \n", "1966.000000 | \n", "1.400000e+06 | \n", "0.000000 | \n", "4.000000 | \n", "123.000000 | \n", "12102.804000 | \n", "5970.000000 | \n", "0.750000 | \n", "1.850000 | \n", "4.340000 | \n", "
| 75% | \n", "1980.000000 | \n", "2.450000e+06 | \n", "0.000000 | \n", "5.000000 | \n", "160.000000 | \n", "21374.045000 | \n", "8250.000000 | \n", "3.250000 | \n", "2.340000 | \n", "5.500000 | \n", "
| max | \n", "2024.000000 | \n", "4.595500e+07 | \n", "30.000000 | \n", "15.000000 | \n", "984.000000 | \n", "75000.000000 | \n", "9990.000000 | \n", "9.500000 | \n", "7.700000 | \n", "10.140000 | \n", "
| \n", " | model | \n", "MAE | \n", "RMSE | \n", "R2 | \n", "
|---|---|---|---|---|
| 2 | \n", "Gradient Boosting | \n", "8.655158e+05 | \n", "1.389433e+06 | \n", "0.383369 | \n", "
| 1 | \n", "Decision Tree | \n", "8.746477e+05 | \n", "1.441747e+06 | \n", "0.336062 | \n", "
| 0 | \n", "Baseline Linear Regression | \n", "1.001504e+06 | \n", "1.535592e+06 | \n", "0.246815 | \n", "
| \n", " | feature | \n", "importance | \n", "
|---|---|---|
| 0 | \n", "num__sqm | \n", "0.268776 | \n", "
| 6 | \n", "num__sale_year | \n", "0.217320 | \n", "
| 22 | \n", "cat__cluster_id_1 | \n", "0.138602 | \n", "
| 16 | \n", "cat__house_type_Apartment | \n", "0.073080 | \n", "
| 8 | \n", "num__property_age | \n", "0.070329 | \n", "
| \n", " | feature | \n", "importance | \n", "
|---|---|---|
| 0 | \n", "num__sqm | \n", "0.289714 | \n", "
| 6 | \n", "num__sale_year | \n", "0.227584 | \n", "
| 22 | \n", "cat__cluster_id_1 | \n", "0.132897 | \n", "
| 16 | \n", "cat__house_type_Apartment | \n", "0.094074 | \n", "
| 8 | \n", "num__property_age | \n", "0.056479 | \n", "
| \n", " | feature | \n", "coefficient | \n", "abs_coefficient | \n", "
|---|---|---|---|
| 7 | \n", "cat__house_type_Apartment | \n", "733143.505723 | \n", "733143.505723 | \n", "
| 0 | \n", "num__sqm | \n", "703483.624955 | \n", "703483.624955 | \n", "
| 6 | \n", "cat__region_Zealand | \n", "640145.869399 | \n", "640145.869399 | \n", "
| 11 | \n", "cat__house_type_Villa | \n", "-531435.350419 | \n", "531435.350419 | \n", "
| 3 | \n", "cat__region_Bornholm | \n", "-428036.674507 | \n", "428036.674507 | \n", "
| \n", " | model | \n", "accuracy | \n", "
|---|---|---|
| 2 | \n", "Random Forest | \n", "0.610901 | \n", "
| 0 | \n", "Logistic Regression | \n", "0.527018 | \n", "
| 1 | \n", "KNN | \n", "0.498878 | \n", "