Overview

Dataset statistics

Number of variables8
Number of observations50
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory69.6 B

Variable types

Numeric3
Text2
Categorical3

Dataset

Description충청남도 보령시의 환경기초시설(분뇨처리장, 폐수처리장, 하수처리시설 등)에 대한 시설명, 가동여부, 소재지 주소, 관리기관, 위경도 정보를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=103&beforeMenuCd=DOM_000000201001001000&publicdatapk=15100526

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
시설명 has unique valuesUnique
소재지 주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:16:50.791615
Analysis finished2024-01-09 20:16:51.928023
Duration1.14 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.5
Minimum1
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2024-01-10T05:16:52.017314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.45
Q113.25
median25.5
Q337.75
95-th percentile47.55
Maximum50
Range49
Interquartile range (IQR)24.5

Descriptive statistics

Standard deviation14.57738
Coefficient of variation (CV)0.57166195
Kurtosis-1.2
Mean25.5
Median Absolute Deviation (MAD)12.5
Skewness0
Sum1275
Variance212.5
MonotonicityStrictly increasing
2024-01-10T05:16:52.161290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
2.0%
39 1
 
2.0%
29 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
36 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
ValueCountFrequency (%)
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%

시설명
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-01-10T05:16:52.360664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length11.28
Min length7

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)100.0%

Sample

1st row보령분뇨처리장
2nd row보령축산폐수공공처리장
3rd row죽도공공하수처리시설
4th row도화담공공하수처리시설
5th row금암리공공하수처리시설
ValueCountFrequency (%)
보령분뇨처리장 1
 
2.0%
깊은골공공하수처리시설 1
 
2.0%
보령내평하수처리시설 1
 
2.0%
홍보(1)공공하수처리시설 1
 
2.0%
신죽공공하수처리시설 1
 
2.0%
라원(2)공공하수처리시설 1
 
2.0%
개화(기도원)공공하수처리시설 1
 
2.0%
개화(석재)공공하수처리시설 1
 
2.0%
개화(보창)공공하수처리시설 1
 
2.0%
라원리공공하수처리시설 1
 
2.0%
Other values (40) 40
80.0%
2024-01-10T05:16:52.743653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
공 90
16.0%
리 58
 
10.3%
수 51
 
9.0%
처 50
 
8.9%
시 46
 
8.2%
하 46
 
8.2%
설 45
 
8.0%
보 10
 
1.8%
( 9
 
1.6%
) 9
 
1.6%
Other values (78) 150
26.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 539
95.6%
Open Punctuation 9
 
1.6%
Close Punctuation 9
 
1.6%
Decimal Number 7
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 90
16.7%
리 58
10.8%
수 51
 
9.5%
처 50
 
9.3%
시 46
 
8.5%
하 46
 
8.5%
설 45
 
8.3%
보 10
 
1.9%
령 7
 
1.3%
장 7
 
1.3%
Other values (73) 129
23.9%
Decimal Number
ValueCountFrequency (%)
1 3
42.9%
2 2
28.6%
3 2
28.6%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 539
95.6%
Common 25
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 90
16.7%
리 58
10.8%
수 51
 
9.5%
처 50
 
9.3%
시 46
 
8.5%
하 46
 
8.5%
설 45
 
8.3%
보 10
 
1.9%
령 7
 
1.3%
장 7
 
1.3%
Other values (73) 129
23.9%
Common
ValueCountFrequency (%)
( 9
36.0%
) 9
36.0%
1 3
 
12.0%
2 2
 
8.0%
3 2
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 539
95.6%
ASCII 25
 
4.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
공 90
16.7%
리 58
10.8%
수 51
 
9.5%
처 50
 
9.3%
시 46
 
8.5%
하 46
 
8.5%
설 45
 
8.3%
보 10
 
1.9%
령 7
 
1.3%
장 7
 
1.3%
Other values (73) 129
23.9%
ASCII
ValueCountFrequency (%)
( 9
36.0%
) 9
36.0%
1 3
 
12.0%
2 2
 
8.0%
3 2
 
8.0%

