Overview

Dataset statistics

Number of variables3
Number of observations73
Missing cells22
Missing cells (%)10.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory25.8 B

Variable types

Text3

Dataset

Description군산시에 소재한 관내 안경업소에 대한 데이터로 안경업소명칭, 사업장소재지(도로명), 사업장전화번호 등에 대한 현황을 제공합니다.
Author전북특별자치도 군산시
URLhttps://www.data.go.kr/data/3080247/fileData.do

Alerts

사업장전화번호 has 22 (30.1%) missing valuesMissing
사업장소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-03-14 17:54:07.032814
Analysis finished2024-03-14 17:54:07.802514
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct72
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size712.0 B
2024-03-15T02:54:08.881896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length7.5753425
Min length3

Characters and Unicode

Total characters553
Distinct characters128
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

Unique71 ?
Unique (%)97.3%

Sample

1st row으뜸50안경 군산디오션점
2nd row안경나라 군산대점
3rd row아이리움안경원 군산점
4th row안경상회
5th row라라렌즈lalalens
ValueCountFrequency (%)
안경나라 3
 
3.2%
군산수송점 3
 
3.2%
지니스안경 2
 
2.1%
안경매니져 2
 
2.1%
군산중앙점 2
 
2.1%
군산디오션점 2
 
2.1%
군산점 2
 
2.1%
일공공일안경콘택트 1
 
1.1%
일공공일안경나운점 1
 
1.1%
아이러브안경콘택트 1
 
1.1%
Other values (75) 75
79.8%
2024-03-15T02:54:10.606893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
61
 
11.0%
61
 
11.0%
34
 
6.1%
21
 
3.8%
20
 
3.6%
18
 
3.3%
16
 
2.9%
15
 
2.7%
14
 
2.5%
14
 
2.5%
Other values (118) 279
50.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 517
93.5%
Space Separator 21
 
3.8%
Lowercase Letter 10
 
1.8%
Decimal Number 4
 
0.7%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
61
 
11.8%
61
 
11.8%
34
 
6.6%
20
 
3.9%
18
 
3.5%
16
 
3.1%
15
 
2.9%
14
 
2.7%
14
 
2.7%
13
 
2.5%
Other values (107) 251
48.5%
Lowercase Letter
ValueCountFrequency (%)
l 3
30.0%
a 2
20.0%
e 1
 
10.0%
n 1
 
10.0%
s 1
 
10.0%
b 1
 
10.0%
y 1
 
10.0%
Decimal Number
ValueCountFrequency (%)
0 2
50.0%
5 2
50.0%
Space Separator
ValueCountFrequency (%)
21
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 517
93.5%
Common 26
 
4.7%
Latin 10
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
61
 
11.8%
61
 
11.8%
34
 
6.6%
20
 
3.9%
18
 
3.5%
16
 
3.1%
15
 
2.9%
14
 
2.7%
14
 
2.7%
13
 
2.5%
Other values (107) 251
48.5%
Latin
ValueCountFrequency (%)
l 3
30.0%
a 2
20.0%
e 1
 
10.0%
n 1
 
10.0%
s 1
 
10.0%
b 1
 
10.0%
y 1
 
10.0%
Common
ValueCountFrequency (%)
21
80.8%
0 2
 
7.7%
5 2
 
7.7%
. 1
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 517
93.5%
ASCII 36
 
6.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
61
 
11.8%
61
 
11.8%
34
 
6.6%
20
 
3.9%
18
 
3.5%
16
 
3.1%
15
 
2.9%
14
 
2.7%
14
 
2.7%
13
 
2.5%
Other values (107) 251
48.5%
ASCII
ValueCountFrequency (%)
21
58.3%
l 3
 
8.3%
0 2
 
5.6%
5 2
 
5.6%
a 2
 
5.6%
e 1
 
2.8%
n 1
 
2.8%
s 1
 
2.8%
b 1
 
