Overview

Dataset statistics

Number of variables5
Number of observations99
Missing cells43
Missing cells (%)8.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory42.3 B

Variable types

Numeric1
Text4

Dataset

Description부산광역시해운대구_옥외광고업현황_20220906
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3075793

Alerts

영업장전화번호 has 43 (43.4%) missing valuesMissing
순번 has unique valuesUnique
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:33:07.138082
Analysis finished2023-12-10 16:33:08.029293
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct99
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50
Minimum1
Maximum99
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T01:33:08.113407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.9
Q125.5
median50
Q374.5
95-th percentile94.1
Maximum99
Range98
Interquartile range (IQR)49

Descriptive statistics

Standard deviation28.722813
Coefficient of variation (CV)0.57445626
Kurtosis-1.2
Mean50
Median Absolute Deviation (MAD)25
Skewness0
Sum4950
Variance825
MonotonicityStrictly increasing
2023-12-11T01:33:08.298732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
64 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
67 1
 
1.0%
Other values (89) 89
89.9%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%
90 1
1.0%

업소명
Text

UNIQUE 

Distinct99
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-11T01:33:08.625610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length14
Mean length6.5252525
Min length2

Characters and Unicode

Total characters646
Distinct characters176
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

Unique99 ?
Unique (%)100.0%

Sample

1st row(주) 두리컴
2nd row(주)KNN
3rd row동일애드산업
4th row반석애드
5th row세명기획
ValueCountFrequency (%)
주식회사 12
 
10.1%
디자인 2
 
1.7%
광고기획 2
 
1.7%
주 1
 
0.8%
한국광고공사 1
 
0.8%
부산광고사 1
 
0.8%
주)피알프로모션 1
 
0.8%
디자인팩토리 1
 
0.8%
더현수막 1
 
0.8%
더사인 1
 
0.8%
Other values (96) 96
80.7%
2023-12-11T01:33:09.169617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 31
 
4.8%
인 24
 
3.7%
사 23
 
3.6%
디 22
 
3.4%
( 20
 
3.1%
) 20
 
3.1%
20
 
3.1%
드 20
 
3.1%
이 18
 
2.8%
광 17
 
2.6%
Other values (166) 431
66.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 554
85.8%
Uppercase Letter 22
 
3.4%
Open Punctuation 20
 
3.1%
Close Punctuation 20
 
3.1%
Space Separator 20
 
3.1%
Lowercase Letter 6
 
0.9%
Other Punctuation 3
 
0.5%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 31
 
5.6%
인 24
 
4.3%
사 23
 
4.2%
디 22
 
4.0%
드 20
 
3.6%
이 18
 
3.2%
광 17
 
3.1%
자 16
 
2.9%
기 16
 
2.9%
스 15
 
2.7%
Other values (142) 352
63.5%
Uppercase Letter
ValueCountFrequency (%)
N 4
18.2%
S 3
13.6%
A 2
9.1%
L 2
9.1%
C 2
9.1%
T 2
9.1%
M 1
 
4.5%
I 1
 
4.5%
K 1
 
4.5%
G 1
 
4.5%
Other values (3) 3
13.6%
Lowercase Letter
ValueCountFrequency (%)
o 2
33.3%
d 1
16.7%
t 1
16.7%
g 1
16.7%
n 1
16.7%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
, 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 554
85.8%
Common 64
 
9.9%
Latin 28
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 31
 
5.6%
인 24
 
4.3%
사 23
 
4.2%
디 22
 
4.0%
드 20
 
3.6%
이 18
 
3.2%
광 17
 
3.1%
자 16
 
2.9%
기 16
 
2.9%
스 15
 
2.7%
Other values (142) 352
63.5%
Latin
ValueCountFrequency (%)
N 4
14.3%
S 3
 
10.7%
o 2
 
7.1%
A 2
 
7.1%
L 2
 
7.1%
C 2
 
7.1%
T 2
 
7.1%
M 1
 
3.6%
I 1
 
3.6%
K 1
 
3.6%
Other values (8) 8
28.6%
Common
ValueCountFrequency (%)
( 20
31.2%
) 20
31.2%
20
31.2%
. 2
 
3.1%
, 1
 
1.6%
- 1
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 554
85.8%
ASCII 92
 
14.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 31
 
5.6%
인 24
 
4.3%
사 23
 
4.2%
디 22
 
4.0%
드 20
 
3.6%
이 18
 
