Overview

Dataset statistics

Number of variables4
Number of observations77
Missing cells27
Missing cells (%)8.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory33.7 B

Variable types

Categorical1
Text3

Dataset

Description충청남도 아산시 이용업소 현황으로 업소명, 업종명, 주소, 업소현황 등의 정보를 제공합니다-----------------------------
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=416&beforeMenuCd=DOM_000000201001001000&publicdatapk=15055141

Alerts

업종명 has constant value ""Constant
소재지전화 has 27 (35.1%) missing valuesMissing
업소명 has unique valuesUnique
영업소 주소(도로명) has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:39:10.465280
Analysis finished2024-01-09 20:39:10.825867
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size748.0 B
이용업
77 

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 (%)
이용업 77
100.0%

Length

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

Common Values (Plot)

2024-01-10T05:39:10.951571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
이용업 77
100.0%

업소명
Text

UNIQUE 

Distinct77
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size748.0 B
2024-01-10T05:39:11.155923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length14
Mean length6.3116883
Min length4

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)100.0%

Sample

1st row염티이발관
2nd row산전이발관
3rd row제일이발관
4th row제일이발관
5th row연암이발관
ValueCountFrequency (%)
이용원 4
 
4.5%
제일이발관 2
 
2.2%
현대이용원 2
 
2.2%
염티이발관 1
 
1.1%
시민이용원 1
 
1.1%
명동이용원 1
 
1.1%
동성이용원 1
 
1.1%
정수이용원 1
 
1.1%
청주탕 1
 
1.1%
남성컷트전문점 1
 
1.1%
Other values (74) 74
83.1%
2024-01-10T05:39:11.515486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 68
 
14.0%
용 45
 
9.3%
원 44
 
9.1%
35
 
7.2%
발 22
 
4.5%
관 21
 
4.3%
신 8
 
1.6%
성 8
 
1.6%
아 7
 
1.4%
온 6
 
1.2%
Other values (123) 222
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 432
88.9%
Space Separator 35
 
7.2%
Uppercase Letter 15
 
3.1%
Open Punctuation 2
 
0.4%
Close Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 68
 
15.7%
용 45
 
10.4%
원 44
 
10.2%
발 22
 
5.1%
관 21
 
4.9%
신 8
 
1.9%
성 8
 
1.9%
아 7
 
1.6%
온 6
 
1.4%
점 6
 
1.4%
Other values (109) 197
45.6%
Uppercase Letter
ValueCountFrequency (%)
P 2
13.3%
O 2
13.3%
B 2
13.3%
R 2
13.3%
U 1
6.7%
N 1
6.7%
T 1
6.7%
A 1
6.7%
E 1
6.7%
S 1
6.7%
Space Separator
ValueCountFrequency (%)
35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 432
88.9%
Common 39
 
8.0%
Latin 15
 
3.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 68
 
15.7%
용 45
 
10.4%
원 44
 
10.2%
발 22
 
5.1%
관 21
 
4.9%
신 8
 
1.9%
성 8
 
1.9%
아 7
 
1.6%
온 6
 
1.4%
점 6
 
1.4%
Other values (109) 197
45.6%
Latin
ValueCountFrequency (%)
P 2
13.3%
O 2
13.3%
B 2
13.3%
R 2
13.3%
U 1
6.7%
N 1
6.7%
T 1
6.7%
A 1
6.7%
E 1
6.7%
S 1
6.7%
Common
ValueCountFrequency (%)
35
89.7%
( 2
 
5.1%
) 2
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 432
88.9%
ASCII 54
 
11.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 68
 
15.7%
용 45
 
10.4%
원 44
 
10.2%
발 22
 
5.1%
관 21
 
4.9%
신 8
 
1.9%
성 8
 
1.9%
아 7
 
1.6%
온 6
 
1.4%
점 6
 
1.4%
Other values (109) 197
45.6%
ASCII
ValueCountFrequency (%)
35
64.8%
( 2
 
3.7%
) 2
 
3.7%
P 2
 
3.7%
O 2
 
3.7%
B 2
 
3.7%
R 2
 
3.7%
U 1
 
1.9%
N 1
 
1.9%
T 1
 
1.9%
Other values (4) 4
 
7.4%

