Overview

Dataset statistics

Number of variables10
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory85.9 B

Variable types

Categorical6
Text1
Numeric1
DateTime2

Dataset

Description경기도 여주시 토양오염에 따른 정화명령내역(업소명, 소재지, 오염원, 오염도, 정화명령일, 명령내용, 이행일자, 이행내용, 이행여부확인)을 제공합니다.
Author경기도 여주시
URLhttps://www.data.go.kr/data/15038591/fileData.do

Alerts

이행여부확인결과 has constant value ""Constant
비고 has constant value ""Constant
명령내용 is highly overall correlated with 이행내용High correlation
이행내용 is highly overall correlated with 명령내용High correlation
오염도 has unique valuesUnique

Reproduction

Analysis started2024-03-16 04:19:08.183085
Analysis finished2024-03-16 04:19:09.857493
Duration1.67 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Categorical

Distinct6
Distinct (%)22.2%
Missing0
Missing (%)0.0%
Memory size348.0 B
**주유소
19 
**뱅크㈜
2 
**휴게소
2 
(구)**주유소
2 
**관리대
 
1

Length

Max length8
Median length5
Mean length5.2962963
Min length5

Unique

Unique2 ?
Unique (%)7.4%

Sample

1st row**주유소
2nd row**주유소
3rd row**주유소
4th row**주유소
5th row**주유소

Common Values

ValueCountFrequency (%)
**주유소 19
70.4%
**뱅크㈜ 2
 
7.4%
**휴게소 2
 
7.4%
(구)**주유소 2
 
7.4%
**관리대 1
 
3.7%
제**55부대 1
 
3.7%

Length

2024-03-16T13:19:10.033531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:10.229028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 19
70.4%
뱅크㈜ 2
 
7.4%
휴게소 2
 
7.4%
구)**주유소 2
 
7.4%
관리대 1
 
3.7%
제**55부대 1
 
3.7%

소재지
Text

Distinct19
Distinct (%)70.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-03-16T13:19:10.503953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length14
Min length11

Characters and Unicode

Total characters378
Distinct characters45
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique13 ?
Unique (%)48.1%

Sample

1st row경기도 여주시 가남면 삼군리
2nd row경기도 여주시 대신면 계림리 일대
3rd row경기도 여주시 가남면 신해리
4th row여주군 여주읍 오학동
5th row경기도 여주시 흥천면 다대리
ValueCountFrequency (%)
경기도 25
25.0%
여주시 25
25.0%
가남읍 7
 
7.0%
여주읍 4
 
4.0%
경충대로 3
 
3.0%
점봉리 3
 
3.0%
흥천면 3
 
3.0%
여주남로 3
 
3.0%
대신면 3
 
3.0%
가남면 2
 
2.0%
Other values (17) 22
22.0%
2024-03-16T13:19:11.203457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
73
19.3%
여 36
 
9.5%
주 34
 
9.0%
경 28
 
7.4%
도 26
 
6.9%
시 25
 
6.6%
기 25
 
6.6%
로 13
 
3.4%
남 12
 
3.2%
가 11
 
2.9%
Other values (35) 95
25.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 305
80.7%
Space Separator 73
 
19.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 36
11.8%
주 34
11.1%
경 28
 
9.2%
도 26
 
8.5%
시 25
 
8.2%
기 25
 
8.2%
로 13
 
4.3%
남 12
 
3.9%
가 11
 
3.6%
리 11
 
3.6%
Other values (34) 84
27.5%
Space Separator
ValueCountFrequency (%)
73
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 305
80.7%
Common 73
 
19.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 36
11.8%
주 34
11.1%
경 28
 
9.2%
도 26
 
8.5%
시 25
 
8.2%
기 25
 
8.2%
로 13
 
4.3%
남 12
 
3.9%
가 11
 
3.6%
리 11
 
3.6%
Other values (34) 84
27.5%
Common
ValueCountFrequency (%)
73
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 305
80.7%
ASCII 73
 