3.2%
광 17
 
3.1%
자 16
 
2.9%
기 16
 
2.9%
스 15
 
2.7%
Other values (142) 352
63.5%
ASCII
ValueCountFrequency (%)
( 20
21.7%
) 20
21.7%
20
21.7%
N 4
 
4.3%
S 3
 
3.3%
o 2
 
2.2%
. 2
 
2.2%
A 2
 
2.2%
L 2
 
2.2%
C 2
 
2.2%
Other values (14) 15
16.3%

영업장전화번호
Text

MISSING 

Distinct56
Distinct (%)100.0%
Missing43
Missing (%)43.4%
Memory size924.0 B
2023-12-11T01:33:09.725828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.732143
Min length9

Characters and Unicode

Total characters769
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique56 ?
Unique (%)100.0%

Sample

1st row051 -501 -5240
2nd row051 -782 -2770
3rd row051 -742 -1074
4th row051-784- 6088
5th row051 -781 -2444
ValueCountFrequency (%)
051 50
32.1%
747 7
 
4.5%
746 4
 
2.6%
782 3
 
1.9%
744 3
 
1.9%
741 3
 
1.9%
704 3
 
1.9%
740 2
 
1.3%
753 2
 
1.3%
742 2
 
1.3%
Other values (75) 77
49.4%
2023-12-11T01:33:10.148431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 111
14.4%
100
13.0%
0 98
12.7%
5 90
11.7%
1 87
11.3%
7 79
10.3%
4 70
9.1%
8 34
 
4.4%
2 34
 
4.4%
3 23
 
3.0%
Other values (2) 43
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 558
72.6%
Dash Punctuation 111
 
14.4%
Space Separator 100
 
13.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 98
17.6%
5 90
16.1%
1 87
15.6%
7 79
14.2%
4 70
12.5%
8 34
 
6.1%
2 34
 
6.1%
3 23
 
4.1%
6 23
 
4.1%
9 20
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 111
100.0%
Space Separator
ValueCountFrequency (%)
100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 769
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 111
14.4%
100
13.0%
0 98
12.7%
5 90
11.7%
1 87
11.3%
7 79
10.3%
4 70
9.1%
8 34
 
4.4%
2 34
 
4.4%
3 23
 
3.0%
Other values (2) 43
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 769
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 111
14.4%
100
13.0%
0 98
12.7%
5 90
11.7%
1 87
11.3%
7 79
10.3%
4 70
9.1%
8 34
 
4.4%
2 34
 
4.4%
3 23
 
3.0%
Other values (2) 43
 
5.6%

영업장도로명주소
Text

Distinct96
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-11T01:33:10.545951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length42
Mean length34.484848
Min length23

Characters and Unicode

Total characters3414
Distinct characters158
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

Unique93 ?
Unique (%)93.9%

Sample

1st row부산광역시 해운대구 재송1로 12, 거호빌딩 3층 302호 (재송동)
2nd row부산광역시 해운대구 센텀서로 30, 케이엔엔타워 (우동)
3rd row부산광역시 해운대구 해운대로76번길 41 (재송동)
4th row부산광역시 해운대구 좌동순환로15번길 17-1 (좌동)
5th row부산광역시 해운대구 해운대로81번길20-1(재송동)
ValueCountFrequency (%)
부산광역시 99
 
16.0%
해운대구 99
 
16.0%
우동 32
 
5.2%
재송동 22
 
3.5%
좌동 12
 
1.9%
반여동 9
 
1.5%
중동 9
 
1.5%
apec로 9
 
1.5%
벡스코 7
 
1.1%
55 7
 
1.1%
Other values (212) 315
50.8%
2023-12-11T01:33:11.125831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
522
 
15.3%
동 139
 
4.1%
1 130
 
3.8%
대 123
 
3.6%
해 115
 
3.4%
운 113
 
3.3%
산 108
 
3.2%
시 107
 
3.1%
부 102
 
3.0%
광 100
 
2.9%
Other values (148) 1855
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2013
59.0%
Decimal Number 533
 
15.6%
Space Separator 522
 
15.3%
Close Punctuation 99
 
2.9%
Open Punctuation 99
 
2.9%
Other Punctuation 78
 
2.3%
Uppercase Letter 48
 
1.4%
Dash Punctuation 20
 
0.6%
Math Symbol 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 139
 
6.9%
대 123
 
6.1%
해 115
 
