Overview

Dataset statistics

Number of variables4
Number of observations55
Missing cells9
Missing cells (%)4.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory35.4 B

Variable types

Numeric1
Text3

Dataset

Description동구 관내 안경업소 현황으로 2023.1.2. 기준 안경업소명, 도로명 주소 및 사업장 전화번호의 정보를 제공합니다.
Author대전광역시 동구
URLhttps://www.data.go.kr/data/3081064/fileData.do

Alerts

사업장전화번호 has 9 (16.4%) missing valuesMissing
순번 has unique valuesUnique
안경업소명칭 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:36:39.338603
Analysis finished2023-12-12 21:36:39.772799
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct55
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28
Minimum1
Maximum55
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size627.0 B
2023-12-13T06:36:39.847106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.7
Q114.5
median28
Q341.5
95-th percentile52.3
Maximum55
Range54
Interquartile range (IQR)27

Descriptive statistics

Standard deviation16.02082
Coefficient of variation (CV)0.57217214
Kurtosis-1.2
Mean28
Median Absolute Deviation (MAD)14
Skewness0
Sum1540
Variance256.66667
MonotonicityStrictly increasing
2023-12-13T06:36:39.989022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.8%
2 1
 
1.8%
31 1
 
1.8%
32 1
 
1.8%
33 1
 
1.8%
34 1
 
1.8%
35 1
 
1.8%
36 1
 
1.8%
37 1
 
1.8%
38 1
 
1.8%
Other values (45) 45
81.8%
ValueCountFrequency (%)
1 1
1.8%
2 1
1.8%
3 1
1.8%
4 1
1.8%
5 1
1.8%
6 1
1.8%
7 1
1.8%
8 1
1.8%
9 1
1.8%
10 1
1.8%
ValueCountFrequency (%)
55 1
1.8%
54 1
1.8%
53 1
1.8%
52 1
1.8%
51 1
1.8%
50 1
1.8%
49 1
1.8%
48 1
1.8%
47 1
1.8%
46 1
1.8%

안경업소명칭
Text

UNIQUE 

Distinct55
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size572.0 B
2023-12-13T06:36:40.225327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length14
Mean length8.2
Min length3

Characters and Unicode

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

Unique

Unique55 ?
Unique (%)100.0%

Sample

1st rowGLASS FAMILY(글라스패밀리)
2nd row더베이직안경원
3rd row안경플래너(성남점)
4th row아이피아안경원(동대전홈플러스점)
5th row원셀프안경콘택트(대동역점)
ValueCountFrequency (%)
아쿠아이즈안경원 2
 
3.0%
오렌즈 2
 
3.0%
glass 1
 
1.5%
안경매니아한남대점 1
 
1.5%
안경닥터 1
 
1.5%
정안경원 1
 
1.5%
수안경원 1
 
1.5%
글라스반 1
 
1.5%
애체안경원 1
 
1.5%
서울안경 1
 
1.5%
Other values (54) 54
81.8%
2023-12-13T06:36:40.605141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
경 49
 
10.9%
안 49
 
10.9%
원 20
 
4.4%
점 20
 
4.4%
대 19
 
4.2%
아 14
 
3.1%
11
 
2.4%
콘 9
 
2.0%
트 9
 
2.0%
이 8
 
1.8%
Other values (116) 243
53.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 410
90.9%
Space Separator 11
 
2.4%
Uppercase Letter 11
 
2.4%
Close Punctuation 7
 
1.6%
Open Punctuation 7
 
1.6%
Decimal Number 4
 
0.9%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 49
 
12.0%
안 49
 
12.0%
원 20
 
4.9%
점 20
 
4.9%
대 19
 
4.6%
아 14
 
3.4%
콘 9
 
2.2%
트 9
 
2.2%
이 8
 
2.0%
스 8
 
2.0%
Other values (102) 205
50.0%
Uppercase Letter
ValueCountFrequency (%)
L 2
18.2%
A 2
18.2%
S 2
18.2%
G 1
9.1%
Y 1
9.1%
I 1
9.1%
M 1
9.1%
F 1
9.1%
Decimal Number
ValueCountFrequency (%)
0 2
50.0%
1 2
50.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 410
90.9%
Common 30
 
6.7%
Latin 11
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 49
 
12.0%
안 49
 
12.0%
원 20
 
4.9%
점 20
 
4.9%
대 19
 
4.6%
아 14
 
3.4%
콘 9
 
2.2%
트 9
 
2.2%
이 8
 
2.0%
스 8
 
