Overview

Dataset statistics

Number of variables5
Number of observations49
Missing cells5
Missing cells (%)2.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory43.7 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description인천광역시 계양구 관내 안경업소 현황에 대한 데이터로, 안경업소 명칭, 사업장 소재지(도로명 주소), 사업장 전화번호 등을 제공합니다.
Author인천광역시 계양구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=3077871&srcSe=7661IVAWM27C61E190

Alerts

기준일자 has constant value ""Constant
사업장전화번호 has 5 (10.2%) missing valuesMissing
순번 has unique valuesUnique
사업장소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-03-13 06:05:38.232614
Analysis finished2024-03-13 06:05:38.697246
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25
Minimum1
Maximum49
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2024-03-13T15:05:38.771020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.4
Q113
median25
Q337
95-th percentile46.6
Maximum49
Range48
Interquartile range (IQR)24

Descriptive statistics

Standard deviation14.28869
Coefficient of variation (CV)0.57154761
Kurtosis-1.2
Mean25
Median Absolute Deviation (MAD)12
Skewness0
Sum1225
Variance204.16667
MonotonicityStrictly increasing
2024-03-13T15:05:38.909317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
1 1
 
2.0%
38 1
 
2.0%
28 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%
Other values (39) 39
79.6%
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 (%)
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%
40 1
2.0%
Distinct48
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
2024-03-13T15:05:39.160001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length16
Mean length7.9795918
Min length3

Characters and Unicode

Total characters391
Distinct characters110
Distinct categories6 ?
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 (%)95.9%

Sample

1st row안경마을
2nd row으뜸50안경 계양구청점
3rd row위드아이안경
4th row으뜸플러스 인천계산점
5th row플러스
ValueCountFrequency (%)
안경 3
 
4.1%
서전안경백화점 2
 
2.7%
글라스 2
 
2.7%
안경콘택트 2
 
2.7%
동양점 2
 
2.7%
밝은눈안경 2
 
2.7%
우리안경콘텍트 1
 
1.4%
으뜸플러스안경 1
 
1.4%
효성점 1
 
1.4%
으뜸50안경 1
 
1.4%
Other values (56) 56
76.7%
2024-03-13T15:05:39.560801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
43
 
11.0%
43
 
11.0%
24
 
6.1%
18
 
4.6%
11
 
2.8%
11
 
2.8%
11
 
2.8%
9
 
2.3%
8
 
2.0%
6
 
1.5%
Other values (100) 207
52.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 343
87.7%
Space Separator 24
 
6.1%
Decimal Number 10
 
2.6%
Uppercase Letter 10
 
2.6%
Open Punctuation 2
 
0.5%
Close Punctuation 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
43
 
12.5%
43
 
12.5%
18
 
5.2%
11
 
3.2%
11
 
3.2%
11
 
3.2%
9
 
2.6%
8
 
2.3%
6
 
1.7%
6
 
1.7%
Other values (85) 177
51.6%
Uppercase Letter
ValueCountFrequency (%)
L 2
20.0%
S 2
20.0%
G 1
10.0%
A 1
10.0%
W 1
10.0%
O 1
10.0%
R 1
10.0%
D 1
10.0%
Decimal Number
ValueCountFrequency (%)
0 5
50.0%
1 3
30.0%
8 1
 
10.0%
5 1
 
10.0%
Space Separator
ValueCountFrequency (%)
24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 343
87.7%
Common 38
 
9.7%
Latin 10
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
43
 
12.5%
43
 
12.5%
18
 
5.2%
11
 
3.2%
11
 
3.2%
11
 
3.2%
9
 
2.6%
8
 
2.3%
6
 
1.7%
6
 
1.7%
Other values (85) 177
51.6%
Latin
ValueCountFrequency (%)
L 2
20.0%
S 2
20.0%
G 1
10.0%
A 1
10.0%
W 1
10.0%
O 1
10.0%
R 1
10.0%
D 1
10.0%
Common
ValueCountFrequency (%)
24
63.2%
0 5
 
13.2%
1 3
 
7.9%
( 2
 
5.3%
) 2
 
5.3%
8 1
 
2.6%
5 1
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 343
87.7%
ASCII 48
 
12.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
43
 
12.5%
43
 
12.5%
18
 
5.2%
11
 
3.2%
11
 
3.2%
11
 
3.2%
9
 
2.6%
8
 
2.3%
6
 
