Overview

Dataset statistics

Number of variables5
Number of observations167
Missing cells4
Missing cells (%)0.5%
Duplicate rows4
Duplicate rows (%)2.4%
Total size in memory6.7 KiB
Average record size in memory40.8 B

Variable types

Text3
Categorical2

Dataset

Description충청남도 홍성군 음식물쓰레기 다량배출사업장 현황으로 사업장 상호, 주소, 전화번호, 데이터 기준일 등을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=302&beforeMenuCd=DOM_000000201001001000&publicdatapk=15094829

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 4 (2.4%) duplicate rowsDuplicates
전화번호 has 4 (2.4%) missing valuesMissing

Reproduction

Analysis started2024-01-09 20:53:54.631848
Analysis finished2024-01-09 20:53:55.007882
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

Distinct163
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-01-10T05:53:55.141389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length7.2095808
Min length2

Characters and Unicode

Total characters1204
Distinct characters277
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique159 ?
Unique (%)95.2%

Sample

1st row삼거리갈비
2nd row삼정숯불갈비
3rd row서해수산
4th row양평해장국
5th row왕솥단지삼겹살
ValueCountFrequency (%)
청운대학교 3
 
1.5%
갈산중고등학교 2
 
1.0%
홍성점 2
 
1.0%
홍성한우 2
 
1.0%
의료법인 2
 
1.0%
홍성대학로점 2
 
