Overview

Dataset statistics

Number of variables9
Number of observations40
Missing cells40
Missing cells (%)11.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory76.3 B

Variable types

Categorical5
Text2
DateTime1
Unsupported1

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=15099984

Alerts

시도명 has constant value ""Constant
시군구명 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 40 (100.0%) missing valuesMissing
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 21:40:00.204930
Analysis finished2024-01-09 21:40:00.619741
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
충청남도
40 

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 (%)
충청남도 40
100.0%

Length

2024-01-10T06:40:00.664517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:40:00.733911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 40
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
서산시
40 

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 (%)
서산시 40
100.0%

Length

2024-01-10T06:40:00.807928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:40:00.876751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서산시 40
100.0%

설치주소
Text

Distinct37
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2024-01-10T06:40:01.034088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length12
Min length7

Characters and Unicode

Total characters480
Distinct characters71
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

Unique34 ?
Unique (%)85.0%

Sample

1st row대산읍 가로림로 64
2nd row대산읍 개화1길 3
3rd row대산읍 독곶리 295-7
4th row대산읍 망일산로 834-6
5th row대산읍 반곡길 35
ValueCountFrequency (%)
대산읍 13
 
11.3%
음암면 8
 
7.0%
부석면 8
 
7.0%
충의로 3
 
2.6%
팔봉면 3
 
2.6%
간월도리 3
 
2.6%
창리 3
 
2.6%
반곡길 2
 
1.7%
어송리 2
 
1.7%
갈산동 2
 
1.7%
Other values (61) 68
59.1%
2024-01-10T06:40:01.329276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
75
 
15.6%
3 27
 
5.6%
2 24
 
5.0%
1 22
 
4.6%
- 22
 
4.6%
면 21
 
4.4%
산 19
 
4.0%
리 18
 
3.8%
9 16
 
3.3%
읍 15
 
3.1%
Other values (61) 221
46.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 232
48.3%
Decimal Number 151
31.5%
Space Separator 75
 
15.6%
Dash Punctuation 22
 
4.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 21
 
9.1%
산 19
 
8.2%
리 18
 
7.8%
읍 15
 
6.5%
로 14
 
6.0%
대 13
 
5.6%
석 10
 
4.3%
음 9
 
3.9%
암 9
 
3.9%
부 8
 
3.4%
Other values (49) 96
41.4%
Decimal Number
ValueCountFrequency (%)
3 27
17.9%
2 24
15.9%
1 22
14.6%
9 16
10.6%
5 13
8.6%
6 12
7.9%
7 12
7.9%
4 11
7.3%
8 8
 
5.3%
0 6
 
4.0%
Space Separator
ValueCountFrequency (%)
75
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 248
51.7%
Hangul 232
48.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 21
 
9.1%
산 19
 
8.2%
리 18
 
7.8%
읍 15
 
6.5%
로 14
 
6.0%
대 13
 
5.6%
석 10
 
4.3%
음 9
 
3.9%
암 9
 
3.9%
부 8
 
3.4%
Other values (49) 96
41.4%
Common
ValueCountFrequency (%)
75
30.2%
3 27
 
10.9%
2 24
 
9.7%
1 22
 
8.9%
- 22
 
8.9%
9 16
 
6.5%
5 13
 
5.2%
6 12
 
4.8%
7 12
 
4.8%
4 11
 
4.4%
Other values (2) 14
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 248
51.7%
Hangul 232
48.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
75
30.2%
3 27
 
10.9%
2 24
 
9.7%
1 22
 
8.9%
- 22
 
8.9%
9 16
 
6.5%
5 13
 
5.2%
6 12
 
4.8%
7 12
 
4.8%
4 11
 
4.4%
Other values (2) 14
 
5.6%
Hangul
ValueCountFrequency (%)
면 21
 
9.1%
산 19
 
8.2%
리 18
 
7.8%
읍 15
 
6.5%
로 14
 
6.0%
대 13
 
5.6%
석 10
 
4.3%
음 9
 
3.9%
암 9
 
3.9%
부 8
 