5.7%
운 113
 
5.6%
산 108
 
5.4%
시 107
 
5.3%
부 102
 
5.1%
광 100
 
5.0%
구 99
 
4.9%
로 99
 
4.9%
Other values (124) 908
45.1%
Decimal Number
ValueCountFrequency (%)
1 130
24.4%
2 77
14.4%
0 75
14.1%
5 58
10.9%
3 45
 
8.4%
6 41
 
7.7%
7 37
 
6.9%
9 26
 
4.9%
4 24
 
4.5%
8 20
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
A 12
25.0%
E 10
20.8%
C 10
20.8%
P 9
18.8%
B 4
 
8.3%
I 1
 
2.1%
S 1
 
2.1%
T 1
 
2.1%
Space Separator
ValueCountFrequency (%)
522
100.0%
Close Punctuation
ValueCountFrequency (%)
) 99
100.0%
Open Punctuation
ValueCountFrequency (%)
( 99
100.0%
Other Punctuation
ValueCountFrequency (%)
, 78
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2013
59.0%
Common 1353
39.6%
Latin 48
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 139
 
6.9%
대 123
 
6.1%
해 115
 
5.7%
운 113
 
5.6%
산 108
 
5.4%
시 107
 
5.3%
부 102
 
5.1%
광 100
 
5.0%
구 99
 
4.9%
로 99
 
4.9%
Other values (124) 908
45.1%
Common
ValueCountFrequency (%)
522
38.6%
1 130
 
9.6%
) 99
 
7.3%
( 99
 
7.3%
, 78
 
5.8%
2 77
 
5.7%
0 75
 
5.5%
5 58
 
4.3%
3 45
 
3.3%
6 41
 
3.0%
Other values (6) 129
 
9.5%
Latin
ValueCountFrequency (%)
A 12
25.0%
E 10
20.8%
C 10
20.8%
P 9
18.8%
B 4
 
8.3%
I 1
 
2.1%
S 1
 
2.1%
T 1
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2013
59.0%
ASCII 1401
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
522
37.3%
1 130
 
9.3%
) 99
 
7.1%
( 99
 
7.1%
, 78
 
5.6%
2 77
 
5.5%
0 75
 
5.4%
5 58
 
4.1%
3 45
 
3.2%
6 41
 
2.9%
Other values (14) 177
 
12.6%
Hangul
ValueCountFrequency (%)
동 139
 
6.9%
대 123
 
6.1%
해 115
 
5.7%
운 113
 
5.6%
산 108
 
5.4%
시 107
 
5.3%
부 102
 
5.1%
광 100
 
5.0%
구 99
 
4.9%
로 99
 
4.9%
Other values (124) 908
45.1%

영업내용
Text

Distinct70
Distinct (%)70.7%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-11T01:33:11.384442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length18
Mean length9.0808081
Min length3

Characters and Unicode

Total characters899
Distinct characters59
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

Unique60 ?
Unique (%)60.6%

Sample

1st row옥외광고물등제작
2nd row옥외광고물 제작 표시 등
3rd row광고물제조
4th row광고물제조업
5th row옥외광고물 제작
ValueCountFrequency (%)
제작 26
 
12.4%
간판제작등 16
 
7.6%
옥외광고물 16
 
7.6%
설치 15
 
7.1%
및 15
 
7.1%
광고대행 9
 
4.3%
광고물 7
 
3.3%
간판제작 7
 
3.3%
등 7
 
3.3%
시공 6
 
2.9%
Other values (51) 86
41.0%
2023-12-11T01:33:11.855743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
112
 
12.5%
광 78
 
8.7%
고 77
 
8.6%
제 75
 
8.3%
작 70
 
7.8%
외 39
 
4.3%
옥 38
 
4.2%
물 38
 
4.2%
, 34
 
3.8%
판 33
 
3.7%
Other values (49) 305
33.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 748
83.2%
Space Separator 112
 
12.5%
Other Punctuation 35
 
3.9%
Close Punctuation 2
 
0.2%
Open Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 78
 
10.4%
고 77
 
10.3%
제 75
 
10.0%
작 70
 
9.4%
외 39
 
5.2%
옥 38
 
5.1%
물 38
 
5.1%
판 33
 
4.4%
간 32
 
4.3%
등 28
 
3.7%
Other values (44) 240
32.1%
Other Punctuation
ValueCountFrequency (%)
, 34
97.1%
. 1
 
2.9%
Space Separator
ValueCountFrequency (%)
112
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 748
83.2%
Common 151
 
16.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 78
 
10.4%
고 77
 
10.3%
제 75
 
10.0%
작 70
 
9.4%
외 39
 
5.2%
옥 38
 
5.1%
물 38
 
5.1%
판 33
 
4.4%
간 32
 
4.3%
등 28
 
3.7%
Other values (44) 240
32.1%
Common
ValueCountFrequency (%)
112
74.2%
, 34
 
22.5%
) 2
 
