Overview

Dataset statistics

Number of variables5
Number of observations81
Missing cells39
Missing cells (%)9.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory41.6 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description충청남도 공주시 문화유통업현황에 대한 데이터로 (구분, 상호, 영업소소재지, 전화번호) 등의 항목을 제공합니다,
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=419&beforeMenuCd=DOM_000000201001001000&publicdatapk=3084499

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 39 (48.1%) missing valuesMissing

Reproduction

Analysis started2024-01-09 23:03:58.975784
Analysis finished2024-01-09 23:03:59.686554
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct3
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size780.0 B
노래연습장
55 
인터넷게임시설제공업
24 
비디어감상실업
 
2

Length

Max length10
Median length5
Mean length6.5308642
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인터넷게임시설제공업
2nd row인터넷게임시설제공업
3rd row인터넷게임시설제공업
4th row인터넷게임시설제공업
5th row인터넷게임시설제공업

Common Values

ValueCountFrequency (%)
노래연습장 55
67.9%
인터넷게임시설제공업 24
29.6%
비디어감상실업 2
 
2.5%

Length

2024-01-10T08:03:59.758863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:03:59.872546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노래연습장 55
67.9%
인터넷게임시설제공업 24
29.6%
비디어감상실업 2
 
2.5%

상호
Text

Distinct80
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size780.0 B
2024-01-10T08:04:00.099908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length7.6790123
Min length5

Characters and Unicode

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

Unique

Unique79 ?
Unique (%)97.5%

Sample

1st rowCF PC방
2nd row하늘다리 PC방
3rd row슈퍼맨PC방
4th row컴스쿨pc방
5th rowAce pc zone
ValueCountFrequency (%)
노래연습장 12
 
11.0%
pc방 7
 
6.4%
노리터 2
 
1.8%
pc 2
 
1.8%
공주신관점 2
 
1.8%
코인잼노래연습장 1
 
0.9%
아우성노래연습장 1
 
0.9%
궁노래연습장 1
 
0.9%
대전노래방 1
 
0.9%
볼가리노래연습장 1
 
0.9%
Other values (79) 79
72.5%
2024-01-10T08:04:00.455768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
노 57
 
9.2%
래 56
 
9.0%
장 50
 
8.0%
습 49
 
7.9%
연 49
 
7.9%
28
 
4.5%
방 24
 
3.9%
C 17
 
2.7%
P 15
 
2.4%
리 9
 
1.4%
Other values (152) 268
43.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 520
83.6%
Uppercase Letter 46
 
7.4%
Space Separator 28
 
4.5%
Lowercase Letter 21
 
3.4%
Decimal Number 6
 
1.0%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
노 57
 
11.0%
래 56
 
10.8%
장 50
 
9.6%
습 49
 
9.4%
연 49
 
9.4%
방 24
 
4.6%
리 9
 
1.7%
스 8
 
1.5%
신 7
 
1.3%
오 7
 
1.3%
Other values (128) 204
39.2%
Uppercase Letter
ValueCountFrequency (%)
C 17
37.0%
P 15
32.6%
L 2
 
4.3%
S 2
 
4.3%
A 2
 
4.3%
F 1
 
2.2%
N 1
 
2.2%
V 1
 
2.2%
D 1
 
2.2%
Q 1
 
2.2%
Other values (3) 3
 
6.5%
Lowercase Letter
ValueCountFrequency (%)
c 8
38.1%
p 7
33.3%
e 2
 
9.5%
z 1
 
4.8%
d 1
 
4.8%
o 1
 
4.8%
n 1
 
4.8%
Decimal Number
ValueCountFrequency (%)
2 4
66.7%
1 2
33.3%
Space Separator
ValueCountFrequency (%)
28
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 520
83.6%
Latin 67
 
10.8%
Common 35
 
5.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
노 57
 
11.0%
래 56
 
10.8%
장 50
 
9.6%
습 49
 
9.4%
연 49
 
9.4%
방 24
 
4.6%
리 9
 
1.7%
스 8
 
1.5%
신 7
 
1.3%
오 7
 
1.3%
Other values (128) 204
39.2%
Latin
ValueCountFrequency (%)
C 17
25.4%
P 15
22.4%
c 8
11.9%
p 7
10.4%
L 2
 
3.0%
S 2
 
3.0%
e 2
 
3.0%
A 2
 
3.0%
F 1
 
1.5%
z 1
 
1.5%
Other values (10) 10
14.9%
Common
ValueCountFrequency (%)
28
80.0%
2 4
 
11.4%
1 2
 
5.7%
& 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 520
83.6%
ASCII 102
 
16.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
노 57
 
11.0%
래 56
 
10.8%
장 50
 
9.6%
습 49
 
