Dataset statistics
| Number of variables | 7 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 693.4 KiB |
| Average record size in memory | 71.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Categorical | 2 |
Dataset
| Description | 파일 다운로드 |
|---|---|
| Author | 서울특별시 |
| URL | https://data.seoul.go.kr/dataList/OA-15526/S/1/datasetView.do |
국가 기준초과 구분 has constant value "" | Constant |
지자체 기준초과 구분 has constant value "" | Constant |
측정항목 is highly overall correlated with 평균값 | High correlation |
평균값 is highly overall correlated with 측정항목 | High correlation |
측정기 상태 has 9802 (98.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-04 03:58:04.621863 |
|---|---|
| Analysis finished | 2024-05-04 03:58:16.926423 |
| Duration | 12.3 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
측정일시
Real number (ℝ)
| Distinct | 446 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.011011 × 109 |
| Minimum | 2.0110101 × 109 |
|---|---|
| Maximum | 2.0110119 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 2.0110101 × 109 |
|---|---|
| 5-th percentile | 2.0110101 × 109 |
| Q1 | 2.0110105 × 109 |
| median | 2.011011 × 109 |
| Q3 | 2.0110114 × 109 |
| 95-th percentile | 2.0110118 × 109 |
| Maximum | 2.0110119 × 109 |
| Range | 1813 |
| Interquartile range (IQR) | 907.25 |
Descriptive statistics
| Standard deviation | 534.4345 |
|---|---|
| Coefficient of variation (CV) | 2.6575414 × 10-7 |
| Kurtosis | -1.2025629 |
| Mean | 2.011011 × 109 |
| Median Absolute Deviation (MAD) | 492 |
| Skewness | -0.0050054639 |
| Sum | 2.011011 × 1013 |
| Variance | 285620.23 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2011010414 | 34 | 0.3% |
| 2011011022 | 34 | 0.3% |
| 2011011005 | 34 | 0.3% |
| 2011010500 | 34 | 0.3% |
| 2011011305 | 34 | 0.3% |
| 2011010513 | 34 | 0.3% |
| 2011011211 | 33 | 0.3% |
| 2011011615 | 32 | 0.3% |
| 2011010822 | 32 | 0.3% |
| 2011011909 | 32 | 0.3% |
| Other values (436) | 9667 |
| Value | Count | Frequency (%) |
| 2011010100 | 24 | |
| 2011010101 | 23 | |
| 2011010102 | 18 | |
| 2011010103 | 22 | |
| 2011010104 | 27 | |
| 2011010105 | 27 | |
| 2011010106 | 25 | |
| 2011010107 | 23 | |
| 2011010108 | 31 | |
| 2011010109 | 19 |
| Value | Count | Frequency (%) |
| 2011011913 | 14 | |
| 2011011912 | 21 | |
| 2011011911 | 25 | |
| 2011011910 | 15 | |
| 2011011909 | 32 | |
| 2011011908 | 19 | |
| 2011011907 | 23 | |
| 2011011906 | 21 | |
| 2011011905 | 22 | |
| 2011011904 | 27 |
측정소 코드
Real number (ℝ)
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.0572 |
| Minimum | 101 |
|---|---|
| Maximum | 125 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 102 |
| Q1 | 107 |
| median | 113 |
| Q3 | 119 |
| 95-th percentile | 124 |
| Maximum | 125 |
| Range | 24 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.1562315 |
|---|---|
| Coefficient of variation (CV) | 0.063297441 |
| Kurtosis | -1.1801404 |
| Mean | 113.0572 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.012683888 |
| Sum | 1130572 |
| Variance | 51.211649 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 114 | 434 | 4.3% |
| 116 | 434 | 4.3% |
| 109 | 427 | 4.3% |
| 110 | 426 | 4.3% |
| 108 | 414 | 4.1% |
| 117 | 412 | 4.1% |
| 101 | 410 | 4.1% |
| 123 | 409 | 4.1% |
| 113 | 409 | 4.1% |
| 121 | 405 | 4.0% |
| Other values (15) | 5820 |
| Value | Count | Frequency (%) |
| 101 | 410 | |
| 102 | 367 | |
| 103 | 383 | |
| 104 | 398 | |
| 105 | 370 | |
| 106 | 400 | |
| 107 | 374 | |
| 108 | 414 | |
| 109 | 427 | |
| 110 | 426 |
| Value | Count | Frequency (%) |
| 125 | 386 | |
| 124 | 399 | |
| 123 | 409 | |
| 122 | 394 | |
| 121 | 405 | |
| 120 | 400 | |
| 119 | 381 | |
| 118 | 401 | |
| 117 | 412 | |
| 116 | 434 |
측정항목
Real number (ℝ)
HIGH CORRELATION
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.3246 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 9 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.7376604 |
|---|---|
| Coefficient of variation (CV) | 0.51415325 |
| Kurtosis | -1.1973041 |
| Mean | 5.3246 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.20007258 |
| Sum | 53246 |
| Variance | 7.4947843 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 5 | 1729 | |
| 3 | 1665 | |
| 8 | 1661 | |
| 1 | 1655 | |
| 6 | 1649 | |
| 9 | 1641 |
| Value | Count | Frequency (%) |
| 1 | 1655 | |
| 3 | 1665 | |
| 5 | 1729 | |
| 6 | 1649 | |
| 8 | 1661 | |
| 9 | 1641 |
| Value | Count | Frequency (%) |
| 9 | 1641 | |
| 8 | 1661 | |
| 6 | 1649 | |
| 5 | 1729 | |
| 3 | 1665 | |
| 1 | 1655 |
평균값
Real number (ℝ)
HIGH CORRELATION
| Distinct | 230 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -19.17761 |
| Minimum | -9999 |
|---|---|
| Maximum | 1068 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 101 |
| Negative (%) | 1.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 0.003 |
| Q1 | 0.01 |
| median | 0.0735 |
| Q3 | 21 |
| 95-th percentile | 55 |
| Maximum | 1068 |
| Range | 11067 |
| Interquartile range (IQR) | 20.99 |
Descriptive statistics
| Standard deviation | 540.95238 |
|---|---|
| Coefficient of variation (CV) | -28.207497 |
| Kurtosis | 333.19472 |
| Mean | -19.17761 |
| Median Absolute Deviation (MAD) | 0.2265 |
| Skewness | -18.22665 |
| Sum | -191776.1 |
| Variance | 292629.48 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.005 | 403 | 4.0% |
| 0.006 | 361 | 3.6% |
| 0.004 | 322 | 3.2% |
| 0.007 | 274 | 2.7% |
| 0.5 | 250 | 2.5% |
| 0.4 | 247 | 2.5% |
| 0.003 | 233 | 2.3% |
| 0.008 | 218 | 2.2% |
| 0.6 | 198 | 2.0% |
| 0.002 | 196 | 2.0% |
| Other values (220) | 7298 |
| Value | Count | Frequency (%) |
| -9999.0 | 29 | 0.3% |
| -999.9 | 23 | 0.2% |
| -9.999 | 49 | 0.5% |
| 0.0 | 13 | 0.1% |
| 0.001 | 127 | 1.3% |
| 0.002 | 196 | |
| 0.003 | 233 | |
| 0.004 | 322 | |
| 0.005 | 403 | |
| 0.006 | 361 |
| Value | Count | Frequency (%) |
| 1068.0 | 1 | |
| 774.0 | 1 | |
| 247.0 | 1 | |
| 140.0 | 1 | |
| 135.0 | 1 | |
| 128.0 | 1 | |
| 123.0 | 1 | |
| 117.0 | 1 | |
| 116.0 | 1 | |
| 115.0 | 1 |
측정기 상태
Real number (ℝ)
ZEROS
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0732 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 9802 |
| Zeros (%) | 98.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.63299434 |
|---|---|
| Coefficient of variation (CV) | 8.6474636 |
| Kurtosis | 128.40949 |
| Mean | 0.0732 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.71186 |
| Sum | 732 |
| Variance | 0.40068183 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 9802 | |
| 4 | 92 | 0.9% |
| 1 | 66 | 0.7% |
| 9 | 26 | 0.3% |
| 2 | 8 | 0.1% |
| 8 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 9802 | |
| 1 | 66 | 0.7% |
| 2 | 8 | 0.1% |
| 4 | 92 | 0.9% |
| 8 | 6 | 0.1% |
| 9 | 26 | 0.3% |
| Value | Count | Frequency (%) |
| 9 | 26 | 0.3% |
| 8 | 6 | 0.1% |
| 4 | 92 | 0.9% |
| 2 | 8 | 0.1% |
| 1 | 66 | 0.7% |
| 0 | 9802 |
국가 기준초과 구분
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| 0 |
|---|
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 | 10000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 10000 |
지자체 기준초과 구분
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| 0 |
|---|
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 | 10000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 10000 |
| 측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | |
|---|---|---|---|---|---|
| 측정일시 | 1.000 | 0.027 | 0.000 | 0.064 | 0.145 |
| 측정소 코드 | 0.027 | 1.000 | 0.000 | 0.126 | 0.210 |
| 측정항목 | 0.000 | 0.000 | 1.000 | 0.143 | 0.112 |
| 평균값 | 0.064 | 0.126 | 0.143 | 1.000 | 0.686 |
| 측정기 상태 | 0.145 | 0.210 | 0.112 | 0.686 | 1.000 |
| 측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | |
|---|---|---|---|---|---|
| 측정일시 | 1.000 | -0.023 | -0.013 | -0.068 | 0.081 |
| 측정소 코드 | -0.023 | 1.000 | -0.010 | 0.014 | -0.083 |
| 측정항목 | -0.013 | -0.010 | 1.000 | 0.704 | 0.031 |
| 평균값 | -0.068 | 0.014 | 0.704 | 1.000 | -0.097 |
| 측정기 상태 | 0.081 | -0.083 | 0.031 | -0.097 | 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.
| 측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | 지자체 기준초과 구분 | |
|---|---|---|---|---|---|---|---|
| 31661 | 2011010919 | 102 | 9 | 8.0 | 0 | 0 | 0 |
| 54816 | 2011011605 | 112 | 1 | 0.003 | 0 | 0 | 0 |
| 48880 | 2011011413 | 122 | 8 | 93.0 | 1 | 0 | 0 |
| 28692 | 2011010823 | 108 | 1 | 0.013 | 0 | 0 | 0 |
| 66323 | 2011011910 | 104 | 9 | 27.0 | 0 | 0 | 0 |
| 63182 | 2011011813 | 106 | 5 | 0.5 | 0 | 0 | 0 |
| 18299 | 2011010601 | 125 | 9 | 20.0 | 0 | 0 | 0 |
| 36518 | 2011011103 | 112 | 5 | 1.0 | 0 | 0 | 0 |
| 18094 | 2011010600 | 116 | 8 | 37.0 | 0 | 0 | 0 |
| 26204 | 2011010806 | 118 | 5 | 1.2 | 0 | 0 | 0 |
| 측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | 지자체 기준초과 구분 | |
|---|---|---|---|---|---|---|---|
| 56651 | 2011011617 | 117 | 9 | 31.0 | 0 | 0 | 0 |
| 58710 | 2011011707 | 111 | 1 | 0.005 | 0 | 0 | 0 |
| 11487 | 2011010404 | 115 | 6 | 0.012 | 0 | 0 | 0 |
| 4065 | 2011010203 | 103 | 6 | 0.002 | 0 | 0 | 0 |
| 34211 | 2011011012 | 102 | 9 | 10.0 | 0 | 0 | 0 |
| 27318 | 2011010814 | 104 | 1 | 0.009 | 0 | 0 | 0 |
| 32930 | 2011011003 | 114 | 5 | 0.5 | 0 | 0 | 0 |
| 55615 | 2011011610 | 120 | 3 | 0.019 | 0 | 0 | 0 |
| 23520 | 2011010712 | 121 | 1 | 0.005 | 0 | 0 | 0 |
| 60545 | 2011011719 | 116 | 9 | 13.0 | 0 | 0 | 0 |