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

Numeric5
Categorical2

Dataset

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

Alerts

국가 기준초과 구분 has constant value ""Constant
지자체 기준초과 구분 has constant value ""Constant
측정항목 is highly overall correlated with 평균값 and 1 other fieldsHigh correlation
평균값 is highly overall correlated with 측정항목 and 1 other fieldsHigh correlation
측정기 상태 is highly overall correlated with 측정항목 and 1 other fieldsHigh correlation
평균값 has 539 (5.4%) zerosZeros
측정기 상태 has 5985 (59.9%) zerosZeros

Reproduction

Analysis started2024-04-13 06:03:52.924743
Analysis finished2024-04-13 06:04:00.840097
Duration7.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

측정일시
Real number (ℝ)

Distinct2072
Distinct (%)20.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9890212 × 109
Minimum1.9890101 × 109
Maximum1.9890328 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-13T06:04:01.054730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9890101 × 109
5-th percentile1.9890105 × 109
Q11.9890122 × 109
median1.9890213 × 109
Q31.9890307 × 109
95-th percentile1.9890324 × 109
Maximum1.9890328 × 109
Range22719
Interquartile range (IQR)18493.5

Descriptive statistics

Standard deviation8207.9906
Coefficient of variation (CV)4.1266481 × 10-6
Kurtosis-1.4895621
Mean1.9890212 × 109
Median Absolute Deviation (MAD)9210
Skewness0.059127457
Sum1.9890212 × 1013
Variance67371110
MonotonicityNot monotonic
2024-04-13T06:04:01.416932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1989010116 12
 
0.1%
1989011511 12
 
0.1%
1989031401 12
 
0.1%
1989010606 12
 
0.1%
1989010419 12
 
0.1%
1989011010 12
 
0.1%
1989012123 11
 
0.1%
1989031118 11
 
0.1%
1989032609 11
 
0.1%
1989011513 11
 
0.1%
Other values (2062) 9884
98.8%
ValueCountFrequency (%)
1989010100 4
 
< 0.1%
1989010101 3
 
< 0.1%
1989010102 9
0.1%
1989010103 4
 
< 0.1%
1989010104 6
0.1%
1989010105 2
 
< 0.1%
1989010106 10
0.1%
1989010107 4
 
< 0.1%
1989010108 7
0.1%
1989010109 1
 
< 0.1%
ValueCountFrequency (%)
1989032819 3
 
< 0.1%
1989032818 8
0.1%
1989032817 6
0.1%
1989032816 4
< 0.1%
1989032815 2
 
< 0.1%
1989032814 5
0.1%
1989032813 4
< 0.1%
1989032812 5
0.1%
1989032811 6
0.1%
1989032810 2
 
< 0.1%

측정소 코드
Real number (ℝ)

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean112.3326
Minimum103
Maximum124
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-13T06:04:01.721615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum103
5-th percentile103
Q1105
median108
Q3117
95-th percentile124
Maximum124
Range21
Interquartile range (IQR)12

Descriptive statistics

Standard deviation7.4218654
Coefficient of variation (CV)0.066070449
Kurtosis-1.383501
Mean112.3326
Median Absolute Deviation (MAD)5
Skewness0.34611355
Sum1123326
Variance55.084086
MonotonicityNot monotonic
2024-04-13T06:04:02.058048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
105 1353
13.5%
122 1270
12.7%
107 1252
12.5%
117 1242
12.4%
124 1229
12.3%
113 1220
12.2%
108 1217
12.2%
103 1217
12.2%
ValueCountFrequency (%)
103 1217
12.2%
105 1353
13.5%
107 1252
12.5%
108 1217
12.2%
113 1220
12.2%
117 1242
12.4%
122 1270
12.7%
124 1229
12.3%
ValueCountFrequency (%)
124 1229
12.3%
122 1270
12.7%
117 1242
12.4%
113 1220
12.2%
108 1217
12.2%
107 1252
12.5%
105 1353
13.5%
103 1217
12.2%