1.7%
6
 
1.7%
Other values (85) 177
51.6%
ASCII
ValueCountFrequency (%)
24
50.0%
0 5
 
10.4%
1 3
 
6.2%
( 2
 
4.2%
L 2
 
4.2%
S 2
 
4.2%
) 2
 
4.2%
8 1
 
2.1%
5 1
 
2.1%
G 1
 
2.1%
Other values (5) 5
 
10.4%
Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
2024-03-13T15:05:39.797956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length39
Mean length28.469388
Min length22

Characters and Unicode

Total characters1395
Distinct characters112
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

Unique49 ?
Unique (%)100.0%

Sample

1st row인천광역시 계양구 장제로 867, 1층 104호 (임학동)
2nd row인천광역시 계양구 계산새로 71, 하이베라스 D동 305호 (계산동)
3rd row인천광역시 계양구 장제로 822, 롯데마트 계양점 2층 (계산동)
4th row인천광역시 계양구 경명대로 1090, 계산메가타운 3층 302호 (계산동)
5th row인천광역시 계양구 경명대로 1137 (계산동)
ValueCountFrequency (%)
인천광역시 49
17.1%
계양구 49
17.1%
계산동 19
 
6.6%
작전동 13
 
4.5%
1층 8
 
2.8%
경명대로 7
 
2.4%
계양대로 7
 
2.4%
장제로 7
 
2.4%
동양동 3
 
1.0%
용종로 3
 
1.0%
Other values (101) 121
42.3%
2024-03-13T15:05:40.171034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
237
 
17.0%
86
 
6.2%
67
 
4.8%
1 57
 
4.1%
56
 
4.0%
50
 
3.6%
49
 
3.5%
( 49
 
3.5%
) 49
 
3.5%
49
 
3.5%
Other values (102) 646
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 836
59.9%
Space Separator 237
 
17.0%
Decimal Number 198
 
14.2%
Open Punctuation 49
 
3.5%
Close Punctuation 49
 
3.5%
Other Punctuation 24
 
1.7%
Uppercase Letter 1
 
0.1%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
 
10.3%
67
 
8.0%
56
 
6.7%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
48
 
5.7%
Other values (86) 284
34.0%
Decimal Number
ValueCountFrequency (%)
1 57
28.8%
0 31
15.7%
2 23
11.6%
3 18
 
9.1%
8 15
 
7.6%
5 14
 
7.1%
7 13
 
6.6%
6 12
 
6.1%
4 8
 
4.0%
9 7
 
3.5%
Space Separator
ValueCountFrequency (%)
237
100.0%
Open Punctuation
ValueCountFrequency (%)
( 49
100.0%
Close Punctuation
ValueCountFrequency (%)
) 49
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 836
59.9%
Common 558
40.0%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
 
10.3%
67
 
8.0%
56
 
6.7%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
48
 
5.7%
Other values (86) 284
34.0%
Common
ValueCountFrequency (%)
237
42.5%
1 57
 
10.2%
( 49
 
8.8%
) 49
 
8.8%
0 31
 
5.6%
, 24
 
4.3%
2 23
 
4.1%
3 18
 
3.2%
8 15
 
2.7%
5 14
 
2.5%
Other values (5) 41
 
7.3%
Latin
ValueCountFrequency (%)
D 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 836
59.9%
ASCII 559
40.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
237
42.4%
1 57
 
10.2%
( 49
 
8.8%
) 49
 
8.8%
0 31
 
5.5%
, 24
 
4.3%
2 23
 
4.1%
3 18
 
3.2%
8 15
 
2.7%
5 14
 
2.5%
Other values (6) 42
 
7.5%
Hangul
ValueCountFrequency (%)
86
 
10.3%
67
 
8.0%
56
 
6.7%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
48
 
5.7%
Other values (86) 284
34.0%

사업장전화번호
Text

MISSING 

Distinct44
Distinct (%)100.0%
Missing5
Missing (%)10.2%
Memory size524.0 B
2024-03-13T15:05:40.427381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique44 ?
Unique (%)100.0%

Sample

1st row032-545-5050
2nd row031-913-9002
3rd row032-278-7002
4th row032-541-3422
5th row032-240-8437
ValueCountFrequency (%)
032-545-5050 1
 
2.3%
031-913-9002 1
 
2.3%
032-555-1017 1
 
2.3%
032-540-2110 1
 
2.3%
032-544-4912 1
 