영업소 주소(도로명)
Text

UNIQUE 

Distinct77
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size748.0 B
2024-01-10T05:39:11.753508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length37
Mean length26.324675
Min length19

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)100.0%

Sample

1st row충청남도 아산시 염치읍 곡교리길 19
2nd row충청남도 아산시 둔포면 충무로 1392 ((1층))
3rd row충청남도 아산시 영인면 영인로96번길 8-5
4th row충청남도 아산시 시민로409번길 2 (온천동)
5th row충청남도 아산시 음봉면 연암율금로 506
ValueCountFrequency (%)
충청남도 77
 
17.8%
아산시 77
 
17.8%
1층 25
 
5.8%
온천동 24
 
5.5%
온천대로 8
 
1.8%
음봉면 7
 
1.6%
둔포면 6
 
1.4%
배방읍 6
 
1.4%
모종동 5
 
1.2%
충무로 4
 
0.9%
Other values (155) 194
44.8%
2024-01-10T05:39:12.109037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
357
 
17.6%
1 94
 
4.6%
아 89
 
4.4%
산 88
 
4.3%
충 83
 
4.1%
시 82
 
4.0%
도 80
 
3.9%
남 78
 
3.8%
청 78
 
3.8%
로 66
 
3.3%
Other values (119) 932
46.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1204
59.4%
Space Separator 357
 
17.6%
Decimal Number 306
 
15.1%
Open Punctuation 53
 
2.6%
Close Punctuation 53
 
2.6%
Other Punctuation 36
 
1.8%
Dash Punctuation 17
 
0.8%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 89
 
7.4%
산 88
 
7.3%
충 83
 
6.9%
시 82
 
6.8%
도 80
 
6.6%
남 78
 
6.5%
청 78
 
6.5%
로 66
 
5.5%
동 49
 
4.1%
온 48
 
4.0%
Other values (102) 463
38.5%
Decimal Number
ValueCountFrequency (%)
1 94
30.7%
2 34
 
11.1%
3 29
 
9.5%
6 24
 
7.8%
8 24
 
7.8%
4 23
 
7.5%
9 22
 
7.2%
5 19
 
6.2%
7 19
 
6.2%
0 18
 
5.9%
Other Punctuation
ValueCountFrequency (%)
, 35
97.2%
@ 1
 
2.8%
Space Separator
ValueCountFrequency (%)
357
100.0%
Open Punctuation
ValueCountFrequency (%)
( 53
100.0%
Close Punctuation
ValueCountFrequency (%)
) 53
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1204
59.4%
Common 822
40.6%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 89
 
7.4%
산 88
 
7.3%
충 83
 
6.9%
시 82
 
6.8%
도 80
 
6.6%
남 78
 
6.5%
청 78
 
6.5%
로 66
 
5.5%
동 49
 
4.1%
온 48
 
4.0%
Other values (102) 463
38.5%
Common
ValueCountFrequency (%)
357
43.4%
1 94
 
11.4%
( 53
 
6.4%
) 53
 
6.4%
, 35
 
4.3%
2 34
 
4.1%
3 29
 
3.5%
6 24
 
2.9%
8 24
 
2.9%
4 23
 
2.8%
Other values (6) 96
 
11.7%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1204
59.4%
ASCII 823
40.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
357
43.4%
1 94
 
11.4%
( 53
 
6.4%
) 53
 
6.4%
, 35
 
4.3%
2 34
 
4.1%
3 29
 
3.5%
6 24
 
2.9%
8 24
 
2.9%
4 23
 
2.8%
Other values (7) 97
 
11.8%
Hangul
ValueCountFrequency (%)
아 89
 
7.4%
산 88
 
7.3%
충 83
 
6.9%
시 82
 
6.8%
도 80
 
6.6%
남 78
 
6.5%
청 78
 
6.5%
로 66
 
5.5%
동 49
 
4.1%
온 48
 
4.0%
Other values (102) 463
38.5%

소재지전화
Text

MISSING 

Distinct50
Distinct (%)100.0%
Missing27
Missing (%)35.1%
Memory size748.0 B
2024-01-10T05:39:12.292224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters600
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

Unique50 ?
Unique (%)100.0%

Sample

