Overview

Dataset statistics

Number of variables3
Number of observations51
Missing cells4
Missing cells (%)2.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory26.6 B

Variable types

Text3

Dataset

Description부산광역시_금정구_안경업소현황_20230920
Author부산광역시 금정구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15025844

Alerts

사업장전화번호 has 4 (7.8%) missing valuesMissing

Reproduction

Analysis started2023-12-10 16:14:42.261081
Analysis finished2023-12-10 16:14:42.815407
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct48
Distinct (%)94.1%
Missing0
Missing (%)0.0%
Memory size540.0 B
2023-12-11T01:14:43.053324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length13
Mean length6.7254902
Min length4

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)90.2%

Sample

1st row룩&아이안경
2nd row하이브안경
3rd row유니유니
4th row으뜸50안경 부산대점
5th row유앤아이 부산대점
ValueCountFrequency (%)
갤러리안경 3
 
5.2%
부산대점 3
 
5.2%
눈사랑안경 2
 
3.4%
시민안경원 1
 
1.7%
channel 1
 
1.7%
갤러리안경원 1
 
1.7%
룩&아이안경 1
 
1.7%
디에치피안경점 1
 
1.7%
으뜸아이안경 1
 
1.7%
부곡점 1
 
1.7%
Other values (43) 43
74.1%
2023-12-11T01:14:43.549604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
41
 
12.0%
41
 
12.0%
11
 
3.2%
11
 
3.2%
10
 
2.9%
10
 
2.9%
9
 
2.6%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (109) 187
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 299
87.2%
Lowercase Letter 16
 
4.7%
Decimal Number 10
 
2.9%
Space Separator 7
 
2.0%
Uppercase Letter 5
 
1.5%
Open Punctuation 2
 
0.6%
Close Punctuation 2
 
0.6%
Other Punctuation 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
41
 
13.7%
41
 
13.7%
11
 
3.7%
11
 
3.7%
10
 
3.3%
10
 
3.3%
9
 
3.0%
8
 
2.7%
8
 
2.7%
7
 
2.3%
Other values (87) 143
47.8%
Lowercase Letter
ValueCountFrequency (%)
e 3
18.8%
c 2
12.5%
a 2
12.5%
l 2
12.5%
n 2
12.5%
s 1
 
6.2%
h 1
 
6.2%
i 1
 
6.2%
t 1
 
6.2%
p 1
 
6.2%
Decimal Number
ValueCountFrequency (%)
0 5
50.0%
1 2
 
20.0%
8 2
 
20.0%
5 1
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
O 3
60.0%
L 1
 
20.0%
K 1
 
20.0%
Other Punctuation
ValueCountFrequency (%)
& 1
50.0%
· 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 299
87.2%
Common 23
 
6.7%
Latin 21
 
6.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
41
 
13.7%
41
 
13.7%
11
 
3.7%
11
 
3.7%
10
 
3.3%
10
 
3.3%
9
 
3.0%
8
 
2.7%
8
 
2.7%
7
 
2.3%
Other values (87) 143
47.8%
Latin
ValueCountFrequency (%)
e 3
14.3%
O 3
14.3%
c 2
9.5%
a 2
9.5%
l 2
9.5%
n 2
9.5%
s 1
 
4.8%
h 1
 
4.8%
i 1
 
4.8%
L 1
 
4.8%
Other values (3) 3
14.3%
Common
ValueCountFrequency (%)
7
30.4%
0 5
21.7%
( 2
 
8.7%
) 2
 
8.7%
1 2
 
8.7%
8 2
 
8.7%
5 1
 
4.3%
& 1
 
4.3%
· 1
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 299
87.2%
ASCII 43
 
12.5%
None 1
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
41
 
13.7%
41
 
13.7%
11
 
3.7%
11
 
3.7%
10
 
3.3%
10
 
3.3%
9
 
3.0%
8
 
2.7%
8
 
2.7%
7
 
2.3%
Other values (87) 143
47.8%
ASCII
ValueCountFrequency (%)
7
16.3%
0 5
 
11.6%
e 3
 
7.0%
O 3
 
7.0%
( 2
 
4.7%
c 2
 
4.7%
a 2
 
4.7%
l 2
 
4.7%
) 2
 