2.3%
032-541-1081 1
 
2.3%
032-553-1145 1
 
2.3%
032-556-9963 1
 
2.3%
032-545-8921 1
 
2.3%
032-541-1001 1
 
2.3%
Other values (34) 34
77.3%
2024-03-13T15:05:40.763636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 88
16.7%
0 85
16.1%
5 75
14.2%
2 72
13.6%
3 65
12.3%
4 44
8.3%
1 41
7.8%
8 18
 
3.4%
7 17
 
3.2%
6 12
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 440
83.3%
Dash Punctuation 88
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 85
19.3%
5 75
17.0%
2 72
16.4%
3 65
14.8%
4 44
10.0%
1 41
9.3%
8 18
 
4.1%
7 17
 
3.9%
6 12
 
2.7%
9 11
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 88
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 528
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 88
16.7%
0 85
16.1%
5 75
14.2%
2 72
13.6%
3 65
12.3%
4 44
8.3%
1 41
7.8%
8 18
 
3.4%
7 17
 
3.2%
6 12
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 528
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 88
16.7%
0 85
16.1%
5 75
14.2%
2 72
13.6%
3 65
12.3%
4 44
8.3%
1 41
7.8%
8 18
 
3.4%
7 17
 
3.2%
6 12
 
2.3%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
Minimum2024-03-07 00:00:00
Maximum2024-03-07 00:00:00
2024-03-13T15:05:40.881771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T15:05:40.975164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-13T15:05:38.448919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T15:05:41.045246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번안경업소명칭사업장소재지(도로명)사업장전화번호
순번1.0000.9361.0001.000
안경업소명칭0.9361.0001.0001.000
사업장소재지(도로명)1.0001.0001.0001.000
사업장전화번호1.0001.0001.0001.000

Missing values

2024-03-13T15:05:38.564913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T15:05:38.656598image/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안경마을인천광역시 계양구 장제로 867, 1층 104호 (임학동)<NA>2024-03-07
12으뜸50안경 계양구청점인천광역시 계양구 계산새로 71, 하이베라스 D동 305호 (계산동)032-545-50502024-03-07
23위드아이안경인천광역시 계양구 장제로 822, 롯데마트 계양점 2층 (계산동)031-913-90022024-03-07
34으뜸플러스 인천계산점인천광역시 계양구 경명대로 1090, 계산메가타운 3층 302호 (계산동)032-278-70022024-03-07
45플러스인천광역시 계양구 경명대로 1137 (계산동)<NA>2024-03-07
56세계옵티크인천광역시 계양구 용종로 30, 은행마을아주아파트 상가동 124,125,131호 (계산동)<NA>2024-03-07
67더 베이직 안경원인천광역시 계양구 계양대로 176, 1층 (계산동)032-541-34222024-03-07
78아이뷰안경원인천광역시 계양구 계양문화로 20, 메디플렉스 세종병원 1층 (작전동)032-240-84372024-03-07
89미인안경점인천광역시 계양구 주부토로 379 (작전동)032-542-56982024-03-07
910안경백서 계산점인천광역시 계양구 경명대로 1074, 삼환1빌딩 1층 105호 (계산동)032-548-10032024-03-07
순번안경업소명칭사업장소재지(도로명)사업장전화번호기준일자
3940아이데코안경원 위드렌즈인천광역시 계양구 경명대로 1063 (계산동)032-546-42082024-03-07
4041미금당안경원인천광역시 계양구 안산로 51 (임학동)032-546-84482024-03-07
4142안경박사인천광역시 계양구 안남로 548 (효성동)032-547-70882024-03-07
4243밝은세상안경인천광역시 계양구 계양문화로 86 (용종동)032-285-10042024-03-07
4344우리안경인천광역시 계양구 장제로 912 (병방동)032-545-16562024-03-07
4445대학당안경마트인천광역시 계양구 아나지로417번길 20 (작전동)032-545-31072024-03-07
4546서전안경백화점인천광역시 계양구 효서로 380 (작전동)032-551-64272024-03-07
4647성모안경인천광역시 계양구 계양대로 208 (계산동)032-547-90092024-03-07
4748해맑은 안경콘택트인천광역시 계양구 동양로 101, 명일프라자 1층 101호 (동양동)032-542-35392024-03-07
4849디올안경인천광역시 계양구 효서로229번길 13-1 (작전동)032-543-08262024-03-07