2.8%
y 1
 
2.8%
Distinct73
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size712.0 B
2024-03-15T02:54:12.130136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length37
Mean length28.452055
Min length20

Characters and Unicode

Total characters2077
Distinct characters134
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

Unique73 ?
Unique (%)100.0%

Sample

1st row전북특별자치도 군산시 궁포3로 8, 201호 (조촌동)
2nd row전북특별자치도 군산시 황룡로 9, 1층 102호 (미룡동)
3rd row전북특별자치도 군산시 궁포안1길 33, 102호 (조촌동)
4th row전북특별자치도 군산시 소룡안3길 30 (소룡동)
5th row전북특별자치도 군산시 나운2길 38, (중간통로 우측) (나운동)
ValueCountFrequency (%)
전북특별자치도 73
 
18.0%
군산시 73
 
18.0%
나운동 14
 
3.5%
수송동 12
 
3.0%
수송로 10
 
2.5%
조촌동 9
 
2.2%
월명로 6
 
1.5%
1층 6
 
1.5%
102호 5
 
1.2%
대학로 5
 
1.2%
Other values (153) 192
47.4%
2024-03-15T02:54:13.977730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
332
 
16.0%
79
 
3.8%
76
 
3.7%
76
 
3.7%
75
 
3.6%
74
 
3.6%
73
 
3.5%
73
 
3.5%
73
 
3.5%
73
 
3.5%
Other values (124) 1073
51.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1287
62.0%
Space Separator 332
 
16.0%
Decimal Number 289
 
13.9%
Close Punctuation 62
 
3.0%
Open Punctuation 62
 
3.0%
Other Punctuation 31
 
1.5%
Dash Punctuation 13
 
0.6%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
79
 
6.1%
76
 
5.9%
76
 
5.9%
75
 
5.8%
74
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
Other values (107) 542
42.1%
Decimal Number
ValueCountFrequency (%)
1 67
23.2%
2 54
18.7%
3 36
12.5%
0 28
9.7%
4 21
 
7.3%
8 19
 
6.6%
5 18
 
6.2%
7 16
 
5.5%
6 16
 
5.5%
9 14
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 29
93.5%
. 2
 
6.5%
Space Separator
ValueCountFrequency (%)
332
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1287
62.0%
Common 789
38.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
79
 
6.1%
76
 
5.9%
76
 
5.9%
75
 
5.8%
74
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
Other values (107) 542
42.1%
Common
ValueCountFrequency (%)
332
42.1%
1 67
 
8.5%
) 62
 
7.9%
( 62
 
7.9%
2 54
 
6.8%
3 36
 
4.6%
, 29
 
3.7%
0 28
 
3.5%
4 21
 
2.7%
8 19
 
2.4%
Other values (6) 79
 
10.0%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1287
62.0%
ASCII 790
38.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
332
42.0%
1 67
 
8.5%
) 62
 