9.4%
연 49
 
9.4%
방 24
 
4.6%
리 9
 
1.7%
스 8
 
1.5%
신 7
 
1.3%
오 7
 
1.3%
Other values (128) 204
39.2%
ASCII
ValueCountFrequency (%)
28
27.5%
C 17
16.7%
P 15
14.7%
c 8
 
7.8%
p 7
 
6.9%
2 4
 
3.9%
L 2
 
2.0%
1 2
 
2.0%
S 2
 
2.0%
e 2
 
2.0%
Other values (14) 15
14.7%

영업소소재지(도로명)
Text

Distinct79
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size780.0 B
2024-01-10T08:04:00.730377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length30
Mean length23.876543
Min length18

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)95.1%

Sample

1st row충청남도 공주시 번영1로 154 (신관동)
2nd row충청남도 공주시 공주대학로 78 (신관동)
3rd row충청남도 공주시 매산동길 36 (신관동)
4th row충청남도 공주시 국고개길 3-1 (중동)
5th row충청남도 공주시 중골1길 18-1 (옥룡동)
ValueCountFrequency (%)
충청남도 81
19.1%
공주시 81
19.1%
신관동 45
 
10.6%
번영2로 13
 
3.1%
번영1로 10
 
2.4%
공주대학로 9
 
2.1%
반포면 8
 
1.9%
유구읍 5
 
1.2%
2층 5
 
1.2%
옥룡동 4
 
0.9%
Other values (118) 162
38.3%
2024-01-10T08:04:01.165092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
344
17.8%
공 90
 
4.7%
주 90
 
4.7%
시 85
 
4.4%
남 83
 
4.3%
충 81
 
4.2%
도 81
 
4.2%
청 81
 
4.2%
1 76
 
3.9%
동 69
 
3.6%
Other values (84) 854
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1138
58.8%
Space Separator 344
 
17.8%
Decimal Number 278
 
14.4%
Close Punctuation 61
 
3.2%
Open Punctuation 61
 
3.2%
Dash Punctuation 37
 
1.9%
Other Punctuation 15
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 90
 
7.9%
주 90
 
7.9%
시 85
 
7.5%
남 83
 
7.3%
충 81
 
7.1%
도 81
 
7.1%
청 81
 
7.1%
동 69
 
6.1%
로 50
 
4.4%
신 50
 
4.4%
Other values (69) 378
33.2%
Decimal Number
ValueCountFrequency (%)
1 76
27.3%
2 43
15.5%
3 28
 
10.1%
7 28
 
10.1%
8 28
 
10.1%
5 23
 
8.3%
6 16
 
5.8%
4 15
 
5.4%
9 12
 
4.3%
0 9
 
3.2%
Space Separator
ValueCountFrequency (%)
344
100.0%
Close Punctuation
ValueCountFrequency (%)
) 61
100.0%
Open Punctuation
ValueCountFrequency (%)
( 61
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Other Punctuation
ValueCountFrequency (%)
, 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1138
58.8%
Common 796
41.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 90
 
7.9%
주 90
 
7.9%
시 85
 
7.5%
남 83
 
7.3%
충 81
 
7.1%
도 81
 
7.1%
청 81
 
7.1%
동 69
 
6.1%
로 50
 
4.4%
신 50
 
4.4%
Other values (69) 378
33.2%
Common
ValueCountFrequency (%)
344
43.2%
1 76
 
9.5%
) 61
 
7.7%
( 61
 
7.7%
2 43
 
5.4%
- 37
 
4.6%
3 28
 
3.5%
7 28
 
3.5%
8 28
 
3.5%
5 23
 
2.9%
Other values (5) 67
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1138
58.8%
ASCII 796
41.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
344
43.2%
1 76
 
9.5%
) 61
 