가동여부
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
가동중
50 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가동중
2nd row가동중
3rd row가동중
4th row가동중
5th row가동중

Common Values

ValueCountFrequency (%)
가동중 50
100.0%

Length

2024-01-10T05:16:53.108822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:16:53.192226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가동중 50
100.0%

소재지 주소
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-01-10T05:16:53.394650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length20.94
Min length16

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)100.0%

Sample

1st row충청남도 보령시 대천동 1387
2nd row충청남도 보령시 천북면 신죽리 890
3rd row충청남도 보령시 남포면 월전리 843
4th row충청남도 보령시 미산면 도화담리 204-3
5th row충청남도 보령시 주산면 금암리 638-1
ValueCountFrequency (%)
충청남도 50
20.5%
보령시 50
20.5%
오천면 8
 
3.3%
미산면 7
 
2.9%
남포면 6
 
2.5%
청라면 5
 
2.0%
성주면 4
 
1.6%
개화리 4
 
1.6%
웅천읍 4
 
1.6%
천북면 3
 
1.2%
Other values (89) 103
42.2%
2024-01-10T05:16:53.813016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
194
18.5%
청 58
 
5.5%
남 57
 
5.4%
도 54
 
5.2%
시 51
 
4.9%
충 50
 
4.8%
보 50
 
4.8%
령 50
 
4.8%
리 45
 
4.3%
면 41
 
3.9%
Other values (65) 397
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 640
61.1%
Space Separator 194
 
18.5%
Decimal Number 182
 
17.4%
Dash Punctuation 31
 
3.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 58
 
9.1%
남 57
 
8.9%
도 54
 
8.4%
시 51
 
8.0%
충 50
 
7.8%
보 50
 
7.8%
령 50
 
7.8%
리 45
 
7.0%
면 41
 
6.4%
천 17
 
2.7%
Other values (53) 167
26.1%
Decimal Number
ValueCountFrequency (%)
1 40
22.0%
4 24
13.2%
2 24
13.2%
7 19
10.4%
3 18
9.9%
5 16
 
8.8%
8 12
 
6.6%
6 12
 
6.6%
0 10
 
5.5%
9 7
 
3.8%
Space Separator
ValueCountFrequency (%)
194
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 640
61.1%
Common 407
38.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 58
 
9.1%
남 57
 
8.9%
도 54
 
8.4%
시 51
 
8.0%
충 50
 
7.8%
보 50
 
7.8%
령 50
 
7.8%
리 45
 
7.0%
면 41
 
6.4%
천 17
 
2.7%
Other values (53) 167
26.1%
Common
ValueCountFrequency (%)
194
47.7%
1 40
 
9.8%
- 31
 
7.6%
4 24
 
5.9%
2 24
 
5.9%
7 19
 
4.7%
3 18
 
4.4%
5 16
 
3.9%
8 12
 
2.9%
6 12
 
2.9%
Other values (2) 17
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 640
61.1%
ASCII 407
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
194
47.7%
1 40
 
9.8%
- 31
 
7.6%
4 24
 
5.9%
2 24
 
5.9%
7 19
 
4.7%
3 18
 
4.4%
5 16
 
3.9%
8 12
 
2.9%
6 12
 
2.9%
Other values (2) 17
 
4.2%
Hangul
ValueCountFrequency (%)
청 58
 
9.1%
남 57
 
8.9%
도 54
 
8.4%
시 51
 
8.0%
충 50
 
7.8%
보 50
 
7.8%
령 50
 
7.8%
리 45
 
7.0%
면 41
 
6.4%
천 17
 
2.7%
Other values (53) 167
26.1%

관리기관
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
테크로스환경서비스
25 
보령시시설관리공단
17 
㈜테크로스환경서비스
4 
서해환경
 
2
㈜티에스케이워터
 
1

Length

Max length12
Median length9
Mean length8.92
Min length4

Unique

Unique2 ?
Unique (%)4.0%

Sample

1st row보령시시설관리공단
2nd row보령시시설관리공단
3rd row보령시시설관리공단
4th row보령시시설관리공단
5th row보령시시설관리공단

Common Values

