Overview

Dataset statistics

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

Variable types

Text3

Dataset

Description안경업소명칭,사업장소재지(도로명),사업장전화번호
Author강북구
URLhttps://data.seoul.go.kr/dataList/OA-11583/S/1/datasetView.do

Alerts

사업장전화번호 has 5 (10.0%) missing valuesMissing
안경업소명칭 has unique valuesUnique
사업장소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-11 07:07:42.998211
Analysis finished2023-12-11 07:07:43.343181
Duration0.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

안경업소명칭
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-11T16:07:43.550779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length6.54
Min length3

Characters and Unicode

Total characters327
Distinct characters113
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

Unique50 ?
Unique (%)100.0%

Sample

1st row으뜸플러스안경 수유점
2nd row바이준안경원
3rd row우리들안경
4th row으뜸50안경
5th row부라더스
ValueCountFrequency (%)
수유점 4
 
6.7%
뉴그랑프리안경원 1
 
1.7%
안경나라수유점 1
 
1.7%
행복한안경씨 1
 
1.7%
명동안경 1
 
1.7%
제누네안경 1
 
1.7%
안경진정성 1
 
1.7%
세컨아이즈 1
 
1.7%
안경원 1
 
1.7%
미아안경나라 1
 
1.7%
Other values (47) 47
78.3%
2023-12-11T16:07:44.054486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
안 42
 
12.8%
경 41
 
12.5%
점 13
 
4.0%
아 12
 
3.7%
10
 
3.1%
미 9
 
2.8%
수 8
 
2.4%
원 8
 
2.4%
스 7
 
2.1%
유 7
 
2.1%
Other values (103) 170
52.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 311
95.1%
Space Separator 10
 
3.1%
Lowercase Letter 2
 
0.6%
Other Punctuation 2
 
0.6%
Decimal Number 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 42
 
13.5%
경 41
 
13.2%
점 13
 
4.2%
아 12
 
3.9%
미 9
 
2.9%
수 8
 
2.6%
원 8
 
2.6%
스 7
 
2.3%
유 7
 
2.3%
이 6
 
1.9%
Other values (96) 158
50.8%
Lowercase Letter
ValueCountFrequency (%)
y 1
50.0%
b 1
50.0%
Other Punctuation
ValueCountFrequency (%)
: 1
50.0%
. 1
50.0%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
5 1
50.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 311
95.1%
Common 14
 
4.3%
Latin 2
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 42
 
13.5%
경 41
 
13.2%
점 13
 
4.2%
아 12
 
3.9%
미 9
 
2.9%
수 8
 
2.6%
원 8
 
2.6%
스 7
 
2.3%
유 7
 
2.3%
이 6
 
1.9%
Other values (96) 158
50.8%
Common
ValueCountFrequency (%)
10
71.4%
: 1
 
7.1%
0 1
 
7.1%
5 1
 
7.1%
. 1
 
7.1%
Latin
ValueCountFrequency (%)
y 1
50.0%
b 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 311
95.1%
ASCII 16
 
4.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
안 42
 
13.5%
경 41
 
13.2%
점 13
 
4.2%
아 12
 
3.9%
미 9
 
2.9%
수 8
 
2.6%
원 8
 
2.6%
스 7
 
2.3%
유 7
 
2.3%
이 6
 
1.9%
Other values (96) 158
50.8%
ASCII
ValueCountFrequency (%)
10
62.5%
y 1
 
6.2%
b 1
 
6.2%
: 1
 
6.2%
0 1
 
6.2%
5 1
 
6.2%
. 1
 
6.2%

사업장소재지(도로명)
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-11T16:07:44.396449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length35
Mean length27.14
Min length21

Characters and Unicode

Total characters1357
Distinct characters85
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

Unique50 ?
Unique (%)100.0%

Sample

1st row서울특별시 강북구 도봉로 341, 2층 (수유동)
2nd row서울특별시 강북구 솔샘로 249-1 (미아동)
3rd row서울특별시 강북구 삼양로 589 (우이동)
4th row서울특별시 강북구 도봉로 327, 2층 (수유동)
5th row서울특별시 강북구 삼양로139가길 48, 2층 (우이동)
ValueCountFrequency (%)
서울특별시 50
17.9%
강북구 50
17.9%
미아동 22
 
7.9%
수유동 18
 
6.5%
도봉로 15
 
5.4%
삼양로 8
 
2.9%
번동 8
 
2.9%
1층 8
 
2.9%
한천로 5
 
1.8%
솔샘로 5
 
1.8%
Other values (82) 90
32.3%
2023-12-11T16:07:44.995661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
231
 
17.0%
서 51
 
3.8%
시 51
 
3.8%
북 51
 
3.8%
로 50
 
3.7%
) 50
 
3.7%
동 50
 
3.7%
( 50
 
3.7%
울 50
 
3.7%
구 50
 
3.7%
Other values (75) 673
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 794
58.5%
Space Separator 231
 
17.0%
Decimal Number 194
 
14.3%
Close Punctuation 50
 
3.7%
Open Punctuation 50
 
3.7%
Other Punctuation 31
 
2.3%
Dash Punctuation 7
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 51
 
6.4%
시 51
 
6.4%
북 51
 
6.4%
로 50
 
6.3%
동 50
 
6.3%
울 50
 
6.3%
구 50
 
6.3%
강 50
 
6.3%
별 50
 
6.3%
특 50
 
6.3%
Other values (60) 291
36.6%
Decimal Number
ValueCountFrequency (%)
1 41
21.1%
2 32
16.5%
4 23
11.9%
3 20
10.3%
7 18
9.3%
5 17
8.8%
9 15
 
7.7%
0 12
 
6.2%
6 8
 
4.1%
8 8
 
4.1%
Space Separator
ValueCountFrequency (%)
231
100.0%
Close Punctuation
ValueCountFrequency (%)
) 50
100.0%
Open Punctuation
ValueCountFrequency (%)
( 50
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 794
58.5%
Common 563
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 51
 
6.4%
시 51
 
6.4%
북 51
 
6.4%
로 50
 
6.3%
동 50
 
6.3%
울 50
 
6.3%
구 50
 
6.3%
강 50
 
6.3%
별 50
 
6.3%
특 50
 
6.3%
Other values (60) 291
36.6%
Common
ValueCountFrequency (%)
231
41.0%
) 50
 