2.0%
Other values (102) 205
50.0%
Latin
ValueCountFrequency (%)
L 2
18.2%
A 2
18.2%
S 2
18.2%
G 1
9.1%
Y 1
9.1%
I 1
9.1%
M 1
9.1%
F 1
9.1%
Common
ValueCountFrequency (%)
11
36.7%
) 7
23.3%
( 7
23.3%
0 2
 
6.7%
1 2
 
6.7%
. 1
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 410
90.9%
ASCII 41
 
9.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
경 49
 
12.0%
안 49
 
12.0%
원 20
 
4.9%
점 20
 
4.9%
대 19
 
4.6%
아 14
 
3.4%
콘 9
 
2.2%
트 9
 
2.2%
이 8
 
2.0%
스 8
 
2.0%
Other values (102) 205
50.0%
ASCII
ValueCountFrequency (%)
11
26.8%
) 7
17.1%
( 7
17.1%
L 2
 
4.9%
0 2
 
4.9%
A 2
 
4.9%
S 2
 
4.9%
1 2
 
4.9%
. 1
 
2.4%
G 1
 
2.4%
Other values (4) 4
 
9.8%

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

Distinct54
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size572.0 B
2023-12-13T06:36:40.886317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length38
Mean length26.545455
Min length20

Characters and Unicode

Total characters1460
Distinct characters103
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

Unique53 ?
Unique (%)96.4%

Sample

1st row대전광역시 동구 옥천로 183, 판암퍼스트타워 107,108호 (판암동)
2nd row대전광역시 동구 한밭대로 1322, 2층 203,204호 (용전동)
3rd row대전광역시 동구 우암로 169 (성남동)
4th row대전광역시 동구 한밭대로 1282, (주)홈플러스 (주)동대전점 2층 (용전동)
5th row대전광역시 동구 동대전로 51, 1층 (대동)
ValueCountFrequency (%)
대전광역시 55
 
18.0%
동구 55
 
18.0%
동대전로 8
 
2.6%
홍도동 7
 
2.3%
대동 7
 
2.3%
용전동 7
 
2.3%
가오동 6
 
2.0%
1층 6
 
2.0%
용운동 5
 
1.6%
가양동 5
 
1.6%
Other values (109) 144
47.2%
2023-12-13T06:36:41.417795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
250
17.1%
동 131
 
9.0%
대 90
 
6.2%
전 80
 
5.5%
1 67
 
4.6%
( 59
 
4.0%
) 59
 
4.0%
구 58
 
4.0%
역 56
 
3.8%
광 55
 
3.8%
Other values (93) 555
38.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 828
56.7%
Space Separator 250
 
17.1%
Decimal Number 233
 
16.0%
Open Punctuation 59
 
4.0%
Close Punctuation 59
 
4.0%
Other Punctuation 17
 
1.2%
Dash Punctuation 11
 
0.8%
Uppercase Letter 2
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 131
15.8%
대 90
10.9%
전 80
 
9.7%
구 58
 
7.0%
역 56
 
6.8%
광 55
 
6.6%
시 55
 
6.6%
로 54
 
6.5%
용 16
 
1.9%
가 13
 
1.6%
Other values (75) 220
26.6%
Decimal Number
ValueCountFrequency (%)
1 67
28.8%
2 33
14.2%
8 20
 
8.6%
6 19
 
8.2%
0 18
 
7.7%
3 17
 
7.3%
7 16
 
6.9%
9 15
 
6.4%
5 15
 
6.4%
4 13
 
5.6%
Uppercase Letter
ValueCountFrequency (%)
W 1
50.0%
E 1
50.0%
Space Separator
ValueCountFrequency (%)
250
100.0%
Open Punctuation
ValueCountFrequency (%)
( 59
100.0%
Close Punctuation
ValueCountFrequency (%)
) 59
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 828
56.7%
Common 630
43.2%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 131
15.8%
대 90
10.9%
전 80
 
9.7%
구 58
 
7.0%
역 56
 
6.8%
광 55
 
6.6%
시 55
 
6.6%
로 54
 
6.5%
용 16
 
1.9%
가 13
 
1.6%
Other values (75) 220
26.6%
Common
ValueCountFrequency (%)
250
39.7%
1 67
 
10.6%
( 59
 
9.4%
) 59
 
9.4%
2 33
 
5.2%
8 20
 
3.2%
6 19
 
3.0%
0 18
 
2.9%
, 17
 
2.7%
3 17
 
2.7%
Other values (6) 71
 
11.3%
Latin
ValueCountFrequency (%)
W 1
50.0%
E 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 828
56.7%
ASCII 632
43.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
250
39.6%
1 67
 
10.6%
( 59
 
9.3%
) 59
 
9.3%
2 33
 
5.2%
8 20
 
3.2%
6 19
 
3.0%
0 18
 
2.8%
, 17
 
2.7%
3 17
 
2.7%
Other values (8) 73
 
11.6%
Hangul
ValueCountFrequency (%)
동 131
15.8%
대 90
10.9%
전 80
 
9.7%
구 58
 
7.0%
역 56
 
6.8%
광 55
 
6.6%
시 55
 
6.6%
로 54
 
6.5%
용 16
 
1.9%
가 13
 
1.6%
Other values (75) 220
26.6%

사업장전화번호
Text

MISSING 

Distinct46
Distinct (%)100.0%
Missing9
Missing (%)16.4%
Memory size572.0 B
2023-12-13T06:36:41.743120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.021739
Min length12

Characters and Unicode

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

Unique46 ?
Unique (%)100.0%

Sample

1st row042-272-7757
2nd row042-622-1088
3rd row042-300-8008
4th row042-826-0933
5th row042-256-1080
ValueCountFrequency (%)
070-7787-9122 1
 
2.2%
042-639-1001 1
 
2.2%
042-672-0085 1
 
2.2%
042-623-6971 1
 
2.2%
042-271-4884 1
 
2.2%
042-627-1777 1
 
2.2%
042-637-6007 1
 
2.2%
042-627-3638 1
 
2.2%
042-627-1118 1
 
2.2%
042-274-1181 1
 
2.2%
Other values (36) 36
78.3%
2023-12-13T06:36:42.396420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 100
18.1%
- 92
16.6%
0 82
14.8%
4 66
11.9%
6 42
7.6%
7 39
 
7.1%
8 35
 
6.3%
1 30
 
5.4%
5 26
 
4.7%
3 24
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 461
83.4%
Dash Punctuation 92
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 100
21.7%
0 82
17.8%
4 66
14.3%
6 42
9.1%
7 39
 
8.5%
8 35
 
7.6%
1 30
 
6.5%
5 26
 
5.6%
3 24
 
5.2%
9 17
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 553
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 100
18.1%
- 92
16.6%
0 82
14.8%
4 66
11.9%
6 42
7.6%
7 39
 
7.1%
8 35
 
6.3%
1 30
 
5.4%
5 26
 
4.7%
3 24
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 553
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 100
18.1%
- 92
16.6%
0 82
14.8%
4 66
11.9%
6 42
7.6%
7 39
 
7.1%
8 35
 
6.3%
1 30
 
5.4%
5 26
 
4.7%
3 24
 
4.3%

Interactions

2023-12-13T06:36:39.548919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:36:42.518906image/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-13T06:36:39.638655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:36:39.736490image/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

순번안경업소명칭사업장소재지(도로명)사업장전화번호
01GLASS FAMILY(글라스패밀리)대전광역시 동구 옥천로 183, 판암퍼스트타워 107,108호 (판암동)042-272-7757
12더베이직안경원대전광역시 동구 한밭대로 1322, 2층 203,204호 (용전동)042-622-1088
23안경플래너(성남점)대전광역시 동구 우암로 169 (성남동)042-300-8008
34아이피아안경원(동대전홈플러스점)대전광역시 동구 한밭대로 1282, (주)홈플러스 (주)동대전점 2층 (용전동)042-826-0933
45원셀프안경콘택트(대동역점)대전광역시 동구 동대전로 51, 1층 (대동)042-256-1080
56안경매니아(용운점)대전광역시 동구 백룡로 145, 1층 (용운동)<NA>
67오렌즈 대전복합터미널점대전광역시 동구 동서대로 1689, 대전복합터미널(서관) EW120호 (용전동)<NA>
78렌즈미대전광역시 동구 동서대로1695번길 12 (용전동)042-719-1025
89안경매니져 우송대점대전광역시 동구 동대전로 119-3, 1층 (대동, 아썸타워)<NA>
910오케이글라스대전광역시 동구 대전로448번길 85-29 (가오동)<NA>
순번안경업소명칭사업장소재지(도로명)사업장전화번호
4546새롬안경원대전광역시 동구 동산초교로 21-2 (홍도동)042-635-3467
4647안경마을대전광역시 동구 동대전로 272, 타임빌딩 1층 103호 (가양동)042-625-3600
4748남안경점대전광역시 동구 대전로 834 (정동)042-221-0101
4849대신당안경원대전광역시 동구 새둑길 3 (신안동)042-625-9987
4950아쿠아이즈안경원대전광역시 동구 동대전로 130-2 (대동)042-673-2492
5051안경나라보건대점대전광역시 동구 동서대로1754번길 82, 1층 (가양동)<NA>
5152동아안경원대전광역시 동구 충정로 5 (가양동)042-626-5557
5253명신안경원대전광역시 동구 대전로791번길 5 (중동)042-226-5805
5354윙크안경콘택트대전광역시 동구 용운로 162 (용운동)042-286-8008
5455오렌즈우송대점 안경나라대전광역시 동구 동대전로 160 (자양동)042-627-9613