Overview

Dataset statistics

Number of variables5
Number of observations46
Missing cells3
Missing cells (%)1.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory43.9 B

Variable types

Numeric1
Categorical1
Text3

Dataset

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

Alerts

영업구분 has constant value ""Constant
사업장전화번호 has 3 (6.5%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:25:35.598090
Analysis finished2023-12-10 16:25:36.358748
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.5
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2023-12-11T01:25:36.492113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.25
Q112.25
median23.5
Q334.75
95-th percentile43.75
Maximum46
Range45
Interquartile range (IQR)22.5

Descriptive statistics

Standard deviation13.422618
Coefficient of variation (CV)0.57117522
Kurtosis-1.2
Mean23.5
Median Absolute Deviation (MAD)11.5
Skewness0
Sum1081
Variance180.16667
MonotonicityStrictly increasing
2023-12-11T01:25:36.674456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
1 1
 
2.2%
36 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
34 1
 
2.2%
Other values (36) 36
78.3%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
46 1
2.2%
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%

영업구분
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
영업중
46 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 46
100.0%

Length

2023-12-11T01:25:36.842774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:25:36.945047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 46
100.0%

안경업소명칭
Text

Distinct45
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-12-11T01:25:37.479324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length6.6956522
Min length3

Characters and Unicode

Total characters308
Distinct characters101
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique44 ?
Unique (%)95.7%

Sample

1st row안경친구(감전점)
2nd row하이눈안경원
3rd row으뜸50안경(사상터미널점)
4th row으뜸 플러스 안경 부산 사상점
5th row안경하우스
ValueCountFrequency (%)
갤러리안경 3
 
5.4%
한빛안경 2
 
3.6%
사상점 2
 
3.6%
마트안경 1
 
1.8%
눈나라안경 1
 
1.8%
안경친구 1
 
1.8%
아이리더 1
 
1.8%
안경코디 1
 
1.8%
안경점 1
 
1.8%
밝은세상안경 1
 
1.8%
Other values (42) 42
75.0%
2023-12-11T01:25:37.883602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
안 43
 
14.0%
경 43
 
14.0%
점 11
 
3.6%
10
 
3.2%
상 9
 
2.9%
사 8
 
2.6%
이 7
 
2.3%
러 6
 
1.9%
0 6
 
1.9%
갤 5
 
1.6%
Other values (91) 160
51.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 277
89.9%
Decimal Number 15
 
4.9%
Space Separator 10
 
3.2%
Close Punctuation 3
 
1.0%
Open Punctuation 3
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 43
 
15.5%
경 43
 
15.5%
점 11
 
4.0%
상 9
 
3.2%
사 8
 
2.9%
이 7
 
2.5%
러 6
 
2.2%
갤 5
 
1.8%
스 5
 
1.8%
리 5
 
1.8%
Other values (82) 135
48.7%
Decimal Number
ValueCountFrequency (%)
0 6
40.0%
1 3
20.0%
5 3
20.0%
3 1
 
6.7%
6 1
 
6.7%
8 1
 
6.7%
Space Separator
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 277
89.9%
Common 31
 
10.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 43
 
15.5%
경 43
 
15.5%
점 11
 
4.0%
상 9
 
3.2%
사 8
 
2.9%
이 7
 
2.5%
러 6
 
2.2%
갤 5
 
1.8%
스 5
 
1.8%
리 5
 
1.8%
Other values (82) 135
48.7%
Common
ValueCountFrequency (%)
10
32.3%
0 6
19.4%
1 3
 
9.7%
5 3
 
9.7%
) 3
 
9.7%
( 3
 
9.7%
3 1
 
3.2%
6 1
 
3.2%
8 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 277
89.9%
ASCII 31
 
10.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
안 43
 
15.5%
경 43
 
15.5%
점 11
 
4.0%
상 9
 
3.2%
사 8
 
2.9%
이 7
 
2.5%
러 6
 
2.2%
갤 5
 
1.8%
스 5
 
1.8%
리 5
 
1.8%
Other values (82) 135
48.7%
ASCII
ValueCountFrequency (%)
10
32.3%
0 6
19.4%
1 3
 
9.7%
5 3
 
9.7%
) 3
 