4.7%
1 2
 
4.7%
Other values (11) 13
30.2%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct49
Distinct (%)96.1%
Missing0
Missing (%)0.0%
Memory size540.0 B
2023-12-11T01:14:43.901412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length42
Mean length26.745098
Min length21

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)92.2%

Sample

1st row부산광역시 금정구 부곡로 113, 1층 (부곡동)
2nd row부산광역시 금정구 명서로45번길 53, 2층 203호 (서동)
3rd row부산광역시 금정구 명서로45번길 53, 2층 201호 (서동)
4th row부산광역시 금정구 금정로 61, 2층 (장전동)
5th row부산광역시 금정구 부산대학로 63 (장전동)
ValueCountFrequency (%)
부산광역시 51
18.2%
금정구 51
18.2%
장전동 23
 
8.2%
금정로 9
 
3.2%
서동 8
 
2.9%
구서동 7
 
2.5%
부산대학로 7
 
2.5%
부곡동 7
 
2.5%
1층 6
 
2.1%
남산동 5
 
1.8%
Other values (77) 106
37.9%
2023-12-11T01:14:44.407985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
229
 
16.8%
73
 
5.4%
68
 
5.0%
66
 
4.8%
61
 
4.5%
61
 
4.5%
59
 
4.3%
53
 
3.9%
52
 
3.8%
51
 
3.7%
Other values (58) 591
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 818
60.0%
Space Separator 229
 
16.8%
Decimal Number 185
 
13.6%
Open Punctuation 51
 
3.7%
Close Punctuation 51
 
3.7%
Other Punctuation 21
 
1.5%
Dash Punctuation 6
 
0.4%
Uppercase Letter 2
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
73
 
8.9%
68
 
8.3%
66
 
8.1%
61
 
7.5%
61
 
7.5%
59
 
7.2%
53
 
6.5%
52
 
6.4%
51
 
6.2%
51
 
6.2%
Other values (41) 223
27.3%
Decimal Number
ValueCountFrequency (%)
1 45
24.3%
2 30
16.2%
5 19
10.3%
7 18
 
9.7%
3 17
 
9.2%
6 16
 
8.6%
4 12
 
6.5%
9 12
 
6.5%
0 12
 
6.5%
8 4
 
2.2%
Space Separator
ValueCountFrequency (%)
229
100.0%
Open Punctuation
ValueCountFrequency (%)
( 51
100.0%
Close Punctuation
ValueCountFrequency (%)
) 51
100.0%
Other Punctuation
ValueCountFrequency (%)
, 21
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 2
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 818
60.0%
Common 544
39.9%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
73
 
8.9%
68
 
8.3%
66
 
8.1%
61
 
7.5%
61
 
7.5%
59
 
7.2%
53
 
6.5%
52
 
6.4%
51
 
6.2%
51
 
6.2%
Other values (41) 223
27.3%
Common
ValueCountFrequency (%)
229
42.1%
( 51
 
9.4%
) 51
 
9.4%
1 45
 
8.3%
2 30
 
5.5%
, 21
 
3.9%
5 19
 
3.5%
7 18
 
3.3%
3 17
 
3.1%
6 16
 
2.9%
Other values (6) 47
 
8.6%
Latin
ValueCountFrequency (%)
A 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 818
60.0%
ASCII 546
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
229
41.9%
( 51
 
9.3%
) 51
 
9.3%
1 45
 
8.2%
2 30
 
5.5%
, 21
 
3.8%
5 19
 
3.5%
7 18
 
3.3%
3 17
 
3.1%
6 16
 
2.9%
Other values (7) 49
 
9.0%
Hangul
ValueCountFrequency (%)
73
 
8.9%
68
 
8.3%
66
 
8.1%
61
 
7.5%
61
 
7.5%
59
 
7.2%
53
 
6.5%
52
 
6.4%
51
 
6.2%
51
 
6.2%
Other values (41) 223
27.3%

사업장전화번호
Text

MISSING 

Distinct47
Distinct (%)100.0%
Missing4
Missing (%)7.8%
Memory size540.0 B
2023-12-11T01:14:44.773561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique47 ?
Unique (%)100.0%

