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 | 4 |
---|---|
Categorical | 3 |
Dataset
Description | 파일 다운로드 |
---|---|
Author | 서울특별시 |
URL | https://data.seoul.go.kr/dataList/OA-15526/S/1/datasetView.do |
지자체 기준초과 구분 has constant value "" | Constant |
측정항목 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 측정항목 and 1 other fields | High correlation |
국가 기준초과 구분 is highly imbalanced (97.8%) | Imbalance |
평균값 has 960 (9.6%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-04 04:03:33.496757 |
---|---|
Analysis finished | 2024-05-04 04:03:41.325137 |
Duration | 7.83 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
측정일시
Real number (ℝ)
Distinct | 1845 |
---|---|
Distinct (%) | 18.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.9930198 × 109 |
Minimum | 1.9930101 × 109 |
---|---|
Maximum | 1.9930319 × 109 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1.9930101 × 109 |
---|---|
5-th percentile | 1.9930104 × 109 |
Q1 | 1.993012 × 109 |
median | 1.9930208 × 109 |
Q3 | 1.9930227 × 109 |
95-th percentile | 1.9930315 × 109 |
Maximum | 1.9930319 × 109 |
Range | 21803 |
Interquartile range (IQR) | 10706 |
Descriptive statistics
Standard deviation | 7572.3336 |
---|---|
Coefficient of variation (CV) | 3.7994272 × 10-6 |
Kurtosis | -1.2966211 |
Mean | 1.9930198 × 109 |
Median Absolute Deviation (MAD) | 8695 |
Skewness | 0.2518719 |
Sum | 1.9930198 × 1013 |
Variance | 57340236 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1993020223 | 13 | 0.1% |
1993021215 | 12 | 0.1% |
1993021312 | 12 | 0.1% |
1993031406 | 12 | 0.1% |
1993030203 | 12 | 0.1% |
1993021800 | 12 | 0.1% |
1993011203 | 12 | 0.1% |
1993022513 | 12 | 0.1% |
1993020107 | 11 | 0.1% |
1993012223 | 11 | 0.1% |
Other values (1835) | 9881 |
Value | Count | Frequency (%) |
1993010100 | 7 | |
1993010101 | 6 | |
1993010102 | 4 | < 0.1% |
1993010103 | 5 | |
1993010104 | 5 | |
1993010105 | 4 | < 0.1% |
1993010106 | 11 | |
1993010107 | 3 | < 0.1% |
1993010108 | 8 | |
1993010109 | 3 | < 0.1% |
Value | Count | Frequency (%) |
1993031903 | 6 | |
1993031902 | 7 | |
1993031901 | 3 | |
1993031900 | 5 | |
1993031823 | 7 | |
1993031822 | 2 | < 0.1% |
1993031821 | 3 | |
1993031820 | 7 | |
1993031819 | 3 | |
1993031818 | 2 | < 0.1% |
측정소 코드
Real number (ℝ)
Distinct | 9 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 112.7578 |
Minimum | 103 |
---|---|
Maximum | 124 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 103 |
---|---|
5-th percentile | 103 |
Q1 | 107 |
median | 113 |
Q3 | 117 |
95-th percentile | 124 |
Maximum | 124 |
Range | 21 |
Interquartile range (IQR) | 10 |
Descriptive statistics
Standard deviation | 7.1142814 |
---|---|
Coefficient of variation (CV) | 0.063093475 |
Kurtosis | -1.3281624 |
Mean | 112.7578 |
Median Absolute Deviation (MAD) | 6 |
Skewness | 0.18968437 |
Sum | 1127578 |
Variance | 50.613 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
103 | 1145 | |
116 | 1140 | |
124 | 1135 | |
105 | 1129 | |
108 | 1103 | |
113 | 1103 | |
122 | 1096 | |
107 | 1079 | |
117 | 1070 |
Value | Count | Frequency (%) |
103 | 1145 | |
105 | 1129 | |
107 | 1079 | |
108 | 1103 | |
113 | 1103 | |
116 | 1140 | |
117 | 1070 | |
122 | 1096 | |
124 | 1135 |
Value | Count | Frequency (%) |
124 | 1135 | |
122 | 1096 | |
117 | 1070 | |
116 | 1140 | |
113 | 1103 | |
108 | 1103 | |
107 | 1079 | |
105 | 1129 | |
103 | 1145 |
측정항목
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.3158 |
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.7484224 |
---|---|
Coefficient of variation (CV) | 0.51702893 |
Kurtosis | -1.2097316 |
Mean | 5.3158 |
Median Absolute Deviation (MAD) | 2 |
Skewness | -0.19933983 |
Sum | 53158 |
Variance | 7.5538257 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1 | 1684 | |
6 | 1676 | |
3 | 1669 | |
5 | 1666 | |
8 | 1664 | |
9 | 1641 |
Value | Count | Frequency (%) |
1 | 1684 | |
3 | 1669 | |
5 | 1666 | |
6 | 1676 | |
8 | 1664 | |
9 | 1641 |
Value | Count | Frequency (%) |
9 | 1641 | |
8 | 1664 | |
6 | 1676 | |
5 | 1666 | |
3 | 1669 | |
1 | 1684 |
평균값
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 263 |
---|---|
Distinct (%) | 2.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -2498.5532 |
Minimum | -9999 |
---|---|
Maximum | 21.1 |
Zeros | 960 |
Zeros (%) | 9.6% |
Negative | 2535 |
Negative (%) | 25.4% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -9999 |
---|---|
5-th percentile | -9999 |
Q1 | -999.9 |
median | 0.0135 |
Q3 | 0.046 |
95-th percentile | 2.1 |
Maximum | 21.1 |
Range | 10020.1 |
Interquartile range (IQR) | 999.946 |
Descriptive statistics
Standard deviation | 4328.4188 |
---|---|
Coefficient of variation (CV) | -1.7323701 |
Kurtosis | -0.66373635 |
Mean | -2498.5532 |
Median Absolute Deviation (MAD) | 0.0325 |
Skewness | -1.1559164 |
Sum | -24985532 |
Variance | 18735209 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-9999.0 | 2498 | |
0.0 | 960 | 9.6% |
0.001 | 194 | 1.9% |
0.002 | 130 | 1.3% |
0.1 | 126 | 1.3% |
0.012 | 121 | 1.2% |
0.01 | 121 | 1.2% |
0.015 | 119 | 1.2% |
0.011 | 118 | 1.2% |
0.023 | 113 | 1.1% |
Other values (253) | 5500 |
Value | Count | Frequency (%) |
-9999.0 | 2498 | |
-999.9 | 3 | < 0.1% |
-999.4 | 1 | < 0.1% |
-999.3 | 1 | < 0.1% |
-999.2 | 2 | < 0.1% |
-999.1 | 2 | < 0.1% |
-998.7 | 1 | < 0.1% |
-998.6 | 1 | < 0.1% |
-9.999 | 2 | < 0.1% |
-9.995 | 1 | < 0.1% |
Value | Count | Frequency (%) |
21.1 | 1 | |
12.0 | 1 | |
11.8 | 1 | |
9.5 | 1 | |
9.3 | 1 | |
9.0 | 2 | |
8.6 | 1 | |
8.0 | 2 | |
7.9 | 1 | |
7.7 | 1 |
측정기 상태
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
4 | |
2 | 104 |
1 | 22 |
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 | 6556 | |
4 | 3318 | |
2 | 104 | 1.0% |
1 | 22 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 6556 | |
4 | 3318 | |
2 | 104 | 1.0% |
1 | 22 | 0.2% |
국가 기준초과 구분
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 21 |
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 | 9979 | |
1 | 21 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9979 | |
1 | 21 | 0.2% |
지자체 기준초과 구분
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
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | |
---|---|---|---|---|---|---|
측정일시 | 1.000 | 0.000 | 0.000 | 0.026 | 0.081 | 0.024 |
측정소 코드 | 0.000 | 1.000 | 0.000 | 0.028 | 0.099 | 0.066 |
측정항목 | 0.000 | 0.000 | 1.000 | 0.056 | 0.740 | 0.138 |
평균값 | 0.026 | 0.028 | 0.056 | 1.000 | 0.352 | 0.000 |
측정기 상태 | 0.081 | 0.099 | 0.740 | 0.352 | 1.000 | 0.043 |
국가 기준초과 구분 | 0.024 | 0.066 | 0.138 | 0.000 | 0.043 | 1.000 |
국가 기준초과 구분 | 측정기 상태 | |
---|---|---|
국가 기준초과 구분 | 1.000 | 0.028 |
측정기 상태 | 0.028 | 1.000 |
측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | |
---|---|---|---|---|---|---|
측정일시 | 1.000 | 0.017 | 0.006 | -0.023 | 0.066 | 0.029 |
측정소 코드 | 0.017 | 1.000 | -0.007 | -0.015 | 0.064 | 0.047 |
측정항목 | 0.006 | -0.007 | 1.000 | -0.752 | 0.576 | 0.099 |
평균값 | -0.023 | -0.015 | -0.752 | 1.000 | 0.602 | 0.022 |
측정기 상태 | 0.066 | 0.064 | 0.576 | 0.602 | 1.000 | 0.028 |
국가 기준초과 구분 | 0.029 | 0.047 | 0.099 | 0.022 | 0.028 | 1.000 |
측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | 지자체 기준초과 구분 | |
---|---|---|---|---|---|---|---|
78762 | 1993030218 | 116 | 1 | 0.023 | 0 | 0 | 0 |
40779 | 1993020111 | 105 | 6 | 0.007 | 0 | 0 | 0 |
19173 | 1993011519 | 103 | 6 | 0.011 | 0 | 0 | 0 |
91700 | 1993031218 | 105 | 5 | 1.4 | 0 | 0 | 0 |
43779 | 1993020318 | 117 | 6 | 0.011 | 0 | 0 | 0 |
54886 | 1993021208 | 108 | 8 | -9999.0 | 4 | 0 | 0 |
32316 | 1993012522 | 113 | 1 | 0.084 | 0 | 0 | 0 |
51227 | 1993020912 | 116 | 9 | -9999.0 | 4 | 0 | 0 |
81715 | 1993030501 | 107 | 3 | 0.056 | 0 | 0 | 0 |
65954 | 1993022021 | 108 | 5 | 0.4 | 0 | 0 | 0 |
측정일시 | 측정소 코드 | 측정항목 | 평균값 | 측정기 상태 | 국가 기준초과 구분 | 지자체 기준초과 구분 | |
---|---|---|---|---|---|---|---|
28494 | 1993012223 | 117 | 1 | 0.067 | 0 | 0 | 0 |
19169 | 1993011518 | 124 | 9 | -9999.0 | 4 | 0 | 0 |
38665 | 1993013020 | 103 | 3 | 0.046 | 0 | 0 | 0 |
44907 | 1993020415 | 116 | 6 | 0.01 | 0 | 0 | 0 |
96996 | 1993031620 | 107 | 1 | 0.016 | 0 | 0 | 0 |
23597 | 1993011904 | 124 | 9 | -9999.0 | 4 | 0 | 0 |
92811 | 1993031314 | 117 | 6 | 0.02 | 0 | 0 | 0 |
94643 | 1993031500 | 116 | 9 | -9999.0 | 4 | 0 | 0 |
46942 | 1993020605 | 107 | 8 | -9999.0 | 4 | 0 | 0 |
56980 | 1993021323 | 105 | 8 | 0.0 | 4 | 0 | 0 |