Overview

Dataset statistics

Number of variables5
Number of observations113
Missing cells29
Missing cells (%)5.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory41.2 B

Variable types

Text3
Categorical1
DateTime1

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
전화번호 has 29 (25.7%) missing valuesMissing
상호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:53:48.520871
Analysis finished2024-01-09 20:53:48.910912
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct113
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-01-10T05:53:49.072819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length7.2831858
Min length2

Characters and Unicode

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

Unique

Unique113 ?
Unique (%)100.0%

Sample

1st row갈산초등학교
2nd row일진전기 사원기숙사식당
3rd row갈산중고등학교
4th row홍성명품한우기분좋소
5th row홍성공업고등학교
ValueCountFrequency (%)
청운대학교 3
 
2.1%
홍성대학로점 2
 
1.4%
의료법인 2
 
1.4%
홍성점 2
 
1.4%
맘스터치 1
 
0.7%
피쉬 1
 
0.7%
리첸시아웨딩컨벤션 1
 
0.7%
홍성중학교장 1
 
0.7%
보령참숯갈비 1
 
0.7%
로얄회관 1
 
0.7%
Other values (125) 125
89.3%
2024-01-10T05:53:49.419754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 29
 
3.5%
28
 
3.4%
홍 28
 
3.4%
교 25
 
3.0%
성 20
 
2.4%
등 15
 
1.8%
식 13
 
1.6%
대 13
 
1.6%
장 13
 
1.6%
) 12
 
1.5%
Other values (225) 627
76.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 757
92.0%
Space Separator 28
 
3.4%
Close Punctuation 12
 
1.5%
Open Punctuation 12
 
1.5%
Uppercase Letter 7
 
0.9%
Other Punctuation 3
 
0.4%
Lowercase Letter 3
 
0.4%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 29
 
3.8%
홍 28
 
3.7%
교 25
 
3.3%
성 20
 
2.6%
등 15
 
2.0%
식 13
 
1.7%
대 13
 
1.7%
장 13
 
1.7%
산 12
 
1.6%
한 12
 
1.6%
Other values (209) 577
76.2%
Uppercase Letter
ValueCountFrequency (%)
V 1
14.3%
I 1
14.3%
K 1
14.3%
P 1
14.3%
T 1
14.3%
D 1
14.3%
J 1
14.3%
Lowercase Letter
ValueCountFrequency (%)
k 1
33.3%
o 1
33.3%
p 1
33.3%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
· 1
33.3%
Space Separator
ValueCountFrequency (%)
28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 756
91.9%
Common 56
 
6.8%
Latin 10
 
1.2%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 29
 
3.8%
홍 28
 
3.7%
교 25
 
3.3%
성 20
 
2.6%
등 15
 
2.0%
식 13
 
1.7%
대 13
 
1.7%
장 13
 
1.7%
산 12
 
1.6%
한 12
 