3.4%
Other values (49) 96
41.4%

설치지점
Text

Distinct31
Distinct (%)77.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2024-01-10T06:40:01.486697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length6.925
Min length3

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)72.5%

Sample

1st row한미아파트
2nd row화곡2리 마을회관 앞
3rd row독곶1리 마을회관 앞
4th row휴먼시아아파트
5th row화곡1리 마을회관 앞
ValueCountFrequency (%)
도로변 9
 
13.8%
마을회관 7
 
10.8%
앞 7
 
10.8%
대산읍 3
 
4.6%
주차장 3
 
4.6%
근처 2
 
3.1%
삼길포항 2
 
3.1%
화곡1리 2
 
3.1%
운산4리 2
 
3.1%
식당옆 2
 
3.1%
Other values (26) 26
40.0%
2024-01-10T06:40:01.738183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25
 
9.0%
트 12
 
4.3%
아 12
 
4.3%
파 11
 
4.0%
도 9
 
3.2%
로 9
 
3.2%
을 9
 
3.2%
마 9
 
3.2%
리 9
 
3.2%
변 9
 
3.2%
Other values (78) 163
58.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 246
88.8%
Space Separator 25
 
9.0%
Decimal Number 6
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
트 12
 
4.9%
아 12
 
4.9%
파 11
 
4.5%
도 9
 
3.7%
로 9
 
3.7%
을 9
 
3.7%
마 9
 
3.7%
리 9
 
3.7%
변 9
 
3.7%
관 7
 
2.8%
Other values (74) 150
61.0%
Decimal Number
ValueCountFrequency (%)
1 3
50.0%
4 2
33.3%
2 1
 
16.7%
Space Separator
ValueCountFrequency (%)
25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 246
88.8%
Common 31
 
11.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
트 12
 
4.9%
아 12
 
4.9%
파 11
 
4.5%
도 9
 
3.7%
로 9
 
3.7%
을 9
 
3.7%
마 9
 
3.7%
리 9
 
3.7%
변 9
 
3.7%
관 7
 
2.8%
Other values (74) 150
61.0%
Common
ValueCountFrequency (%)
25
80.6%
1 3
 
9.7%
4 2
 
6.5%
2 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 246
88.8%
ASCII 31
 
11.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
25
80.6%
1 3
 
9.7%
4 2
 
6.5%
2 1
 
3.2%
Hangul
ValueCountFrequency (%)
트 12
 
4.9%
아 12
 
4.9%
파 11
 
4.5%
도 9
 
3.7%
로 9
 
3.7%
을 9
 
3.7%
마 9
 
3.7%
리 9
 
3.7%
변 9
 
3.7%
관 7
 
2.8%
Other values (74) 150
61.0%

쓰레기통 종류
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)17.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
일반쓰레기통 및 분리수거대(클린하우스)
17 
일반쓰레기통 및 분리수거대(아파트단지내)
12 
클린하우스
5 
일반쓰레기
2 
재활용쓰레기
2 
Other values (2)
2 

Length

Max length22
Median length21
Mean length17.175
Min length5

Unique

Unique2 ?
Unique (%)5.0%

Sample

1st row일반쓰레기통 및 분리수거대(아파트단지내)
2nd row일반쓰레기통 및 분리수거대(클린하우스)
3rd row일반쓰레기통 및 분리수거대(클린하우스)
4th row일반쓰레기통 및 분리수거대(아파트단지내)
5th row일반쓰레기통 및 분리수거대(클린하우스)

Common Values

ValueCountFrequency (%)
일반쓰레기통 및 분리수거대(클린하우스) 17
42.5%
일반쓰레기통 및 분리수거대(아파트단지내) 12
30.0%
클린하우스 5
 
12.5%
일반쓰레기 2
 
5.0%
재활용쓰레기 2
 
5.0%
음식물쓰레기 1
 
2.5%
일반쓰레기, 재활용쓰레기 1
 
2.5%

Length