19.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
73
100.0%
Hangul
ValueCountFrequency (%)
여 36
11.8%
주 34
11.1%
경 28
 
9.2%
도 26
 
8.5%
시 25
 
8.2%
기 25
 
8.2%
로 13
 
4.3%
남 12
 
3.9%
가 11
 
3.6%
리 11
 
3.6%
Other values (34) 84
27.5%

오염원항목
Categorical

Distinct4
Distinct (%)14.8%
Missing0
Missing (%)0.0%
Memory size348.0 B
TPH
19 
크실렌
6 
벤젠
 
1
Pb
 
1

Length

Max length3
Median length3
Mean length2.9259259
Min length2

Unique

Unique2 ?
Unique (%)7.4%

Sample

1st rowTPH
2nd rowTPH
3rd rowTPH
4th row크실렌
5th rowTPH

Common Values

ValueCountFrequency (%)
TPH 19
70.4%
크실렌 6
 
22.2%
벤젠 1
 
3.7%
Pb 1
 
3.7%

Length

2024-03-16T13:19:11.616478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:11.795899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
tph 19
70.4%
크실렌 6
 
22.2%
벤젠 1
 
3.7%
pb 1
 
3.7%

오염도
Real number (ℝ)

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3899.3045
Minimum8.322
Maximum20019
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2024-03-16T13:19:11.965601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8.322
5-th percentile52.7
Q1223.05
median3905
Q34683.5
95-th percentile10429.6
Maximum20019
Range20010.678
Interquartile range (IQR)4460.45

Descriptive statistics

Standard deviation4300.2922
Coefficient of variation (CV)1.1028357
Kurtosis6.9075241
Mean3899.3045
Median Absolute Deviation (MAD)2320
Skewness2.2244494
Sum105281.22
Variance18492513
MonotonicityNot monotonic
2024-03-16T13:19:12.244218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
6481.0 1
 
3.7%
3881.0 1
 
3.7%
1091.3 1
 
3.7%
66.0 1
 
3.7%
5054.0 1
 
3.7%
2144.0 1
 
3.7%
9311.0 1
 
3.7%
159.4 1
 
3.7%
20019.0 1
 
3.7%
10909.0 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
8.322 1
3.7%
47.0 1
3.7%
66.0 1
3.7%
75.0 1
3.7%
105.0 1
3.7%
132.5 1
3.7%
159.4 1
3.7%
286.7 1
3.7%
1091.3 1
3.7%
2144.0 1
3.7%
ValueCountFrequency (%)
20019.0 1
3.7%
10909.0 1
3.7%
9311.0 1
3.7%
6481.0 1
3.7%
6225.0 1
3.7%
5054.0 1
3.7%
4736.0 1
3.7%
4631.0 1
3.7%
4179.0 1
3.7%
4069.0 1
3.7%

정화명령일자
Date

Distinct21
Distinct (%)77.8%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2010-05-12 00:00:00
Maximum2020-11-03 00:00:00
2024-03-16T13:19:12.468066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:19:12.645106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

명령내용
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)18.5%
Missing0
Missing (%)0.0%
Memory size348.0 B
오염토양정화명령
20 
오염토양시정명령
3 
시설개선 및 오염토양정화명령
 
2
토양정밀조사명령
 
1
시정명령 (누출검사,정밀조사)
 
1

Length

Max length16
Median length8
Mean length8.8148148
Min length8

Unique

Unique2 ?
Unique (%)7.4%

Sample

1st row오염토양정화명령
2nd row오염토양정화명령
3rd row오염토양정화명령
4th row오염토양정화명령
5th row토양정밀조사명령

Common Values

ValueCountFrequency (%)
오염토양정화명령 20
74.1%
오염토양시정명령 3
 
11.1%
시설개선 및 오염토양정화명령 2
 
7.4%
토양정밀조사명령 1
 
3.7%
시정명령 (누출검사,정밀조사) 1
 
3.7%

Length