1.0%
혜전대학(여자기숙사 2
 
1.0%
구항초등학교 2
 
1.0%
바다의왕자(홍성.법원점 2
 
1.0%
홍주초등학교 1
 
0.5%
Other values (180) 180
90.0%
2024-01-10T05:53:55.482884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
홍 45
 
3.7%
학 42
 
3.5%
교 37
 
3.1%
성 34
 
2.8%
33
 
2.7%
등 28
 
2.3%
한 20
 
1.7%
식 19
 
1.6%
점 19
 
1.6%
초 18
 
1.5%
Other values (267) 909
75.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1111
92.3%
Space Separator 33
 
2.7%
Close Punctuation 16
 
1.3%
Open Punctuation 16
 
1.3%
Uppercase Letter 10
 
0.8%
Other Punctuation 7
 
0.6%
Decimal Number 5
 
0.4%
Lowercase Letter 5
 
0.4%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 45
 
4.1%
학 42
 
3.8%
교 37
 
3.3%
성 34
 
3.1%
등 28
 
2.5%
한 20
 
1.8%
식 19
 
1.7%
점 19
 
1.7%
초 18
 
1.6%
우 18
 
1.6%
Other values (246) 831
74.8%
Uppercase Letter
ValueCountFrequency (%)
K 2
20.0%
P 2
20.0%
J 1
10.0%
O 1
10.0%
V 1
10.0%
I 1
10.0%
T 1
10.0%
D 1
10.0%
Lowercase Letter
ValueCountFrequency (%)
s 2
40.0%
a 1
20.0%
l 1
20.0%
c 1
20.0%
Other Punctuation
ValueCountFrequency (%)
. 4
57.1%
& 2
28.6%
· 1
 
14.3%
Decimal Number
ValueCountFrequency (%)
0 3
60.0%
2 2
40.0%
Space Separator
ValueCountFrequency (%)
33
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1110
92.2%
Common 78
 
6.5%
Latin 15
 
1.2%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 45
 
4.1%
학 42
 
3.8%
교 37
 
3.3%
성 34
 
3.1%
등 28
 
2.5%
한 20
 
1.8%
식 19
 
1.7%
점 19
 
1.7%
초 18
 
1.6%
우 18
 
1.6%
Other values (245) 830
74.8%
Latin
ValueCountFrequency (%)
K 2
13.3%
P 2
13.3%
s 2
13.3%
J 1
6.7%
a 1
6.7%
l 1
6.7%
c 1
6.7%
O 1
6.7%
V 1
6.7%
I 1
6.7%
Other values (2) 2
13.3%
Common
ValueCountFrequency (%)
33
42.3%
) 16
20.5%
( 16
20.5%
. 4
 
5.1%
0 3
 
3.8%
& 2
 
2.6%
2 2
 
2.6%
- 1
 
1.3%
· 1
 
1.3%
Han
ValueCountFrequency (%)
本 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1110
92.2%
ASCII 92
 
7.6%
CJK 1
 
0.1%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
홍 45
 
4.1%
학 42
 
3.8%
교 37
 
3.3%
성 34
 
3.1%
등 28
 
2.5%
한 20
 
1.8%
식 19
 
1.7%
점 19
 
1.7%
초 18
 
1.6%
우 18
 
1.6%
Other values (245) 830
74.8%
ASCII
ValueCountFrequency (%)
33
35.9%
) 16
17.4%
( 16
17.4%
. 4
 
4.3%
0 3
 
3.3%
K 2
 
2.2%
P 2
 
2.2%
& 2
 
2.2%
2 2
 
2.2%
s 2
 
2.2%
Other values (10) 10
 
10.9%
CJK
ValueCountFrequency (%)
本 1
100.0%
None
ValueCountFrequency (%)
· 1
100.0%

사업장도로명주소
Text

Distinct158
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-01-10T05:53:55.691578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length42
Mean length24.131737
Min length18

Characters and Unicode

Total characters4030
Distinct characters168
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique151 ?
Unique (%)90.4%

Sample

1st row충청남도 홍성군 홍성읍 월계천길 238
2nd row충청남도 홍성군 광천읍 홍남로 767
3rd row충청남도 홍성군 서부면 남당항로 186
4th row충청남도 홍성군 홍성읍 충서로1322번길 42
5th row충청남도 홍성군 홍성읍 의사로72번길 16
ValueCountFrequency (%)
충청남도 167
18.5%
홍성군 160
 
17.8%
홍성읍 75
 
8.3%
홍북읍 25
 
2.8%
홍북면 19
 
2.1%
서부면 11
 
1.2%
충서로 11
 
1.2%
광천읍 10
 
1.1%
대학길 9
 
1.0%
구항면 7
 
0.8%
Other values (277) 407
45.2%
2024-01-10T05:53:56.028643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
736
18.3%
홍 315
 
7.8%
성 253
 
6.3%
남 198
 
4.9%
청 192
 
4.8%
충 188
 
4.7%
도 181
 
4.5%
군 160
 
4.0%
로 127
 
3.2%
1 126
 
3.1%
Other values (158) 1554
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2539
63.0%
Space Separator 736
 
18.3%
Decimal Number 642
 
15.9%
Dash Punctuation 32
 
0.8%
Connector Punctuation 24
 
0.6%
Open Punctuation 19
 
0.5%
Close Punctuation 19
 
0.5%
Uppercase Letter 7
 
0.2%
Other Punctuation 6
 
0.1%
Math Symbol 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 315
12.4%
성 253
 
10.0%
남 198
 
7.8%
청 192
 
7.6%
충 188
 
7.4%
도 181
 
7.1%
군 160
 
6.3%
로 127
 
5.0%
읍 110
 
4.3%
길 76
 
3.0%
Other values (131) 739
29.1%
Decimal Number
ValueCountFrequency (%)
1 126
19.6%
2 111
17.3%
4 63
9.8%
3 62
9.7%
5 56
8.7%
7 54
8.4%
0 49
 
7.6%
6 45
 
7.0%
9 40
 
6.2%
8 36
 
5.6%
Uppercase Letter
ValueCountFrequency (%)
A 2
28.6%
O 1
14.3%
N 1
14.3%
E 1
14.3%
V 1
14.3%
I 1
14.3%
Lowercase Letter
ValueCountFrequency (%)
o 1
33.3%
n 1
33.3%
e 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 5
83.3%
. 1
 
16.7%
Space Separator
ValueCountFrequency (%)
736
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 32
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2539
63.0%
Common 1481
36.7%
Latin 10
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 315
12.4%
성 253
 
10.0%
남 198
 
7.8%
청 192
 
7.6%
충 188
 
7.4%
도 181
 
7.1%
군 160
 
6.3%
로 127
 
5.0%
읍 110
 
4.3%
길 76
 
3.0%
Other values (131) 739
29.1%
Common
ValueCountFrequency (%)
736
49.7%
1 126
 
8.5%
2 111
 
7.5%
4 63
 
4.3%
3 62
 
4.2%
5 56
 
3.8%
7 54
 
3.6%
0 49
 
3.3%
6 45
 
3.0%
9 40
 
2.7%
Other values (8) 139
 
9.4%
Latin
ValueCountFrequency (%)
A 2
20.0%
O 1
10.0%
N 1
10.0%
E 1
10.0%
V 1
10.0%
I 1
10.0%
o 1
10.0%
n 1
10.0%
e 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2539
63.0%
ASCII 1491
37.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
736
49.4%
1 126
 
8.5%
2 111
 
7.4%
4 63
 
4.2%
3 62
 
4.2%
5 56
 
3.8%
7 54
 
3.6%
0 49
 
3.3%
6 45
 
3.0%
9 40
 
2.7%
Other values (17) 149
 
10.0%
Hangul
ValueCountFrequency (%)
홍 315
12.4%
성 253
 
10.0%
남 198
 
7.8%
청 192
 
7.6%
충 188
 
7.4%
도 181
 
7.1%
군 160
 
6.3%
로 127
 
5.0%
읍 110
 
4.3%
길 76
 
3.0%
Other values (131) 739
29.1%

사업장구분
Categorical

Distinct4
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
일반음식점
110 
집단급식소
54 
휴게음식점
 
2
대규모점포
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row일반음식점
2nd row일반음식점
3rd row일반음식점
4th row일반음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 110
65.9%
집단급식소 54
32.3%
휴게음식점 2
 
1.2%
대규모점포 1
 
0.6%

Length

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

Common Values (Plot)

2024-01-10T05:53:56.242033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 110
65.9%
집단급식소 54
32.3%
휴게음식점 2
 
1.2%
대규모점포 1
 
0.6%

전화번호
Text

MISSING 

Distinct155
Distinct (%)95.1%
Missing4
Missing (%)2.4%
Memory size1.4 KiB
2024-01-10T05:53:56.440404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.177914
Min length9

Characters and Unicode

Total characters1985
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique149 ?
Unique (%)91.4%

Sample

1st row041-632-2681
2nd row041-641-1641
3rd row041-632-6818
4th row041-633-5254
5th row041-634-8751
ValueCountFrequency (%)
041-630-3133 3
 
1.8%
041-633-4455 3
 
1.8%
041-634-5302 2
 
1.2%
041-630-5114 2
 
1.2%
041-632-7013 2
 
1.2%
050-4110-5616 2
 
1.2%
041-632-2681 1
 
0.6%
041-631-0092 1
 
0.6%
0507-1391-5020 1
 
0.6%
041-632-8898 1
 
0.6%
Other values (145) 145
89.0%
2024-01-10T05:53:56.765671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 325
16.4%
0 305
15.4%
1 285
14.4%
4 245
12.3%
3 225
11.3%
6 196
9.9%
2 115
 
5.8%
5 100
 
5.0%
8 70
 
3.5%
7 67
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1660
83.6%
Dash Punctuation 325
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 305
18.4%
1 285
17.2%
4 245
14.8%
3 225
13.6%
6 196
11.8%
2 115
 
6.9%
5 100
 
6.0%
8 70
 
4.2%
7 67
 
4.0%
9 52
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 325
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1985
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 325
16.4%
0 305
15.4%
1 285
14.4%
4 245
12.3%
3 225
11.3%
6 196
9.9%
2 115
 
5.8%
5 100
 
5.0%
8 70
 
3.5%
7 67
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1985
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 325
16.4%
0 305
15.4%
1 285
14.4%
4 245
12.3%
3 225
11.3%
6 196
9.9%
2 115
 
5.8%
5 100
 
5.0%
8 70
 
3.5%
7 67
 
3.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2022-12-06
167 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-12-06
2nd row2022-12-06
3rd row2022-12-06
4th row2022-12-06
5th row2022-12-06

Common Values

ValueCountFrequency (%)
2022-12-06 167
100.0%

Length

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

Common Values (Plot)

2024-01-10T05:53:57.011073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-06 167
100.0%

Missing values

2024-01-10T05:53:54.893942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:53:54.974921image/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삼거리갈비충청남도 홍성군 홍성읍 월계천길 238일반음식점041-632-26812022-12-06
1삼정숯불갈비충청남도 홍성군 광천읍 홍남로 767일반음식점041-641-16412022-12-06
2서해수산충청남도 홍성군 서부면 남당항로 186일반음식점041-632-68182022-12-06
3양평해장국충청남도 홍성군 홍성읍 충서로1322번길 42일반음식점041-633-52542022-12-06
4왕솥단지삼겹살충청남도 홍성군 홍성읍 의사로72번길 16일반음식점041-634-87512022-12-06
5장군해물손칼국수충청남도 홍성군 홍성읍 충서로 1106-25일반음식점041-632-29032022-12-06
6채선당홍성점충청남도 홍성군 홍성읍 월산로50번길 6일반음식점041-631-22922022-12-06
7천수만만남의집충청남도 홍성군 서부면 서부서길 304일반음식점041-632-63102022-12-06
8현대뷔페·식당충청남도 홍성군 광천읍 홍남로686번길 24일반음식점041-642-31312022-12-06
9한우일번지충청남도 홍성군 홍성읍 문화로 172일반음식점041-634-67442022-12-06
상호사업장도로명주소사업장구분전화번호데이터기준일자
157홍북초등학교충청남도 홍성군 홍북읍 매죽헌길 5집단급식소041-632-90272022-12-06
158구항초등학교충청남도 홍성군 구항면 구성남로 928집단급식소041-632-70132022-12-06
159결성초등학교충청남도 홍성군 결성면 홍남서로738번길 30집단급식소041-642-79712022-12-06
160서부초등학교충청남도 홍성군 서부면 서부로 505 서부초교집단급식소041-632-80202022-12-06
161은하초등학교충청남도 홍성군 은하면 은하로 220집단급식소041-642-40002022-12-06
162금당초등학교충청남도 홍성군 홍동면 초롱산길 9집단급식소041-633-31702022-12-06
163대정초등학교충청남도 홍성군 구항면 거북로 20집단급식소041-641-06422022-12-06
164신당초등학교충청남도 홍성군 서부면 남당항로270번길 43집단급식소041-632-81502022-12-06
165구항초등학교충청남도 홍성군 구항면 구성남로 928집단급식소041-632-70132022-12-06
166장수요양병원충청남도 홍성군 은하면 구성남로 381집단급식소041-642-00012022-12-06

Duplicate rows

Most frequently occurring

상호사업장도로명주소사업장구분전화번호데이터기준일자# duplicates
0갈산중고등학교충청남도 홍성군 갈산면 상촌로9번길 27집단급식소041-634-53022022-12-062
1구항초등학교충청남도 홍성군 구항면 구성남로 928집단급식소041-632-70132022-12-062
2바다의왕자(홍성.법원점)충청남도 홍성군 홍성읍 법원로 31일반음식점050-4110-56162022-12-062
3혜전대학(여자기숙사)충청남도 홍성군 홍성읍 남학길 175집단급식소041-630-51142022-12-062