7.7%
( 61
 
7.7%
2 43
 
5.4%
- 37
 
4.6%
3 28
 
3.5%
7 28
 
3.5%
8 28
 
3.5%
5 23
 
2.9%
Other values (5) 67
 
8.4%
Hangul
ValueCountFrequency (%)
공 90
 
7.9%
주 90
 
7.9%
시 85
 
7.5%
남 83
 
7.3%
충 81
 
7.1%
도 81
 
7.1%
청 81
 
7.1%
동 69
 
6.1%
로 50
 
4.4%
신 50
 
4.4%
Other values (69) 378
33.2%

전화번호
Text

MISSING 

Distinct41
Distinct (%)97.6%
Missing39
Missing (%)48.1%
Memory size780.0 B
2024-01-10T08:04:01.386094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique40 ?
Unique (%)95.2%

Sample

1st row041-852-7742
2nd row041-852-1288
3rd row041-881-8695
4th row041-856-0705
5th row041-853-4799
ValueCountFrequency (%)
042-825-4700 2
 
4.8%
041-858-9700 1
 
2.4%
042-825-7664 1
 
2.4%
041-854-3821 1
 
2.4%
041-825-0022 1
 
2.4%
041-858-3339 1
 
2.4%
041-854-0888 1
 
2.4%
041-881-8880 1
 
2.4%
041-854-3434 1
 
2.4%
041-881-1800 1
 
2.4%
Other values (31) 31
73.8%
2024-01-10T08:04:01.689076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 84
16.7%
0 79
15.7%
8 66
13.1%
4 63
12.5%
1 61
12.1%
5 46
9.1%
2 33
 
6.5%
6 23
 
4.6%
7 20
 
4.0%
9 16
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 420
83.3%
Dash Punctuation 84
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 79
18.8%
8 66
15.7%
4 63
15.0%
1 61
14.5%
5 46
11.0%
2 33
7.9%
6 23
 
5.5%
7 20
 
4.8%
9 16
 
3.8%
3 13
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 504
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 84
16.7%
0 79
15.7%
8 66
13.1%
4 63
12.5%
1 61
12.1%
5 46
9.1%
2 33
 
6.5%
6 23
 
4.6%
7 20
 
4.0%
9 16
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 504
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 84
16.7%
0 79
15.7%
8 66
13.1%
4 63
12.5%
1 61
12.1%
5 46
9.1%
2 33
 
6.5%
6 23
 
4.6%
7 20
 
4.0%
9 16
 
3.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size780.0 B
Minimum2017-05-19 00:00:00
Maximum2017-05-19 00:00:00
2024-01-10T08:04:01.801752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T08:04:01.887734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T08:04:01.950323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분상호영업소소재지(도로명)전화번호
구분1.0001.0000.9321.000
상호1.0001.0000.9961.000
영업소소재지(도로명)0.9320.9961.0001.000
전화번호1.0001.0001.0001.000

Missing values

2024-01-10T08:03:59.536262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T08:03:59.643296image/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인터넷게임시설제공업CF PC방충청남도 공주시 번영1로 154 (신관동)<NA>2017-05-19
1인터넷게임시설제공업하늘다리 PC방충청남도 공주시 공주대학로 78 (신관동)<NA>2017-05-19
2인터넷게임시설제공업슈퍼맨PC방충청남도 공주시 매산동길 36 (신관동)<NA>2017-05-19
3인터넷게임시설제공업컴스쿨pc방충청남도 공주시 국고개길 3-1 (중동)<NA>2017-05-19
4인터넷게임시설제공업Ace pc zone충청남도 공주시 중골1길 18-1 (옥룡동)<NA>2017-05-19
5인터넷게임시설제공업게임존pc방충청남도 공주시 무안길 17 (금학동)<NA>2017-05-19
6인터넷게임시설제공업아이넷폴리스충청남도 공주시 유구읍 석남외마루길 6<NA>2017-05-19
7인터넷게임시설제공업EONpc방충청남도 공주시 공주대학로 59 (신관동, 대창빌딩)041-852-77422017-05-19
8인터넷게임시설제공업블랙Qpc방충청남도 공주시 남문길 8 (산성동)<NA>2017-05-19
9인터넷게임시설제공업프렌드pc방충청남도 공주시 금성길 20 (금성동)041-852-12882017-05-19
구분상호영업소소재지(도로명)전화번호데이터기준일자
71노래연습장텔미노래연습장충청남도 공주시 유구읍 중앙1길 62<NA>2017-05-19
72노래연습장호박노래연습장충청남도 공주시 전막1길 16-13 (신관동)<NA>2017-05-19
73노래연습장신바람노래연습장충청남도 공주시 반포면 임금봉길 31-11042-825-70072017-05-19
74노래연습장매직 노래연습장충청남도 공주시 번영1로 50, 지하 1층동 (신관동)<NA>2017-05-19
75노래연습장싸이 노래연습장충청남도 공주시 번영2로 78-1 (신관동, 지하 1층)<NA>2017-05-19
76노래연습장신파라오 노래연습장충청남도 공주시 계룡면 영규대사로 67-1, 1층<NA>2017-05-19
77노래연습장코인잼노래연습장충청남도 공주시 공주대학로 77-1 (신관동)<NA>2017-05-19
78노래연습장까치노래연습장충청남도 공주시 산성시장5길 78-12 (금성동)041-855-32352017-05-19
79노래연습장퍼펙트코인 노래연습장충청남도 공주시 번영2로 75, 3층 (신관동)<NA>2017-05-19
80노래연습장게임1번지&코인노래연습장충청남도 공주시 흑수골길 10 (신관동)<NA>2017-05-19