Sample

1st row051-518-5051
2nd row051-517-7707
3rd row051-523-5454
4th row051-517-7585
5th row051-517-6834
ValueCountFrequency (%)
051-518-5051 1
 
2.1%
051-522-2085 1
 
2.1%
051-583-7775 1
 
2.1%
051-524-7900 1
 
2.1%
051-583-3322 1
 
2.1%
051-513-9515 1
 
2.1%
051-583-7044 1
 
2.1%
051-583-1112 1
 
2.1%
051-524-0232 1
 
2.1%
051-513-6200 1
 
2.1%
Other values (37) 37
78.7%
2023-12-11T01:14:45.300520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 117
20.7%
- 94
16.7%
1 92
16.3%
0 80
14.2%
2 31
 
5.5%
3 30
 
5.3%
7 30
 
5.3%
8 29
 
5.1%
4 22
 
3.9%
6 20
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 470
83.3%
Dash Punctuation 94
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 117
24.9%
1 92
19.6%
0 80
17.0%
2 31
 
6.6%
3 30
 
6.4%
7 30
 
6.4%
8 29
 
6.2%
4 22
 
4.7%
6 20
 
4.3%
9 19
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 94
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 564
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 117
20.7%
- 94
16.7%
1 92
16.3%
0 80
14.2%
2 31
 
5.5%
3 30
 
5.3%
7 30
 
5.3%
8 29
 
5.1%
4 22
 
3.9%
6 20
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 564
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 117
20.7%
- 94
16.7%
1 92
16.3%
0 80
14.2%
2 31
 
5.5%
3 30
 
5.3%
7 30
 
5.3%
8 29
 
5.1%
4 22
 
3.9%
6 20
 
3.5%

Correlations

2023-12-11T01:14:45.457365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
안경업소명칭사업장소재지(도로명)사업장전화번호
안경업소명칭1.0000.9691.000
사업장소재지(도로명)0.9691.0001.000
사업장전화번호1.0001.0001.000

Missing values

2023-12-11T01:14:42.655647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:14:42.769030image/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룩&아이안경부산광역시 금정구 부곡로 113, 1층 (부곡동)<NA>
1하이브안경부산광역시 금정구 명서로45번길 53, 2층 203호 (서동)<NA>
2유니유니부산광역시 금정구 명서로45번길 53, 2층 201호 (서동)<NA>
3으뜸50안경 부산대점부산광역시 금정구 금정로 61, 2층 (장전동)051-518-5051
4유앤아이 부산대점부산광역시 금정구 부산대학로 63 (장전동)<NA>
5굿모닝안경부산광역시 금정구 장전온천천로 55, 1층 (장전동)051-517-7707
6나진안경콘텍트부산광역시 금정구 서동중심로 46, 1층 (서동)051-523-5454
7으뜸플러스안경부산광역시 금정구 장전온천천로 51, 211~212호 (장전동, 테라스파크)051-517-7585
8글라스미 렌즈미 부산대점부산광역시 금정구 금정로68번길 34 (장전동)051-517-6834
9오렌지안경원부산광역시 금정구 중앙대로 2002-1, 1층 (남산동)051-759-9881
안경업소명칭사업장소재지(도로명)사업장전화번호
41갤러리안경부산광역시 금정구 금정로 77-1 (장전동)051-514-4333
42안경홀릭부산광역시 금정구 금정로 77 (장전동)051-512-7452
43눈사랑안경부산광역시 금정구 금정로 79 (장전동)051-582-9933
44안경바보부산광역시 금정구 금정로 84 (장전동)051-517-0555
45안경테백화점부산광역시 금정구 금정로 79-1 (장전동)051-513-8328
46제일안경원(see channel)부산광역시 금정구 금강로 567 (구서동)051-516-1803
47시민안경원부산광역시 금정구 서동로149번길 5 (서동)051-526-9900
48금화안경원부산광역시 금정구 서동중심로 51-1 (서동)051-526-1081
490808안경원부산광역시 금정구 중앙대로 2097 (남산동)051-513-0808
50문창부대안경부산광역시 금정구 부산대학로63번길 2-1, 2005호 (장전동, 효원굿플러스)051-581-6495