Overview

Dataset statistics

Number of variables5
Number of observations99
Missing cells44
Missing cells (%)8.9%
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부산광역시해운대구_옥외광고업현황_20230920
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3075793

Alerts

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

Reproduction

Analysis started2023-12-10 16:32:59.793929
Analysis finished2023-12-10 16:33:01.340368
Duration1.55 second
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:01.489829image/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:01.838227image/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:02.211488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length14
Mean length6.5252525
Min length2

Characters and Unicode

Total characters646
Distinct characters175
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
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부산 디자인＋
3rd row하나애드텍
4th row온누리애드
5th row(주)이오스디자인
ValueCountFrequency (%)
주식회사 11
 
9.2%
디자인 2
 
1.7%
광고기획 2
 
1.7%
예스플랜 1
 
0.8%
월드디자인 1
 
0.8%
신도시광고기획 1
 
0.8%
sim 1
 
0.8%
제일애드컴 1
 
0.8%
윤광고기획 1
 
0.8%
비준애드 1
 
0.8%
Other values (97) 97
81.5%
2023-12-11T01:33:02.777926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 31
 
4.8%
인 25
 
3.9%
사 23
 
3.6%
디 22
 
3.4%
드 21
 
3.3%
20
 
3.1%
이 20
 
3.1%
) 20
 
