Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory693.4 KiB
Average record size in memory71.0 B

Variable types

Numeric4
Categorical3

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15526/S/1/datasetView.do

Alerts

평균값 is highly overall correlated with 측정기 상태High correlation
측정기 상태 is highly overall correlated with 평균값High correlation
국가 기준초과 구분 is highly overall correlated with 지자체 기준초과 구분High correlation
지자체 기준초과 구분 is highly overall correlated with 국가 기준초과 구분High correlation
측정기 상태 is highly imbalanced (57.8%)Imbalance
국가 기준초과 구분 is highly imbalanced (93.0%)Imbalance
지자체 기준초과 구분 is highly imbalanced (88.5%)Imbalance
평균값 has 337 (3.4%) zerosZeros

Reproduction

Analysis started2024-07-13 17:52:25.362251
Analysis finished2024-07-13 17:52:28.716553
Duration3.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

측정일시
Real number (ℝ)

Distinct926
Distinct (%)9.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9970134 × 109
Minimum1.9970101 × 109
Maximum1.9970208 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-07-14T02:52:28.794552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9970101 × 109
5-th percentile1.9970103 × 109
Q11.997011 × 109
median1.997012 × 109
Q31.997013 × 109
95-th percentile1.9970206 × 109
Maximum1.9970208 × 109
Range10713
Interquartile range (IQR)1981.25

Descriptive statistics

Standard deviation3633.9041
Coefficient of variation (CV)1.8196693 × 10-6
Kurtosis-0.01894227
Mean1.9970134 × 109
Median Absolute Deviation (MAD)991
Skewness1.3073003
Sum1.9970134 × 1013
Variance13205259
MonotonicityNot monotonic
2024-07-14T02:52:29.343400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1997012404 22
 
0.2%
1997011214 21
 
0.2%
1997012704 20
 
0.2%
1997012421 20
 
0.2%
1997010516 20
 
0.2%
1997010605 20
 
0.2%
1997011508 20
 
0.2%
1997020205 19
 
0.2%
1997012809 19
 
0.2%
1997020400 19
 
0.2%
Other values (916) 9800
98.0%
ValueCountFrequency (%)
1997010100 10
0.1%
1997010101 8
0.1%
1997010102 13
0.1%
1997010103 11
0.1%
1997010104 11
0.1%
1997010105 12
0.1%
1997010106 10
0.1%
1997010107 13
0.1%
1997010108 11
0.1%
1997010109 6
0.1%
ValueCountFrequency (%)
1997020813 13
0.1%
1997020812 10
0.1%
1997020811 12
0.1%
1997020810 15
0.1%
1997020809 14
0.1%
1997020808 9
0.1%
1997020807 12
0.1%
1997020806 13
0.1%
1997020805 10
0.1%
1997020804 9
0.1%

측정소 코드
Real number (ℝ)

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean112.1725
Minimum102
Maximum124
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-07-14T02:52:29.560623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum102
5-th percentile102
Q1106
median110
Q3119
95-th percentile124
Maximum124
Range22
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.1498291
Coefficient of variation (CV)0.063739589
Kurtosis-1.3164854
Mean112.1725
Median Absolute Deviation (MAD)6
Skewness0.2683658
Sum1121725
Variance51.120056
MonotonicityNot monotonic
2024-07-14T02:52:29.730421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
107 599
 
6.0%
102 589
 
5.9%
109 583
 
5.8%
116 571
 
5.7%
104 567
 
5.7%
122 565
 
5.7%
124 564
 
5.6%
110 563
 
5.6%
106 561
 
5.6%
108 557
 
5.6%
Other values (8) 4281
42.8%
ValueCountFrequency (%)
102 589
5.9%
103 529
5.3%
104 567
5.7%
105 513
5.1%
106 561
5.6%
107 599
6.0%
108 557
5.6%
109 583
5.8%
110 563
5.6%
111 537
5.4%
ValueCountFrequency (%)
124 564
5.6%
123 539
5.4%
122 565
5.7%
121 535
5.3%
119 545
5.5%
117 540
5.4%
116 571
5.7%
113 543
5.4%
111 537
5.4%
110 563
5.6%