2024-03-16T13:19:12.852561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:13.098514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오염토양정화명령 22
68.8%
오염토양시정명령 3
 
9.4%
시설개선 2
 
6.2%
및 2
 
6.2%
토양정밀조사명령 1
 
3.1%
시정명령 1
 
3.1%
누출검사,정밀조사 1
 
3.1%

이행일자
Date

Distinct20
Distinct (%)74.1%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2010-10-22 00:00:00
Maximum2023-11-15 00:00:00
2024-03-16T13:19:13.497809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:19:13.738091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)

이행내용
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)18.5%
Missing0
Missing (%)0.0%
Memory size348.0 B
오염토양정화 이행완료
21 
누출검사 토양정밀조사(기준이내)
 
2
토양정밀조사(기준이내)
 
2
토양정밀조사 (기준이내)
 
1
오염토양정화이행완료
 
1

Length

Max length17
Median length11
Mean length11.555556
Min length10

Unique

Unique2 ?
Unique (%)7.4%

Sample

1st row오염토양정화 이행완료
2nd row오염토양정화 이행완료
3rd row오염토양정화 이행완료
4th row오염토양정화 이행완료
5th row토양정밀조사 (기준이내)

Common Values

ValueCountFrequency (%)
오염토양정화 이행완료 21
77.8%
누출검사 토양정밀조사(기준이내) 2
 
7.4%
토양정밀조사(기준이내) 2
 
7.4%
토양정밀조사 (기준이내) 1
 
3.7%
오염토양정화이행완료 1
 
3.7%

Length

