Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 4063 |
| Missing cells | 23512 |
| Missing cells (%) | 23.1% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 954.3 KiB |
| Average record size in memory | 240.5 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 11 |
awareness_of_electricity_consumption_of_renters has constant value "1.0" | Constant |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
LECO_csc_area is highly overall correlated with type_of_electricity_meter | High correlation |
charging_method_of_renters_for_electricity is highly overall correlated with floor_which_house_located and 2 other fields | High correlation |
floor_which_house_located is highly overall correlated with charging_method_of_renters_for_electricity | High correlation |
highest_level_of_education_of_the_chief_wage_earner is highly overall correlated with socio_economic_class | High correlation |
is_there_business_carried_out_in_the_household is highly overall correlated with type_of_business | High correlation |
no_of_storeys is highly overall correlated with charging_method_of_renters_for_electricity and 2 other fields | High correlation |
occupy_renters_boarders is highly overall correlated with own_the_house_or_living_on_rent | High correlation |
own_the_house_or_living_on_rent is highly overall correlated with charging_method_of_renters_for_electricity and 1 other fields | High correlation |
socio_economic_class is highly overall correlated with highest_level_of_education_of_the_chief_wage_earner | High correlation |
type_of_business is highly overall correlated with is_there_business_carried_out_in_the_household and 1 other fields | High correlation |
type_of_electricity_meter is highly overall correlated with LECO_csc_area | High correlation |
type_of_house is highly overall correlated with no_of_storeys | High correlation |
own_the_house_or_living_on_rent is highly imbalanced (68.5%) | Imbalance |
occupy_renters_boarders is highly imbalanced (86.2%) | Imbalance |
is_there_business_carried_out_in_the_household is highly imbalanced (73.2%) | Imbalance |
any_constructions_or_renovations_in_the_household is highly imbalanced (71.3%) | Imbalance |
occupy_renters_boarders has 536 (13.2%) missing values | Missing |
awareness_of_electricity_consumption_of_renters has 3959 (97.4%) missing values | Missing |
no_of_storeys has 3814 (93.9%) missing values | Missing |
charging_method_of_renters_for_electricity has 3959 (97.4%) missing values | Missing |
charged_method_for_rent_for_electricity has 3527 (86.8%) missing values | Missing |
type_of_business has 3877 (95.4%) missing values | Missing |
whom_or_how_the_house_was_designed has 1280 (31.5%) missing values | Missing |
availability_of_certificate_of_compliance has 1280 (31.5%) missing values | Missing |
main_material_used_for_roof_of_the_house has 1280 (31.5%) missing values | Missing |
Reproduction
| Analysis started | 2024-11-18 08:35:57.414065 |
|---|---|
| Analysis finished | 2024-11-18 08:36:16.291615 |
| Duration | 18.88 seconds |
| Software version | ydata-profiling vv4.11.0 |
| Download configuration | config.json |
Variables
no_of_electricity_meters
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0762983 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.31628519 |
|---|---|
| Coefficient of variation (CV) | 0.29386387 |
| Kurtosis | 51.158272 |
| Mean | 1.0762983 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.6452849 |
| Sum | 4373 |
| Variance | 0.10003632 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 3799 | |
| 2 | 225 | 5.5% |
| 3 | 36 | 0.9% |
| 5 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 3799 | |
| 2 | 225 | 5.5% |
| 3 | 36 | 0.9% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 36 | 0.9% |
| 2 | 225 | 5.5% |
| 1 | 3799 |
LECO_csc_area
Categorical
High correlation
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| MORATUWA NORTH | |
|---|---|
| MORATUWA SOUTH | |
| PANADURA | |
| GALLE | 216 |
| KESELWATTA | 206 |
| Other values (18) |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 9.6475511 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | GALLE |
|---|---|
| 2nd row | GALLE |
| 3rd row | GALLE |
| 4th row | BORALASGAMUWA |
| 5th row | KOLONNAWA |
Common Values
| Value | Count | Frequency (%) |
| MORATUWA NORTH | 533 | 13.1% |
| MORATUWA SOUTH | 370 | 9.1% |
| PANADURA | 357 | 8.8% |
| GALLE | 216 | 5.3% |
| KESELWATTA | 206 | 5.1% |
| MAHARAGAMA | 202 | 5.0% |
| PAYAGALA | 196 | 4.8% |
| KALUTARA | 189 | 4.7% |
| HIKKADUWA | 163 | 4.0% |
| ALUTHGAMA | 158 | 3.9% |
| Other values (13) | 1473 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| moratuwa | 903 | |
| north | 533 | 10.7% |
| south | 370 | 7.5% |
| panadura | 357 | 7.2% |
| galle | 216 | 4.3% |
| keselwatta | 206 | 4.1% |
| maharagama | 202 | 4.1% |
| payagala | 196 | 3.9% |
| kalutara | 189 | 3.8% |
| hikkaduwa | 163 | 3.3% |
| Other values (14) | 1631 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 10055 | |
| T | 3417 | 8.7% |
| O | 2914 | 7.4% |
| U | 2568 | 6.6% |
| R | 2454 | 6.3% |
| M | 2125 | 5.4% |
| L | 1849 | 4.7% |
| W | 1788 | 4.6% |
| N | 1693 | 4.3% |
| H | 1565 | 4.0% |
| Other values (12) | 8770 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39198 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 10055 | |
| T | 3417 | 8.7% |
| O | 2914 | 7.4% |
| U | 2568 | 6.6% |
| R | 2454 | 6.3% |
| M | 2125 | 5.4% |
| L | 1849 | 4.7% |
| W | 1788 | 4.6% |
| N | 1693 | 4.3% |
| H | 1565 | 4.0% |
| Other values (12) | 8770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39198 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 10055 | |
| T | 3417 | 8.7% |
| O | 2914 | 7.4% |
| U | 2568 | 6.6% |
| R | 2454 | 6.3% |
| M | 2125 | 5.4% |
| L | 1849 | 4.7% |
| W | 1788 | 4.6% |
| N | 1693 | 4.3% |
| H | 1565 | 4.0% |
| Other values (12) | 8770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39198 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 10055 | |
| T | 3417 | 8.7% |
| O | 2914 | 7.4% |
| U | 2568 | 6.6% |
| R | 2454 | 6.3% |
| M | 2125 | 5.4% |
| L | 1849 | 4.7% |
| W | 1788 | 4.6% |
| N | 1693 | 4.3% |
| H | 1565 | 4.0% |
| Other values (12) | 8770 |
own_the_house_or_living_on_rent
Categorical
High correlation Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| 1 | |
|---|---|
| 2 | |
| 4 | 50 |
| 3 | 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3527 | |
| 2 | 482 | 11.9% |
| 4 | 50 | 1.2% |
| 3 | 4 | 0.1% |
occupy_renters_boarders
Categorical
High correlation Imbalance Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 536 |
| Missing (%) | 13.2% |
| Memory size | 192.5 KiB |
| 3.0 | |
|---|---|
| 1.0 | 72 |
| 2.0 | 32 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 3.0 |
| 4th row | 3.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 3.0 | 3423 | |
| 1.0 | 72 | 1.8% |
| 2.0 | 32 | 0.8% |
| (Missing) | 536 | 13.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3.0 | 3423 | |
| 1.0 | 72 | 2.0% |
| 2.0 | 32 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 3527 | |
| 0 | 3527 | |
| 3 | 3423 | |
| 1 | 72 | 0.7% |
| 2 | 32 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10581 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 3527 | |
| 0 | 3527 | |
| 3 | 3423 | |
| 1 | 72 | 0.7% |
| 2 | 32 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10581 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 3527 | |
| 0 | 3527 | |
| 3 | 3423 | |
| 1 | 72 | 0.7% |
| 2 | 32 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10581 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 3527 | |
| 0 | 3527 | |
| 3 | 3423 | |
| 1 | 72 | 0.7% |
| 2 | 32 | 0.3% |
awareness_of_electricity_consumption_of_renters
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 3959 |
| Missing (%) | 97.4% |
| Memory size | 192.5 KiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 104 | 2.6% |
| (Missing) | 3959 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 104 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 104 | |
| . | 104 | |
| 0 | 104 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104 | |
| . | 104 | |
| 0 | 104 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104 | |
| . | 104 | |
| 0 | 104 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104 | |
| . | 104 | |
| 0 | 104 |
built_year_of_the_house
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6022643 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.7987946 |
|---|---|
| Coefficient of variation (CV) | 0.49935108 |
| Kurtosis | -0.86253795 |
| Mean | 3.6022643 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.11934928 |
| Sum | 14636 |
| Variance | 3.235662 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 4 | 918 | |
| 5 | 758 | |
| 1 | 740 | |
| 3 | 615 | |
| 2 | 482 | |
| 7 | 325 | 8.0% |
| 6 | 225 | 5.5% |
| Value | Count | Frequency (%) |
| 1 | 740 | |
| 2 | 482 | |
| 3 | 615 | |
| 4 | 918 | |
| 5 | 758 | |
| 6 | 225 | 5.5% |
| 7 | 325 | 8.0% |
| Value | Count | Frequency (%) |
| 7 | 325 | 8.0% |
| 6 | 225 | 5.5% |
| 5 | 758 | |
| 4 | 918 | |
| 3 | 615 | |
| 2 | 482 | |
| 1 | 740 |
type_of_house
Real number (ℝ)
High correlation
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5439331 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.99307151 |
|---|---|
| Coefficient of variation (CV) | 0.64320892 |
| Kurtosis | 19.557807 |
| Mean | 1.5439331 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.7390786 |
| Sum | 6273 |
| Variance | 0.98619103 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1 | 2482 | |
| 2 | 1332 | |
| 3 | 113 | 2.8% |
| 5 | 80 | 2.0% |
| 6 | 13 | 0.3% |
| 9 | 11 | 0.3% |
| 8 | 11 | 0.3% |
| 4 | 10 | 0.2% |
| 7 | 9 | 0.2% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2482 | |
| 2 | 1332 | |
| 3 | 113 | 2.8% |
| 4 | 10 | 0.2% |
| 5 | 80 | 2.0% |
| 6 | 13 | 0.3% |
| 7 | 9 | 0.2% |
| 8 | 11 | 0.3% |
| 9 | 11 | 0.3% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 2 | < 0.1% |
| 9 | 11 | 0.3% |
| 8 | 11 | 0.3% |
| 7 | 9 | 0.2% |
| 6 | 13 | 0.3% |
| 5 | 80 | 2.0% |
| 4 | 10 | 0.2% |
| 3 | 113 | 2.8% |
| 2 | 1332 | |
| 1 | 2482 |
floor_which_house_located
Real number (ℝ)
High correlation
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.91361063 |
| Minimum | -1 |
|---|---|
| Maximum | 11 |
| Zeros | 17 |
| Zeros (%) | 0.4% |
| Negative | 3970 |
| Negative (%) | 97.7% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | -1 |
| median | -1 |
| Q3 | -1 |
| 95-th percentile | -1 |
| Maximum | 11 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.70600528 |
|---|---|
| Coefficient of variation (CV) | -0.77276386 |
| Kurtosis | 129.58793 |
| Mean | -0.91361063 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.656777 |
| Sum | -3712 |
| Variance | 0.49844346 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| -1 | 3970 | |
| 1 | 24 | 0.6% |
| 2 | 18 | 0.4% |
| 0 | 17 | 0.4% |
| 3 | 7 | 0.2% |
| 4 | 7 | 0.2% |
| 5 | 4 | 0.1% |
| 8 | 4 | 0.1% |
| 6 | 3 | 0.1% |
| 7 | 3 | 0.1% |
| Other values (3) | 6 | 0.1% |
| Value | Count | Frequency (%) |
| -1 | 3970 | |
| 0 | 17 | 0.4% |
| 1 | 24 | 0.6% |
| 2 | 18 | 0.4% |
| 3 | 7 | 0.2% |
| 4 | 7 | 0.2% |
| 5 | 4 | 0.1% |
| 6 | 3 | 0.1% |
| 7 | 3 | 0.1% |
| 8 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 3 | 0.1% |
| 8 | 4 | 0.1% |
| 7 | 3 | 0.1% |
| 6 | 3 | 0.1% |
| 5 | 4 | 0.1% |
| 4 | 7 | 0.2% |
| 3 | 7 | 0.2% |
| 2 | 18 |
no_of_storeys
Real number (ℝ)
High correlation Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 3814 |
| Missing (%) | 93.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.746988 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 35 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 3 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.1378039 |
|---|---|
| Coefficient of variation (CV) | 0.65129465 |
| Kurtosis | -1.2583883 |
| Mean | 1.746988 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.013050986 |
| Sum | 435 |
| Variance | 1.2945977 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 93 | 2.3% |
| 1 | 91 | 2.2% |
| 0 | 35 | 0.9% |
| 2 | 28 | 0.7% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| (Missing) | 3814 |
| Value | Count | Frequency (%) |
| 0 | 35 | 0.9% |
| 1 | 91 | |
| 2 | 28 | 0.7% |
| 3 | 93 | |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 93 | |
| 2 | 28 | 0.7% |
| 1 | 91 | |
| 0 | 35 | 0.9% |
floor_area
Real number (ℝ)
| Distinct | 387 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1987.4175 |
| Minimum | 100 |
|---|---|
| Maximum | 99999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 300 |
| Q1 | 607.555 |
| median | 1000 |
| Q3 | 2000 |
| 95-th percentile | 3000 |
| Maximum | 99999 |
| Range | 99899 |
| Interquartile range (IQR) | 1392.445 |
Descriptive statistics
| Standard deviation | 7923.4353 |
|---|---|
| Coefficient of variation (CV) | 3.9867996 |
| Kurtosis | 147.08142 |
| Mean | 1987.4175 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 12.119169 |
| Sum | 8074877.3 |
| Variance | 62780827 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3000 | 277 | 6.8% |
| 1000 | 264 | 6.5% |
| 1200 | 256 | 6.3% |
| 800 | 203 | 5.0% |
| 600 | 202 | 5.0% |
| 2400 | 180 | 4.4% |
| 1500 | 175 | 4.3% |
| 2000 | 171 | 4.2% |
| 500 | 140 | 3.4% |
| 400 | 111 | 2.7% |
| Other values (377) | 2084 |
| Value | Count | Frequency (%) |
| 100 | 12 | |
| 108 | 1 | < 0.1% |
| 120 | 2 | < 0.1% |
| 125 | 1 | < 0.1% |
| 136.5 | 1 | < 0.1% |
| 140 | 2 | < 0.1% |
| 143 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 150 | 22 | |
| 160 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99999 | 26 | |
| 9000 | 2 | < 0.1% |
| 6000 | 1 | < 0.1% |
| 5000 | 1 | < 0.1% |
| 4700 | 1 | < 0.1% |
| 4600 | 7 | 0.2% |
| 4400 | 8 | 0.2% |
| 4200 | 15 | |
| 4000 | 23 | |
| 3960 | 2 | < 0.1% |
no_of_household_members
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0044302 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6872622 |
|---|---|
| Coefficient of variation (CV) | 0.42134889 |
| Kurtosis | 1.2549374 |
| Mean | 4.0044302 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.68467186 |
| Sum | 16270 |
| Variance | 2.8468538 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 4 | 1014 | |
| 3 | 818 | |
| 5 | 772 | |
| 2 | 602 | |
| 6 | 407 | |
| 1 | 186 | 4.6% |
| 7 | 144 | 3.5% |
| 8 | 65 | 1.6% |
| 9 | 29 | 0.7% |
| 10 | 15 | 0.4% |
| Other values (3) | 11 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 186 | 4.6% |
| 2 | 602 | |
| 3 | 818 | |
| 4 | 1014 | |
| 5 | 772 | |
| 6 | 407 | |
| 7 | 144 | 3.5% |
| 8 | 65 | 1.6% |
| 9 | 29 | 0.7% |
| 10 | 15 | 0.4% |
| Value | Count | Frequency (%) |
| 13 | 2 | < 0.1% |
| 12 | 4 | 0.1% |
| 11 | 5 | 0.1% |
| 10 | 15 | 0.4% |
| 9 | 29 | 0.7% |
| 8 | 65 | 1.6% |
| 7 | 144 | 3.5% |
| 6 | 407 | |
| 5 | 772 | |
| 4 | 1014 |
charging_method_of_renters_for_electricity
Categorical
High correlation Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 3959 |
| Missing (%) | 97.4% |
| Memory size | 192.5 KiB |
| 1.0 | |
|---|---|
| 5.0 | |
| 2.0 | |
| 3.0 | |
| 4.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5.0 |
|---|---|
| 2nd row | 5.0 |
| 3rd row | 5.0 |
| 4th row | 3.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 34 | 0.8% |
| 5.0 | 24 | 0.6% |
| 2.0 | 21 | 0.5% |
| 3.0 | 19 | 0.5% |
| 4.0 | 6 | 0.1% |
| (Missing) | 3959 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 34 | |
| 5.0 | 24 | |
| 2.0 | 21 | |
| 3.0 | 19 | |
| 4.0 | 6 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 104 | |
| 0 | 104 | |
| 1 | 34 | 10.9% |
| 5 | 24 | 7.7% |
| 2 | 21 | 6.7% |
| 3 | 19 | 6.1% |
| 4 | 6 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 104 | |
| 0 | 104 | |
| 1 | 34 | 10.9% |
| 5 | 24 | 7.7% |
| 2 | 21 | 6.7% |
| 3 | 19 | 6.1% |
| 4 | 6 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 104 | |
| 0 | 104 | |
| 1 | 34 | 10.9% |
| 5 | 24 | 7.7% |
| 2 | 21 | 6.7% |
| 3 | 19 | 6.1% |
| 4 | 6 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 312 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 104 | |
| 0 | 104 | |
| 1 | 34 | 10.9% |
| 5 | 24 | 7.7% |
| 2 | 21 | 6.7% |
| 3 | 19 | 6.1% |
| 4 | 6 | 1.9% |
charged_method_for_rent_for_electricity
Real number (ℝ)
Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 3527 |
| Missing (%) | 86.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2294776 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2.25 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.94401633 |
|---|---|
| Coefficient of variation (CV) | 0.76781905 |
| Kurtosis | 18.995525 |
| Mean | 1.2294776 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4520099 |
| Sum | 659 |
| Variance | 0.89116683 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 496 | 12.2% |
| 6 | 17 | 0.4% |
| 2 | 13 | 0.3% |
| 3 | 6 | 0.1% |
| 4 | 3 | 0.1% |
| 5 | 1 | < 0.1% |
| (Missing) | 3527 |
| Value | Count | Frequency (%) |
| 1 | 496 | |
| 2 | 13 | 0.3% |
| 3 | 6 | 0.1% |
| 4 | 3 | 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 17 | 0.4% |
| Value | Count | Frequency (%) |
| 6 | 17 | 0.4% |
| 5 | 1 | < 0.1% |
| 4 | 3 | 0.1% |
| 3 | 6 | 0.1% |
| 2 | 13 | 0.3% |
| 1 | 496 |
is_there_business_carried_out_in_the_household
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| 0 | |
|---|---|
| 1 | 186 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3877 | |
| 1 | 186 | 4.6% |
type_of_business
Categorical
High correlation Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 3877 |
| Missing (%) | 95.4% |
| Memory size | 192.5 KiB |
| 3.0 | |
|---|---|
| 1.0 | |
| 2.0 | 2 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 3.0 |
| 4th row | 3.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 3.0 | 121 | 3.0% |
| 1.0 | 63 | 1.6% |
| 2.0 | 2 | < 0.1% |
| (Missing) | 3877 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3.0 | 121 | |
| 1.0 | 63 | |
| 2.0 | 2 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 186 | |
| 0 | 186 | |
| 3 | 121 | |
| 1 | 63 | 11.3% |
| 2 | 2 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 558 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 186 | |
| 0 | 186 | |
| 3 | 121 | |
| 1 | 63 | 11.3% |
| 2 | 2 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 558 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 186 | |
| 0 | 186 | |
| 3 | 121 | |
| 1 | 63 | 11.3% |
| 2 | 2 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 558 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 186 | |
| 0 | 186 | |
| 3 | 121 | |
| 1 | 63 | 11.3% |
| 2 | 2 | 0.4% |
whom_or_how_the_house_was_designed
Real number (ℝ)
Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1280 |
| Missing (%) | 31.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9238232 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 6 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.1515088 |
|---|---|
| Coefficient of variation (CV) | 0.73585461 |
| Kurtosis | -1.5456763 |
| Mean | 2.9238232 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.44931759 |
| Sum | 8137 |
| Variance | 4.6289901 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 1389 | |
| 6 | 738 | |
| 4 | 359 | 8.8% |
| 3 | 125 | 3.1% |
| 2 | 117 | 2.9% |
| 5 | 55 | 1.4% |
| (Missing) | 1280 |
| Value | Count | Frequency (%) |
| 1 | 1389 | |
| 2 | 117 | 2.9% |
| 3 | 125 | 3.1% |
| 4 | 359 | 8.8% |
| 5 | 55 | 1.4% |
| 6 | 738 |
| Value | Count | Frequency (%) |
| 6 | 738 | |
| 5 | 55 | 1.4% |
| 4 | 359 | 8.8% |
| 3 | 125 | 3.1% |
| 2 | 117 | 2.9% |
| 1 | 1389 |
availability_of_certificate_of_compliance
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1280 |
| Missing (%) | 31.5% |
| Memory size | 192.5 KiB |
| 1.0 | |
|---|---|
| 2.0 | |
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 1268 | |
| 2.0 | 851 | |
| 0.0 | 664 | |
| (Missing) | 1280 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 1268 | |
| 2.0 | 851 | |
| 0.0 | 664 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3447 | |
| . | 2783 | |
| 1 | 1268 | 15.2% |
| 2 | 851 | 10.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8349 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3447 | |
| . | 2783 | |
| 1 | 1268 | 15.2% |
| 2 | 851 | 10.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8349 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3447 | |
| . | 2783 | |
| 1 | 1268 | 15.2% |
| 2 | 851 | 10.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8349 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3447 | |
| . | 2783 | |
| 1 | 1268 | 15.2% |
| 2 | 851 | 10.2% |
main_material_used_for_walls_of_the_house
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4767413 |
| Minimum | 1 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.634354 |
|---|---|
| Coefficient of variation (CV) | 1.0636371 |
| Kurtosis | 5.4584519 |
| Mean | 2.4767413 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.5815581 |
| Sum | 10063 |
| Variance | 6.9398208 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 2 | 1837 | |
| 1 | 1621 | |
| 11 | 299 | 7.4% |
| 4 | 191 | 4.7% |
| 7 | 49 | 1.2% |
| 5 | 29 | 0.7% |
| 3 | 19 | 0.5% |
| 10 | 9 | 0.2% |
| 9 | 8 | 0.2% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1621 | |
| 2 | 1837 | |
| 3 | 19 | 0.5% |
| 4 | 191 | 4.7% |
| 5 | 29 | 0.7% |
| 7 | 49 | 1.2% |
| 8 | 1 | < 0.1% |
| 9 | 8 | 0.2% |
| 10 | 9 | 0.2% |
| 11 | 299 | 7.4% |
| Value | Count | Frequency (%) |
| 11 | 299 | 7.4% |
| 10 | 9 | 0.2% |
| 9 | 8 | 0.2% |
| 8 | 1 | < 0.1% |
| 7 | 49 | 1.2% |
| 5 | 29 | 0.7% |
| 4 | 191 | 4.7% |
| 3 | 19 | 0.5% |
| 2 | 1837 | |
| 1 | 1621 |
main_material_used_for_roof_of_the_house
Real number (ℝ)
Missing
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1280 |
| Missing (%) | 31.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.093065 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.82006123 |
|---|---|
| Coefficient of variation (CV) | 0.39179921 |
| Kurtosis | 18.909896 |
| Mean | 2.093065 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.695379 |
| Sum | 5825 |
| Variance | 0.67250042 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 2 | 1665 | |
| 3 | 577 | 14.2% |
| 1 | 494 | 12.2% |
| 5 | 19 | 0.5% |
| 4 | 14 | 0.3% |
| 9 | 8 | 0.2% |
| 8 | 5 | 0.1% |
| 7 | 1 | < 0.1% |
| (Missing) | 1280 |
| Value | Count | Frequency (%) |
| 1 | 494 | 12.2% |
| 2 | 1665 | |
| 3 | 577 | 14.2% |
| 4 | 14 | 0.3% |
| 5 | 19 | 0.5% |
| 7 | 1 | < 0.1% |
| 8 | 5 | 0.1% |
| 9 | 8 | 0.2% |
| Value | Count | Frequency (%) |
| 9 | 8 | 0.2% |
| 8 | 5 | 0.1% |
| 7 | 1 | < 0.1% |
| 5 | 19 | 0.5% |
| 4 | 14 | 0.3% |
| 3 | 577 | 14.2% |
| 2 | 1665 | |
| 1 | 494 | 12.2% |
any_constructions_or_renovations_in_the_household
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| 0 | |
|---|---|
| 1 | 204 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3859 | |
| 1 | 204 | 5.0% |
highest_level_of_education_of_the_chief_wage_earner
Real number (ℝ)
High correlation
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4176717 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.3204272 |
|---|---|
| Coefficient of variation (CV) | 0.29889665 |
| Kurtosis | -0.11769917 |
| Mean | 4.4176717 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.58894582 |
| Sum | 17949 |
| Variance | 1.7435281 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 4 | 1879 | |
| 3 | 672 | 16.5% |
| 5 | 563 | 13.9% |
| 7 | 528 | 13.0% |
| 6 | 272 | 6.7% |
| 2 | 125 | 3.1% |
| 1 | 24 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 24 | 0.6% |
| 2 | 125 | 3.1% |
| 3 | 672 | 16.5% |
| 4 | 1879 | |
| 5 | 563 | 13.9% |
| 6 | 272 | 6.7% |
| 7 | 528 | 13.0% |
| Value | Count | Frequency (%) |
| 7 | 528 | 13.0% |
| 6 | 272 | 6.7% |
| 5 | 563 | 13.9% |
| 4 | 1879 | |
| 3 | 672 | 16.5% |
| 2 | 125 | 3.1% |
| 1 | 24 | 0.6% |
occupation_of_education_of_the_chief_wage_earner
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8562638 |
| Minimum | 1 |
|---|---|
| Maximum | 19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 7 |
| 95-th percentile | 10 |
| Maximum | 19 |
| Range | 18 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.1687349 |
|---|---|
| Coefficient of variation (CV) | 0.65250468 |
| Kurtosis | -0.65681245 |
| Mean | 4.8562638 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.59021035 |
| Sum | 19731 |
| Variance | 10.040881 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 2 | 1239 | |
| 8 | 483 | 11.9% |
| 7 | 452 | 11.1% |
| 3 | 398 | 9.8% |
| 1 | 334 | 8.2% |
| 10 | 262 | 6.4% |
| 5 | 251 | 6.2% |
| 6 | 237 | 5.8% |
| 11 | 160 | 3.9% |
| 4 | 153 | 3.8% |
| Other values (9) | 94 | 2.3% |
| Value | Count | Frequency (%) |
| 1 | 334 | 8.2% |
| 2 | 1239 | |
| 3 | 398 | 9.8% |
| 4 | 153 | 3.8% |
| 5 | 251 | 6.2% |
| 6 | 237 | 5.8% |
| 7 | 452 | 11.1% |
| 8 | 483 | 11.9% |
| 9 | 53 | 1.3% |
| 10 | 262 | 6.4% |
| Value | Count | Frequency (%) |
| 19 | 2 | < 0.1% |
| 18 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 16 | 0.4% |
| 12 | 16 | 0.4% |
| 11 | 160 | |
| 10 | 262 |
socio_economic_class
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| 3 | |
|---|---|
| 2 | |
| 1 | |
| 4 | |
| 5 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 4 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1485 | |
| 2 | 868 | |
| 1 | 786 | |
| 4 | 669 | |
| 5 | 255 | 6.3% |
total_monthly_expenditure_of_last_month
Real number (ℝ)
| Distinct | 86 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33295637 |
| Minimum | 5000 |
|---|---|
| Maximum | 1 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 192.5 KiB |
Quantile statistics
| Minimum | 5000 |
|---|---|
| 5-th percentile | 20000 |
| Q1 | 40000 |
| median | 60000 |
| Q3 | 100000 |
| 95-th percentile | 200000 |
| Maximum | 1 × 109 |
| Range | 9.99995 × 108 |
| Interquartile range (IQR) | 60000 |
Descriptive statistics
| Standard deviation | 1.7923726 × 108 |
|---|---|
| Coefficient of variation (CV) | 5.3832055 |
| Kurtosis | 25.163093 |
| Mean | 33295637 |
| Median Absolute Deviation (MAD) | 20000 |
| Skewness | 5.2106339 |
| Sum | 1.3528017 × 1011 |
| Variance | 3.2125994 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50000 | 535 | |
| 100000 | 498 | |
| 60000 | 417 | 10.3% |
| 40000 | 294 | 7.2% |
| 30000 | 249 | 6.1% |
| 80000 | 223 | 5.5% |
| 70000 | 218 | 5.4% |
| 150000 | 191 | 4.7% |
| 75000 | 158 | 3.9% |
| 999999999 | 135 | 3.3% |
| Other values (76) | 1145 |
| Value | Count | Frequency (%) |
| 5000 | 6 | 0.1% |
| 6000 | 2 | < 0.1% |
| 7000 | 1 | < 0.1% |
| 7500 | 2 | < 0.1% |
| 8000 | 3 | 0.1% |
| 10000 | 36 | |
| 11000 | 1 | < 0.1% |
| 12000 | 10 | 0.2% |
| 13000 | 1 | < 0.1% |
| 15000 | 64 |
| Value | Count | Frequency (%) |
| 999999999 | 135 | |
| 275000 | 2 | < 0.1% |
| 270000 | 1 | < 0.1% |
| 250000 | 31 | 0.8% |
| 230000 | 3 | 0.1% |
| 225000 | 2 | < 0.1% |
| 220000 | 1 | < 0.1% |
| 215000 | 1 | < 0.1% |
| 200000 | 113 | |
| 180000 | 6 | 0.1% |
type_of_electricity_meter
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 192.5 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4063 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2186 | |
| 2 | 1877 |
Interactions
Correlations
| LECO_csc_area | any_constructions_or_renovations_in_the_household | availability_of_certificate_of_compliance | built_year_of_the_house | charged_method_for_rent_for_electricity | charging_method_of_renters_for_electricity | floor_area | floor_which_house_located | highest_level_of_education_of_the_chief_wage_earner | is_there_business_carried_out_in_the_household | main_material_used_for_roof_of_the_house | main_material_used_for_walls_of_the_house | no_of_electricity_meters | no_of_household_members | no_of_storeys | occupation_of_education_of_the_chief_wage_earner | occupy_renters_boarders | own_the_house_or_living_on_rent | socio_economic_class | total_monthly_expenditure_of_last_month | type_of_business | type_of_electricity_meter | type_of_house | whom_or_how_the_house_was_designed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LECO_csc_area | 1.000 | 0.062 | 0.240 | 0.079 | 0.076 | 0.171 | 0.041 | 0.077 | 0.177 | 0.028 | 0.158 | 0.110 | 0.057 | 0.058 | 0.193 | 0.115 | 0.075 | 0.108 | 0.177 | 0.101 | 0.172 | 0.502 | 0.124 | 0.181 |
| any_constructions_or_renovations_in_the_household | 0.062 | 1.000 | 0.064 | 0.150 | 0.000 | 0.150 | 0.000 | 0.000 | 0.000 | 0.041 | 0.071 | 0.046 | 0.000 | 0.000 | 0.000 | 0.034 | 0.009 | 0.078 | 0.000 | 0.013 | 0.000 | 0.000 | 0.047 | 0.101 |
| availability_of_certificate_of_compliance | 0.240 | 0.064 | 1.000 | 0.285 | 0.182 | 0.000 | 0.043 | 0.035 | 0.213 | 0.005 | 0.117 | 0.248 | 0.078 | 0.022 | 0.238 | 0.171 | 0.041 | 0.278 | 0.217 | 0.033 | 0.000 | 0.125 | 0.228 | 0.435 |
| built_year_of_the_house | 0.079 | 0.150 | 0.285 | 1.000 | -0.094 | 0.020 | 0.020 | 0.073 | 0.027 | 0.039 | 0.297 | 0.201 | 0.019 | 0.052 | 0.088 | 0.018 | 0.012 | 0.442 | 0.023 | 0.085 | 0.093 | 0.075 | 0.257 | 0.005 |
| charged_method_for_rent_for_electricity | 0.076 | 0.000 | 0.182 | -0.094 | 1.000 | 0.000 | -0.003 | -0.040 | -0.043 | 0.000 | -0.030 | -0.131 | 0.064 | -0.103 | -0.060 | -0.076 | 0.000 | 0.267 | 0.030 | -0.078 | 0.000 | 0.047 | 0.035 | -0.127 |
| charging_method_of_renters_for_electricity | 0.171 | 0.150 | 0.000 | 0.020 | 0.000 | 1.000 | 0.000 | 1.000 | 0.156 | 0.075 | 0.000 | 0.042 | 0.000 | 0.163 | 0.577 | 0.000 | 0.361 | 1.000 | 0.103 | 0.000 | 0.000 | 0.000 | 0.200 | 0.000 |
| floor_area | 0.041 | 0.000 | 0.043 | 0.020 | -0.003 | 0.000 | 1.000 | -0.099 | 0.346 | 0.000 | -0.016 | -0.179 | 0.087 | 0.022 | 0.374 | 0.244 | 0.000 | 0.000 | 0.007 | 0.269 | 0.000 | 0.023 | 0.232 | -0.319 |
| floor_which_house_located | 0.077 | 0.000 | 0.035 | 0.073 | -0.040 | 1.000 | -0.099 | 1.000 | -0.037 | 0.000 | 0.180 | 0.146 | -0.033 | -0.012 | -0.349 | -0.049 | 0.000 | 0.030 | 0.048 | -0.026 | 0.000 | 0.020 | 0.297 | 0.095 |
| highest_level_of_education_of_the_chief_wage_earner | 0.177 | 0.000 | 0.213 | 0.027 | -0.043 | 0.156 | 0.346 | -0.037 | 1.000 | 0.042 | 0.069 | -0.175 | 0.074 | -0.050 | 0.345 | 0.302 | 0.000 | 0.036 | 0.650 | 0.334 | 0.159 | 0.176 | 0.262 | -0.233 |
| is_there_business_carried_out_in_the_household | 0.028 | 0.041 | 0.005 | 0.039 | 0.000 | 0.075 | 0.000 | 0.000 | 0.042 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.140 | 0.000 | 0.000 | 0.052 | 0.000 | 1.000 | 0.008 | 0.000 | 0.000 |
| main_material_used_for_roof_of_the_house | 0.158 | 0.071 | 0.117 | 0.297 | -0.030 | 0.000 | -0.016 | 0.180 | 0.069 | 0.000 | 1.000 | 0.055 | 0.131 | 0.035 | 0.048 | 0.065 | 0.106 | 0.000 | 0.057 | 0.049 | 0.000 | 0.160 | 0.339 | -0.094 |
| main_material_used_for_walls_of_the_house | 0.110 | 0.046 | 0.248 | 0.201 | -0.131 | 0.042 | -0.179 | 0.146 | -0.175 | 0.000 | 0.055 | 1.000 | -0.045 | 0.008 | -0.493 | -0.108 | 0.000 | 0.270 | 0.066 | -0.122 | 0.000 | 0.042 | -0.076 | 0.327 |
| no_of_electricity_meters | 0.057 | 0.000 | 0.078 | 0.019 | 0.064 | 0.000 | 0.087 | -0.033 | 0.074 | 0.000 | 0.131 | -0.045 | 1.000 | -0.035 | 0.100 | 0.106 | 0.000 | 0.000 | 0.048 | 0.054 | 0.051 | 0.101 | 0.248 | -0.070 |
| no_of_household_members | 0.058 | 0.000 | 0.022 | 0.052 | -0.103 | 0.163 | 0.022 | -0.012 | -0.050 | 0.000 | 0.035 | 0.008 | -0.035 | 1.000 | 0.018 | -0.007 | 0.098 | 0.021 | 0.063 | 0.242 | 0.000 | 0.000 | 0.015 | -0.002 |
| no_of_storeys | 0.193 | 0.000 | 0.238 | 0.088 | -0.060 | 0.577 | 0.374 | -0.349 | 0.345 | 0.000 | 0.048 | -0.493 | 0.100 | 0.018 | 1.000 | 0.386 | 0.000 | 0.114 | 0.157 | 0.352 | 1.000 | 0.138 | -0.671 | -0.339 |
| occupation_of_education_of_the_chief_wage_earner | 0.115 | 0.034 | 0.171 | 0.018 | -0.076 | 0.000 | 0.244 | -0.049 | 0.302 | 0.140 | 0.065 | -0.108 | 0.106 | -0.007 | 0.386 | 1.000 | 0.000 | 0.000 | 0.444 | 0.248 | 0.105 | 0.141 | 0.172 | -0.123 |
| occupy_renters_boarders | 0.075 | 0.009 | 0.041 | 0.012 | 0.000 | 0.361 | 0.000 | 0.000 | 0.000 | 0.000 | 0.106 | 0.000 | 0.000 | 0.098 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.022 | 0.000 | 0.000 | 0.000 | 0.000 |
| own_the_house_or_living_on_rent | 0.108 | 0.078 | 0.278 | 0.442 | 0.267 | 1.000 | 0.000 | 0.030 | 0.036 | 0.000 | 0.000 | 0.270 | 0.000 | 0.021 | 0.114 | 0.000 | 1.000 | 1.000 | 0.039 | 0.000 | 0.000 | 0.033 | 0.063 | 0.261 |
| socio_economic_class | 0.177 | 0.000 | 0.217 | 0.023 | 0.030 | 0.103 | 0.007 | 0.048 | 0.650 | 0.052 | 0.057 | 0.066 | 0.048 | 0.063 | 0.157 | 0.444 | 0.000 | 0.039 | 1.000 | 0.039 | 0.128 | 0.192 | 0.184 | 0.168 |
| total_monthly_expenditure_of_last_month | 0.101 | 0.013 | 0.033 | 0.085 | -0.078 | 0.000 | 0.269 | -0.026 | 0.334 | 0.000 | 0.049 | -0.122 | 0.054 | 0.242 | 0.352 | 0.248 | 0.022 | 0.000 | 0.039 | 1.000 | 0.000 | 0.000 | 0.198 | -0.167 |
| type_of_business | 0.172 | 0.000 | 0.000 | 0.093 | 0.000 | 0.000 | 0.000 | 0.000 | 0.159 | 1.000 | 0.000 | 0.000 | 0.051 | 0.000 | 1.000 | 0.105 | 0.000 | 0.000 | 0.128 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
| type_of_electricity_meter | 0.502 | 0.000 | 0.125 | 0.075 | 0.047 | 0.000 | 0.023 | 0.020 | 0.176 | 0.008 | 0.160 | 0.042 | 0.101 | 0.000 | 0.138 | 0.141 | 0.000 | 0.033 | 0.192 | 0.000 | 0.000 | 1.000 | 0.220 | 0.101 |
| type_of_house | 0.124 | 0.047 | 0.228 | 0.257 | 0.035 | 0.200 | 0.232 | 0.297 | 0.262 | 0.000 | 0.339 | -0.076 | 0.248 | 0.015 | -0.671 | 0.172 | 0.000 | 0.063 | 0.184 | 0.198 | 0.000 | 0.220 | 1.000 | -0.201 |
| whom_or_how_the_house_was_designed | 0.181 | 0.101 | 0.435 | 0.005 | -0.127 | 0.000 | -0.319 | 0.095 | -0.233 | 0.000 | -0.094 | 0.327 | -0.070 | -0.002 | -0.339 | -0.123 | 0.000 | 0.261 | 0.168 | -0.167 | 0.000 | 0.101 | -0.201 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| no_of_electricity_meters | LECO_csc_area | own_the_house_or_living_on_rent | occupy_renters_boarders | awareness_of_electricity_consumption_of_renters | built_year_of_the_house | type_of_house | floor_which_house_located | no_of_storeys | floor_area | no_of_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | whom_or_how_the_house_was_designed | availability_of_certificate_of_compliance | main_material_used_for_walls_of_the_house | main_material_used_for_roof_of_the_house | any_constructions_or_renovations_in_the_household | highest_level_of_education_of_the_chief_wage_earner | occupation_of_education_of_the_chief_wage_earner | socio_economic_class | total_monthly_expenditure_of_last_month | type_of_electricity_meter | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| household_ID | |||||||||||||||||||||||||
| ID0001 | 1 | GALLE | 1 | 3.0 | NaN | 4 | 2 | -1 | NaN | 1500.0 | 4 | NaN | NaN | 0 | NaN | 1.0 | 0.0 | 1 | 2.0 | 0 | 4 | 2 | 3 | 35000 | 2 |
| ID0002 | 1 | GALLE | 1 | 3.0 | NaN | 1 | 1 | -1 | NaN | 440.0 | 3 | NaN | NaN | 0 | NaN | 5.0 | 1.0 | 1 | 2.0 | 0 | 5 | 1 | 4 | 40000 | 2 |
| ID0003 | 1 | GALLE | 1 | 3.0 | NaN | 2 | 1 | -1 | NaN | 2500.0 | 4 | NaN | NaN | 0 | NaN | 1.0 | 0.0 | 1 | 1.0 | 0 | 7 | 6 | 1 | 250000 | 1 |
| ID0004 | 1 | BORALASGAMUWA | 1 | 3.0 | NaN | 5 | 2 | -1 | NaN | 2600.0 | 4 | NaN | NaN | 0 | NaN | 1.0 | 0.0 | 2 | 3.0 | 0 | 6 | 11 | 1 | 100000 | 1 |
| ID0005 | 1 | KOLONNAWA | 1 | 3.0 | NaN | 5 | 5 | 10 | 1.0 | 480.0 | 2 | NaN | NaN | 0 | NaN | 1.0 | 1.0 | 11 | 3.0 | 0 | 3 | 2 | 4 | 60000 | 1 |
| ID0006 | 1 | KOLONNAWA | 1 | 3.0 | NaN | 5 | 5 | 1 | 2.0 | 440.0 | 6 | NaN | NaN | 0 | NaN | 5.0 | 1.0 | 2 | 3.0 | 0 | 3 | 1 | 5 | 100000 | 1 |
| ID0007 | 1 | KOLONNAWA | 1 | 3.0 | NaN | 5 | 5 | 2 | 1.0 | 480.0 | 4 | NaN | NaN | 0 | NaN | 5.0 | 1.0 | 2 | 3.0 | 0 | 4 | 8 | 3 | 60000 | 1 |
| ID0008 | 2 | GALLE | 1 | 3.0 | NaN | 5 | 2 | -1 | NaN | 1400.0 | 5 | NaN | NaN | 0 | NaN | 1.0 | 1.0 | 2 | 2.0 | 0 | 6 | 3 | 2 | 150000 | 1 |
| ID0009 | 1 | GALLE | 1 | 3.0 | NaN | 4 | 1 | -1 | NaN | 350.0 | 2 | NaN | NaN | 0 | NaN | 1.0 | 0.0 | 1 | 2.0 | 0 | 4 | 2 | 3 | 15000 | 2 |
| ID0010 | 1 | GALLE | 1 | 3.0 | NaN | 3 | 1 | -1 | NaN | 1000.0 | 7 | NaN | NaN | 0 | NaN | 1.0 | 0.0 | 1 | 1.0 | 0 | 3 | 1 | 5 | 50000 | 2 |
| no_of_electricity_meters | LECO_csc_area | own_the_house_or_living_on_rent | occupy_renters_boarders | awareness_of_electricity_consumption_of_renters | built_year_of_the_house | type_of_house | floor_which_house_located | no_of_storeys | floor_area | no_of_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | whom_or_how_the_house_was_designed | availability_of_certificate_of_compliance | main_material_used_for_walls_of_the_house | main_material_used_for_roof_of_the_house | any_constructions_or_renovations_in_the_household | highest_level_of_education_of_the_chief_wage_earner | occupation_of_education_of_the_chief_wage_earner | socio_economic_class | total_monthly_expenditure_of_last_month | type_of_electricity_meter | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| household_ID | |||||||||||||||||||||||||
| ID4054 | 1 | NEGOMBO | 2 | NaN | NaN | 2 | 1 | -1 | NaN | 1250.0 | 6 | NaN | 1.0 | 0 | NaN | NaN | NaN | 1 | NaN | 0 | 4 | 2 | 3 | 70000 | 1 |
| ID4055 | 1 | NEGOMBO | 1 | 3.0 | NaN | 4 | 2 | -1 | NaN | 1500.0 | 3 | NaN | NaN | 0 | NaN | NaN | NaN | 1 | NaN | 0 | 4 | 6 | 2 | 60000 | 1 |
| ID4056 | 1 | GALLE | 1 | 3.0 | NaN | 4 | 1 | -1 | NaN | 2400.0 | 3 | NaN | NaN | 0 | NaN | NaN | NaN | 2 | NaN | 0 | 3 | 1 | 5 | 999999999 | 2 |
| ID4057 | 1 | GALLE | 1 | 3.0 | NaN | 1 | 1 | -1 | NaN | 2400.0 | 2 | NaN | NaN | 0 | NaN | NaN | NaN | 4 | NaN | 0 | 4 | 2 | 3 | 25000 | 2 |
| ID4058 | 1 | GALLE | 1 | 3.0 | NaN | 3 | 1 | -1 | NaN | 3000.0 | 6 | NaN | NaN | 0 | NaN | NaN | NaN | 2 | NaN | 0 | 5 | 2 | 3 | 8000 | 2 |
| ID4059 | 1 | NUGEGODA | 1 | 3.0 | NaN | 6 | 2 | -1 | NaN | 400.0 | 4 | NaN | NaN | 0 | NaN | NaN | NaN | 1 | NaN | 0 | 7 | 3 | 2 | 150000 | 1 |
| ID4060 | 1 | HIKKADUWA | 1 | 3.0 | NaN | 1 | 1 | -1 | NaN | 3000.0 | 1 | NaN | NaN | 0 | NaN | NaN | NaN | 5 | NaN | 0 | 4 | 9 | 2 | 50000 | 2 |
| ID4061 | 1 | WATTALA | 1 | 3.0 | NaN | 4 | 1 | -1 | NaN | 680.0 | 2 | NaN | NaN | 0 | NaN | NaN | NaN | 2 | NaN | 0 | 4 | 1 | 4 | 20000 | 2 |
| ID4062 | 1 | ALUTHGAMA | 1 | 3.0 | NaN | 2 | 1 | -1 | NaN | 700.0 | 2 | NaN | NaN | 0 | NaN | NaN | NaN | 4 | NaN | 0 | 4 | 10 | 2 | 30000 | 2 |
| ID4063 | 1 | ALUTHGAMA | 1 | 3.0 | NaN | 5 | 2 | -1 | NaN | 2400.0 | 5 | NaN | NaN | 0 | NaN | NaN | NaN | 2 | NaN | 0 | 3 | 2 | 4 | 100000 | 2 |
Duplicate rows
Most frequently occurring
| no_of_electricity_meters | LECO_csc_area | own_the_house_or_living_on_rent | occupy_renters_boarders | awareness_of_electricity_consumption_of_renters | built_year_of_the_house | type_of_house | floor_which_house_located | no_of_storeys | floor_area | no_of_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | whom_or_how_the_house_was_designed | availability_of_certificate_of_compliance | main_material_used_for_walls_of_the_house | main_material_used_for_roof_of_the_house | any_constructions_or_renovations_in_the_household | highest_level_of_education_of_the_chief_wage_earner | occupation_of_education_of_the_chief_wage_earner | socio_economic_class | total_monthly_expenditure_of_last_month | type_of_electricity_meter | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | NEGOMBO | 1 | 3.0 | NaN | 1 | 1 | -1 | NaN | 600.0 | 2 | NaN | NaN | 0 | NaN | NaN | NaN | 2 | NaN | 0 | 3 | 3 | 4 | 50000 | 1 | 2 |