1st row041-543-7189
2nd row041-545-7295
3rd row041-542-5677
4th row041-542-8782
5th row041-546-9454
ValueCountFrequency (%)
041-546-0084 1
 
2.0%
041-533-4747 1
 
2.0%
041-546-5266 1
 
2.0%
041-541-5526 1
 
2.0%
041-543-5060 1
 
2.0%
041-549-8467 1
 
2.0%
041-541-7740 1
 
2.0%
041-532-7517 1
 
2.0%
041-543-6074 1
 
2.0%
041-533-7773 1
 
2.0%
Other values (40) 40
80.0%
2024-01-10T05:39:12.571942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 118
19.7%
- 100
16.7%
5 81
13.5%
1 76
12.7%
0 72
12.0%
3 30
 
5.0%
7 29
 
4.8%
2 28
 
4.7%
6 23
 
3.8%
9 23
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 500
83.3%
Dash Punctuation 100
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 118
23.6%
5 81
16.2%
1 76
15.2%
0 72
14.4%
3 30
 
6.0%
7 29
 
5.8%
2 28
 
5.6%
6 23
 
4.6%
9 23
 
4.6%
8 20
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 600
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 118
19.7%
- 100
16.7%
5 81
13.5%
1 76
12.7%
0 72
12.0%
3 30
 
5.0%
7 29
 
4.8%
2 28
 
4.7%
6 23
 
3.8%
9 23
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 600
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 118
19.7%
- 100
16.7%
5 81
13.5%
1 76
12.7%
0 72
12.0%
3 30
 
5.0%
7 29
 
4.8%
2 28
 
4.7%
6 23
 
3.8%
9 23
 
3.8%

Correlations

2024-01-10T05:39:12.659362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명영업소 주소(도로명)소재지전화
업소명1.0001.0001.000
영업소 주소(도로명)1.0001.0001.000
소재지전화1.0001.0001.000

Missing values

2024-01-10T05:39:10.719907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:39:10.794191image/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이용업염티이발관충청남도 아산시 염치읍 곡교리길 19041-543-7189
1이용업산전이발관충청남도 아산시 둔포면 충무로 1392 ((1층))041-545-7295
2이용업제일이발관충청남도 아산시 영인면 영인로96번길 8-5041-542-5677
3이용업제일이발관충청남도 아산시 시민로409번길 2 (온천동)041-542-8782
4이용업연암이발관충청남도 아산시 음봉면 연암율금로 506041-546-9454
5이용업강능이발관충청남도 아산시 충무로 89-8 (권곡동)041-545-8077
6이용업예성이발관충청남도 아산시 충무로40번길 9-13 (온천동)041-545-4114
7이용업선도이발관충청남도 아산시 선장면 아산만로356번길 31-9041-542-0689
8이용업삼성이용원충청남도 아산시 배방읍 북수로 97041-548-7904
9이용업영광이발관충청남도 아산시 번영로 179 (권곡동)041-545-9840
업종명업소명영업소 주소(도로명)소재지전화
67이용업태후사랑(온천점)충청남도 아산시 온화로 27, 1층 (온천동)041-544-0067
68이용업별장이용원충청남도 아산시 도고면 도고면로 188, 도고별장스파피아 2동 1(일부)층<NA>
69이용업신신이용원충청남도 아산시 온양역길 64, 지하1(일부)층 (온천동)<NA>
70이용업아티션바버샵충청남도 아산시 온천대로 1589, 1층 (모종동)<NA>
71이용업제일이용원충청남도 아산시 온천대로 1462, 온양제일호텔 지하1층 (온천동)<NA>
72이용업크리드바버샵 음봉점충청남도 아산시 음봉면 음봉로586번길 77-21, 1층<NA>
73이용업신신이발관충청남도 아산시 둔포면 둔포면로 7, 1층041-531-6621
74이용업승안이용원충청남도 아산시 실옥로 220, 아산건강문화센터 1층 (배미동)<NA>
75이용업시크릿잉크 천안점충청남도 아산시 배방읍 희망로46번길 19-3, 1층 106호<NA>
76이용업푼토바버샵(PUNTO BARBERSHOP)충청남도 아산시 용화로12번길 8-6, 1층 (용화동)<NA>