Overview

Dataset statistics

Number of variables5
Number of observations2868
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory115.0 KiB
Average record size in memory41.0 B

Variable types

Numeric1
Text2
Categorical2

Dataset

Description부산광역시동래구_옥외광고물_허가관리정보_20230216
Author부산광역시 동래구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15086600

Alerts

구분 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 17:20:15.038401
Analysis finished2023-12-10 17:20:17.008319
Duration1.97 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct2868
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1434.5
Minimum1
Maximum2868
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size25.3 KiB
2023-12-11T02:20:17.196725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile144.35
Q1717.75
median1434.5
Q32151.25
95-th percentile2724.65
Maximum2868
Range2867
Interquartile range (IQR)1433.5

Descriptive statistics

Standard deviation828.06461
Coefficient of variation (CV)0.57724964
Kurtosis-1.2
Mean1434.5
Median Absolute Deviation (MAD)717
Skewness0
Sum4114146
Variance685691
MonotonicityStrictly increasing
2023-12-11T02:20:17.491502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1929 1
 
< 0.1%
1909 1
 
< 0.1%
1910 1
 
< 0.1%
1911 1
 
< 0.1%
1912 1
 
< 0.1%
1913 1
 
< 0.1%
1914 1
 
< 0.1%
1915 1
 
< 0.1%
1916 1
 
< 0.1%
Other values (2858) 2858
99.7%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2868 1
< 0.1%
2867 1
< 0.1%
2866 1
< 0.1%
2865 1
< 0.1%
2864 1
< 0.1%
2863 1
< 0.1%
2862 1
< 0.1%
2861 1
< 0.1%
2860 1
< 0.1%
2859 1
< 0.1%
Distinct2181
Distinct (%)76.0%
Missing0
Missing (%)0.0%
Memory size22.5 KiB
2023-12-11T02:20:18.055510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length22
Mean length7.4344491
Min length2

Characters and Unicode

Total characters21322
Distinct characters743
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1901 ?
Unique (%)66.3%

Sample

1st row에이치에스케이모터스
2nd row명국에너지서비스
3rd row태양가든
4th row부산은행 온천동금융센터
5th row에스에스모텔
ValueCountFrequency (%)
뉴미디어기획(주 151
 
4.8%
주)삼원기업 61
 
1.9%
주)에스유미디어 43
 
1.4%
주)태영티엔티 39
 
1.2%
티지엠씨지점 39
 
1.2%
주)애드스토리 33
 
1.0%
주)비지에프리테일 17
 
0.5%
주)가이던스 12
 
0.4%
와우미디어 10
 
0.3%
주)락미디어 10
 
0.3%
Other values (2292) 2743
86.9%
2023-12-11T02:20:18.923955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
623
 
2.9%
577
 
2.7%
) 532
 
