Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 3951 |
| Missing cells | 2087 |
| Missing cells (%) | 2.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 602.0 KiB |
| Average record size in memory | 156.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 5 |
| Text | 2 |
Dataset
| Description | 부산광역시 상수도사업본부에서 상하수도 요금 계산 및 징수를 위해 운영하는 수용가정보시스템에 사용되는 검침정보 자료입니다.(사업소코드, 동코드, 관리번호, 가구수, 구경, 사용월수, 사용량 등) |
|---|---|
| Author | 부산광역시 상수도사업본부 |
| URL | https://www.data.go.kr/data/15100354/fileData.do |
다량관리년도 has constant value "" | Constant |
사업소명 is highly overall correlated with 사업소코드 and 2 other fields | High correlation |
구명 is highly overall correlated with 사업소코드 and 3 other fields | High correlation |
연번 is highly overall correlated with 구분 | High correlation |
사업소코드 is highly overall correlated with 사업소명 and 1 other fields | High correlation |
구코드 is highly overall correlated with 사업소명 and 1 other fields | High correlation |
동코드 is highly overall correlated with 구명 | High correlation |
가구수 is highly overall correlated with 구경(mm) and 4 other fields | High correlation |
구경(mm) is highly overall correlated with 가구수 and 5 other fields | High correlation |
사용량 is highly overall correlated with 가구수 and 4 other fields | High correlation |
평균사용량 is highly overall correlated with 가구수 and 4 other fields | High correlation |
총사용금액 is highly overall correlated with 가구수 and 4 other fields | High correlation |
월평균사용금액 is highly overall correlated with 가구수 and 4 other fields | High correlation |
상수도업종 is highly overall correlated with 구분 | High correlation |
구분 is highly overall correlated with 연번 and 2 other fields | High correlation |
상수도업종 is highly imbalanced (52.5%) | Imbalance |
가구수 has 2087 (52.8%) missing values | Missing |
연번 has unique values | Unique |
가구수 has 158 (4.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-14 14:26:31.790584 |
|---|---|
| Analysis finished | 2024-03-14 14:26:59.964520 |
| Duration | 28.17 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
연번
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 3951 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1976 |
| Minimum | 1 |
|---|---|
| Maximum | 3951 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 198.5 |
| Q1 | 988.5 |
| median | 1976 |
| Q3 | 2963.5 |
| 95-th percentile | 3753.5 |
| Maximum | 3951 |
| Range | 3950 |
| Interquartile range (IQR) | 1975 |
Descriptive statistics
| Standard deviation | 1140.6998 |
|---|---|
| Coefficient of variation (CV) | 0.57727722 |
| Kurtosis | -1.2 |
| Mean | 1976 |
| Median Absolute Deviation (MAD) | 988 |
| Skewness | 0 |
| Sum | 7807176 |
| Variance | 1301196 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2626 | 1 | < 0.1% |
| 2628 | 1 | < 0.1% |
| 2629 | 1 | < 0.1% |
| 2630 | 1 | < 0.1% |
| 2631 | 1 | < 0.1% |
| 2632 | 1 | < 0.1% |
| 2633 | 1 | < 0.1% |
| 2634 | 1 | < 0.1% |
| 2635 | 1 | < 0.1% |
| Other values (3941) | 3941 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 3951 | 1 | |
| 3950 | 1 | |
| 3949 | 1 | |
| 3948 | 1 | |
| 3947 | 1 | |
| 3946 | 1 | |
| 3945 | 1 | |
| 3944 | 1 | |
| 3943 | 1 | |
| 3942 | 1 |
다량관리년도
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
| 2023 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2023 |
|---|---|
| 2nd row | 2023 |
| 3rd row | 2023 |
| 4th row | 2023 |
| 5th row | 2023 |
Common Values
| Value | Count | Frequency (%) |
| 2023 | 3951 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023 | 3951 |
고객번호
Text
| Distinct | 3079 |
|---|---|
| Distinct (%) | 77.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 23706 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2362 ? |
|---|---|
| Unique (%) | 59.8% |
Sample
| 1st row | *15*08 |
|---|---|
| 2nd row | *51*19 |
| 3rd row | *51*24 |
| 4th row | *51*25 |
| 5th row | *51*77 |
| Value | Count | Frequency (%) |
| 93*61 | 5 | 0.1% |
| 10*00 | 5 | 0.1% |
| 30*38 | 5 | 0.1% |
| 12*02 | 4 | 0.1% |
| 12*24 | 4 | 0.1% |
| 12*30 | 4 | 0.1% |
| 00*92 | 4 | 0.1% |
| 74*68 | 4 | 0.1% |
| 13*59 | 4 | 0.1% |
| 13*56 | 4 | 0.1% |
| Other values (3069) | 3908 |
Most occurring characters
| Value | Count | Frequency (%) |
| * | 7902 | |
| 9 | 1860 | 7.8% |
| 0 | 1854 | 7.8% |
| 1 | 1826 | 7.7% |
| 3 | 1720 | 7.3% |
| 2 | 1675 | 7.1% |
| 8 | 1449 | 6.1% |
| 5 | 1447 | 6.1% |
| 7 | 1433 | 6.0% |
| 4 | 1328 | 5.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 15804 | |
| Other Punctuation | 7902 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 1860 | |
| 0 | 1854 | |
| 1 | 1826 | |
| 3 | 1720 | |
| 2 | 1675 | |
| 8 | 1449 | |
| 5 | 1447 | |
| 7 | 1433 | |
| 4 | 1328 | |
| 6 | 1212 |
Other Punctuation
| Value | Count | Frequency (%) |
| * | 7902 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 23706 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| * | 7902 | |
| 9 | 1860 | 7.8% |
| 0 | 1854 | 7.8% |
| 1 | 1826 | 7.7% |
| 3 | 1720 | 7.3% |
| 2 | 1675 | 7.1% |
| 8 | 1449 | 6.1% |
| 5 | 1447 | 6.1% |
| 7 | 1433 | 6.0% |
| 4 | 1328 | 5.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| * | 7902 | |
| 9 | 1860 | 7.8% |
| 0 | 1854 | 7.8% |
| 1 | 1826 | 7.7% |
| 3 | 1720 | 7.3% |
| 2 | 1675 | 7.1% |
| 8 | 1449 | 6.1% |
| 5 | 1447 | 6.1% |
| 7 | 1433 | 6.0% |
| 4 | 1328 | 5.6% |
사업소코드
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 296.51531 |
| Minimum | 244 |
|---|---|
| Maximum | 312 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 244 |
|---|---|
| 5-th percentile | 244 |
| Q1 | 302 |
| median | 306 |
| Q3 | 308 |
| 95-th percentile | 312 |
| Maximum | 312 |
| Range | 68 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 23.382904 |
|---|---|
| Coefficient of variation (CV) | 0.078859011 |
| Kurtosis | 1.2119535 |
| Mean | 296.51531 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.7649285 |
| Sum | 1171532 |
| Variance | 546.76021 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 244 | 646 | |
| 308 | 507 | |
| 307 | 492 | |
| 309 | 449 | |
| 304 | 447 | |
| 306 | 442 | |
| 311 | 281 | |
| 301 | 233 | 5.9% |
| 312 | 209 | 5.3% |
| 302 | 140 | 3.5% |
| Value | Count | Frequency (%) |
| 244 | 646 | |
| 301 | 233 | 5.9% |
| 302 | 140 | 3.5% |
| 303 | 105 | 2.7% |
| 304 | 447 | |
| 306 | 442 | |
| 307 | 492 | |
| 308 | 507 | |
| 309 | 449 | |
| 311 | 281 |
| Value | Count | Frequency (%) |
| 312 | 209 | |
| 311 | 281 | |
| 309 | 449 | |
| 308 | 507 | |
| 307 | 492 | |
| 306 | 442 | |
| 304 | 447 | |
| 303 | 105 | 2.7% |
| 302 | 140 | 3.5% |
| 301 | 233 |
사업소명
Categorical
HIGH CORRELATION
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
| 동래통합사업소 | |
|---|---|
| 해운대사업소 | |
| 북부사업소 | |
| 사하사업소 | |
| 부산진 사업소 | |
| Other values (6) |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.9954442 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 북부사업소 |
|---|---|
| 2nd row | 해운대사업소 |
| 3rd row | 기장사업소 |
| 4th row | 해운대사업소 |
| 5th row | 동래통합사업소 |
Common Values
| Value | Count | Frequency (%) |
| 동래통합사업소 | 646 | |
| 해운대사업소 | 507 | |
| 북부사업소 | 492 | |
| 사하사업소 | 449 | |
| 부산진 사업소 | 447 | |
| 남부사업소 | 442 | |
| 강서사업소 | 281 | |
| 중동부사업소 | 233 | 5.9% |
| 기장사업소 | 209 | 5.3% |
| 서부 사업소 | 140 | 3.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 동래통합사업소 | 646 | |
| 사업소 | 587 | |
| 해운대사업소 | 507 | |
| 북부사업소 | 492 | |
| 사하사업소 | 449 | |
| 부산진 | 447 | |
| 남부사업소 | 442 | |
| 강서사업소 | 281 | |
| 중동부사업소 | 233 | 5.1% |
| 기장사업소 | 209 | 4.6% |
| Other values (2) | 245 | 5.4% |
구코드
Real number (ℝ)
HIGH CORRELATION
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 358.00304 |
| Minimum | 110 |
|---|---|
| Maximum | 710 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 110 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 260 |
| median | 350 |
| Q3 | 440 |
| 95-th percentile | 710 |
| Maximum | 710 |
| Range | 600 |
| Interquartile range (IQR) | 180 |
Descriptive statistics
| Standard deviation | 136.68345 |
|---|---|
| Coefficient of variation (CV) | 0.38179411 |
| Kurtosis | 0.34750183 |
| Mean | 358.00304 |
| Median Absolute Deviation (MAD) | 90 |
| Skewness | 0.5901255 |
| Sum | 1414470 |
| Variance | 18682.366 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 350 | 507 | |
| 380 | 449 | |
| 230 | 447 | |
| 440 | 281 | 7.1% |
| 260 | 264 | 6.7% |
| 530 | 253 | 6.4% |
| 290 | 252 | 6.4% |
| 320 | 239 | 6.0% |
| 470 | 216 | 5.5% |
| 710 | 209 | 5.3% |
| Other values (6) | 834 |
| Value | Count | Frequency (%) |
| 110 | 92 | 2.3% |
| 140 | 140 | 3.5% |
| 170 | 141 | 3.6% |
| 200 | 105 | 2.7% |
| 230 | 447 | |
| 260 | 264 | |
| 290 | 252 | |
| 320 | 239 | |
| 350 | 507 | |
| 380 | 449 |
| Value | Count | Frequency (%) |
| 710 | 209 | |
| 530 | 253 | |
| 500 | 190 | 4.8% |
| 470 | 216 | |
| 440 | 281 | |
| 410 | 166 | 4.2% |
| 380 | 449 | |
| 350 | 507 | |
| 320 | 239 | |
| 290 | 252 |
구명
Categorical
HIGH CORRELATION
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
| 해운대구 | |
|---|---|
| 사하구 | |
| 부산진구 | |
| 강서구 | |
| 동래구 | |
| Other values (11) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.022779 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 사상구 |
|---|---|
| 2nd row | 해운대구 |
| 3rd row | 기장군 |
| 4th row | 해운대구 |
| 5th row | 연제구 |
Common Values
| Value | Count | Frequency (%) |
| 해운대구 | 507 | |
| 사하구 | 449 | |
| 부산진구 | 447 | |
| 강서구 | 281 | 7.1% |
| 동래구 | 264 | 6.7% |
| 사상구 | 253 | 6.4% |
| 남구 | 252 | 6.4% |
| 북구 | 239 | 6.0% |
| 연제구 | 216 | 5.5% |
| 기장군 | 209 | 5.3% |
| Other values (6) | 834 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 해운대구 | 507 | |
| 사하구 | 449 | |
| 부산진구 | 447 | |
| 강서구 | 281 | 7.1% |
| 동래구 | 264 | 6.7% |
| 사상구 | 253 | 6.4% |
| 남구 | 252 | 6.4% |
| 북구 | 239 | 6.0% |
| 연제구 | 216 | 5.5% |
| 기장군 | 209 | 5.3% |
| Other values (6) | 834 |
동코드
Real number (ℝ)
HIGH CORRELATION
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 582.19894 |
| Minimum | 250 |
|---|---|
| Maximum | 800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 250 |
|---|---|
| 5-th percentile | 310 |
| Q1 | 530 |
| median | 572 |
| Q3 | 650 |
| 95-th percentile | 760 |
| Maximum | 800 |
| Range | 550 |
| Interquartile range (IQR) | 120 |
Descriptive statistics
| Standard deviation | 104.69284 |
|---|---|
| Coefficient of variation (CV) | 0.17982314 |
| Kurtosis | 2.7895852 |
| Mean | 582.19894 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | -1.0087686 |
| Sum | 2300268 |
| Variance | 10960.591 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 530 | 277 | 7.0% |
| 560 | 265 | 6.7% |
| 510 | 250 | 6.3% |
| 520 | 203 | 5.1% |
| 620 | 169 | 4.3% |
| 680 | 161 | 4.1% |
| 540 | 152 | 3.8% |
| 610 | 147 | 3.7% |
| 550 | 146 | 3.7% |
| 660 | 141 | 3.6% |
| Other values (52) | 2040 |
| Value | Count | Frequency (%) |
| 250 | 66 | 1.7% |
| 253 | 30 | 0.8% |
| 256 | 88 | 2.2% |
| 310 | 19 | 0.5% |
| 330 | 6 | 0.2% |
| 510 | 250 | |
| 520 | 203 | |
| 521 | 9 | 0.2% |
| 525 | 46 | 1.2% |
| 530 | 277 |
| Value | Count | Frequency (%) |
| 800 | 36 | |
| 790 | 20 | 0.5% |
| 780 | 30 | 0.8% |
| 770 | 81 | |
| 762 | 8 | 0.2% |
| 761 | 9 | 0.2% |
| 760 | 33 | |
| 750 | 35 | |
| 740 | 45 | |
| 730 | 49 |
동명
Text
| Distinct | 211 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.6529992 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14433 |
|---|---|
| Distinct characters | 107 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 주례1동 |
|---|---|
| 2nd row | 우2동 |
| 3rd row | 장안읍 |
| 4th row | 송정동 |
| 5th row | 연산1동 |
| Value | Count | Frequency (%) |
| 녹산동 | 160 | 4.0% |
| 정관읍 | 88 | 2.2% |
| 명지동 | 86 | 2.2% |
| 중1동 | 80 | 2.0% |
| 우2동 | 76 | 1.9% |
| 기장읍 | 66 | 1.7% |
| 신평2동 | 64 | 1.6% |
| 우1동 | 58 | 1.5% |
| 부전2동 | 58 | 1.5% |
| 괘법동 | 57 | 1.4% |
| Other values (201) | 3158 |
Most occurring characters
| Value | Count | Frequency (%) |
| 동 | 3812 | |
| 1 | 1183 | 8.2% |
| 2 | 933 | 6.5% |
| 3 | 483 | 3.3% |
| 산 | 327 | 2.3% |
| 장 | 289 | 2.0% |
| 천 | 274 | 1.9% |
| 연 | 265 | 1.8% |
| 대 | 239 | 1.7% |
| 전 | 232 | 1.6% |
| Other values (97) | 6396 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 11565 | |
| Decimal Number | 2868 | 19.9% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 동 | 3812 | |
| 산 | 327 | 2.8% |
| 장 | 289 | 2.5% |
| 천 | 274 | 2.4% |
| 연 | 265 | 2.3% |
| 대 | 239 | 2.1% |
| 전 | 232 | 2.0% |
| 읍 | 221 | 1.9% |
| 부 | 221 | 1.9% |
| 명 | 220 | 1.9% |
| Other values (89) | 5465 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1183 | |
| 2 | 933 | |
| 3 | 483 | |
| 4 | 136 | 4.7% |
| 5 | 74 | 2.6% |
| 9 | 29 | 1.0% |
| 6 | 25 | 0.9% |
| 8 | 5 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 11565 | |
| Common | 2868 | 19.9% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 동 | 3812 | |
| 산 | 327 | 2.8% |
| 장 | 289 | 2.5% |
| 천 | 274 | 2.4% |
| 연 | 265 | 2.3% |
| 대 | 239 | 2.1% |
| 전 | 232 | 2.0% |
| 읍 | 221 | 1.9% |
| 부 | 221 | 1.9% |
| 명 | 220 | 1.9% |
| Other values (89) | 5465 |
Common
| Value | Count | Frequency (%) |
| 1 | 1183 | |
| 2 | 933 | |
| 3 | 483 | |
| 4 | 136 | 4.7% |
| 5 | 74 | 2.6% |
| 9 | 29 | 1.0% |
| 6 | 25 | 0.9% |
| 8 | 5 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 11565 | |
| ASCII | 2868 | 19.9% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 동 | 3812 | |
| 산 | 327 | 2.8% |
| 장 | 289 | 2.5% |
| 천 | 274 | 2.4% |
| 연 | 265 | 2.3% |
| 대 | 239 | 2.1% |
| 전 | 232 | 2.0% |
| 읍 | 221 | 1.9% |
| 부 | 221 | 1.9% |
| 명 | 220 | 1.9% |
| Other values (89) | 5465 |
ASCII
| Value | Count | Frequency (%) |
| 1 | 1183 | |
| 2 | 933 | |
| 3 | 483 | |
| 4 | 136 | 4.7% |
| 5 | 74 | 2.6% |
| 9 | 29 | 1.0% |
| 6 | 25 | 0.9% |
| 8 | 5 | 0.2% |
상수도업종
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
| 일반용 | |
|---|---|
| 가정용 | |
| 욕탕용 | 205 |
| 공업용수 | 55 |
| 목욕장용(온천) | 5 |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.0222728 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 가정용 |
|---|---|
| 2nd row | 일반용 |
| 3rd row | 일반용 |
| 4th row | 가정용 |
| 5th row | 가정용 |
Common Values
| Value | Count | Frequency (%) |
| 일반용 | 2620 | |
| 가정용 | 1064 | |
| 욕탕용 | 205 | 5.2% |
| 공업용수 | 55 | 1.4% |
| 목욕장용(온천) | 5 | 0.1% |
| 영업용(온천) | 2 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 일반용 | 2620 | |
| 가정용 | 1064 | |
| 욕탕용 | 205 | 5.2% |
| 공업용수 | 55 | 1.4% |
| 목욕장용(온천 | 5 | 0.1% |
| 영업용(온천 | 2 | 0.1% |
가구수
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 799 |
|---|---|
| Distinct (%) | 42.9% |
| Missing | 2087 |
| Missing (%) | 52.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 408.94099 |
| Minimum | 0 |
|---|---|
| Maximum | 5235 |
| Zeros | 158 |
| Zeros (%) | 4.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 70 |
| median | 267.5 |
| Q3 | 552.25 |
| 95-th percentile | 1319.55 |
| Maximum | 5235 |
| Range | 5235 |
| Interquartile range (IQR) | 482.25 |
Descriptive statistics
| Standard deviation | 471.37284 |
|---|---|
| Coefficient of variation (CV) | 1.1526672 |
| Kurtosis | 10.697861 |
| Mean | 408.94099 |
| Median Absolute Deviation (MAD) | 215.5 |
| Skewness | 2.4577164 |
| Sum | 762266 |
| Variance | 222192.36 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 158 | 4.0% |
| 1 | 17 | 0.4% |
| 49 | 15 | 0.4% |
| 48 | 14 | 0.4% |
| 70 | 14 | 0.4% |
| 50 | 13 | 0.3% |
| 39 | 13 | 0.3% |
| 67 | 11 | 0.3% |
| 45 | 11 | 0.3% |
| 69 | 10 | 0.3% |
| Other values (789) | 1588 | |
| (Missing) | 2087 |
| Value | Count | Frequency (%) |
| 0 | 158 | |
| 1 | 17 | 0.4% |
| 2 | 3 | 0.1% |
| 3 | 3 | 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 2 | 0.1% |
| 10 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 5235 | 1 | |
| 3392 | 1 | |
| 3060 | 1 | |
| 3000 | 1 | |
| 2882 | 1 | |
| 2863 | 1 | |
| 2752 | 1 | |
| 2716 | 1 | |
| 2623 | 1 | |
| 2544 | 1 |
구경(mm)
Real number (ℝ)
HIGH CORRELATION
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.535561 |
| Minimum | 15 |
|---|---|
| Maximum | 300 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 40 |
| median | 50 |
| Q3 | 100 |
| 95-th percentile | 200 |
| Maximum | 300 |
| Range | 285 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 54.717907 |
|---|---|
| Coefficient of variation (CV) | 0.69672778 |
| Kurtosis | 2.1908602 |
| Mean | 78.535561 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.5145298 |
| Sum | 310294 |
| Variance | 2994.0493 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 50 | 903 | |
| 40 | 680 | |
| 80 | 594 | |
| 100 | 508 | |
| 150 | 425 | |
| 25 | 297 | 7.5% |
| 200 | 190 | 4.8% |
| 32 | 117 | 3.0% |
| 20 | 100 | 2.5% |
| 250 | 60 | 1.5% |
| Other values (2) | 77 | 1.9% |
| Value | Count | Frequency (%) |
| 15 | 47 | 1.2% |
| 20 | 100 | 2.5% |
| 25 | 297 | 7.5% |
| 32 | 117 | 3.0% |
| 40 | 680 | |
| 50 | 903 | |
| 80 | 594 | |
| 100 | 508 | |
| 150 | 425 | |
| 200 | 190 | 4.8% |
| Value | Count | Frequency (%) |
| 300 | 30 | 0.8% |
| 250 | 60 | 1.5% |
| 200 | 190 | 4.8% |
| 150 | 425 | |
| 100 | 508 | |
| 80 | 594 | |
| 50 | 903 | |
| 40 | 680 | |
| 32 | 117 | 3.0% |
| 25 | 297 | 7.5% |
사용월수
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.972918 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.47149164 |
|---|---|
| Coefficient of variation (CV) | 0.039379843 |
| Kurtosis | 355.78122 |
| Mean | 11.972918 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -17.81883 |
| Sum | 47305 |
| Variance | 0.22230437 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 12 | 3910 | |
| 13 | 16 | 0.4% |
| 9 | 8 | 0.2% |
| 10 | 5 | 0.1% |
| 2 | 3 | 0.1% |
| 8 | 2 | 0.1% |
| 5 | 2 | 0.1% |
| 1 | 2 | 0.1% |
| 4 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2 | 0.1% |
| 2 | 3 | 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2 | 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 2 | 0.1% |
| 9 | 8 | 0.2% |
| 10 | 5 | 0.1% |
| 11 | 1 | < 0.1% |
| 12 | 3910 |
| Value | Count | Frequency (%) |
| 13 | 16 | 0.4% |
| 12 | 3910 | |
| 11 | 1 | < 0.1% |
| 10 | 5 | 0.1% |
| 9 | 8 | 0.2% |
| 8 | 2 | 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 2 | 0.1% |
| 4 | 1 | < 0.1% |
| 2 | 3 | 0.1% |
사용량
Real number (ℝ)
HIGH CORRELATION
| Distinct | 3659 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52659.571 |
| Minimum | 621 |
|---|---|
| Maximum | 4273935 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 621 |
|---|---|
| 5-th percentile | 6342.5 |
| Q1 | 8284 |
| median | 15583 |
| Q3 | 56466.5 |
| 95-th percentile | 199229 |
| Maximum | 4273935 |
| Range | 4273314 |
| Interquartile range (IQR) | 48182.5 |
Descriptive statistics
| Standard deviation | 124491.52 |
|---|---|
| Coefficient of variation (CV) | 2.3640816 |
| Kurtosis | 455.44007 |
| Mean | 52659.571 |
| Median Absolute Deviation (MAD) | 8911 |
| Skewness | 16.723483 |
| Sum | 2.0805796 × 108 |
| Variance | 1.549814 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7533 | 5 | 0.1% |
| 6976 | 4 | 0.1% |
| 6085 | 4 | 0.1% |
| 7029 | 4 | 0.1% |
| 6614 | 4 | 0.1% |
| 6309 | 3 | 0.1% |
| 7586 | 3 | 0.1% |
| 6447 | 3 | 0.1% |
| 7248 | 3 | 0.1% |
| 7431 | 3 | 0.1% |
| Other values (3649) | 3915 |
| Value | Count | Frequency (%) |
| 621 | 1 | |
| 1234 | 1 | |
| 2231 | 1 | |
| 3940 | 1 | |
| 4033 | 1 | |
| 5819 | 1 | |
| 5999 | 1 | |
| 6012 | 1 | |
| 6014 | 1 | |
| 6022 | 1 |
| Value | Count | Frequency (%) |
| 4273935 | 1 | |
| 2790040 | 1 | |
| 2704090 | 1 | |
| 1326312 | 1 | |
| 1252254 | 1 | |
| 1237732 | 1 | |
| 1179349 | 1 | |
| 854348 | 1 | |
| 778622 | 1 | |
| 721094 | 1 |
평균사용량
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2444 |
|---|---|
| Distinct (%) | 61.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4395.7628 |
| Minimum | 501 |
|---|---|
| Maximum | 356161 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 501 |
|---|---|
| 5-th percentile | 530 |
| Q1 | 690 |
| median | 1307 |
| Q3 | 4717.5 |
| 95-th percentile | 16602 |
| Maximum | 356161 |
| Range | 355660 |
| Interquartile range (IQR) | 4027.5 |
Descriptive statistics
| Standard deviation | 10374.213 |
|---|---|
| Coefficient of variation (CV) | 2.3600484 |
| Kurtosis | 455.40329 |
| Mean | 4395.7628 |
| Median Absolute Deviation (MAD) | 749 |
| Skewness | 16.721593 |
| Sum | 17367659 |
| Variance | 1.076243 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 15 | 0.4% |
| 520 | 15 | 0.4% |
| 627 | 14 | 0.4% |
| 659 | 12 | 0.3% |
| 530 | 11 | 0.3% |
| 551 | 10 | 0.3% |
| 503 | 10 | 0.3% |
| 593 | 10 | 0.3% |
| 589 | 10 | 0.3% |
| 522 | 10 | 0.3% |
| Other values (2434) | 3834 |
| Value | Count | Frequency (%) |
| 501 | 3 | 0.1% |
| 502 | 7 | |
| 503 | 10 | |
| 504 | 9 | |
| 505 | 6 | |
| 506 | 3 | 0.1% |
| 507 | 7 | |
| 508 | 9 | |
| 509 | 4 | 0.1% |
| 510 | 7 |
| Value | Count | Frequency (%) |
| 356161 | 1 | |
| 232503 | 1 | |
| 225340 | 1 | |
| 110526 | 1 | |
| 104354 | 1 | |
| 103144 | 1 | |
| 98279 | 1 | |
| 71195 | 1 | |
| 64885 | 1 | |
| 60091 | 1 |
총사용금액
Real number (ℝ)
HIGH CORRELATION
| Distinct | 3883 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41845855 |
| Minimum | 0 |
|---|---|
| Maximum | 3.5245134 × 109 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5856570 |
| Q1 | 9432305 |
| median | 17087120 |
| Q3 | 45327130 |
| 95-th percentile | 1.4365839 × 108 |
| Maximum | 3.5245134 × 109 |
| Range | 3.5245134 × 109 |
| Interquartile range (IQR) | 35894825 |
Descriptive statistics
| Standard deviation | 89298426 |
|---|---|
| Coefficient of variation (CV) | 2.133985 |
| Kurtosis | 645.74715 |
| Mean | 41845855 |
| Median Absolute Deviation (MAD) | 9584720 |
| Skewness | 19.408973 |
| Sum | 1.6533297 × 1011 |
| Variance | 7.9742088 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9801380 | 3 | 0.1% |
| 8065200 | 3 | 0.1% |
| 8535220 | 2 | 0.1% |
| 8587060 | 2 | 0.1% |
| 13988400 | 2 | 0.1% |
| 9351840 | 2 | 0.1% |
| 11164630 | 2 | 0.1% |
| 7736400 | 2 | 0.1% |
| 7740000 | 2 | 0.1% |
| 9060570 | 2 | 0.1% |
| Other values (3873) | 3929 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 195840 | 1 | |
| 801930 | 1 | |
| 1593220 | 1 | |
| 2934000 | 1 | |
| 2943230 | 1 | |
| 3329340 | 1 | |
| 3890160 | 1 | |
| 3924180 | 1 | |
| 3957840 | 1 |
| Value | Count | Frequency (%) |
| 3524513450 | 1 | |
| 1665209820 | 1 | |
| 1645895560 | 1 | |
| 904921970 | 1 | |
| 864140120 | 1 | |
| 641090250 | 1 | |
| 583526140 | 1 | |
| 577615260 | 1 | |
| 536828160 | 1 | |
| 534955870 | 1 |
월평균사용금액
Real number (ℝ)
HIGH CORRELATION
| Distinct | 3862 |
|---|---|
| Distinct (%) | 97.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3492691.4 |
| Minimum | 0 |
|---|---|
| Maximum | 2.9370945 × 108 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 34.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 491585 |
| Q1 | 788600 |
| median | 1428580 |
| Q3 | 3778750 |
| 95-th percentile | 11971530 |
| Maximum | 2.9370945 × 108 |
| Range | 2.9370945 × 108 |
| Interquartile range (IQR) | 2990150 |
Descriptive statistics
| Standard deviation | 7440157.2 |
|---|---|
| Coefficient of variation (CV) | 2.1302074 |
| Kurtosis | 646.16924 |
| Mean | 3492691.4 |
| Median Absolute Deviation (MAD) | 803130 |
| Skewness | 19.417275 |
| Sum | 1.3799624 × 1010 |
| Variance | 5.5355939 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 672100 | 3 | 0.1% |
| 816780 | 3 | 0.1% |
| 693200 | 3 | 0.1% |
| 852690 | 2 | 0.1% |
| 2211500 | 2 | 0.1% |
| 692530 | 2 | 0.1% |
| 652300 | 2 | 0.1% |
| 677130 | 2 | 0.1% |
| 626700 | 2 | 0.1% |
| 644700 | 2 | 0.1% |
| Other values (3852) | 3928 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 16320 | 1 | |
| 244500 | 1 | |
| 277440 | 1 | |
| 324180 | 1 | |
| 327010 | 1 | |
| 329820 | 1 | |
| 331140 | 1 | |
| 340260 | 1 | |
| 342300 | 1 |
| Value | Count | Frequency (%) |
| 293709450 | 1 | |
| 138767480 | 1 | |
| 137157960 | 1 | |
| 75410160 | 1 | |
| 72011670 | 1 | |
| 53424180 | 1 | |
| 48627170 | 1 | |
| 48134600 | 1 | |
| 44735680 | 1 | |
| 44579650 | 1 |
구분
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.0 KiB |
| 다량 | |
|---|---|
| 비다량 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.428246 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 다량 |
|---|---|
| 2nd row | 다량 |
| 3rd row | 다량 |
| 4th row | 다량 |
| 5th row | 다량 |
Common Values
| Value | Count | Frequency (%) |
| 다량 | 2259 | |
| 비다량 | 1692 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 다량 | 2259 | |
| 비다량 | 1692 |
| 연번 | 사업소코드 | 사업소명 | 구코드 | 구명 | 동코드 | 상수도업종 | 가구수 | 구경(mm) | 사용월수 | 사용량 | 평균사용량 | 총사용금액 | 월평균사용금액 | 구분 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 연번 | 1.000 | 0.312 | 0.470 | 0.457 | 0.570 | 0.256 | 0.301 | 0.159 | 0.320 | 0.076 | 0.000 | 0.000 | 0.000 | 0.000 | 0.734 |
| 사업소코드 | 0.312 | 1.000 | 1.000 | 1.000 | 1.000 | 0.444 | 0.168 | 0.191 | 0.087 | 0.000 | 0.053 | 0.051 | 0.031 | 0.031 | 0.107 |
| 사업소명 | 0.470 | 1.000 | 1.000 | 0.956 | 1.000 | 0.744 | 0.265 | 0.200 | 0.159 | 0.082 | 0.063 | 0.062 | 0.000 | 0.000 | 0.104 |
| 구코드 | 0.457 | 1.000 | 0.956 | 1.000 | 1.000 | 0.861 | 0.204 | 0.196 | 0.131 | 0.072 | 0.028 | 0.026 | 0.010 | 0.010 | 0.119 |
| 구명 | 0.570 | 1.000 | 1.000 | 1.000 | 1.000 | 0.894 | 0.288 | 0.276 | 0.189 | 0.061 | 0.019 | 0.000 | 0.000 | 0.000 | 0.125 |
| 동코드 | 0.256 | 0.444 | 0.744 | 0.861 | 0.894 | 1.000 | 0.158 | 0.162 | 0.080 | 0.130 | 0.000 | 0.000 | 0.000 | 0.000 | 0.065 |
| 상수도업종 | 0.301 | 0.168 | 0.265 | 0.204 | 0.288 | 0.158 | 1.000 | 0.566 | 0.520 | 0.000 | 0.337 | 0.341 | 0.000 | 0.000 | 0.739 |
| 가구수 | 0.159 | 0.191 | 0.200 | 0.196 | 0.276 | 0.162 | 0.566 | 1.000 | 0.591 | 0.035 | 0.955 | 0.959 | 0.880 | 0.880 | 0.478 |
| 구경(mm) | 0.320 | 0.087 | 0.159 | 0.131 | 0.189 | 0.080 | 0.520 | 0.591 | 1.000 | 0.000 | 0.336 | 0.338 | 0.316 | 0.316 | 0.602 |
| 사용월수 | 0.076 | 0.000 | 0.082 | 0.072 | 0.061 | 0.130 | 0.000 | 0.035 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 사용량 | 0.000 | 0.053 | 0.063 | 0.028 | 0.019 | 0.000 | 0.337 | 0.955 | 0.336 | 0.000 | 1.000 | 1.000 | 0.767 | 0.767 | 0.089 |
| 평균사용량 | 0.000 | 0.051 | 0.062 | 0.026 | 0.000 | 0.000 | 0.341 | 0.959 | 0.338 | 0.000 | 1.000 | 1.000 | 0.769 | 0.769 | 0.087 |
| 총사용금액 | 0.000 | 0.031 | 0.000 | 0.010 | 0.000 | 0.000 | 0.000 | 0.880 | 0.316 | 0.000 | 0.767 | 0.769 | 1.000 | 1.000 | 0.050 |
| 월평균사용금액 | 0.000 | 0.031 | 0.000 | 0.010 | 0.000 | 0.000 | 0.000 | 0.880 | 0.316 | 0.000 | 0.767 | 0.769 | 1.000 | 1.000 | 0.050 |
| 구분 | 0.734 | 0.107 | 0.104 | 0.119 | 0.125 | 0.065 | 0.739 | 0.478 | 0.602 | 0.000 | 0.089 | 0.087 | 0.050 | 0.050 | 1.000 |
| 구분 | 사업소명 | 구명 | 상수도업종 | |
|---|---|---|---|---|
| 구분 | 1.000 | 0.100 | 0.098 | 0.548 |
| 사업소명 | 0.100 | 1.000 | 0.999 | 0.139 |
| 구명 | 0.098 | 0.999 | 1.000 | 0.142 |
| 상수도업종 | 0.548 | 0.139 | 0.142 | 1.000 |
| 연번 | 사업소코드 | 구코드 | 동코드 | 가구수 | 구경(mm) | 사용월수 | 사용량 | 평균사용량 | 총사용금액 | 월평균사용금액 | 사업소명 | 구명 | 상수도업종 | 구분 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 연번 | 1.000 | 0.000 | 0.203 | 0.077 | -0.278 | -0.324 | -0.014 | -0.427 | -0.427 | -0.395 | -0.395 | 0.221 | 0.264 | 0.163 | 0.575 |
| 사업소코드 | 0.000 | 1.000 | 0.492 | -0.387 | 0.190 | 0.032 | -0.031 | 0.061 | 0.063 | 0.082 | 0.084 | 0.999 | 0.998 | 0.097 | 0.061 |
| 구코드 | 0.203 | 0.492 | 1.000 | 0.037 | 0.140 | -0.004 | -0.015 | 0.044 | 0.046 | 0.057 | 0.059 | 0.870 | 0.999 | 0.114 | 0.089 |
| 동코드 | 0.077 | -0.387 | 0.037 | 1.000 | -0.034 | 0.018 | 0.014 | 0.020 | 0.019 | -0.002 | -0.003 | 0.474 | 0.547 | 0.088 | 0.047 |
| 가구수 | -0.278 | 0.190 | 0.140 | -0.034 | 1.000 | 0.826 | -0.056 | 0.924 | 0.926 | 0.854 | 0.856 | 0.095 | 0.099 | 0.281 | 0.359 |
| 구경(mm) | -0.324 | 0.032 | -0.004 | 0.018 | 0.826 | 1.000 | -0.008 | 0.774 | 0.774 | 0.721 | 0.723 | 0.079 | 0.087 | 0.342 | 0.648 |
| 사용월수 | -0.014 | -0.031 | -0.015 | 0.014 | -0.056 | -0.008 | 1.000 | 0.031 | -0.010 | 0.022 | -0.024 | 0.037 | 0.025 | 0.000 | 0.000 |
| 사용량 | -0.427 | 0.061 | 0.044 | 0.020 | 0.924 | 0.774 | 0.031 | 1.000 | 0.998 | 0.938 | 0.936 | 0.032 | 0.009 | 0.128 | 0.064 |
| 평균사용량 | -0.427 | 0.063 | 0.046 | 0.019 | 0.926 | 0.774 | -0.010 | 0.998 | 1.000 | 0.936 | 0.939 | 0.031 | 0.000 | 0.129 | 0.062 |
| 총사용금액 | -0.395 | 0.082 | 0.057 | -0.002 | 0.854 | 0.721 | 0.022 | 0.938 | 0.936 | 1.000 | 0.997 | 0.000 | 0.000 | 0.000 | 0.061 |
| 월평균사용금액 | -0.395 | 0.084 | 0.059 | -0.003 | 0.856 | 0.723 | -0.024 | 0.936 | 0.939 | 0.997 | 1.000 | 0.000 | 0.000 | 0.000 | 0.061 |
| 사업소명 | 0.221 | 0.999 | 0.870 | 0.474 | 0.095 | 0.079 | 0.037 | 0.032 | 0.031 | 0.000 | 0.000 | 1.000 | 0.999 | 0.139 | 0.100 |
| 구명 | 0.264 | 0.998 | 0.999 | 0.547 | 0.099 | 0.087 | 0.025 | 0.009 | 0.000 | 0.000 | 0.000 | 0.999 | 1.000 | 0.142 | 0.098 |
| 상수도업종 | 0.163 | 0.097 | 0.114 | 0.088 | 0.281 | 0.342 | 0.000 | 0.128 | 0.129 | 0.000 | 0.000 | 0.139 | 0.142 | 1.000 | 0.548 |
| 구분 | 0.575 | 0.061 | 0.089 | 0.047 | 0.359 | 0.648 | 0.000 | 0.064 | 0.062 | 0.061 | 0.061 | 0.100 | 0.098 | 0.548 | 1.000 |
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.
| 연번 | 다량관리년도 | 고객번호 | 사업소코드 | 사업소명 | 구코드 | 구명 | 동코드 | 동명 | 상수도업종 | 가구수 | 구경(mm) | 사용월수 | 사용량 | 평균사용량 | 총사용금액 | 월평균사용금액 | 구분 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2023 | *15*08 | 307 | 북부사업소 | 530 | 사상구 | 650 | 주례1동 | 가정용 | 493 | 150 | 12 | 97624 | 8135 | 71509920 | 5959160 | 다량 |
| 1 | 2 | 2023 | *51*19 | 308 | 해운대사업소 | 350 | 해운대구 | 520 | 우2동 | 일반용 | <NA> | 50 | 12 | 17845 | 1487 | 23445850 | 1953820 | 다량 |
| 2 | 3 | 2023 | *51*24 | 312 | 기장사업소 | 710 | 기장군 | 253 | 장안읍 | 일반용 | <NA> | 100 | 12 | 87687 | 7307 | 116335710 | 9694640 | 다량 |
| 3 | 4 | 2023 | *51*25 | 308 | 해운대사업소 | 350 | 해운대구 | 560 | 송정동 | 가정용 | 889 | 150 | 12 | 142572 | 11881 | 85422960 | 7118580 | 다량 |
| 4 | 5 | 2023 | *51*77 | 244 | 동래통합사업소 | 470 | 연제구 | 650 | 연산1동 | 가정용 | 1598 | 200 | 12 | 323546 | 26962 | 236547480 | 19712290 | 다량 |
| 5 | 6 | 2023 | *51*95 | 311 | 강서사업소 | 440 | 강서구 | 560 | 녹산동 | 일반용 | <NA> | 80 | 12 | 98160 | 8180 | 130264800 | 10855400 | 다량 |
| 6 | 7 | 2023 | *51*06 | 304 | 부산진 사업소 | 230 | 부산진구 | 530 | 범전동 | 일반용 | 0 | 200 | 12 | 69323 | 5776 | 91911590 | 7659290 | 다량 |
| 7 | 8 | 2023 | *51*28 | 304 | 부산진 사업소 | 230 | 부산진구 | 680 | 당감2동 | 일반용 | <NA> | 80 | 12 | 79796 | 6649 | 105840680 | 8820050 | 다량 |
| 8 | 9 | 2023 | *51*77 | 244 | 동래통합사업소 | 470 | 연제구 | 660 | 연산2동 | 일반용 | <NA> | 80 | 12 | 12499 | 1041 | 16335640 | 1361300 | 다량 |
| 9 | 10 | 2023 | *51*78 | 307 | 북부사업소 | 320 | 북구 | 543 | 화명3동 | 일반용 | <NA> | 50 | 12 | 17252 | 1437 | 22657160 | 1888090 | 다량 |
| 연번 | 다량관리년도 | 고객번호 | 사업소코드 | 사업소명 | 구코드 | 구명 | 동코드 | 동명 | 상수도업종 | 가구수 | 구경(mm) | 사용월수 | 사용량 | 평균사용량 | 총사용금액 | 월평균사용금액 | 구분 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3941 | 3942 | 2023 | *32*04 | 244 | 동래통합사업소 | 260 | 동래구 | 570 | 온천3동 | 일반용 | <NA> | 50 | 12 | 6342 | 528 | 7610400 | 634200 | 비다량 |
| 3942 | 3943 | 2023 | *32*13 | 244 | 동래통합사업소 | 260 | 동래구 | 570 | 온천3동 | 일반용 | 0 | 40 | 12 | 11438 | 953 | 14924540 | 1243710 | 비다량 |
| 3943 | 3944 | 2023 | *33*27 | 244 | 동래통합사업소 | 260 | 동래구 | 570 | 온천3동 | 일반용 | 39 | 32 | 12 | 6618 | 551 | 4470720 | 372560 | 비다량 |
| 3944 | 3945 | 2023 | *33*36 | 244 | 동래통합사업소 | 260 | 동래구 | 570 | 온천3동 | 일반용 | <NA> | 20 | 12 | 8529 | 710 | 11055570 | 921290 | 비다량 |
| 3945 | 3946 | 2023 | *33*38 | 244 | 동래통합사업소 | 260 | 동래구 | 570 | 온천3동 | 일반용 | 54 | 40 | 12 | 9007 | 750 | 6145740 | 512140 | 비다량 |
| 3946 | 3947 | 2023 | *34*22 | 244 | 동래통합사업소 | 260 | 동래구 | 580 | 사직1동 | 일반용 | <NA> | 50 | 12 | 9895 | 824 | 12872320 | 1072690 | 비다량 |
| 3947 | 3948 | 2023 | *34*44 | 244 | 동래통합사업소 | 260 | 동래구 | 580 | 사직1동 | 일반용 | 45 | 15 | 12 | 7404 | 617 | 5371860 | 447650 | 비다량 |
| 3948 | 3949 | 2023 | *34*55 | 244 | 동래통합사업소 | 260 | 동래구 | 580 | 사직1동 | 일반용 | <NA> | 50 | 12 | 11024 | 918 | 14373920 | 1197820 | 비다량 |
| 3949 | 3950 | 2023 | *34*41 | 244 | 동래통합사업소 | 260 | 동래구 | 580 | 사직1동 | 일반용 | 64 | 40 | 12 | 11100 | 925 | 8284380 | 690360 | 비다량 |
| 3950 | 3951 | 2023 | *35*29 | 309 | 사하사업소 | 380 | 사하구 | 572 | 신평2동 | 공업용수 | <NA> | 100 | 12 | 58198 | 4849 | 8729700 | 727470 | 다량 |