7.8%
( 62
 
7.8%
2 54
 
6.8%
3 36
 
4.6%
, 29
 
3.7%
0 28
 
3.5%
4 21
 
2.7%
8 19
 
2.4%
Other values (7) 80
 
10.1%
Hangul
ValueCountFrequency (%)
79
 
6.1%
76
 
5.9%
76
 
5.9%
75
 
5.8%
74
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
73
 
5.7%
Other values (107) 542
42.1%

사업장전화번호
Text

MISSING 

Distinct50
Distinct (%)98.0%
Missing22
Missing (%)30.1%
Memory size712.0 B
2024-03-15T02:54:14.935665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique49 ?
Unique (%)96.1%

Sample

1st row063-445-5051
2nd row063-471-7766
3rd row063-446-3905
4th row063-471-4969
5th row063-445-0105
ValueCountFrequency (%)
063-451-0061 2
 
3.9%
063-443-4721 1
 
2.0%
063-445-2851 1
 
2.0%
063-445-5051 1
 
2.0%
063-462-1400 1
 
2.0%
063-443-4722 1
 
2.0%
063-461-2321 1
 
2.0%
063-446-0066 1
 
2.0%
063-465-5626 1
 
2.0%
063-466-8014 1
 
2.0%
Other values (40) 40
78.4%
2024-03-15T02:54:16.408082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 102
16.7%
6 101
16.5%
0 83
13.6%
4 82
13.4%
3 73
11.9%
5 37
 
6.0%
2 34
 
5.6%
1 32
 
5.2%
7 27
 
4.4%
8 23
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 510
83.3%
Dash Punctuation 102
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 101
19.8%
0 83
16.3%
4 82
16.1%
3 73
14.3%
5 37
 
7.3%
2 34
 
6.7%
1 32
 
6.3%
7 27
 
5.3%
8 23
 
4.5%
9 18
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 102
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 612
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 102
16.7%
6 101
16.5%
0 83
13.6%
4 82
13.4%
3 73
11.9%
5 37
 
6.0%
2 34
 
5.6%
1 32
 
5.2%
7 27
 
4.4%
8 23
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 612
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 102
16.7%
6 101
16.5%
0 83
13.6%
4 82
13.4%
3 73
11.9%
5 37
 
6.0%
2 34
 
5.6%
1 32
 
5.2%
7 27
 
4.4%
8 23
 
3.8%

Correlations

2024-03-15T02:54:16.683831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
안경업소명칭사업장소재지(도로명)사업장전화번호
안경업소명칭1.0001.0001.000
사업장소재지(도로명)1.0001.0001.000
사업장전화번호1.0001.0001.000

Missing values

2024-03-15T02:54:07.432769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T02:54:07.697046image/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으뜸50안경 군산디오션점전북특별자치도 군산시 궁포3로 8, 201호 (조촌동)063-445-5051
1안경나라 군산대점전북특별자치도 군산시 황룡로 9, 1층 102호 (미룡동)063-471-7766
2아이리움안경원 군산점전북특별자치도 군산시 궁포안1길 33, 102호 (조촌동)063-446-3905
3안경상회전북특별자치도 군산시 소룡안3길 30 (소룡동)<NA>
4라라렌즈lalalens전북특별자치도 군산시 나운2길 38, (중간통로 우측) (나운동)<NA>
5지니스안경 조촌지플레이스점전북특별자치도 군산시 궁포안2길 27, 121호 (조촌동)<NA>
6지니스안경 군산수송점전북특별자치도 군산시 월명로 190(수송동)063-471-4969
7다비치안경 군산나운점전북특별자치도 군산시 공단대로 384, 1층 101호 보청기실 일부 제외한 부분 (나운동)<NA>
8안경매니져전북특별자치도 군산시 대명길 3, 상가동 109호 (대명동, 현대메트로타워)063-445-0105
9이노티안경 군산수송점전북특별자치도 군산시 축동안3길 29 (수송동)063-466-0257
안경업소명칭사업장소재지(도로명)사업장전화번호
63시민안경원전북특별자치도 군산시 미원로 125 (중앙로3가)063-445-6656
64안경나라군산점전북특별자치도 군산시 나운2동 156-2 신일상가 102호063-467-0890
65안경대통령전북특별자치도 군산시 소룡동 1323063-467-6980
66안경나라전북특별자치도 군산시 백토로 118 (나운동)<NA>
67반도안경전북특별자치도 군산시 경암동 681-16063-443-2920
68안경대통령나운점전북특별자치도 군산시 나운동 789-32063-461-6980
69아이월드전북특별자치도 군산시 중앙로 152 (장미동)063-445-2290
70명성당안경원전북특별자치도 군산시 중정길 66 (신창동)063-445-2851
71일공공일안경중앙점전북특별자치도 군산시 중앙로1가 9-8063-442-6277
72안경박사중앙점전북특별자치도 군산시 월명로 478 (월명동)063-443-5522