1.3%
( 2
 
1.3%
. 1
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 748
83.2%
ASCII 151
 
16.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
112
74.2%
, 34
 
22.5%
) 2
 
1.3%
( 2
 
1.3%
. 1
 
0.7%
Hangul
ValueCountFrequency (%)
광 78
 
10.4%
고 77
 
10.3%
제 75
 
10.0%
작 70
 
9.4%
외 39
 
5.2%
옥 38
 
5.1%
물 38
 
5.1%
판 33
 
4.4%
간 32
 
4.3%
등 28
 
3.7%
Other values (44) 240
32.1%

Interactions

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

Correlations

2023-12-11T01:33:11.973753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명영업장전화번호영업장도로명주소영업내용
순번1.0001.0001.0000.8080.767
업소명1.0001.0001.0001.0001.000
영업장전화번호1.0001.0001.0001.0001.000
영업장도로명주소0.8081.0001.0001.0000.985
영업내용0.7671.0001.0000.9851.000

Missing values

2023-12-11T01:33:07.886510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:33:07.979053image/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(주) 두리컴051 -501 -5240부산광역시 해운대구 재송1로 12, 거호빌딩 3층 302호 (재송동)옥외광고물등제작
12(주)KNN<NA>부산광역시 해운대구 센텀서로 30, 케이엔엔타워 (우동)옥외광고물 제작 표시 등
23동일애드산업051 -782 -2770부산광역시 해운대구 해운대로76번길 41 (재송동)광고물제조
34반석애드051 -742 -1074부산광역시 해운대구 좌동순환로15번길 17-1 (좌동)광고물제조업
45세명기획051-784- 6088부산광역시 해운대구 해운대로81번길20-1(재송동)옥외광고물 제작
56우주간판051 -781 -2444부산광역시 해운대구 재반로 96-2 (재송동)간판제작
67SC디자인<NA>부산광역시 해운대구 재반로103번길 17 (재송동)옥외광고 제작, 설치
78온누리애드051 -747 -6105부산광역시 해운대구 우동1로20번가길 50 (우동)간판제작등
89비온뒤 광고기획051 -782 -4207부산광역시 해운대구 재반로125번길 47 (재송동)간판, 현수막 제조
910코리아기획051 -204 -7879부산광역시 해운대구 센텀중앙로 90, 큐비이센텀 206호 (재송동)옥외광고사업
순번업소명영업장전화번호영업장도로명주소영업내용
8990(주)피알컴<NA>부산광역시 해운대구 센텀동로 71, 벽산이센텀클래스원2차 804호 (우동)옥외광고물 제작 설치
9091다온종합광고<NA>부산광역시 해운대구 윗반송로 59, 1층 (반송동)옥외광고물 제작 설치
9192조이기획<NA>부산광역시 해운대구 재송1로 56, 3층 (재송동)광고물 제작 등
9293이노디자인<NA>부산광역시 해운대구 삼어로133번나길 8-19 (반여동)광고물제작및 시공
9394화랑광고시공<NA>부산광역시 해운대구 청사포로 12, 나동 1층 105호 (좌동, 에스케이뷰아파트)옥외광고업(제작 설치 및 옥외광고대행)
9495(주)부광기획<NA>부산광역시 해운대구 재반로 7-1 (재송동)간판제작, 시공, 디자인
9596비아디자인<NA>부산광역시 해운대구 선수촌로207번나길 20-9 (반여동)간판제작
9697해운대미스터종합광고<NA>부산광역시 해운대구 좌동로53번길 9 (중동)옥외광고
9798디자인 우리051 -746 -2142부산광역시 해운대구 좌동순환로249번길 7-20, 2층 (좌동, )간판제작업
9899프로인커뮤니케이션<NA>부산광역시 해운대구 센텀동로 71, 307호 (우동, 벽산이센텀클래스원2차)간판제작, 대행, 광고기획