9.7%
( 3
 
9.7%
3 1
 
3.2%
6 1
 
3.2%
8 1
 
3.2%

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

Distinct45
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-12-11T01:25:38.195084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length36
Mean length25.217391
Min length21

Characters and Unicode

Total characters1160
Distinct characters67
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

Unique44 ?
Unique (%)95.7%

Sample

1st row부산광역시 사상구 학감대로 277, 103호 (감전동)
2nd row부산광역시 사상구 백양대로 996, 1층 (모라동)
3rd row부산광역시 사상구 사상로 214, 부전돼지국밥 3층 (괘법동)
4th row부산광역시 사상구 사상로 206, 3층 (괘법동)
5th row부산광역시 사상구 백양대로 970-1 (모라동)
ValueCountFrequency (%)
부산광역시 46
19.2%
사상구 46
19.2%
사상로 13
 
5.4%
괘법동 12
 
5.0%
주례동 10
 
4.2%
백양대로 8
 
3.3%
모라동 8
 
3.3%
감전동 5
 
2.1%
가야대로 4
 
1.7%
엄궁동 4
 
1.7%
Other values (65) 84
35.0%
2023-12-11T01:25:38.816043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
194
 
16.7%
사 62
 
5.3%
상 59
 
5.1%
동 55
 
4.7%
부 49
 
4.2%
광 48
 
4.1%
시 48
 
4.1%
( 46
 
4.0%
) 46
 
4.0%
산 46
 
4.0%
Other values (57) 507
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 712
61.4%
Space Separator 194
 
16.7%
Decimal Number 151
 
13.0%
Open Punctuation 46
 
4.0%
Close Punctuation 46
 
4.0%
Other Punctuation 8
 
0.7%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 62
 
8.7%
상 59
 
8.3%
동 55
 
7.7%
부 49
 
6.9%
광 48
 
6.7%
시 48
 
6.7%
산 46
 
6.5%
로 46
 
6.5%
구 46
 
6.5%
역 46
 
6.5%
Other values (42) 207
29.1%
Decimal Number
ValueCountFrequency (%)
1 24
15.9%
2 22
14.6%
3 18
11.9%
0 17
11.3%
7 17
11.3%
9 14
9.3%
6 12
7.9%
8 11
7.3%
4 8
 
5.3%
5 8
 
5.3%
Space Separator
ValueCountFrequency (%)
194
100.0%
Open Punctuation
ValueCountFrequency (%)
( 46
100.0%
Close Punctuation
ValueCountFrequency (%)
) 46
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 712
61.4%
Common 448
38.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 62
 
8.7%
상 59
 
8.3%
동 55
 
7.7%
부 49
 
6.9%
광 48
 
6.7%
시 48
 
6.7%
산 46
 
6.5%
로 46
 
6.5%
구 46
 
6.5%
역 46
 
6.5%
Other values (42) 207
29.1%
Common
ValueCountFrequency (%)
194
43.3%
( 46
 
10.3%
) 46
 
10.3%
1 24
 
5.4%
2 22
 
4.9%
3 18
 
4.0%
0 17
 
3.8%
7 17
 
3.8%
9 14
 
3.1%
6 12
 
2.7%
Other values (5) 38
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 712
61.4%
ASCII 448
38.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
194
43.3%
( 46
 
10.3%
) 46
 
10.3%
1 24
 
5.4%
2 22
 
4.9%
3 18
 
4.0%
0 17
 
3.8%
7 17
 
3.8%
9 14
 
3.1%
6 12
 
2.7%
Other values (5) 38
 
8.5%
Hangul
ValueCountFrequency (%)
사 62
 
8.7%
상 59
 
8.3%
동 55
 
7.7%
부 49
 
6.9%
광 48
 
6.7%
시 48
 
6.7%
산 46
 
6.5%
로 46
 
6.5%
구 46
 
6.5%
역 46
 
6.5%
Other values (42) 207
29.1%

사업장전화번호
Text

MISSING 

Distinct43
Distinct (%)100.0%
Missing3
Missing (%)6.5%
Memory size500.0 B
2023-12-11T01:25:39.160155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique43 ?
Unique (%)100.0%

Sample

1st row051-315-2208
2nd row051-322-2809
3rd row051-326-3009
4th row051-315-1003
5th row051-315-5111
ValueCountFrequency (%)
051-315-2208 1
 
2.3%
051-313-5800 1
 
2.3%
051-314-2779 1
 
2.3%
051-313-8528 1
 
2.3%
051-325-2080 1
 
2.3%
051-315-8978 1
 
2.3%
051-316-4411 1
 
2.3%
051-317-0213 1
 
2.3%
051-327-6246 1
 
2.3%
051-310-0815 1
 
2.3%
Other values (33) 33
76.7%
2023-12-11T01:25:39.710465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 91
17.6%
- 86
16.7%
0 76
14.7%
5 70
13.6%
3 67
13.0%
2 38
7.4%
7 25
 
4.8%
8 21
 
4.1%
4 15
 
2.9%
9 15
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 430
83.3%
Dash Punctuation 86
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 91
21.2%
0 76
17.7%
5 70
16.3%
3 67
15.6%
2 38
8.8%
7 25
 
5.8%
8 21
 
4.9%
4 15
 
3.5%
9 15
 
3.5%
6 12
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 86
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 516
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 91
17.6%
- 86
16.7%
0 76
14.7%
5 70
13.6%
3 67
13.0%
2 38
7.4%
7 25
 
4.8%
8 21
 
4.1%
4 15
 
2.9%
9 15
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 516
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 91
17.6%
- 86
16.7%
0 76
14.7%
5 70
13.6%
3 67
13.0%
2 38
7.4%
7 25
 
4.8%
8 21
 
4.1%
4 15
 
2.9%
9 15
 
2.9%

Interactions

2023-12-11T01:25:35.969769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:25:39.903950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번안경업소명칭사업장소재지(도로명)사업장전화번호
순번1.0000.9310.9311.000
안경업소명칭0.9311.0000.9981.000
사업장소재지(도로명)0.9310.9981.0001.000
사업장전화번호1.0001.0001.0001.000

Missing values

2023-12-11T01:25:36.114278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:25:36.300055image/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영업중안경친구(감전점)부산광역시 사상구 학감대로 277, 103호 (감전동)051-315-2208
12영업중하이눈안경원부산광역시 사상구 백양대로 996, 1층 (모라동)051-322-2809
23영업중으뜸50안경(사상터미널점)부산광역시 사상구 사상로 214, 부전돼지국밥 3층 (괘법동)<NA>
34영업중으뜸 플러스 안경 부산 사상점부산광역시 사상구 사상로 206, 3층 (괘법동)051-326-3009
45영업중안경하우스부산광역시 사상구 백양대로 970-1 (모라동)051-315-1003
56영업중스마일안경원부산광역시 사상구 대동로 67, 1층 (학장동)051-315-5111
67영업중지니스안경 사상애플아울렛점부산광역시 사상구 사상로 201, 서부시외버스터미널 지하1층 (괘법동)051-559-6346
78영업중갤러리안경 엄궁점부산광역시 사상구 낙동대로 786 (엄궁동)051-321-3338
89영업중갤러리안경 애플아울렛점부산광역시 사상구 사상로 201 (괘법동, 서부시외버스터미널)<NA>
910영업중오렌즈 사상점부산광역시 사상구 광장로 79 (괘법동)051-311-3007
순번영업구분안경업소명칭사업장소재지(도로명)사업장전화번호
3637영업중여명안경부산광역시 사상구 가야대로 295 (주례동)051-313-5800
3738영업중낮엔해처럼밤엔달처럼부산광역시 사상구 가야대로 288 (주례동)051-312-8337
3839영업중일공공일안경부산광역시 사상구 가야대로366번길 3 (주례동)051-326-2144
3940영업중한빛안경부산광역시 사상구 진사로 38 (주례동)051-323-0990
4041영업중홍콩안경부산광역시 사상구 백양대로 931 (모라동)051-327-6638
4142영업중성보당안경부산광역시 사상구 사상로 290 (덕포동)051-303-1046
4243영업중새서울안경부산광역시 사상구 새벽로167번길 3 (감전동)051-322-7727
4344영업중갤러리 안경원부산광역시 사상구 가야대로 358 (주례동)051-324-3377
4445영업중명성안경부산광역시 사상구 사상로 251 (괘법동)051-314-7340
4546영업중오성사안경부산광역시 사상구 대동로323번길 22-5 (감전동)051-315-2572