ValueCountFrequency (%)
테크로스환경서비스 25
50.0%
보령시시설관리공단 17
34.0%
㈜테크로스환경서비스 4
 
8.0%
서해환경 2
 
4.0%
㈜티에스케이워터 1
 
2.0%
(주)테크로스환경서비스 1
 
2.0%

Length

2024-01-10T05:16:53.953819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:16:54.049552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
테크로스환경서비스 25
50.0%
보령시시설관리공단 17
34.0%
㈜테크로스환경서비스 4
 
8.0%
서해환경 2
 
4.0%
㈜티에스케이워터 1
 
2.0%
주)테크로스환경서비스 1
 
2.0%

위도
Real number (ℝ)

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.339004
Minimum36.200678
Maximum36.485225
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2024-01-10T05:16:54.153266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.200678
5-th percentile36.223325
Q136.292228
median36.329677
Q336.396696
95-th percentile36.461874
Maximum36.485225
Range0.284547
Interquartile range (IQR)0.1044685

Descriptive statistics

Standard deviation0.07772246
Coefficient of variation (CV)0.0021388165
Kurtosis-0.97373793
Mean36.339004
Median Absolute Deviation (MAD)0.0604945
Skewness0.015622905
Sum1816.9502
Variance0.0060407808
MonotonicityNot monotonic
2024-01-10T05:16:54.263978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.354569 1
 
2.0%
36.306095 1
 
2.0%
36.485225 1
 
2.0%
36.386068 1
 
2.0%
36.304997 1
 
2.0%
36.298009 1
 
2.0%
36.295865 1
 
2.0%
36.391428 1
 
2.0%
36.224235 1
 
2.0%
36.375914 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
36.200678 1
2.0%
36.21079 1
2.0%
36.222581 1
2.0%
36.224235 1
2.0%
36.224497 1
2.0%
36.225659 1
2.0%
36.238267 1
2.0%
36.239084 1
2.0%
36.245012 1
2.0%
36.261233 1
2.0%
ValueCountFrequency (%)
36.485225 1
2.0%
36.478009 1
2.0%
36.475003 1
2.0%
36.445828 1
2.0%
36.438763 1
2.0%
36.434767 1
2.0%
36.430924 1
2.0%
36.427415 1
2.0%
36.423536 1
2.0%
36.420608 1
2.0%

경도
Real number (ℝ)

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.58732
Minimum126.26162
Maximum126.68873
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2024-01-10T05:16:54.379037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.26162
5-th percentile126.45205
Q1126.55637
median126.59097
Q3126.65334
95-th percentile126.68061
Maximum126.68873
Range0.427104
Interquartile range (IQR)0.09696775

Descriptive statistics

Standard deviation0.083280775
Coefficient of variation (CV)0.00065789193
Kurtosis4.4010447
Mean126.58732
Median Absolute Deviation (MAD)0.053598
Skewness-1.6241996
Sum6329.3659
Variance0.0069356874
MonotonicityNot monotonic
2024-01-10T05:16:54.495012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.556207 1
 
2.0%
126.523625 1
 
2.0%
126.59732 1
 
2.0%
126.687657 1
 
2.0%
126.649265 1
 
2.0%
126.654057 1
 
2.0%
126.651095 1
 
2.0%
126.679418 1
 
2.0%
126.536403 1
 
2.0%
126.550227 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
126.261622 1
2.0%
126.36132 1
2.0%
126.40954 1
2.0%
126.504004 1
2.0%
126.5191 1
2.0%
126.523625 1
2.0%
126.524373 1
2.0%
126.532929 1
2.0%
126.536403 1
2.0%
126.538335 1
2.0%
ValueCountFrequency (%)
126.688726 1
2.0%
126.687657 1
2.0%
126.680669 1
2.0%
126.680536 1
2.0%
126.679843 1
2.0%
126.679418 1
2.0%
126.677433 1
2.0%
126.677431 1
2.0%
126.672021 1
2.0%
126.661698 1
2.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-05-25
50 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-05-25
2nd row2023-05-25
3rd row2023-05-25
4th row2023-05-25
5th row2023-05-25

Common Values