2.5%
( 530
 
2.5%
453
 
2.1%
419
 
2.0%
387
 
1.8%
383
 
1.8%
355
 
1.7%
341
 
1.6%
Other values (733) 16722
78.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 19110
89.6%
Close Punctuation 532
 
2.5%
Open Punctuation 530
 
2.5%
Uppercase Letter 508
 
2.4%
Space Separator 290
 
1.4%
Decimal Number 202
 
0.9%
Lowercase Letter 124
 
0.6%
Other Punctuation 18
 
0.1%
Dash Punctuation 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
623
 
3.3%
577
 
3.0%
453
 
2.4%
419
 
2.2%
387
 
2.0%
383
 
2.0%
355
 
1.9%
341
 
1.8%
298
 
1.6%
298
 
1.6%
Other values (670) 14976
78.4%
Uppercase Letter
ValueCountFrequency (%)
S 65
12.8%
G 42
 
8.3%
T 40
 
7.9%
C 37
 
7.3%
K 36
 
7.1%
M 35
 
6.9%
E 35
 
6.9%
O 28
 
5.5%
U 23
 
4.5%
P 22
 
4.3%
Other values (13) 145
28.5%
Lowercase Letter
ValueCountFrequency (%)
c 16
12.9%
e 16
12.9%
o 10
 
8.1%
a 10
 
8.1%
s 8
 
6.5%
l 8
 
6.5%
n 7
 
5.6%
i 7
 
5.6%
m 6
 
4.8%
p 6
 
4.8%
Other values (11) 30
24.2%
Decimal Number
ValueCountFrequency (%)
2 58
28.7%
5 30
14.9%
1 26
12.9%
4 26
12.9%
3 21
 
10.4%
0 17
 
8.4%
7 9
 
4.5%
6 7
 
3.5%
9 4
 
2.0%
8 4
 
2.0%
Other Punctuation
ValueCountFrequency (%)
& 12
66.7%
. 3
 
16.7%
' 1
 
5.6%
# 1
 
5.6%
/ 1
 
5.6%
Close Punctuation
ValueCountFrequency (%)
) 532
100.0%
Open Punctuation
ValueCountFrequency (%)
( 530
100.0%
Space Separator
ValueCountFrequency (%)
290
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19109
89.6%
Common 1580
 
7.4%
Latin 632
 
3.0%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
623
 
3.3%
577
 
3.0%
453
 
2.4%
419
 
2.2%
387
 
2.0%
383
 
2.0%
355
 
1.9%
341
 
1.8%
298
 
1.6%
298
 
1.6%
Other values (669) 14975
78.4%
Latin
ValueCountFrequency (%)
S 65
 
10.3%
G 42
 
6.6%
T 40
 
6.3%
C 37
 
5.9%
K 36
 
5.7%
M 35
 
5.5%
E 35
 
5.5%
O 28
 
4.4%
U 23
 
3.6%
P 22
 
3.5%
Other values (34) 269
42.6%
Common
ValueCountFrequency (%)
) 532
33.7%
( 530
33.5%
290
18.4%
2 58
 
3.7%
5 30
 
1.9%
1 26
 
1.6%
4 26
 
1.6%
3 21
 
1.3%
0 17
 
1.1%
& 12
 
0.8%
Other values (9) 38
 
2.4%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19109
89.6%
ASCII 2212
 
10.4%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
623
 
3.3%
577
 
3.0%
453
 
2.4%
419
 
2.2%
387
 
2.0%
383
 
2.0%
355
 
1.9%
341
 
1.8%
298
 
1.6%
298
 
1.6%
Other values (669) 14975
78.4%
ASCII
ValueCountFrequency (%)
) 532
24.1%
( 530
24.0%
290
13.1%
S 65
 
2.9%
2 58
 
2.6%
G 42
 
1.9%
T 40
 
1.8%
C 37
 
1.7%
K 36
 
1.6%
M 35
 
1.6%
Other values (53) 547
24.7%
CJK
ValueCountFrequency (%)
1
100.0%
Distinct1989
Distinct (%)69.4%
Missing0
Missing (%)0.0%
Memory size22.5 KiB
2023-12-11T02:20:20.082691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length53
Mean length27.680962
Min length1

Characters and Unicode

Total characters79389
Distinct characters342
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

Unique1566 ?
Unique (%)54.6%

Sample

1st row부산광역시 동래구 여고로127번길 1 (사직동)
2nd row부산광역시 동래구 미남로 148 (온천동)
3rd row부산광역시 동래구 금정마을로 73 (온천동)
4th row부산광역시 동래구 금강공원로 13-1 (온천동)
5th row부산광역시 동래구 여고북로73번길 54 남경모텔 (온천동)
ValueCountFrequency (%)
부산광역시 2821
18.9%
동래구 2800
18.8%
온천동 604
 
4.0%
사직동 466
 
3.1%
안락동 338
 
2.3%
충렬대로 302
 
2.0%
명륜동 264
 
1.8%
수안동 174
 
1.2%
명장동 153
 
1.0%
아시아드대로 131
 
0.9%
Other values (1648) 6865
46.0%
2023-12-11T02:20:21.119039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13124
 
16.5%
5883
 
7.4%
3210
 
4.0%
2929
 
3.7%
2859
 
3.6%
( 2855
 
3.6%
) 2854
 
3.6%
2848
 
3.6%
2836
 
3.6%
2830
 
3.6%
Other values (332) 37161
46.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 49379
62.2%
Space Separator 13124
 
16.5%
Decimal Number 10718
 
13.5%
Open Punctuation 2855
 
3.6%
Close Punctuation 2854
 
3.6%
Dash Punctuation 334
 
0.4%
Uppercase Letter 99
 
0.1%
Lowercase Letter 22
 
< 0.1%
Other Punctuation 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
5883
 
11.9%
3210
 
6.5%
2929
 
5.9%
2859
 
5.8%
2848
 
5.8%
2836
 
5.7%
2830
 
5.7%
2824
 
5.7%
2819
 
5.7%
1340
 
2.7%
Other values (291) 19001
38.5%
Uppercase Letter
ValueCountFrequency (%)
S 19
19.2%
K 19
19.2%
B 15
15.2%
H 11
11.1%
U 7
 
7.1%
R 5
 
5.1%
Y 5
 
5.1%
T 4
 
4.0%
G 4
 
4.0%
L 2
 
2.0%
Other values (7) 8
8.1%
Decimal Number
ValueCountFrequency (%)
1 2421
22.6%
2 1569
14.6%
3 1185
11.1%
4 1032
9.6%
5 917
 
8.6%
7 754
 
7.0%
9 746
 
7.0%
8 734
 
6.8%
0 720
 
6.7%
6 640
 
6.0%
Lowercase Letter
ValueCountFrequency (%)
b 10
45.5%
o 2
 
9.1%
e 2
 
9.1%
v 2
 
9.1%
i 2
 
9.1%
l 2
 
9.1%
t 1
 
4.5%
k 1
 
4.5%
Other Punctuation
ValueCountFrequency (%)
· 2
50.0%
. 2
50.0%
Space Separator
ValueCountFrequency (%)
13124
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2855
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2854
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 334
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 49379
62.2%
Common 29889
37.6%
Latin 121
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
5883
 
11.9%
3210
 
6.5%
2929
 
5.9%
2859
 
5.8%
2848
 
5.8%
2836
 
5.7%
2830
 
5.7%
2824
 
5.7%
2819
 
5.7%
1340
 
2.7%
Other values (291) 19001
38.5%
Latin
ValueCountFrequency (%)
S 19
15.7%
K 19
15.7%
B 15
12.4%
H 11
9.1%
b 10
8.3%
U 7
 
5.8%
R 5
 
4.1%
Y 5
 
4.1%
T 4
 
3.3%
G 4
 
3.3%
Other values (15) 22
18.2%
Common
ValueCountFrequency (%)
13124
43.9%
( 2855
 
9.6%
) 2854
 
9.5%
1 2421
 
8.1%
2 1569
 
5.2%
3 1185
 
4.0%
4 1032
 
3.5%
5 917
 
3.1%
7 754
 
2.5%
9 746
 
2.5%
Other values (6) 2432
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 49379
62.2%
ASCII 30008
37.8%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13124
43.7%
( 2855
 
9.5%
) 2854
 
9.5%
1 2421
 
8.1%
2 1569
 
5.2%
3 1185
 
3.9%
4 1032
 
3.4%
5 917
 
3.1%
7 754
 
2.5%
9 746
 
2.5%
Other values (30) 2551
 
8.5%
Hangul
ValueCountFrequency (%)
5883
 
11.9%
3210
 
6.5%
2929
 
5.9%
2859
 
5.8%
2848
 
5.8%
2836
 
5.7%
2830
 
5.7%
2824
 
5.7%
2819
 
5.7%
1340
 
2.7%
Other values (291) 19001
38.5%
None
ValueCountFrequency (%)
· 2
100.0%

광고물종류
Categorical

Distinct10
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size22.5 KiB
돌출간판
1787 
벽면이용간판(가로형)
341 
교통수단이용 광고물
232 
공공시설물이용 광고물
 
174
가로형간판_입체형
 
167
Other values (5)
 
167

Length

Max length11
Median length4
Mean length6.195258
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row벽면이용간판(가로형)
2nd row돌출간판
3rd row돌출간판
4th row돌출간판
5th row돌출간판

Common Values

ValueCountFrequency (%)
돌출간판 1787
62.3%
벽면이용간판(가로형) 341
 
11.9%
교통수단이용 광고물 232
 
8.1%
공공시설물이용 광고물 174
 
6.1%
가로형간판_입체형 167
 
5.8%
지주이용 간판 120
 
4.2%
옥상간판 27
 
0.9%
벽면이용간판(세로형) 12
 
0.4%
현수막게시틀 7
 
0.2%
교통시설이용 광고물 1
 
< 0.1%

Length

2023-12-11T02:20:21.433697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T02:20:21.770000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
돌출간판 1787
52.6%
광고물 407
 
12.0%
벽면이용간판(가로형 341
 
10.0%
교통수단이용 232
 
6.8%
공공시설물이용 174
 
5.1%
가로형간판_입체형 167
 
4.9%
지주이용 120
 
3.5%
간판 120
 
3.5%
옥상간판 27
 
0.8%
벽면이용간판(세로형 12
 
0.4%
Other values (2) 8
 
0.2%

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.5 KiB
허가
2868 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row허가
2nd row허가
3rd row허가
4th row허가
5th row허가

Common Values

ValueCountFrequency (%)
허가 2868
100.0%

Length

2023-12-11T02:20:22.109581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T02:20:22.360866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
허가 2868
100.0%

Interactions

2023-12-11T02:20:16.264774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T02:20:22.519094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번광고물종류
순번1.0000.595
광고물종류0.5951.000
2023-12-11T02:20:22.789335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번광고물종류
순번1.0000.219
광고물종류0.2191.000

Missing values

2023-12-11T02:20:16.575625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:20:16.891719image/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에이치에스케이모터스부산광역시 동래구 여고로127번길 1 (사직동)벽면이용간판(가로형)허가
12명국에너지서비스부산광역시 동래구 미남로 148 (온천동)돌출간판허가
23태양가든부산광역시 동래구 금정마을로 73 (온천동)돌출간판허가
34부산은행 온천동금융센터부산광역시 동래구 금강공원로 13-1 (온천동)돌출간판허가
45에스에스모텔부산광역시 동래구 여고북로73번길 54 남경모텔 (온천동)돌출간판허가
56조일탕부산광역시 동래구 여고북로123번길 16 (온천동)돌출간판허가
67에메랄드노래방부산광역시 동래구 아시아드대로 249 (온천동)돌출간판허가
78알파공인중개사무소부산광역시 동래구 아시아드대로 145 (사직동)돌출간판허가
89약수온천부산광역시 동래구 금강로 113 (온천동)돌출간판허가
910프라임치과부산광역시 동래구 충렬대로 405 (안락동)돌출간판허가
순번업소명표시장소(도로명주소)광고물종류구분
28582859퀸즈부산광역시 동래구 온천장로 113 (온천동)돌출간판허가
28592860씨트론과자점부산광역시 동래구 충렬대로107번길 54 상가동 2-32호 (온천동 럭키아파트)가로형간판_입체형허가
28602861자이로토닉 인스파인부산광역시 동래구 중앙대로1381번길 37 (온천동)가로형간판_입체형허가
28612862크린토피아코인워시부산온천벽산아스타부산광역시 동래구 금강공원로 11 온천 메디 플러스 102호 (온천동)돌출간판허가
28622863현지사부산광역시 동래구 중앙대로 1325 이센타워 (온천동)돌출간판허가
28632864헤론수학원부산광역시 동래구 중앙대로1335번길 43 (온천동)가로형간판_입체형허가
28642865보미커피부산광역시 동래구 명장로20번길 87 (명장동)돌출간판허가
28652866제우스부산광역시 동래구 온천장로107번길 22 온천빌딩 5층 (온천동)벽면이용간판(가로형)허가
28662867제우스부산광역시 동래구 온천장로107번길 22 온천빌딩 5층 (온천동)벽면이용간판(가로형)허가
28672868동호주유소부산광역시 동래구 반송로 245 (안락동)지주이용 간판허가