Overview

Dataset statistics

Number of variables7
Number of observations220
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.4 KiB
Average record size in memory57.6 B

Variable types

Categorical5
DateTime1
Numeric1

Dataset

Description인천환경공단 담당사업소별 측정일자, 측정위치(세부 주소 포함) 및 악취 측정값에 관한 데이터로 인천 서구 방면 악취지점 내 현황을 보여주는 역할을 함
URLhttps://www.data.go.kr/data/15105070/fileData.do

Alerts

관할사업소 has constant value ""Constant
좌표(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
좌표(Y), 위도 is highly overall correlated with 측정지점 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-11 23:15:35.110404
Analysis finished2023-12-11 23:15:35.787136
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관할사업소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
가좌사업소
220 

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 (%)
가좌사업소 220
100.0%

Length

2023-12-12T08:15:35.862019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:15:35.989606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가좌사업소 220
100.0%

측정일자
Date

Distinct10
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2022-09-19 00:00:00
Maximum2023-06-12 00:00:00
2023-12-12T08:15:36.101238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:15:36.249572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)

측정지점
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
1단계 종침 2,3계열
 
10
관리동 앞
 
10
분뇨 증설부지
 
10
위생동 주차장
 
10
관사 앞
 
10
Other values (17)
170 

Length

Max length12
Median length10
Mean length7.6363636
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1단계 종침 2,3계열
2nd row관리동 앞
3rd row분뇨 증설부지
4th row위생동 주차장
5th row관사 앞

Common Values

ValueCountFrequency (%)
1단계 종침 2,3계열 10
 
4.5%
관리동 앞 10
 
4.5%
분뇨 증설부지 10
 
4.5%
위생동 주차장 10
 
4.5%
관사 앞 10
 
4.5%
2단계 탈수기동 10
 
4.5%
1단계 탈수기동 10
 
4.5%
1단계 주분배조 10
 
4.5%
북항5부두 삼거리 10
 
4.5%
현대연료 앞 10
 
4.5%
Other values (12) 120
54.5%

Length

2023-12-12T08:15:36.410137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
앞 80
 
18.2%
사거리 40
 
9.1%
1단계 30
 
6.8%
탈수기동 20
 
4.5%
수로 10
 
2.3%
폐차장 10
 
2.3%
유수지 10
 
2.3%
인천교 10
 
2.3%
인천산업용품유통센터 10
 
2.3%
㈜지씨비전 10
 
2.3%
Other values (21) 210
47.7%

주소(위치정보)
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
인천 서구 중봉대로 211
80 
인천 서구 가좌동 597
 
10
인천 서구 원석로 78
 
10
인천 서구 석남동 642
 
10
인천 서구 북항로45번길 32
 
10
Other values (10)
100 

Length

Max length19
Median length16
Mean length14
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천 서구 중봉대로 211
2nd row인천 서구 중봉대로 211
3rd row인천 서구 중봉대로 211
4th row인천 서구 중봉대로 211
5th row인천 서구 중봉대로 211

Common Values

ValueCountFrequency (%)
인천 서구 중봉대로 211 80
36.4%
인천 서구 가좌동 597 10
 
4.5%
인천 서구 원석로 78 10
 
4.5%
인천 서구 석남동 642 10
 
4.5%
인천 서구 북항로45번길 32 10
 
4.5%
인천 서구 석남동 641-1 10
 
4.5%
인천 서구 건진로97번길 33 10
 
4.5%
인천 서구 건지로 122 10
 
4.5%
인천 서구 봉수대로 257 10
 
4.5%
인천 서구 봉수대로 203 10
 
4.5%
Other values (5) 50
22.7%

Length

2023-12-12T08:15:36.616053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
인천 220
25.0%
서구 210
23.9%
중봉대로 80
 
9.1%
211 80
 
9.1%
봉수대로 30
 
3.4%
석남동 20
 
2.3%
148 10
 
1.1%
송현동 10
 
1.1%
보도진로13 10
 
1.1%
동구 10
 
1.1%
Other values (20) 200
22.7%