ValueCountFrequency (%)
2023-05-25 50
100.0%

Length

2024-01-10T05:16:54.595434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:16:54.667532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-05-25 50
100.0%

Interactions

2024-01-10T05:16:51.502820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.049946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.276352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.570168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.110476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.354306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.643037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.205688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:16:51.434115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:16:54.714961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분시설명소재지 주소관리기관위도경도
구분1.0001.0001.0000.8010.4090.200
시설명1.0001.0001.0001.0001.0001.000
소재지 주소1.0001.0001.0001.0001.0001.000
관리기관0.8011.0001.0001.0000.0000.000
위도0.4091.0001.0000.0001.0000.000
경도0.2001.0001.0000.0000.0001.000
2024-01-10T05:16:54.799222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분위도경도관리기관
구분1.000-0.0390.0110.558
위도-0.0391.000-0.3180.000
경도0.011-0.3181.0000.000
관리기관0.5580.0000.0001.000

Missing values

2024-01-10T05:16:51.743481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:16:51.867618image/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

구분시설명가동여부소재지 주소관리기관위도경도데이터기준일
01보령분뇨처리장가동중충청남도 보령시 대천동 1387보령시시설관리공단36.354569126.5562072023-05-25
12보령축산폐수공공처리장가동중충청남도 보령시 천북면 신죽리 890보령시시설관리공단36.478009126.5967292023-05-25
23죽도공공하수처리시설가동중충청남도 보령시 남포면 월전리 843보령시시설관리공단36.276845126.5383352023-05-25
34도화담공공하수처리시설가동중충청남도 보령시 미산면 도화담리 204-3보령시시설관리공단36.291015126.6720212023-05-25
45금암리공공하수처리시설가동중충청남도 보령시 주산면 금암리 638-1보령시시설관리공단36.200678126.631452023-05-25
56남포공공하수처리시설가동중충청남도 보령시 남포면 읍내리 277-1보령시시설관리공단36.303384126.6101132023-05-25
67야동공공하수처리시설가동중충청남도 보령시 남포면 달산리 1313보령시시설관리공단36.29738126.5893612023-05-25
78호도공공하수처리시설가동중충청남도 보령시 오천면 녹도리보령시시설관리공단36.298463126.2616222023-05-25
89소성리공공하수처리시설가동중충청남도 보령시 오천면 소성리 700-1보령시시설관리공단36.438763126.51912023-05-25
910진죽리공공하수처리시설가동중충청남도 보령시 청소면 진죽리 1193보령시시설관리공단36.445828126.5834772023-05-25
구분시설명가동여부소재지 주소관리기관위도경도데이터기준일
4041보령주포농공단지폐수종말처리장가동중충청남도 보령시 주포면 관산리 320-14서해환경36.401501126.5743432023-05-25
4142청소농공폐수종말처리장가동중충청남도 보령시 청소면 장곡리 1174서해환경36.430924126.5831422023-05-25
4243보령공공하수처리시설가동중충청남도 보령시 대천동 845보령시시설관리공단36.356392126.5568782023-05-25
4344웅천공공하수처리시설가동중충청남도 보령시 웅천읍 대창리 219보령시시설관리공단36.224497126.5971992023-05-25
4445무창포공공하수처리시설가동중충청남도 보령시 웅천읍 독산리 산8-3보령시시설관리공단36.239084126.5329292023-05-25
4546성주공공하수처리시설가동중충청남도 보령시 성주면 개화리 174-2보령시시설관리공단36.31572126.6587972023-05-25
4647하만공공하수처리시설가동중충청남도 보령시 천북면 하만리 127-2㈜테크로스환경서비스36.475003126.5243732023-05-25
4748삽시도공공하수처리시설가동중충청남도 보령시 오천면 삽시도리 산5-1㈜테크로스환경서비스36.351287126.361322023-05-25
4849보령내평하수처리시설가동중충청남도 보령시 미산면 내평리 357-2㈜테크로스환경서비스36.21079126.6774312023-05-25
4950보령봉성하수처리시설가동중충청남도 보령시 미산면 봉성리 512㈜테크로스환경서비스36.238267126.6887262023-05-25