Overview

Dataset statistics

Number of variables7
Number of observations144
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory57.9 B

Variable types

Categorical6
Numeric1

Dataset

Description인천시 서구 관내 공촌사업소 및 청라 주변 일대에 발생하는 악취 측정일자, 측정장소, 측정 수치 등의 값들을 수집하여 대시민 대상으로 개방하고 있음
URLhttps://www.data.go.kr/data/15120271/fileData.do

Alerts

관할사업소 has constant value ""Constant
좌표(Y)_위도 is highly overall correlated with 측정지점 and 2 other fieldsHigh correlation
좌표(X)_경도 is highly overall correlated with 측정지점 and 2 other fieldsHigh correlation
주소(위치정보) is highly overall correlated with 측정지점 and 2 other fieldsHigh correlation
측정지점 is highly overall correlated with 주소(위치정보) and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 11:45:47.530040
Analysis finished2023-12-12 11:45:48.213070
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관할사업소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
공촌사업소
144 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공촌사업소
2nd row공촌사업소
3rd row공촌사업소
4th row공촌사업소
5th row공촌사업소

Common Values

ValueCountFrequency (%)
공촌사업소 144
100.0%

Length

2023-12-12T20:45:48.308925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:48.425367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공촌사업소 144
100.0%

측정일자
Categorical

Distinct12
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2022-07-26
12 
2022-08-26
12 
2022-09-21
12 
2022-10-12
12 
2022-11-23
12 
Other values (7)
84 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-26
2nd row2022-07-26
3rd row2022-07-26
4th row2022-07-26
5th row2022-07-26

Common Values

ValueCountFrequency (%)
2022-07-26 12
8.3%
2022-08-26 12
8.3%
2022-09-21 12
8.3%
2022-10-12 12
8.3%
2022-11-23 12
8.3%
2022-12-29 12
8.3%
2023-01-20 12
8.3%
2023-02-17 12
8.3%
2023-03-22 12
8.3%
2023-04-19 12
8.3%
Other values (2) 24
16.7%

Length

2023-12-12T20:45:48.614078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-07-26 12
8.3%
2022-08-26 12
8.3%
2022-09-21 12
8.3%
2022-10-12 12
8.3%
2022-11-23 12
8.3%
2022-12-29 12
8.3%
2023-01-20 12
8.3%
2023-02-17 12
8.3%
2023-03-22 12
8.3%
2023-04-19 12
8.3%
Other values (2) 24
16.7%

측정지점
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
인천체고 주변
12 
탈수기동 주변
12 
사업소 정문
12 
서인천발전 주변
12 
유수지 체육공원
12 
Other values (7)
84 

Length

Max length18
Median length15
Mean length9.5833333
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천체고 주변
2nd row탈수기동 주변
3rd row사업소 정문
4th row서인천발전 주변
5th row유수지 체육공원

Common Values

ValueCountFrequency (%)
인천체고 주변 12
8.3%
탈수기동 주변 12
8.3%
사업소 정문 12
8.3%
서인천발전 주변 12
8.3%
유수지 체육공원 12
8.3%
청라달튼 외국인학교 12
8.3%
영종대교 휴게소 12
8.3%
서인천발전소 입구(사거리) 12
8.3%
청라 모아미래도시 아파트 주변 12
8.3%
군부대 앞 12
8.3%
Other values (2) 24
16.7%

Length

2023-12-12T20:45:48.784122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
주변 48
 
14.3%
인천체고 12
 