1.6%
Other values (208) 576
76.2%
Latin
ValueCountFrequency (%)
V 1
10.0%
k 1
10.0%
I 1
10.0%
o 1
10.0%
K 1
10.0%
P 1
10.0%
p 1
10.0%
T 1
10.0%
D 1
10.0%
J 1
10.0%
Common
ValueCountFrequency (%)
28
50.0%
) 12
21.4%
( 12
21.4%
. 2
 
3.6%
- 1
 
1.8%
· 1
 
1.8%
Han
ValueCountFrequency (%)
本 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 756
91.9%
ASCII 65
 
7.9%
None 1
 
0.1%
CJK 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 29
 
3.8%
홍 28
 
3.7%
교 25
 
3.3%
성 20
 
2.6%
등 15
 
2.0%
식 13
 
1.7%
대 13
 
1.7%
장 13
 
1.7%
산 12
 
1.6%
한 12
 
1.6%
Other values (208) 576
76.2%
ASCII
ValueCountFrequency (%)
28
43.1%
) 12
18.5%
( 12
18.5%
. 2
 
3.1%
- 1
 
1.5%
V 1
 
1.5%
k 1
 
1.5%
I 1
 
1.5%
o 1
 
1.5%
K 1
 
1.5%
Other values (5) 5
 
7.7%
None
ValueCountFrequency (%)
· 1
100.0%
CJK
ValueCountFrequency (%)
本 1
100.0%

사업장도로명주소
Text

Distinct109
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-01-10T05:53:49.646043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length36
Mean length24.159292
Min length19

Characters and Unicode

Total characters2730
Distinct characters129
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

Unique107 ?
Unique (%)94.7%

Sample

1st row충청남도 홍성군 갈산면 갈산로 135
2nd row충청남도 홍성군 갈산면 갈산서길 383
3rd row충청남도 홍성군 갈산면 상촌로9번길 27
4th row충청남도 홍성군 갈산면 와룡로 426-23
5th row충청남도 홍성군 결성면 구성남로 55
ValueCountFrequency (%)
홍성군 118
19.4%
충청남도 113
18.6%
홍성읍 54
 
8.9%
홍북면 19
 
3.1%
홍북읍 12
 
2.0%
충서로 11
 
1.8%
서부면 8
 
1.3%
대학길 6
 
1.0%
청사로 6
 
1.0%
광천읍 6
 
1.0%
Other values (199) 256
42.0%
2024-01-10T05:53:50.228113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
499
18.3%
홍 226
 
8.3%
성 181
 
6.6%
남 133
 
4.9%
충 132
 
4.8%
청 131
 
4.8%
도 120
 
4.4%
군 118
 
4.3%
1 97
 
3.6%
로 89
 
3.3%
Other values (119) 1004
36.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1710
62.6%
Space Separator 499
 
18.3%
Decimal Number 447
 
16.4%
Dash Punctuation 22
 
0.8%
Close Punctuation 13
 
0.5%
Open Punctuation 13
 
0.5%
Connector Punctuation 10
 
0.4%
Other Punctuation 9
 
0.3%
Math Symbol 3
 
0.1%
Lowercase Letter 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 226
13.2%
성 181
 
10.6%
남 133
 
7.8%
충 132
 
7.7%
청 131
 
7.7%
도 120
 
7.0%
군 118
 
6.9%
로 89
 
5.2%
읍 72
 
4.2%
길 51
 
3.0%
Other values (98) 457
26.7%
Decimal Number
ValueCountFrequency (%)
1 97
21.7%
2 74
16.6%
3 48
10.7%
4 46
10.3%
5 38
 
8.5%
0 34
 
7.6%
7 33
 
7.4%
6 29
 
6.5%
9 26
 
5.8%
8 22
 
4.9%
Lowercase Letter
ValueCountFrequency (%)
n 1
33.3%
o 1
33.3%
e 1
33.3%
Space Separator
ValueCountFrequency (%)
499
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 10
100.0%
Other Punctuation
ValueCountFrequency (%)
, 9
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1710
62.6%
Common 1016
37.2%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 226
13.2%
성 181
 
10.6%
남 133
 
7.8%
충 132
 
7.7%
청 131
 
7.7%
도 120
 
7.0%
군 118
 
6.9%
로 89
 
5.2%
읍 72
 
4.2%
길 51
 
3.0%
Other values (98) 457
26.7%
Common
ValueCountFrequency (%)
499
49.1%
1 97
 
9.5%
2 74
 
7.3%
3 48
 
4.7%
4 46
 
4.5%
5 38
 
3.7%
0 34
 
3.3%
7 33
 
3.2%
6 29
 
2.9%
9 26
 
2.6%
Other values (7) 92
 
9.1%
Latin
ValueCountFrequency (%)
n 1
25.0%
A 1
25.0%
o 1
25.0%
e 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1710
62.6%
ASCII 1020
37.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
499
48.9%
1 97
 
9.5%
2 74
 
7.3%
3 48
 
4.7%
4 46
 
4.5%
5 38
 
3.7%
0 34
 
3.3%
7 33
 
3.2%
6 29
 
2.8%
9 26
 
2.5%
Other values (11) 96
 
9.4%
Hangul
ValueCountFrequency (%)
홍 226
13.2%
성 181
 
10.6%
남 133
 
7.8%
충 132
 
7.7%
청 131
 
7.7%
도 120
 
7.0%
군 118
 
6.9%
로 89
 
5.2%
읍 72
 
4.2%
길 51
 
3.0%
Other values (98) 457
26.7%

사업장구분
Categorical

Distinct4
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
일반음식점
75 
집단급식소
35 
휴게음식점
 
2
대규모점포
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row집단급식소
2nd row집단급식소
3rd row집단급식소
4th row일반음식점
5th row집단급식소

Common Values

ValueCountFrequency (%)
일반음식점 75
66.4%
집단급식소 35
31.0%
휴게음식점 2
 
1.8%
대규모점포 1
 
0.9%

Length

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

Common Values (Plot)

2024-01-10T05:53:50.426009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 75
66.4%
집단급식소 35
31.0%
휴게음식점 2
 
1.8%
대규모점포 1
 
0.9%

전화번호
Text

MISSING 

Distinct83
Distinct (%)98.8%
Missing29
Missing (%)25.7%
Memory size1.0 KiB
2024-01-10T05:53:50.617365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length12
Mean length12.071429
Min length1

Characters and Unicode

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

Unique

Unique82 ?
Unique (%)97.6%

Sample

1st row041-633-7575
2nd row041-633-0988
3rd row041-634-5304/041-634-5308
4th row041-642-1961
5th row041-641-0552
ValueCountFrequency (%)
041-632-2648 2
 
2.4%
041-632-2641 1
 
1.2%
041-634-6744 1
 
1.2%
041-630-6114 1
 
1.2%
041-633-0548 1
 
1.2%
041-634-2990 1
 
1.2%
041-632-2681 1
 
1.2%
041-630-1399 1
 
1.2%
041-632-2332 1
 
1.2%
041-634-2292 1
 
1.2%
Other values (73) 73
86.9%
2024-01-10T05:53:50.931520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 169
16.7%
0 146
14.4%
4 141
13.9%
1 141
13.9%
3 115
11.3%
6 110
10.8%
2 60
 
5.9%
5 44
 
4.3%
9 33
 
3.3%
8 31
 
3.1%
Other values (3) 24
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 843
83.1%
Dash Punctuation 169
 
16.7%
Space Separator 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 146
17.3%
4 141
16.7%
1 141
16.7%
3 115
13.6%
6 110
13.0%
2 60
7.1%
5 44
 
5.2%
9 33
 
3.9%
8 31
 
3.7%
7 22
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 169
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1014
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 169
16.7%
0 146
14.4%
4 141
13.9%
1 141
13.9%
3 115
11.3%
6 110
10.8%
2 60
 
5.9%
5 44
 
4.3%
9 33
 
3.3%
8 31
 
3.1%
Other values (3) 24
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1014
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 169
16.7%
0 146
14.4%
4 141
13.9%
1 141
13.9%
3 115
11.3%
6 110
10.8%
2 60
 
5.9%
5 44
 
4.3%
9 33
 
3.3%
8 31
 
3.1%
Other values (3) 24
 
2.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum2021-11-15 00:00:00
Maximum2021-11-15 00:00:00
2024-01-10T05:53:51.039285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:53:51.114813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T05:53:51.170855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업장구분전화번호
사업장구분1.0001.000
전화번호1.0001.000

Missing values

2024-01-10T05:53:48.797487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:53:48.878641image/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갈산초등학교충청남도 홍성군 갈산면 갈산로 135집단급식소041-633-75752021-11-15
1일진전기 사원기숙사식당충청남도 홍성군 갈산면 갈산서길 383집단급식소041-633-09882021-11-15
2갈산중고등학교충청남도 홍성군 갈산면 상촌로9번길 27집단급식소041-634-5304/041-634-53082021-11-15
3홍성명품한우기분좋소충청남도 홍성군 갈산면 와룡로 426-23일반음식점<NA>2021-11-15
4홍성공업고등학교충청남도 홍성군 결성면 구성남로 55집단급식소041-642-19612021-11-15
5광천중학교충청남도 홍성군 광천읍 광천로 396-34집단급식소041-641-05522021-11-15
6한국k-Pop고등학교충청남도 홍성군 광천읍 광천로373번길 14일반음식점041-641-64332021-11-15
7(주)홍주미트충청남도 홍성군 광천읍 홍남로 578-46일반음식점<NA>2021-11-15
8현대뷔페·식당충청남도 홍성군 광천읍 홍남로686번길 24일반음식점041-642-31312021-11-15
9서해삼육중.고등학교충청남도 홍성군 광천읍 홍남로705번길 23집단급식소041-641-09392021-11-15
상호사업장도로명주소사업장구분전화번호데이터기준일자
103진지상한식충청남도 홍성군 홍북읍 충서로 2423일반음식점<NA>2021-11-15
104계룡산업(주)내포신도시 현장식당충청남도 홍성군 홍북읍 신경리 1372일반음식점042-719-71002021-11-15
105황산충청남도 홍성군 홍북읍 충서로 2423일반음식점<NA>2021-11-15
106매화한정식충청남도 홍성군 홍북읍 의향로 289, A_one프라자일반음식점<NA>2021-11-15
107사또왕갈비충청남도 홍성군 홍성읍 홍성천길 144일반음식점<NA>2021-11-15
108백제해장국충청남도 홍성군 광천읍 광천로 200일반음식점041-641-06002021-11-15
109청해활어회센터충청남도 홍성군 홍성읍 문화로 33번길 29일반음식점<NA>2021-11-15
110스시마츠충청남도 홍성군 홍북읍 청사로 174번길 25, 성원타워일반음식점<NA>2021-11-15
111남원추어탕이가내포점충청남도 홍성군 홍북읍 청사로 152 ,201,202호일반음식점<NA>2021-11-15
112담은충청남도 홍성군 구항면 충서로 1067-13일반음식점<NA>2021-11-15