8.9%
( 50
 
8.9%
1 41
 
7.3%
2 32
 
5.7%
, 31
 
5.5%
4 23
 
4.1%
3 20
 
3.6%
7 18
 
3.2%
5 17
 
3.0%
Other values (5) 50
 
8.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 794
58.5%
ASCII 563
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
231
41.0%
) 50
 
8.9%
( 50
 
8.9%
1 41
 
7.3%
2 32
 
5.7%
, 31
 
5.5%
4 23
 
4.1%
3 20
 
3.6%
7 18
 
3.2%
5 17
 
3.0%
Other values (5) 50
 
8.9%
Hangul
ValueCountFrequency (%)
서 51
 
6.4%
시 51
 
6.4%
북 51
 
6.4%
로 50
 
6.3%
동 50
 
6.3%
울 50
 
6.3%
구 50
 
6.3%
강 50
 
6.3%
별 50
 
6.3%
특 50
 
6.3%
Other values (60) 291
36.6%

사업장전화번호
Text

MISSING 

Distinct45
Distinct (%)100.0%
Missing5
Missing (%)10.0%
Memory size532.0 B
2023-12-11T16:07:45.342432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length10.911111
Min length8

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row02-991-2223
2nd row02-981-1001
3rd row02-906-1001
4th row02-998-5055
5th row02-906-1104
ValueCountFrequency (%)
02-987-4747 1
 
2.2%
02-999-6008 1
 
2.2%
02-982-0084 1
 
2.2%
02-981-1729 1
 
2.2%
02-902-8911-2 1
 
2.2%
02-998-4528 1
 
2.2%
02-945-4500 1
 
2.2%
02-980-0810 1
 
2.2%
02-984-0777 1
 
2.2%
02-989-4013 1
 
2.2%
Other values (35) 35
77.8%
2023-12-11T16:07:45.855055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 92
18.7%
- 88
17.9%
9 65
13.2%
2 60
12.2%
1 36
 
7.3%
8 35
 
7.1%
3 35
 
7.1%
7 25
 
5.1%
4 24
 
4.9%
6 16
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 403
82.1%
Dash Punctuation 88
 
17.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 92
22.8%
9 65
16.1%
2 60
14.9%
1 36
 
8.9%
8 35
 
8.7%
3 35
 
8.7%
7 25
 
6.2%
4 24
 
6.0%
6 16
 
4.0%
5 15
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 88
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 491
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 92
18.7%
- 88
17.9%
9 65
13.2%
2 60
12.2%
1 36
 
7.3%
8 35
 
7.1%
3 35
 
7.1%
7 25
 
5.1%
4 24
 
4.9%
6 16
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 491
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 92
18.7%
- 88
17.9%
9 65
13.2%
2 60
12.2%
1 36
 
7.3%
8 35
 
7.1%
3 35
 
7.1%
7 25
 
5.1%
4 24
 
4.9%
6 16
 
3.3%

Correlations

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

Missing values

2023-12-11T16:07:43.209656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T16:07:43.303741image/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으뜸플러스안경 수유점서울특별시 강북구 도봉로 341, 2층 (수유동)02-991-2223
1바이준안경원서울특별시 강북구 솔샘로 249-1 (미아동)02-981-1001
2우리들안경서울특별시 강북구 삼양로 589 (우이동)02-906-1001
3으뜸50안경서울특별시 강북구 도봉로 327, 2층 (수유동)02-998-5055
4부라더스서울특별시 강북구 삼양로139가길 48, 2층 (우이동)<NA>
5세상을쓰다서울특별시 강북구 오패산로 389-1, 1층 (번동)02-906-1104
6필그림안경콘택트서울특별시 강북구 도봉로96길 5-4, 1층 (번동)02-904-0303
7다비치안경원 미아사거리점서울특별시 강북구 월계로 3, 1층 (미아동, 덕신빌딩)02-434-4470
8보다:밝은안경서울특별시 강북구 솔샘로 243, 1층 (미아동)02-980-0818
9레온느안경 위드렌즈 수유점서울특별시 강북구 한천로 1057 (수유동)907-8277
안경업소명칭사업장소재지(도로명)사업장전화번호
40미아리더스안경클럽서울특별시 강북구 삼양로27길 43 (미아동)02-968-3933
41현대안경콘텍트서울특별시 강북구 오패산로 129 (미아동)02-988-0086
42진안경서울특별시 강북구 삼양로77길 2 (수유동, 청자빌딩)02-980-3300
43다본안경서울특별시 강북구 오현로32길 4-3 (번동, 다전빌딩)02-981-1593
44미래안서울특별시 강북구 도봉로 197 (미아동)02-981-1036
45스위스안경서울특별시 강북구 도봉로 353-1 (수유동)02-991-2770
46권박사안경서울특별시 강북구 삼양로 517 (수유동)02-903-7534
47중앙안경서울특별시 강북구 도봉로 352, 104호 (번동, 효성네오인텔리안)02-999-7761
48명동안경서울특별시 강북구 한천로 977 (번동)02-905-4347
49씨.채널안경서울특별시 강북구 삼양로 464 (수유동)02-903-1561