3.1%
( 20
 
3.1%
자 17
 
2.6%
Other values (165) 427
66.1%

Most occurring categories

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

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 31
 
5.6%
인 25
 
4.5%
사 23
 
4.2%
디 22
 
4.0%
드 21
 
3.8%
이 20
 
3.6%
자 17
 
3.1%
광 16
 
2.9%
스 16
 
2.9%
애 15
 
2.7%
Other values (140) 347
62.7%
Uppercase Letter
ValueCountFrequency (%)
N 4
18.2%
S 3
13.6%
L 2
9.1%
A 2
9.1%
T 2
9.1%
C 2
9.1%
M 1
 
4.5%
I 1
 
4.5%
K 1
 
4.5%
P 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%
Space Separator
ValueCountFrequency (%)
20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Math Symbol
ValueCountFrequency (%)
＋ 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 553
85.6%
Common 65
 
10.1%
Latin 28
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 31
 
5.6%
인 25
 
4.5%
사 23
 
4.2%
디 22
 
4.0%
드 21
 
3.8%
이 20
 
3.6%
자 17
 
3.1%
광 16
 
2.9%
스 16
 
2.9%
애 15
 
2.7%
Other values (140) 347
62.7%
Latin
ValueCountFrequency (%)
N 4
14.3%
S 3
 
10.7%
L 2
 
7.1%
o 2
 
7.1%
A 2
 
7.1%
T 2
 
7.1%
C 2
 
7.1%
M 1
 
3.6%
I 1
 
3.6%
K 1
 
3.6%
Other values (8) 8
28.6%
Common
ValueCountFrequency (%)
20
30.8%
) 20
30.8%
( 20
30.8%
. 2
 
3.1%
, 1
 
1.5%
＋ 1
 
1.5%
- 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 553
85.6%
ASCII 92
 
14.2%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 31
 
5.6%
인 25
 
4.5%
사 23
 
4.2%
디 22
 
4.0%
드 21
 
3.8%
이 20
 
3.6%
자 17
 
3.1%
광 16
 
2.9%
스 16
 
2.9%
애 15
 
2.7%
Other values (140) 347
62.7%
ASCII
ValueCountFrequency (%)
20
21.7%
) 20
21.7%
( 20
21.7%
N 4
 
4.3%
S 3
 
3.3%
L 2
 
2.2%
o 2
 
2.2%
A 2
 
2.2%
T 2
 
2.2%
. 2
 
2.2%
Other values (14) 15
16.3%
None
ValueCountFrequency (%)
＋ 1
100.0%

영업장전화번호
Text

MISSING 

Distinct55
Distinct (%)100.0%
Missing44
Missing (%)44.4%
Memory size924.0 B
2023-12-11T01:33:03.126687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.945455
Min length9

Characters and Unicode

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

Unique55 ?
Unique (%)100.0%

Sample

1st row051-744-1317
2nd row051-747-6105
3rd row051-740-7760
4th row051-783-7882
5th row051-501-5240
ValueCountFrequency (%)
051-744-1317 1
 
1.8%
051-742-6687 1
 
1.8%
051-747-7277 1
 
1.8%
051-741-3762 1
 
1.8%
051-747-9066 1
 
1.8%
051-817-0381 1
 
1.8%
051-741-4442 1
 
1.8%
051-780-8200 1
 
1.8%
051-747-3956 1
 
1.8%
051-704-8011 1
 
1.8%
Other values (45) 45
81.8%
2023-12-11T01:33:03.740353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 109
16.6%
0 97
14.8%
5 90
13.7%
1 85
12.9%
7 77
11.7%
4 68
10.4%
2 36
 
5.5%
8 33
 
5.0%
3 22
 
3.3%
6 22
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 548
83.4%
Dash Punctuation 109
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 97
17.7%
5 90
16.4%
1 85
15.5%
7 77
14.1%
4 68
12.4%
2 36
 
6.6%
8 33
 
6.0%
3 22
 
4.0%
6 22
 
4.0%
9 18
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 109
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 657
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 109
16.6%
0 97
14.8%
5 90
13.7%
1 85
12.9%
7 77
11.7%
4 68
10.4%
2 36
 
5.5%
8 33
 
5.0%
3 22
 
3.3%
6 22
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 657
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 109
16.6%
0 97
14.8%
5 90
13.7%
1 85
12.9%
7 77
11.7%
4 68
10.4%
2 36
 
5.5%
8 33
 
5.0%
3 22
 
3.3%
6 22
 
3.3%

영업장도로명주소
Text

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

Length

Max length53
Median length43
Mean length34.353535
Min length23

Characters and Unicode

Total characters3401
Distinct characters168
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부산광역시 해운대구 해운대로 794, 엘리움 14층 1403호 (좌동)
2nd row부산광역시 해운대구 해운대로 1256 (송정동)
3rd row부산광역시 해운대구 좌동순환로15번길 9-12 (좌동)
4th row부산광역시 해운대구 우동1로50번길 11, 2층 (우동)
5th row부산광역시 해운대구 센텀중앙로 48, 에이스하이테크21 1905호 (우동)
ValueCountFrequency (%)
부산광역시 99
 
15.9%
해운대구 99
 
15.9%
우동 29
 
4.6%
재송동 24
 
3.8%
중동 12
 
1.9%
좌동 10
 
1.6%
반여동 9
 
1.4%
송정동 8
 
1.3%
apec로 8
 
1.3%
센텀중앙로 8
 
1.3%
Other values (222) 318
51.0%
2023-12-11T01:33:04.837157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
525
 
15.4%
동 135
 
4.0%
1 131
 
3.9%
대 125
 
3.7%
해 119
 
3.5%
운 116
 
3.4%
산 104
 
3.1%
부 102
 
3.0%
시 102
 
3.0%
광 100
 
2.9%
Other values (158) 1842
54.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2003
58.9%
Decimal Number 533
 
15.7%
Space Separator 525
 
15.4%
Open Punctuation 99
 
2.9%
Close Punctuation 99
 
2.9%
Other Punctuation 78
 
2.3%
Uppercase Letter 45
 
1.3%
Dash Punctuation 18
 
0.5%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 135
 
6.7%
대 125
 
6.2%
해 119
 
5.9%
운 116
 
5.8%
산 104
 
5.2%
부 102
 
5.1%
시 102
 
5.1%
광 100
 
5.0%
역 99
 
4.9%
구 99
 
4.9%
Other values (134) 902
45.0%
Decimal Number
ValueCountFrequency (%)
1 131
24.6%
0 73
13.7%
2 70
13.1%
5 55
10.3%
3 43
 
8.1%
6 43
 
8.1%
7 40
 
7.5%
4 29
 
5.4%
9 25
 
4.7%
8 24
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
A 12
26.7%
C 9
20.0%
E 9
20.0%
P 8
17.8%
B 4
 
8.9%
I 1
 
2.2%
S 1
 
2.2%
T 1
 
2.2%
Space Separator
ValueCountFrequency (%)
525
100.0%
Open Punctuation
ValueCountFrequency (%)
( 99
100.0%
Close Punctuation
ValueCountFrequency (%)
) 99
100.0%
Other Punctuation
ValueCountFrequency (%)
, 78
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2003
58.9%
Common 1353
39.8%
Latin 45
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 135
 
6.7%
대 125
 
6.2%
해 119
 
5.9%
운 116
 
5.8%
산 104
 
5.2%
부 102
 
5.1%
시 102
 
5.1%
광 100
 
5.0%
역 99
 
4.9%
구 99
 
4.9%
Other values (134) 902
45.0%
Common
ValueCountFrequency (%)
525
38.8%
1 131
 
9.7%
( 99
 
7.3%
) 99
 
7.3%
, 78
 
5.8%
0 73
 
5.4%
2 70
 
5.2%
5 55
 
4.1%
3 43
 
3.2%
6 43
 
3.2%
Other values (6) 137
 
10.1%
Latin
ValueCountFrequency (%)
A 12
26.7%
C 9
20.0%
E 9
20.0%
P 8
17.8%
B 4
 
8.9%
I 1
 
2.2%
S 1
 
2.2%
T 1
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2003
58.9%
ASCII 1398
41.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
525
37.6%
1 131
 
9.4%
( 99
 
7.1%
) 99
 
7.1%
, 78
 
5.6%
0 73
 
5.2%
2 70
 
5.0%
5 55
 
3.9%
3 43
 
3.1%
6 43
 
3.1%
Other values (14) 182
 
13.0%
Hangul
ValueCountFrequency (%)
동 135
 
6.7%
대 125
 
6.2%
해 119
 
5.9%
운 116
 
5.8%
산 104
 
5.2%
부 102
 
5.1%
시 102
 
5.1%
광 100
 
5.0%
역 99
 
4.9%
구 99
 
4.9%
Other values (134) 902
45.0%

영업내용
Text

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

Length

Max length41
Median length19
Mean length9.4040404
Min length3

Characters and Unicode

Total characters931
Distinct characters58
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

Unique63 ?
Unique (%)63.6%

Sample

1st row광고물 디자인 및 제작
2nd row옥외광고물 제작 및 설치(시공), 디자인 이벤트 기획, 옥외광고물 대행 등
3rd row현수막제작, 광고디자인
4th row간판제작등
5th row간판등제조
ValueCountFrequency (%)
제작 28
 
12.6%
옥외광고물 18
 
8.1%
및 17
 
7.7%
간판제작등 16
 
7.2%
설치 14
 
6.3%
등 10
 
4.5%
광고물 8
 
3.6%
광고대행 8
 
3.6%
간판제작 7
 
3.2%
시공 6
 
2.7%
Other values (51) 90
40.5%
2023-12-11T01:33:05.679294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
124
 
13.3%
광 79
 
8.5%
고 78
 
8.4%
제 76
 
8.2%
작 71
 
7.6%
물 41
 
4.4%
외 39
 
4.2%
옥 38
 
4.1%
, 34
 
3.7%
판 33
 
3.5%
Other values (48) 318
34.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 768
82.5%
Space Separator 124
 
13.3%
Other Punctuation 35
 
3.8%
Open Punctuation 2
 
0.2%
Close Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 79
 
10.3%
고 78
 
10.2%
제 76
 
9.9%
작 71
 
9.2%
물 41
 
5.3%
외 39
 
5.1%
옥 38
 
4.9%
판 33
 
4.3%
간 32
 
4.2%
등 30
 
3.9%
Other values (43) 251
32.7%
Other Punctuation
ValueCountFrequency (%)
, 34
97.1%
. 1
 
2.9%
Space Separator
ValueCountFrequency (%)
124
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 768
82.5%
Common 163
 
17.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 79
 
10.3%
고 78
 
10.2%
제 76
 
9.9%
작 71
 
9.2%
물 41
 
5.3%
외 39
 
5.1%
옥 38
 
4.9%
판 33
 
4.3%
간 32
 
4.2%
등 30
 
3.9%
Other values (43) 251
32.7%
Common
ValueCountFrequency (%)
124
76.1%
, 34
 
20.9%
( 2
 
1.2%
) 2
 
1.2%
. 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 768
82.5%
ASCII 163
 
17.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
124
76.1%
, 34
 
20.9%
( 2
 
1.2%
) 2
 
1.2%
. 1
 
0.6%
Hangul
ValueCountFrequency (%)
광 79
 
10.3%
고 78
 
10.2%
제 76
 
9.9%
작 71
 
9.2%
물 41
 
5.3%
외 39
 
5.1%
옥 38
 
4.9%
판 33
 
4.3%
간 32
 
4.2%
등 30
 
3.9%
Other values (43) 251
32.7%

Interactions

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

Correlations

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

Missing values

2023-12-11T01:33:01.108817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:33:01.281307image/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예스플랜<NA>부산광역시 해운대구 해운대로 794, 엘리움 14층 1403호 (좌동)광고물 디자인 및 제작
12부산 디자인＋<NA>부산광역시 해운대구 해운대로 1256 (송정동)옥외광고물 제작 및 설치(시공), 디자인 이벤트 기획, 옥외광고물 대행 등
23하나애드텍051-744-1317부산광역시 해운대구 좌동순환로15번길 9-12 (좌동)현수막제작, 광고디자인
34온누리애드051-747-6105부산광역시 해운대구 우동1로50번길 11, 2층 (우동)간판제작등
45(주)이오스디자인051-740-7760부산광역시 해운대구 센텀중앙로 48, 에이스하이테크21 1905호 (우동)간판등제조
56주식회사 빛가람시스템<NA>부산광역시 해운대구 센텀중앙로 90, 큐비이센텀 1810호 (재송동)옥외광고업 등
67(주)애드스토리051-783-7882부산광역시 해운대구 센텀6로 21, 인텔리움센텀 804호 (우동)광고대행
78주식회사알이팩토리<NA>부산광역시 해운대구 재송1로 5, 1209호 (재송동, 협성 루에나 센텀)광고기획 및 광고대행업
89데브스페이스 주식회사<NA>부산광역시 해운대구 해운대해변로 277, 다옴빌딩 701호 (중동)옥외광고서비스업
910공감<NA>부산광역시 해운대구 센텀중앙로 97, 센텀스카이비즈 A동 605호 (재송동)옥외광고 디자인 및 제작, 시공
순번업소명영업장전화번호영업장도로명주소영업내용
8990(주)에이엔케이<NA>부산광역시 해운대구 센텀중앙로 66, 605호 (우동, 센텀T타워)옥외광고물 제작 및 설치
9091그린기획051-7474-833부산광역시 해운대구 해운대로781번길 20, 612호 (좌동, 쥬노벨오피스텔)간판제작등
9192라인디자인051-545-9906부산광역시 해운대구 윗반송로31번길 39 (반송동)광고기획,간판인쇄
9293다온종합광고<NA>부산광역시 해운대구 윗반송로 59, 1층 (반송동)옥외광고물 제작 설치
9394조이기획<NA>부산광역시 해운대구 재송1로 56, 3층 (재송동)광고물 제작 등
9495이노디자인<NA>부산광역시 해운대구 삼어로133번나길 8-19 (반여동)광고물제작및 시공
9596화랑광고시공<NA>부산광역시 해운대구 청사포로 12, 나동 1층 105호 (좌동, 에스케이뷰아파트)옥외광고업(제작 설치 및 옥외광고대행)
9697(주)부광기획<NA>부산광역시 해운대구 재반로 7-1 (재송동)간판제작, 시공, 디자인
9798해운대미스터종합광고<NA>부산광역시 해운대구 좌동로53번길 9 (중동)옥외광고
9899프로인커뮤니케이션<NA>부산광역시 해운대구 센텀동로 71, 307호 (우동, 벽산이센텀클래스원2차)간판제작, 대행, 광고기획