Overview

Dataset statistics

Number of variables4
Number of observations50
Missing cells2
Missing cells (%)1.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory35.6 B

Variable types

Numeric1
Text3

Dataset

Description서울특별시 강북구 관내 운영중인 안경업소 현황현황에 관련한 정보 (안경업소명칭 자료, 사업장소재지(도로명) 자료, 사업장전화번호 자료)
URLhttps://www.data.go.kr/data/15055381/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 14:17:43.654932
Analysis finished2023-12-12 14:17:44.175597
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.5
Minimum1
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T23:17:44.260969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.45
Q113.25
median25.5
Q337.75
95-th percentile47.55
Maximum50
Range49
Interquartile range (IQR)24.5

Descriptive statistics

Standard deviation14.57738
Coefficient of variation (CV)0.57166195
Kurtosis-1.2
Mean25.5
Median Absolute Deviation (MAD)12.5
Skewness0
Sum1275
Variance212.5
MonotonicityStrictly increasing
2023-12-12T23:17:44.449679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
2.0%
39 1
 
2.0%
29 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
36 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
ValueCountFrequency (%)
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%

안경업소명칭
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-12T23:17:44.707030image/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-12T23:17:45.168323image/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%
Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-12T23:17:45.488049image/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-12T23:17:45.939711image/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 

Distinct48
Distinct (%)100.0%
Missing2
Missing (%)4.0%
Memory size532.0 B
2023-12-12T23:17:46.194837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length11.166667
Min length11

Characters and Unicode

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

Unique48 ?
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-996-5343 1
 
2.1%
02-945-7002 1
 
2.1%
02-996-9966 1
 
2.1%
02-988-1337 1
 
2.1%
02-999-6008 1
 
2.1%
02-981-1729 1
 
2.1%
02-902-8911-2 1
 
2.1%
02-998-4528 1
 
2.1%
02-945-4500 1
 
2.1%
02-980-0810 1
 
2.1%
Other values (38) 38
79.2%
2023-12-12T23:17:46.556097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 102
19.0%
- 97
18.1%
9 69
12.9%
2 67
12.5%
1 40
 
7.5%
3 37
 
6.9%
8 36
 
6.7%
4 27
 
5.0%
7 27
 
5.0%
6 18
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 439
81.9%
Dash Punctuation 97
 
18.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 102
23.2%
9 69
15.7%
2 67
15.3%
1 40
 
9.1%
3 37
 
8.4%
8 36
 
8.2%
4 27
 
6.2%
7 27
 
6.2%
6 18
 
4.1%
5 16
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 97
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 536
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 102
19.0%
- 97
18.1%
9 69
12.9%
2 67
12.5%
1 40
 
7.5%
3 37
 
6.9%
8 36
 
6.7%
4 27
 
5.0%
7 27
 
5.0%
6 18
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 536
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 102
19.0%
- 97
18.1%
9 69
12.9%
2 67
12.5%
1 40
 
7.5%
3 37
 
6.9%
8 36
 
6.7%
4 27
 
5.0%
7 27
 
5.0%
6 18
 
3.4%

Interactions

2023-12-12T23:17:43.881628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:17:46.664781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번안경업소명칭사업장소재지(도로명)사업장전화번호
순번1.0001.0001.0001.000
안경업소명칭1.0001.0001.0001.000
사업장소재지(도로명)1.0001.0001.0001.000
사업장전화번호1.0001.0001.0001.000

Missing values

2023-12-12T23:17:44.009282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:17:44.134623image/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

순번안경업소명칭사업장소재지(도로명)사업장전화번호
01으뜸플러스안경 수유점서울특별시 강북구 도봉로 341, 2층 (수유동)02-991-2223
12바이준안경원서울특별시 강북구 솔샘로 249-1 (미아동)02-981-1001
23우리들안경서울특별시 강북구 삼양로 589 (우이동)02-906-1001
34으뜸50안경서울특별시 강북구 도봉로 327, 2층 (수유동)02-998-5055
45부라더스서울특별시 강북구 삼양로139가길 48, 2층 (우이동)<NA>
56세상을쓰다서울특별시 강북구 오패산로 389-1, 1층 (번동)02-906-1104
67필그림안경콘택트서울특별시 강북구 도봉로96길 5-4, 1층 (번동)02-904-0303
78다비치안경원 미아사거리점서울특별시 강북구 월계로 3, 1층 (미아동, 덕신빌딩)02-434-4470
89보다:밝은안경서울특별시 강북구 솔샘로 243, 1층 (미아동)02-980-0818
910레온느안경 위드렌즈 수유점서울특별시 강북구 한천로 1057 (수유동)02-907-8277
순번안경업소명칭사업장소재지(도로명)사업장전화번호
4041미아리더스안경클럽서울특별시 강북구 삼양로27길 43 (미아동)02-968-3933
4142현대안경콘텍트서울특별시 강북구 오패산로 129 (미아동)02-988-0086
4243진안경서울특별시 강북구 삼양로77길 2 (수유동, 청자빌딩)02-980-3300
4344다본안경서울특별시 강북구 오현로32길 4-3 (번동, 다전빌딩)02-981-1593
4445미래안서울특별시 강북구 도봉로 197 (미아동)02-981-1036
4546스위스안경서울특별시 강북구 도봉로 353-1 (수유동)02-991-2770
4647권박사안경서울특별시 강북구 삼양로 517 (수유동)02-903-7534
4748중앙안경서울특별시 강북구 도봉로 352, 104호 (번동, 효성네오인텔리안)02-999-7761
4849명동안경서울특별시 강북구 한천로 977 (번동)02-905-4347
4950씨.채널안경서울특별시 강북구 삼양로 464 (수유동)02-903-1561