좌표(Y), 위도
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
220.12(126°38'43.1")
 
10
284.83(126°38'48.8")
 
10
146.78(126°38'32.3")
 
10
149.66(126°38'31.9")
 
10
283.39(126°38'49.2")
 
10
Other values (17)
170 

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row220.12(126°38'43.1")
2nd row284.83(126°38'48.8")
3rd row146.78(126°38'32.3")
4th row149.66(126°38'31.9")
5th row283.39(126°38'49.2")

Common Values

ValueCountFrequency (%)
220.12(126°38'43.1") 10
 
4.5%
284.83(126°38'48.8") 10
 
4.5%
146.78(126°38'32.3") 10
 
4.5%
149.66(126°38'31.9") 10
 
4.5%
283.39(126°38'49.2") 10
 
4.5%
175.54(126°38'35.9") 10
 
4.5%
230.19(126°38'43.8") 10
 
4.5%
286.27(126°38'49.2") 10
 
4.5%
128.09(126°38'28.3") 10
 
4.5%
137.70(126°38'30.4") 10
 
4.5%
Other values (12) 120
54.5%

Length

2023-12-12T08:15:36.815937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
220.12(126°38'43.1 10
 
4.5%
284.83(126°38'48.8 10
 
4.5%
344.29(126°38'55.9 10
 
4.5%
283.22(126°38'49.5 10
 
4.5%
463.92(126°39'11.4 10
 
4.5%
604.05(126°39'29.2 10
 
4.5%
694.71(126°39'39.6 10
 
4.5%
700.71(126°39'40.2 10
 
4.5%
489.43(126°39'19.7 10
 
4.5%
447.41(126°39'09.1 10
 
4.5%
Other values (12) 120
54.5%

좌표(X), 경도
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
367.98(37°29'49.2")
 
10
426.94(37°29'55.0")
 
10
431.26(37°29'55.7")
 
10
316.22(37°29'44.5")
 
10
252.95(37°29'38.4")
 
10
Other values (17)
170 

Length

Max length19
Median length19
Mean length18.818182
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row367.98(37°29'49.2")
2nd row426.94(37°29'55.0")
3rd row431.26(37°29'55.7")
4th row316.22(37°29'44.5")
5th row252.95(37°29'38.4")

Common Values

ValueCountFrequency (%)
367.98(37°29'49.2") 10
 
4.5%
426.94(37°29'55.0") 10
 
4.5%
431.26(37°29'55.7") 10
 
4.5%
316.22(37°29'44.5") 10
 
4.5%
252.95(37°29'38.4") 10
 
4.5%
344.98(37°29'47.8") 10
 
4.5%
310.46(37°29'43.8") 10
 
4.5%
366.55(37°29'49.6") 10
 
4.5%
324.47(37°29'44.9") 10
 
4.5%
599.76(37°30'08.9") 10
 
4.5%
Other values (12) 120
54.5%

Length

2023-12-12T08:15:36.978131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
367.98(37°29'49.2 10
 
4.5%
426.94(37°29'55.0 10
 
4.5%
272.83(37°29'40.5 10
 
4.5%
103(37°29'22.6 10
 
4.5%
83.76(37°29'21.8 10
 
4.5%
116.39(37°29'24.6 10
 
4.5%
275.25(37°29'39.5 10
 
4.5%
440.91(37°29'56.2 10
 
4.5%
445.71(37°29'56.9 10
 
4.5%
562.16(37°30'08.2 10
 
4.5%
Other values (12) 120
54.5%

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

Distinct112
Distinct (%)50.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.9268182
Minimum1.3
Maximum100.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T08:15:37.176265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.3
5-th percentile1.5
Q12.4
median4.3
Q310.225
95-th percentile30.005
Maximum100.5
Range99.2
Interquartile range (IQR)7.825

Descriptive statistics

Standard deviation11.509573
Coefficient of variation (CV)1.2893254
Kurtosis20.01159
Mean8.9268182
Median Absolute Deviation (MAD)2.5
Skewness3.5631801
Sum1963.9
Variance132.47028
MonotonicityNot monotonic
2023-12-12T08:15:37.347018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.5 8
 
3.6%
1.8 7
 
3.2%
2.4 7
 
3.2%
2.5 7
 
3.2%
3.0 6
 
2.7%
2.0 6
 
2.7%
2.2 6
 
2.7%
2.6 5
 
2.3%
2.1 5
 
2.3%
3.3 5
 
2.3%
Other values (102) 158
71.8%
ValueCountFrequency (%)
1.3 4
1.8%
1.4 5
2.3%
1.5 8
3.6%
1.6 4
1.8%
1.7 1
 
0.5%
1.8 7
3.2%
1.9 2
 
0.9%
2.0 6
2.7%
2.1 5
2.3%
2.2 6
2.7%
ValueCountFrequency (%)
100.5 1
0.5%
61.0 1
0.5%
50.6 1
0.5%
40.2 1
0.5%
38.0 1
0.5%
37.7 1
0.5%
36.9 1
0.5%
31.5 1
0.5%
31.1 1
0.5%
30.2 1
0.5%

Interactions

2023-12-12T08:15:35.435942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:15:37.448730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
측정일자측정지점주소(위치정보)좌표(Y), 위도좌표(X), 경도Z(측정값(복합악취희석배수))
측정일자1.0000.0000.0000.0000.0000.536
측정지점0.0001.0001.0001.0001.0000.335
주소(위치정보)0.0001.0001.0001.0001.0000.449
좌표(Y), 위도0.0001.0001.0001.0001.0000.335
좌표(X), 경도0.0001.0001.0001.0001.0000.335
Z(측정값(복합악취희석배수))0.5360.3350.4490.3350.3351.000
2023-12-12T08:15:37.557973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
좌표(X), 경도주소(위치정보)측정지점좌표(Y), 위도
좌표(X), 경도1.0000.9831.0001.000
주소(위치정보)0.9831.0000.9830.983
측정지점1.0000.9831.0001.000
좌표(Y), 위도1.0000.9831.0001.000
2023-12-12T08:15:37.656794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Z(측정값(복합악취희석배수))측정지점주소(위치정보)좌표(Y), 위도좌표(X), 경도
Z(측정값(복합악취희석배수))1.0000.1430.2170.1430.143
측정지점0.1431.0000.9831.0001.000
주소(위치정보)0.2170.9831.0000.9830.983
좌표(Y), 위도0.1431.0000.9831.0001.000
좌표(X), 경도0.1431.0000.9831.0001.000

Missing values

2023-12-12T08:15:35.576498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:15:35.726097image/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), 경도Z(측정값(복합악취희석배수))
0가좌사업소2022-09-191단계 종침 2,3계열인천 서구 중봉대로 211220.12(126°38'43.1")367.98(37°29'49.2")12.1
1가좌사업소2022-09-19관리동 앞인천 서구 중봉대로 211284.83(126°38'48.8")426.94(37°29'55.0")7.8
2가좌사업소2022-09-19분뇨 증설부지인천 서구 중봉대로 211146.78(126°38'32.3")431.26(37°29'55.7")13.2
3가좌사업소2022-09-19위생동 주차장인천 서구 중봉대로 211149.66(126°38'31.9")316.22(37°29'44.5")9.0
4가좌사업소2022-09-19관사 앞인천 서구 중봉대로 211283.39(126°38'49.2")252.95(37°29'38.4")7.3
5가좌사업소2022-09-192단계 탈수기동인천 서구 중봉대로 211175.54(126°38'35.9")344.98(37°29'47.8")9.8
6가좌사업소2022-09-191단계 탈수기동인천 서구 중봉대로 211230.19(126°38'43.8")310.46(37°29'43.8")6.9
7가좌사업소2022-09-191단계 주분배조인천 서구 중봉대로 211286.27(126°38'49.2")366.55(37°29'49.6")9.5
8가좌사업소2022-09-19북항5부두 삼거리인천 서구 가좌동 597128.09(126°38'28.3")324.47(37°29'44.9")23.8
9가좌사업소2022-09-19현대연료 앞인천 서구 원석로 78137.70(126°38'30.4")599.76(37°30'08.9")30.0
관할사업소측정일자측정지점주소(위치정보)좌표(Y), 위도좌표(X), 경도Z(측정값(복합악취희석배수))
210가좌사업소2023-06-12서인천선착장 사거리인천 서구 석남동 641-1322.57(126°38'53.8")708.61(37°30'22.7")22.6
211가좌사업소2023-06-12미래E비젼 앞인천 서구 건진로97번길 33447.41(126°39'09.1")562.16(37°30'08.2")61.0
212가좌사업소2023-06-12SIMPAC 앞인천 서구 건지로 122489.43(126°39'19.7")445.71(37°29'56.9")19.1
213가좌사업소2023-06-12모래방죽 사거리인천 서구 봉수대로 257700.71(126°39'40.2")440.91(37°29'56.2")25.1
214가좌사업소2023-06-12아주목재 앞인천 서구 봉수대로 203694.71(126°39'39.6")275.25(37°29'39.5")23.8
215가좌사업소2023-06-12㈜지씨비전 앞인천 서구 봉수대로 161번길 28604.05(126°39'29.2")116.39(37°29'24.6")21.2
216가좌사업소2023-06-12인천산업용품유통센터인천 서구 백범로 954463.92(126°39'11.4")83.76(37°29'21.8")29.1
217가좌사업소2023-06-12인천교 유수지인천 동구 송현동 148283.22(126°38'49.5")103(37°29'22.6")37.7
218가좌사업소2023-06-12폐차장 수로인천 서구 보도진로13344.29(126°38'55.9")272.83(37°29'40.5")17.1
219가좌사업소2023-06-12세미산업 사거리인천 서구 보도진로 67535.87(126°39'19.3")238.53(37°29'36.1")28.2