측정항목
Real number (ℝ)

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.3314
Minimum1
Maximum9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-07-14T02:52:29.874538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median6
Q38
95-th percentile9
Maximum9
Range8
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.7345423
Coefficient of variation (CV)0.51291262
Kurtosis-1.1931703
Mean5.3314
Median Absolute Deviation (MAD)2
Skewness-0.20876633
Sum53314
Variance7.4777218
MonotonicityNot monotonic
2024-07-14T02:52:30.010709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
6 1720
17.2%
8 1672
16.7%
5 1667
16.7%
3 1663
16.6%
1 1651
16.5%
9 1627
16.3%
ValueCountFrequency (%)
1 1651
16.5%
3 1663
16.6%
5 1667
16.7%
6 1720
17.2%
8 1672
16.7%
9 1627
16.3%
ValueCountFrequency (%)
9 1627
16.3%
8 1672
16.7%
6 1720
17.2%
5 1667
16.7%
3 1663
16.6%
1 1651
16.5%

평균값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct366
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-2232.6805
Minimum-9999
Maximum500
Zeros337
Zeros (%)3.4%
Negative2876
Negative (%)28.8%
Memory size166.0 KiB
2024-07-14T02:52:30.194925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-9999
5-th percentile-9999
Q1-9.999
median0.013
Q30.068
95-th percentile59
Maximum500
Range10499
Interquartile range (IQR)10.067

Descriptive statistics

Standard deviation4156.6078
Coefficient of variation (CV)-1.8617119
Kurtosis-0.22262861
Mean-2232.6805
Median Absolute Deviation (MAD)0.587
Skewness-1.3316562
Sum-22326805
Variance17277388
MonotonicityNot monotonic
2024-07-14T02:52:30.357488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-9999.0 2225
 
22.2%
-9.999 507
 
5.1%
0.0 337
 
3.4%
0.005 210
 
2.1%
0.006 162
 
1.6%
0.001 162
 
1.6%
0.004 161
 
1.6%
0.007 160
 
1.6%
-999.9 142
 
1.4%
0.011 140
 
1.4%
Other values (356) 5794
57.9%
ValueCountFrequency (%)
-9999.0 2225
22.2%
-999.9 142
 
1.4%
-9.999 507
 
5.1%
-1.1 1
 
< 0.1%
-0.4 1
 
< 0.1%
0.0 337
 
3.4%
0.001 162
 
1.6%
0.002 103
 
1.0%
0.003 129
 
1.3%
0.004 161
 
1.6%
ValueCountFrequency (%)
500.0 1
< 0.1%
399.0 1
< 0.1%
293.0 1
< 0.1%
292.0 1
< 0.1%
283.0 1
< 0.1%
280.0 1
< 0.1%
250.0 1
< 0.1%
248.0 1
< 0.1%
245.0 1
< 0.1%
241.0 1
< 0.1%

측정기 상태
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
6776 
4
3128 
2
 
71
1
 
21
9
 
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4
2nd row0
3rd row4
4th row4
5th row0

Common Values

ValueCountFrequency (%)
0 6776
67.8%
4 3128
31.3%
2 71
 
0.7%
1 21
 
0.2%
9 4
 
< 0.1%

Length

2024-07-14T02:52:30.509656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-07-14T02:52:30.657034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 6776
67.8%
4 3128
31.3%
2 71
 
0.7%
1 21
 
0.2%
9 4
 
< 0.1%

국가 기준초과 구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9916 
1
 
84

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 9916
99.2%
1 84
 
0.8%

Length

2024-07-14T02:52:30.781148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-07-14T02:52:30.899058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9916
99.2%
1 84
 
0.8%

지자체 기준초과 구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9846 
1
 
154

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 9846
98.5%
1 154
 
1.5%

Length

2024-07-14T02:52:31.014315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-07-14T02:52:31.150679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9846
98.5%
1 154
 
1.5%

Interactions

2024-07-14T02:52:27.909358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:26.331277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:26.864799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:27.334496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:28.045608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:26.474284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:26.971400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:27.475980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:28.160333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:26.598853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:27.084744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:27.612966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-07-14T02:52:28.318690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/