3.6%
입구(사거리 12
 
3.6%
단지 12
 
3.6%
푸르지오 12
 
3.6%
청라국제도시역 12
 
3.6%
사거리 12
 
3.6%
화예단지 12
 
3.6%
앞 12
 
3.6%
군부대 12
 
3.6%
Other values (15) 180
53.6%

주소(위치정보)
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
인천시 서구 장도로 138
36 
인천시 서구 청라동 1-1844
12 
인천시 서구 청라동 1-1896
12 
인천시 서구 첨단동로 344
12 
인천시 서구 정서진남로 25
12 
Other values (5)
60 

Length

Max length17
Median length16
Mean length15.75
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천시 서구 장도로 138
2nd row인천시 서구 장도로 138
3rd row인천시 서구 장도로 138
4th row인천시 서구 청라동 1-1844
5th row인천시 서구 청라동 1-1896

Common Values

ValueCountFrequency (%)
인천시 서구 장도로 138 36
25.0%
인천시 서구 청라동 1-1844 12
 
8.3%
인천시 서구 청라동 1-1896 12
 
8.3%
인천시 서구 첨단동로 344 12
 
8.3%
인천시 서구 정서진남로 25 12
 
8.3%
인천시 서구 청라동 1-1866 12
 
8.3%
인천시 서구 청라동 7-18 12
 
8.3%
인천시 서구 청라동 1-1539 12
 
8.3%
인천시 서구 청라동 1-1592 12
 
8.3%
인천시 서구 청라동 1-1565 12
 
8.3%

Length

2023-12-12T20:45:48.977881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:49.166264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천시 144
25.0%
서구 144
25.0%
청라동 84
14.6%
장도로 36
 
6.2%
138 36
 
6.2%
1-1844 12
 
2.1%
1-1896 12
 
2.1%
첨단동로 12
 
2.1%
344 12
 
2.1%
정서진남로 12
 
2.1%
Other values (6) 72
12.5%

좌표(Y)_위도
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
<NA>
24 
251.8125 (126°36'30.9")
10 
241.8681 (126°36'27.6"))
10 
180.3452 (126°36'20.8")
10 
177.3654 (126°36'19.0")
10 
Other values (8)
80 

Length

Max length24
Median length23
Mean length19.902778
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 24
16.7%
251.8125 (126°36'30.9") 10
 
6.9%
241.8681 (126°36'27.6")) 10
 
6.9%
180.3452 (126°36'20.8") 10
 
6.9%
177.3654 (126°36'19.0") 10
 
6.9%
376.4571 (126°36'57.9") 10
 
6.9%
510.1359 (126°37'18.2") 10
 
6.9%
229.2458 (126°36'28.0") 10
 
6.9%
306.4578 (126°36'42.4") 10
 
6.9%
453.1069 (126°37'08.3") 10
 
6.9%
Other values (3) 30
20.8%

Length

2023-12-12T20:45:49.401325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 24
 
9.1%
126°36'57.9 20
 
7.6%
229.2458 10
 
3.8%
126°36'38.6 10
 
3.8%
299.6547 10
 
3.8%
126°36'36.2 10
 
3.8%
260.3574 10
 
3.8%
126°37'08.3 10
 
3.8%
453.1069 10
 
3.8%
126°36'42.4 10
 
3.8%
Other values (14) 140
53.0%

좌표(X)_경도
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
<NA>
24 
220.2292 (37°32'46.0")
10 
247.6723(37°32'50")
10 
212.1536 (37°32'43.1")
10 
36.3241 (37°32'19.0")
10 
Other values (8)
80 

Length

Max length22
Median length22
Mean length18.583333
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 24
16.7%
220.2292 (37°32'46.0") 10
 
6.9%
247.6723(37°32'50") 10
 
6.9%
212.1536 (37°32'43.1") 10
 
6.9%
36.3241 (37°32'19.0") 10
 
6.9%
172.3320 (37°32'37.5") 10
 
6.9%
234.4287 (37°32'51.3") 10
 
6.9%
434.6301 (37°33'14.5") 10
 
6.9%
44.7197 (37°32'20.8") 10
 
6.9%
19.8510 (37°32'16.9") 10
 
6.9%
Other values (3) 30
20.8%

Length

2023-12-12T20:45:49.628162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 24
 
9.4%
220.2292 10
 
3.9%
341.3464 10
 
3.9%
37°33'04.5 10
 
3.9%
274.6318 10
 
3.9%
37°33'01.4 10
 
3.9%
355.6247 10
 
3.9%
37°32'16.9 10
 
3.9%
19.8510 10
 
3.9%
37°32'20.8 10
 
3.9%
Other values (14) 140
55.1%

측정값(복합악취희석배수)
Real number (ℝ)

Distinct28
Distinct (%)19.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.7333333
Minimum3
Maximum7.6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-12T20:45:49.809052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3.8
Q14.2
median4.6
Q35.1
95-th percentile6
Maximum7.6
Range4.6
Interquartile range (IQR)0.9

Descriptive statistics

Standard deviation0.74232671
Coefficient of variation (CV)0.15682959
Kurtosis1.4200773
Mean4.7333333
Median Absolute Deviation (MAD)0.4
Skewness0.87756784
Sum681.6
Variance0.55104895
MonotonicityNot monotonic
2023-12-12T20:45:49.968960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
4.2 21
14.6%
4.6 18
12.5%
4.8 17
11.8%
4.4 11
 
7.6%
4.0 9
 
6.2%
5.2 9
 
6.2%
5.0 8
 
5.6%
5.8 5
 
3.5%
3.6 4
 
2.8%
5.1 4
 
2.8%
Other values (18) 38
26.4%
ValueCountFrequency (%)
3.0 1
 
0.7%
3.2 1
 
0.7%
3.3 1
 
0.7%
3.6 4
 
2.8%
3.8 2
 
1.4%
3.9 2
 
1.4%
4.0 9
6.2%
4.1 3
 
2.1%
4.2 21
14.6%
4.3 3
 
2.1%
ValueCountFrequency (%)
7.6 1
 
0.7%
6.8 1
 
0.7%
6.6 3
2.1%
6.2 2
 
1.4%
6.0 4
2.8%
5.9 1
 
0.7%
5.8 5
3.5%
5.6 4
2.8%
5.5 1
 
0.7%
5.4 3
2.1%

Interactions

2023-12-12T20:45:47.878093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:45:50.067439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
측정일자측정지점주소(위치정보)좌표(Y)_위도좌표(X)_경도측정값(복합악취희석배수)
측정일자1.0000.0000.0000.0000.0000.511
측정지점0.0001.0001.0001.0001.0000.250
주소(위치정보)0.0001.0001.0001.0001.0000.000
좌표(Y)_위도0.0001.0001.0001.0001.0000.395
좌표(X)_경도0.0001.0001.0001.0001.0000.395
측정값(복합악취희석배수)0.5110.2500.0000.3950.3951.000
2023-12-12T20:45:50.208774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
좌표(Y)_위도좌표(X)_경도측정일자주소(위치정보)측정지점
좌표(Y)_위도1.0001.0000.0000.9911.000
좌표(X)_경도1.0001.0000.0000.9911.000
측정일자0.0000.0001.0000.0000.000
주소(위치정보)0.9910.9910.0001.0000.993
측정지점1.0001.0000.0000.9931.000
2023-12-12T20:45:50.351912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
측정값(복합악취희석배수)측정일자측정지점주소(위치정보)좌표(Y)_위도좌표(X)_경도
측정값(복합악취희석배수)1.0000.2400.1040.0000.1730.173
측정일자0.2401.0000.0000.0000.0000.000
측정지점0.1040.0001.0000.9931.0001.000
주소(위치정보)0.0000.0000.9931.0000.9910.991
좌표(Y)_위도0.1730.0001.0000.9911.0001.000
좌표(X)_경도0.1730.0001.0000.9911.0001.000

Missing values

2023-12-12T20:45:47.991816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:45:48.141477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

관할사업소측정일자측정지점주소(위치정보)좌표(Y)_위도좌표(X)_경도측정값(복합악취희석배수)
0공촌사업소2022-07-26인천체고 주변인천시 서구 장도로 138<NA><NA>5.1
1공촌사업소2022-07-26탈수기동 주변인천시 서구 장도로 138<NA><NA>5.9
2공촌사업소2022-07-26사업소 정문인천시 서구 장도로 138<NA><NA>5.6
3공촌사업소2022-07-26서인천발전 주변인천시 서구 청라동 1-1844<NA><NA>6.0
4공촌사업소2022-07-26유수지 체육공원인천시 서구 청라동 1-1896<NA><NA>6.0
5공촌사업소2022-07-26청라달튼 외국인학교인천시 서구 첨단동로 344<NA><NA>5.4
6공촌사업소2022-07-26영종대교 휴게소인천시 서구 정서진남로 25<NA><NA>6.0
7공촌사업소2022-07-26서인천발전소 입구(사거리)인천시 서구 청라동 1-1866<NA><NA>5.8
8공촌사업소2022-07-26청라 모아미래도시 아파트 주변인천시 서구 청라동 7-18<NA><NA>4.8
9공촌사업소2022-07-26군부대 앞인천시 서구 청라동 1-1539<NA><NA>5.2
관할사업소측정일자측정지점주소(위치정보)좌표(Y)_위도좌표(X)_경도측정값(복합악취희석배수)
134공촌사업소2023-06-20사업소 정문인천시 서구 장도로 138180.3452 (126°36'20.8")212.1536 (37°32'43.1")4.2
135공촌사업소2023-06-20서인천발전 주변인천시 서구 청라동 1-1844177.3654 (126°36'19.0")36.3241 (37°32'19.0")4.4
136공촌사업소2023-06-20유수지 체육공원인천시 서구 청라동 1-1896376.4571 (126°36'57.9")172.3320 (37°32'37.5")4.0
137공촌사업소2023-06-20청라달튼 외국인학교인천시 서구 첨단동로 344510.1359 (126°37'18.2")234.4287 (37°32'51.3")3.8
138공촌사업소2023-06-20영종대교 휴게소인천시 서구 정서진남로 25229.2458 (126°36'28.0")434.6301 (37°33'14.5")3.6
139공촌사업소2023-06-20서인천발전소 입구(사거리)인천시 서구 청라동 1-1866306.4578 (126°36'42.4")44.7197 (37°32'20.8")4.5
140공촌사업소2023-06-20청라 모아미래도시 아파트 주변인천시 서구 청라동 7-18453.1069 (126°37'08.3")19.8510 (37°32'16.9")4.0
141공촌사업소2023-06-20군부대 앞인천시 서구 청라동 1-1539260.3574 (126°36'36.2")355.6247 (37°33'01.4")4.8
142공촌사업소2023-06-20화예단지 사거리인천시 서구 청라동 1-1592299.6547 (126°36'38.6")274.6318 (37°33'04.5")4.5
143공촌사업소2023-06-20청라국제도시역 푸르지오 단지 입구인천시 서구 청라동 1-1565398.9541 (126°36'57.9")341.3464 (37°33'01.6")4.2