2024-01-10T06:40:01.846701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:40:01.939903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반쓰레기통 29
29.3%
및 29
29.3%
분리수거대(클린하우스 17
17.2%
분리수거대(아파트단지내 12
12.1%
클린하우스 5
 
5.1%
일반쓰레기 3
 
3.0%
재활용쓰레기 3
 
3.0%
음식물쓰레기 1
 
1.0%

관리기관명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)27.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
대산읍 행정복지센터
13 
음암면 행정복지센터
8 
부춘동 행정복지센터
5 
부석면행정복지센터
3 
부석면 행정복지센터
3 
Other values (6)
8 

Length

Max length11
Median length10
Mean length9.775
Min length5

Unique

Unique5 ?
Unique (%)12.5%

Sample

1st row대산읍 행정복지센터
2nd row대산읍 행정복지센터
3rd row대산읍 행정복지센터
4th row대산읍 행정복지센터
5th row대산읍 행정복지센터

Common Values

ValueCountFrequency (%)
대산읍 행정복지센터 13
32.5%
음암면 행정복지센터 8
20.0%
부춘동 행정복지센터 5
 
12.5%
부석면행정복지센터 3
 
7.5%
부석면 행정복지센터 3
 
7.5%
팔봉면 행정복지센터 3
 
7.5%
옥경이네외 식당 1
 
2.5%
창리회타운 1
 
2.5%
성연면 행정복지센터 1
 
2.5%
동문1동 행정복지센터 1
 
2.5%

Length

2024-01-10T06:40:02.060168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
행정복지센터 35
46.1%
대산읍 13
 
17.1%
음암면 8
 
10.5%
부춘동 5
 
6.6%
부석면행정복지센터 3
 
3.9%
부석면 3
 
3.9%
팔봉면 3
 
3.9%
옥경이네외 1
 
1.3%
식당 1
 
1.3%
창리회타운 1
 
1.3%
Other values (3) 3
 
3.9%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
041-660-3717
13 
041-660-3507
8 
041-660-3597
5 
041-660-3431
3 
041-660-3787
3 
Other values (7)
8 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique6 ?
Unique (%)15.0%

Sample

1st row041-660-3717
2nd row041-660-3717
3rd row041-660-3717
4th row041-660-3717
5th row041-660-3717

Common Values

ValueCountFrequency (%)
041-660-3717 13
32.5%
041-660-3507 8
20.0%
041-660-3597 5
 
12.5%
041-660-3431 3
 
7.5%
041-660-3787 3
 
7.5%
041-660-3444 2
 
5.0%
041-662-4103 1
 
2.5%
041-662-1020 1
 
2.5%
041-660-3492 1
 
2.5%
041-660-3608 1
 
2.5%
Other values (2) 2
 
5.0%

Length

2024-01-10T06:40:02.148132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
041-660-3717 13
32.5%
041-660-3507 8
20.0%
041-660-3597 5
 
12.5%
041-660-3431 3
 
7.5%
041-660-3787 3
 
7.5%
041-660-3444 2
 
5.0%
041-662-4103 1
 
2.5%
041-662-1020 1
 
2.5%
041-660-3492 1
 
2.5%
041-660-3608 1
 
2.5%
Other values (2) 2
 
5.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
Minimum2022-04-27 00:00:00
Maximum2022-04-27 00:00:00
2024-01-10T06:40:02.218064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:40:02.282290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing40
Missing (%)100.0%
Memory size492.0 B

Correlations

2024-01-10T06:40:02.336690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치주소설치지점쓰레기통 종류관리기관명관리기관전화번호
설치주소1.0000.0001.0001.0001.000
설치지점0.0001.0000.0000.0000.000
쓰레기통 종류1.0000.0001.0000.8770.929
관리기관명1.0000.0000.8771.0001.000
관리기관전화번호1.0000.0000.9291.0001.000
2024-01-10T06:40:02.413741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명관리기관전화번호쓰레기통 종류
관리기관명1.0000.9830.647
관리기관전화번호0.9831.0000.738
쓰레기통 종류0.6470.7381.000
2024-01-10T06:40:02.485189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
쓰레기통 종류관리기관명관리기관전화번호
쓰레기통 종류1.0000.6470.738
관리기관명0.6471.0000.983
관리기관전화번호0.7380.9831.000

Missing values

2024-01-10T06:40:00.479101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:40:00.579440image/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충청남도서산시대산읍 가로림로 64한미아파트일반쓰레기통 및 분리수거대(아파트단지내)대산읍 행정복지센터041-660-37172022-04-27<NA>
1충청남도서산시대산읍 개화1길 3화곡2리 마을회관 앞일반쓰레기통 및 분리수거대(클린하우스)대산읍 행정복지센터041-660-37172022-04-27<NA>
2충청남도서산시대산읍 독곶리 295-7독곶1리 마을회관 앞일반쓰레기통 및 분리수거대(클린하우스)대산읍 행정복지센터041-660-37172022-04-27<NA>
3충청남도서산시대산읍 망일산로 834-6휴먼시아아파트일반쓰레기통 및 분리수거대(아파트단지내)대산읍 행정복지센터041-660-37172022-04-27<NA>
4충청남도서산시대산읍 반곡길 35화곡1리 마을회관 앞일반쓰레기통 및 분리수거대(클린하우스)대산읍 행정복지센터041-660-37172022-04-27<NA>
5충청남도서산시대산읍 운산리길 1432운산4리 마을회관 앞일반쓰레기통 및 분리수거대(클린하우스)대산읍 행정복지센터041-660-37172022-04-27<NA>
6충청남도서산시대산읍 충의로 1839-7풍림아파트일반쓰레기통 및 분리수거대(아파트단지내)대산읍 행정복지센터041-660-37172022-04-27<NA>
7충청남도서산시대산읍 충의로 2061삼호아파트일반쓰레기통 및 분리수거대(아파트단지내)대산읍 행정복지센터041-660-37172022-04-27<NA>
8충청남도서산시대산읍 충의로 2083대원그린빌아파트일반쓰레기통 및 분리수거대(아파트단지내)대산읍 행정복지센터041-660-37172022-04-27<NA>
9충청남도서산시대산읍 화곡리 1891삼길포항 주차장일반쓰레기통 및 분리수거대(클린하우스)대산읍 행정복지센터041-660-37172022-04-27<NA>
시도명시군구명설치주소설치지점쓰레기통 종류관리기관명관리기관전화번호데이터기준일자비고
30충청남도서산시음암면 서령로 330음암마을아파트일반쓰레기통 및 분리수거대(아파트단지내)음암면 행정복지센터041-660-35072022-04-27<NA>
31충청남도서산시음암면 석동로 36개나리아파트일반쓰레기통 및 분리수거대(아파트단지내)음암면 행정복지센터041-660-35072022-04-27<NA>
32충청남도서산시음암면 음암로 499수림미소가아파트일반쓰레기통 및 분리수거대(아파트단지내)음암면 행정복지센터041-660-35072022-04-27<NA>
33충청남도서산시음암면 칠거리로 12동서산영무예다음일반쓰레기통 및 분리수거대(아파트단지내)음암면 행정복지센터041-660-35072022-04-27<NA>
34충청남도서산시읍내동 136-5도로변클린하우스부춘동 행정복지센터041-660-35972022-04-27<NA>
35충청남도서산시읍내동 323-7도로변클린하우스부춘동 행정복지센터041-660-35972022-04-27<NA>
36충청남도서산시팔봉면 어송리 1457-4도로변클린하우스팔봉면 행정복지센터041-660-34442022-04-27<NA>
37충청남도서산시팔봉면 어송리 1759도로변일반쓰레기, 재활용쓰레기팔봉면 행정복지센터041-660-34452022-04-27<NA>
38충청남도서산시팔봉면 진장리 산 79-2도로변클린하우스팔봉면 행정복지센터041-660-34442022-04-27<NA>
39충청남도서산시해미면 남문2로 1433문화시설사업소 해미읍성 내클린하우스해미면 행정복지센터041-660-35432022-04-27<NA>