2024-03-16T13:19:14.037903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:14.391167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오염토양정화 21
41.2%
이행완료 21
41.2%
토양정밀조사(기준이내 4
 
7.8%
누출검사 2
 
3.9%
토양정밀조사 1
 
2.0%
기준이내 1
 
2.0%
오염토양정화이행완료 1
 
2.0%

이행여부확인결과
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
이행완료
27 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row이행완료
2nd row이행완료
3rd row이행완료
4th row이행완료
5th row이행완료

Common Values

ValueCountFrequency (%)
이행완료 27
100.0%

Length

2024-03-16T13:19:14.698096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:14.881367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
이행완료 27
100.0%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
특정토양오염관리시설
27 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row특정토양오염관리시설
2nd row특정토양오염관리시설
3rd row특정토양오염관리시설
4th row특정토양오염관리시설
5th row특정토양오염관리시설

Common Values

ValueCountFrequency (%)
특정토양오염관리시설 27
100.0%

Length

2024-03-16T13:19:15.024573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:19:15.182274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
특정토양오염관리시설 27
100.0%

Interactions

2024-03-16T13:19:08.725645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-16T13:19:15.305343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지오염원항목오염도정화명령일자명령내용이행일자이행내용
업소명1.0000.9280.0000.6311.0000.0000.9650.435
소재지0.9281.0000.0000.8771.0001.0000.9911.000
오염원항목0.0000.0001.0000.3850.0000.0000.0000.000
오염도0.6310.8770.3851.0000.9080.0000.8140.000
정화명령일자1.0001.0000.0000.9081.0001.0001.0001.000
명령내용0.0001.0000.0000.0001.0001.0001.0000.960
이행일자0.9650.9910.0000.8141.0001.0001.0001.000
이행내용0.4351.0000.0000.0001.0000.9601.0001.000
2024-03-16T13:19:15.502727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명오염원항목명령내용이행내용
업소명1.0000.0000.0000.293
오염원항목0.0001.0000.0000.000
명령내용0.0000.0001.0000.713
이행내용0.2930.0000.7131.000
2024-03-16T13:19:15.673059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
오염도업소명오염원항목명령내용이행내용
오염도1.0000.4200.2380.0000.000
업소명0.4201.0000.0000.0000.293
오염원항목0.2380.0001.0000.0000.000
명령내용0.0000.0000.0001.0000.713
이행내용0.0000.2930.0000.7131.000

Missing values

2024-03-16T13:19:09.426210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-16T13:19:09.747707image/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

업소명소재지오염원항목오염도정화명령일자명령내용이행일자이행내용이행여부확인결과비고
0**주유소경기도 여주시 가남면 삼군리TPH6481.02010-05-12오염토양정화명령2012-04-16오염토양정화 이행완료이행완료특정토양오염관리시설
1**주유소경기도 여주시 대신면 계림리 일대TPH3881.02010-05-13오염토양정화명령2010-10-22오염토양정화 이행완료이행완료특정토양오염관리시설
2**주유소경기도 여주시 가남면 신해리TPH3920.02010-11-03오염토양정화명령2012-07-19오염토양정화 이행완료이행완료특정토양오염관리시설
3**주유소여주군 여주읍 오학동크실렌75.02011-07-05오염토양정화명령2013-12-17오염토양정화 이행완료이행완료특정토양오염관리시설
4**주유소경기도 여주시 흥천면 다대리TPH4631.02011-12-06토양정밀조사명령2012-02-16토양정밀조사 (기준이내)이행완료특정토양오염관리시설
5**주유소여주군 대신면 계림리TPH3952.02012-01-26오염토양정화명령2012-09-03오염토양정화이행완료이행완료특정토양오염관리시설
6**주유소경기도 여주시 여주읍 점봉리벤젠8.3222012-04-16오염토양정화명령2014-05-28오염토양정화 이행완료이행완료특정토양오염관리시설
7**주유소경기도 여주시 여주읍 점봉리크실렌132.52012-04-16오염토양정화명령2014-05-28오염토양정화 이행완료이행완료특정토양오염관리시설
8**주유소경기도 여주시 여주읍 점봉리TPH3043.02012-04-16오염토양정화명령2014-05-28오염토양정화 이행완료이행완료특정토양오염관리시설
9**주유소경기도 여주시 흥천면 문장리TPH3905.02012-06-18오염토양정화명령2013-06-26오염토양정화 이행완료이행완료특정토양오염관리시설
업소명소재지오염원항목오염도정화명령일자명령내용이행일자이행내용이행여부확인결과비고
17**휴게소경기도 여주시 가남읍 여주남로크실렌286.72017-08-28오염토양시정명령2018-02-26토양정밀조사(기준이내)이행완료특정토양오염관리시설
18**주유소경기도 여주시 흥천면 효자로TPH4179.02018-12-07오염토양정화명령2019-08-01오염토양정화 이행완료이행완료특정토양오염관리시설
19제**55부대경기도 여주시 대신면 당산리TPH10909.02019-05-21오염토양정화명령2019-09-03오염토양정화 이행완료이행완료특정토양오염관리시설
20(구)**주유소경기도 여주시 가남읍 설가로TPH20019.02019-06-03오염토양정화명령2019-08-01오염토양정화 이행완료이행완료특정토양오염관리시설
21(구)**주유소경기도 여주시 가남읍 설가로크실렌159.42019-06-03오염토양정화명령2019-08-01오염토양정화 이행완료이행완료특정토양오염관리시설
22**주유소경기도 여주시 여양로TPH9311.02019-07-24오염토양정화명령2020-07-24오염토양정화 이행완료이행완료특정토양오염관리시설
23**주유소경기도 여주시 장여로TPH2144.02020-11-03오염토양시정명령2021-10-19누출검사 토양정밀조사(기준이내)이행완료특정토양오염관리시설
24**주유소경기도 여주시 세종로TPH5054.02020-05-13시설개선 및 오염토양정화명령2022-03-25오염토양정화 이행완료이행완료특정토양오염관리시설
25**주유소경기도 여주시 세종로크실렌66.02020-05-13시설개선 및 오염토양정화명령2022-03-25오염토양정화 이행완료이행완료특정토양오염관리시설
26**주유소경기도 여주시 가남읍 경충대로Pb1091.32020-11-02오염토양정화명령2023-11-15오염토양정화 이행완료이행완료특정토양오염관리시설