측정항목
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.3159
Minimum1
Maximum9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-13T06:04:02.463158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation2.7718722
Coefficient of variation (CV)0.52143046
Kurtosis-1.2280351
Mean5.3159
Median Absolute Deviation (MAD)3
Skewness-0.20275251
Sum53159
Variance7.6832755
MonotonicityNot monotonic
2024-04-13T06:04:02.761949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 1737
17.4%
9 1680
16.8%
8 1666
16.7%
6 1645
16.4%
5 1644
16.4%
3 1628
16.3%
ValueCountFrequency (%)
1 1737
17.4%
3 1628
16.3%
5 1644
16.4%
6 1645
16.4%
8 1666
16.7%
9 1680
16.8%
ValueCountFrequency (%)
9 1680
16.8%
8 1666
16.7%
6 1645
16.4%
5 1644
16.4%
3 1628
16.3%
1 1737
17.4%

평균값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct515
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-3362.7731
Minimum-9999
Maximum31.9
Zeros539
Zeros (%)5.4%
Negative4013
Negative (%)40.1%
Memory size166.0 KiB
2024-04-13T06:04:03.133309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-9999
5-th percentile-9999
Q1-9999
median0.007
Q30.067
95-th percentile4.5
Maximum31.9
Range10030.9
Interquartile range (IQR)9999.067

Descriptive statistics

Standard deviation4707.9283
Coefficient of variation (CV)-1.4000137
Kurtosis-1.5090334
Mean-3362.7731
Median Absolute Deviation (MAD)2.293
Skewness-0.69890899
Sum-33627731
Variance22164589
MonotonicityNot monotonic
2024-04-13T06:04:03.599929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-9999.0 3346
33.5%
0.0 539
 
5.4%
-9.999 492
 
4.9%
-999.9 173
 
1.7%
0.001 132
 
1.3%
0.002 85
 
0.9%
0.015 68
 
0.7%
0.003 67
 
0.7%
0.031 59
 
0.6%
0.005 58
 
0.6%
Other values (505) 4981
49.8%
ValueCountFrequency (%)
-9999.0 3346
33.5%
-999.9 173
 
1.7%
-10.0 1
 
< 0.1%
-9.999 492
 
4.9%
-0.102 1
 
< 0.1%
0.0 539
 
5.4%
0.001 132
 
1.3%
0.002 85
 
0.9%
0.003 67
 
0.7%
0.004 48
 
0.5%
ValueCountFrequency (%)
31.9 1
< 0.1%
28.6 1
< 0.1%
27.8 1
< 0.1%
26.8 1
< 0.1%
26.1 1
< 0.1%
25.1 1
< 0.1%
24.9 1
< 0.1%
22.9 2
< 0.1%
22.8 1
< 0.1%
22.0 1
< 0.1%

측정기 상태
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5753
Minimum0
Maximum9
Zeros5985
Zeros (%)59.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-13T06:04:03.969748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q34
95-th percentile4
Maximum9
Range9
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.0369941
Coefficient of variation (CV)1.2930833
Kurtosis-0.18835728
Mean1.5753
Median Absolute Deviation (MAD)0
Skewness0.83840754
Sum15753
Variance4.1493448
MonotonicityNot monotonic
2024-04-13T06:04:04.192509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 5985
59.9%
4 3479
34.8%
2 398
 
4.0%
9 98
 
1.0%
1 23
 
0.2%
8 17
 
0.2%
ValueCountFrequency (%)
0 5985
59.9%
1 23
 
0.2%
2 398
 
4.0%
4 3479
34.8%
8 17
 
0.2%
9 98
 
1.0%
ValueCountFrequency (%)
9 98
 
1.0%
8 17
 
0.2%
4 3479
34.8%
2 398
 
4.0%
1 23
 
0.2%
0 5985
59.9%

국가 기준초과 구분
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

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 10000
100.0%

Length

2024-04-13T06:04:04.439872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T06:04:04.725998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

지자체 기준초과 구분
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

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 10000
100.0%

Length

2024-04-13T06:04:05.023825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T06:04:05.303920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

Interactions

2024-04-13T06:03:59.013085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:54.126567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:55.316131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:56.366259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:57.788656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:59.198383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:54.394963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:55.479140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:56.616136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:58.025756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:59.390939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:54.707416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T06:03:55.651592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/