Overview

Dataset statistics

Number of variables7
Number of observations345
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.3 KiB
Average record size in memory57.4 B

Variable types

Numeric1
Categorical3
Text3

Dataset

Description부산광역시영도구_옥외광고물허가관리_20221017
Author부산광역시 영도구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15071143

Alerts

시도 has constant value ""Constant
구군 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:26:22.299177
Analysis finished2023-12-10 16:26:23.101187
Duration0.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct345
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean173
Minimum1
Maximum345
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.2 KiB
2023-12-11T01:26:23.195303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.2
Q187
median173
Q3259
95-th percentile327.8
Maximum345
Range344
Interquartile range (IQR)172

Descriptive statistics

Standard deviation99.737155
Coefficient of variation (CV)0.57651534
Kurtosis-1.2
Mean173
Median Absolute Deviation (MAD)86
Skewness0
Sum59685
Variance9947.5
MonotonicityStrictly increasing
2023-12-11T01:26:23.388506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
228 1
 
0.3%
236 1
 
0.3%
235 1
 
0.3%
234 1
 
0.3%
233 1
 
0.3%
232 1
 
0.3%
231 1
 
0.3%
230 1
 
0.3%
229 1
 
0.3%
Other values (335) 335
97.1%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
345 1
0.3%
344 1
0.3%
343 1
0.3%
342 1
0.3%
341 1
0.3%
340 1
0.3%
339 1
0.3%
338 1
0.3%
337 1
0.3%
336 1
0.3%

광고물종류
Categorical

Distinct7
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
벽면이용간판(가로형)
154 
돌출간판
137 
가로형간판_입체형
34 
벽면이용간판(세로형)
 
9
지주이용 간판
 
8
Other values (2)
 
3

Length

Max length11
Median length10
Mean length7.9246377
Min length4

Unique

Unique1 ?
Unique (%)0.3%

Sample

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

Common Values

ValueCountFrequency (%)
벽면이용간판(가로형) 154
44.6%
돌출간판 137
39.7%
가로형간판_입체형 34
 
9.9%
벽면이용간판(세로형) 9
 
2.6%
지주이용 간판 8
 
2.3%
교통수단이용 광고물 2
 
0.6%
공공시설물이용 광고물 1
 
0.3%

Length

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

Common Values (Plot)

2023-12-11T01:26:23.782328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
벽면이용간판(가로형 154
43.3%
돌출간판 137
38.5%
가로형간판_입체형 34
 
9.6%
벽면이용간판(세로형 9
 
2.5%
지주이용 8
 
2.2%
간판 8
 
2.2%
광고물 3
 
0.8%
교통수단이용 2
 
0.6%
공공시설물이용 1
 
0.3%

업소명
Text

Distinct313
Distinct (%)90.7%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-12-11T01:26:24.151749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length6.2289855
Min length2

Characters and Unicode

Total characters2149
Distinct characters390
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

Unique283 ?
Unique (%)82.0%

Sample

1st row고려개발
2nd row(주)한화전기상사
3rd row김도령신당
4th row나인호텔
5th row나인호텔
ValueCountFrequency (%)
우성스마트시티뷰 3
 
0.8%
푸르지오 3
 
0.8%
영도점 3
 
0.8%
부산오션시티 3
 
0.8%
보타사 2
 
0.5%
프라임부동산중개 2
 
0.5%
dk치킨 2
 
0.5%
복권판매점 2
 
0.5%
돈부자전복삼계탕 2
 
0.5%
케이티에이치말코(주 2
 
0.5%
Other values (322) 348
93.5%
2023-12-11T01:26:24.648287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 51
 
2.4%
스 45
 
2.1%
영 39
 
1.8%
이 39
 
1.8%
주 39
 
1.8%
도 38
 
1.8%
마 35
 
1.6%
( 34
 
1.6%
) 34
 
1.6%
인 34
 
1.6%
Other values (380) 1761
81.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1982
92.2%
Uppercase Letter 36
 
1.7%
Open Punctuation 34
 
1.6%
Close Punctuation 34
 
1.6%
Space Separator 27
 
1.3%
Decimal Number 27
 
1.3%
Lowercase Letter 6
 
0.3%
Other Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 51
 
2.6%
스 45
 
2.3%
영 39
 
2.0%
이 39
 
2.0%
주 39
 
2.0%
도 38
 
1.9%
마 35
 
1.8%
인 34
 
1.7%
점 31
 
1.6%
어 27
 
1.4%
Other values (347) 1604
80.9%
Uppercase Letter
ValueCountFrequency (%)
G 5
13.9%
D 5
13.9%
K 4
11.1%
S 3
8.3%
P 2
 
5.6%
H 2
 
5.6%
O 2
 
5.6%
C 2
 
5.6%
T 2
 
5.6%
E 2
 
5.6%
Other values (6) 7
19.4%
Decimal Number
ValueCountFrequency (%)
2 8
29.6%
5 6
22.2%
1 4
14.8%
0 3
 
11.1%
3 2
 
7.4%
4 2
 
7.4%
7 1
 
3.7%
9 1
 
3.7%
Lowercase Letter
ValueCountFrequency (%)
r 2
33.3%
n 2
33.3%
s 2
33.3%
Other Punctuation
ValueCountFrequency (%)
: 1
33.3%
& 1
33.3%
. 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 34
100.0%
Space Separator
ValueCountFrequency (%)
27
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1982
92.2%
Common 125
 
5.8%
Latin 42
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 51
 
2.6%
스 45
 
2.3%
영 39
 
2.0%
이 39
 
2.0%
주 39
 
2.0%
도 38
 
1.9%
마 35
 
1.8%
인 34
 
1.7%
점 31
 
1.6%
어 27
 
1.4%
Other values (347) 1604
80.9%
Latin
ValueCountFrequency (%)
G 5
 
11.9%
D 5
 
11.9%
K 4
 
9.5%
S 3
 
7.1%
P 2
 
4.8%
H 2
 
4.8%
O 2
 
4.8%
C 2
 
4.8%
T 2
 
4.8%
r 2
 
4.8%
Other values (9) 13
31.0%
Common
ValueCountFrequency (%)
( 34
27.2%
) 34
27.2%
27
21.6%
2 8
 
6.4%
5 6
 
4.8%
1 4
 
3.2%
0 3
 
2.4%
3 2
 
1.6%
4 2
 
1.6%
: 1
 
0.8%
Other values (4) 4
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1982
92.2%
ASCII 167
 
7.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 51
 
2.6%
스 45
 
2.3%
영 39
 
2.0%
이 39
 
2.0%
주 39
 
2.0%
도 38
 
1.9%
마 35
 
1.8%
인 34
 
1.7%
점 31
 
1.6%
어 27
 
1.4%
Other values (347) 1604
80.9%
ASCII
ValueCountFrequency (%)
( 34
20.4%
) 34
20.4%
27
16.2%
2 8
 
4.8%
5 6
 
3.6%
G 5
 
3.0%
D 5
 
3.0%
K 4
 
2.4%
1 4
 
2.4%
S 3
 
1.8%
Other values (23) 37
22.2%

광고물규격
Text

Distinct164
Distinct (%)47.5%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-12-11T01:26:25.019158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length7
Mean length6.1391304
Min length3

Characters and Unicode

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

Unique

Unique108 ?
Unique (%)31.3%

Sample

1st row9*1.2
2nd row5*1
3rd row0.6*0.6
4th row1.2*7
5th row5.1*1
ValueCountFrequency (%)
5*1 30
 
8.5%
0.5*0.5 24
 
6.8%
0.6*0.6 16
 
4.5%
6*1 10
 
2.8%
6*0.9 9
 
2.5%
5.5*1 7
 
2.0%
0.8*1.2 6
 
1.7%
0.8*3 6
 
1.7%
0.4*0.4 6
 
1.7%
0.7*2 5
 
1.4%
Other values (156) 234
66.3%
2023-12-11T01:26:25.548042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 500
23.6%
* 350
16.5%
0 281
13.3%
1 225
10.6%
5 199
 
9.4%
6 107
 
5.1%
8 86
 
4.1%
2 86
 
4.1%
7 78
 
3.7%
4 59
 
2.8%
Other values (6) 147
 
6.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1228
58.0%
Other Punctuation 853
40.3%
Space Separator 31
 
1.5%
Other Letter 6
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 281
22.9%
1 225
18.3%
5 199
16.2%
6 107
 
8.7%
8 86
 
7.0%
2 86
 
7.0%
7 78
 
6.4%
4 59
 
4.8%
9 55
 
4.5%
3 52
 
4.2%
Other Punctuation
ValueCountFrequency (%)
. 500
58.6%
* 350
41.0%
: 3
 
0.4%
Other Letter
ValueCountFrequency (%)
높 3
50.0%
이 3
50.0%
Space Separator
ValueCountFrequency (%)
31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2112
99.7%
Hangul 6
 
0.3%

Most frequent character per script

Common
ValueCountFrequency (%)
. 500
23.7%
* 350
16.6%
0 281
13.3%
1 225
10.7%
5 199
 
9.4%
6 107
 
5.1%
8 86
 
4.1%
2 86
 
4.1%
7 78
 
3.7%
4 59
 
2.8%
Other values (4) 141
 
6.7%
Hangul
ValueCountFrequency (%)
높 3
50.0%
이 3
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2112
99.7%
Hangul 6
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 500
23.7%
* 350
16.6%
0 281
13.3%
1 225
10.7%
5 199
 
9.4%
6 107
 
5.1%
8 86
 
4.1%
2 86
 
4.1%
7 78
 
3.7%
4 59
 
2.8%
Other values (4) 141
 
6.7%
Hangul
ValueCountFrequency (%)
높 3
50.0%
이 3
50.0%

표시장소도로명
Text

Distinct293
Distinct (%)84.9%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-12-11T01:26:25.829113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length40
Mean length27.93913
Min length21

Characters and Unicode

Total characters9639
Distinct characters170
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique251 ?
Unique (%)72.8%

Sample

1st row부산광역시 영도구 남항시장길 197 (신선동2가)
2nd row부산광역시 영도구 남항서로 105 (남항동2가)
3rd row부산광역시 영도구 절영로94번길 10-2 (남항동3가)
4th row부산광역시 영도구 절영로 48-1 지직스모텔 (남항동1가)
5th row부산광역시 영도구 절영로 48-1 지직스모텔 (남항동1가)
ValueCountFrequency (%)
부산광역시 345
 
18.8%
영도구 339
 
18.4%
태종로 40
 
2.2%
남항동1가 37
 
2.0%
절영로 34
 
1.8%
청학동 32
 
1.7%
영선동4가 25
 
1.4%
봉래동3가 23
 
1.3%
영선동1가 22
 
1.2%
대교동1가 22
 
1.2%
Other values (336) 919
50.0%
2023-12-11T01:26:26.331961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1582
 
16.4%
영 508
 
5.3%
1 372
 
3.9%
동 356
 
3.7%
산 353
 
3.7%
도 351
 
3.6%
부 350
 
3.6%
광 348
 
3.6%
시 348
 
3.6%
( 346
 
3.6%
Other values (160) 4725
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5887
61.1%
Space Separator 1582
 
16.4%
Decimal Number 1408
 
14.6%
Open Punctuation 346
 
3.6%
Close Punctuation 346
 
3.6%
Dash Punctuation 62
 
0.6%
Uppercase Letter 8
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 508
 
8.6%
동 356
 
6.0%
산 353
 
6.0%
도 351
 
6.0%
부 350
 
5.9%
광 348
 
5.9%
시 348
 
5.9%
역 345
 
5.9%
구 345
 
5.9%
가 305
 
5.2%
Other values (140) 2278
38.7%
Decimal Number
ValueCountFrequency (%)
1 372
26.4%
2 249
17.7%
3 211
15.0%
4 137
 
9.7%
5 95
 
6.7%
9 83
 
5.9%
0 75
 
5.3%
6 75
 
5.3%
8 56
 
4.0%
7 55
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
P 2
25.0%
B 2
25.0%
E 1
12.5%
U 1
12.5%
A 1
12.5%
C 1
12.5%
Space Separator
ValueCountFrequency (%)
1582
100.0%
Open Punctuation
ValueCountFrequency (%)
( 346
100.0%
Close Punctuation
ValueCountFrequency (%)
) 346
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5887
61.1%
Common 3744
38.8%
Latin 8
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 508
 
8.6%
동 356
 
6.0%
산 353
 
6.0%
도 351
 
6.0%
부 350
 
5.9%
광 348
 
5.9%
시 348
 
5.9%
역 345
 
5.9%
구 345
 
5.9%
가 305
 
5.2%
Other values (140) 2278
38.7%
Common
ValueCountFrequency (%)
1582
42.3%
1 372
 
9.9%
( 346
 
9.2%
) 346
 
9.2%
2 249
 
6.7%
3 211
 
5.6%
4 137
 
3.7%
5 95
 
2.5%
9 83
 
2.2%
0 75
 
2.0%
Other values (4) 248
 
6.6%
Latin
ValueCountFrequency (%)
P 2
25.0%
B 2
25.0%
E 1
12.5%
U 1
12.5%
A 1
12.5%
C 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5887
61.1%
ASCII 3752
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1582
42.2%
1 372
 
9.9%
( 346
 
9.2%
) 346
 
9.2%
2 249
 
6.6%
3 211
 
5.6%
4 137
 
3.7%
5 95
 
2.5%
9 83
 
2.2%
0 75
 
2.0%
Other values (10) 256
 
6.8%
Hangul
ValueCountFrequency (%)
영 508
 
8.6%
동 356
 
6.0%
산 353
 
6.0%
도 351
 
6.0%
부 350
 
5.9%
광 348
 
5.9%
시 348
 
5.9%
역 345
 
5.9%
구 345
 
5.9%
가 305
 
5.2%
Other values (140) 2278
38.7%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
부산광역시
345 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시
2nd row부산광역시
3rd row부산광역시
4th row부산광역시
5th row부산광역시

Common Values

ValueCountFrequency (%)
부산광역시 345
100.0%

Length

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

Common Values (Plot)

2023-12-11T01:26:26.700130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부산광역시 345
100.0%

구군
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
영도구
345 

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 (%)
영도구 345
100.0%

Length

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

Common Values (Plot)

2023-12-11T01:26:26.922745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영도구 345
100.0%

Interactions

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

Correlations

2023-12-11T01:26:26.983425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번광고물종류
순번1.0000.299
광고물종류0.2991.000
2023-12-11T01:26:27.062981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번광고물종류
순번1.0000.155
광고물종류0.1551.000

Missing values

2023-12-11T01:26:22.871819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:26:23.034048image/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벽면이용간판(가로형)고려개발9*1.2부산광역시 영도구 남항시장길 197 (신선동2가)부산광역시영도구
12벽면이용간판(가로형)(주)한화전기상사5*1부산광역시 영도구 남항서로 105 (남항동2가)부산광역시영도구
23돌출간판김도령신당0.6*0.6부산광역시 영도구 절영로94번길 10-2 (남항동3가)부산광역시영도구
34벽면이용간판(세로형)나인호텔1.2*7부산광역시 영도구 절영로 48-1 지직스모텔 (남항동1가)부산광역시영도구
45가로형간판_입체형나인호텔5.1*1부산광역시 영도구 절영로 48-1 지직스모텔 (남항동1가)부산광역시영도구
56벽면이용간판(가로형)소리아이스토리 미술9*1부산광역시 영도구 남항로 12 3층 (남항동2가)부산광역시영도구
67벽면이용간판(가로형)현대건축설비8.9*1.2부산광역시 영도구 하나길 462 (신선동2가)부산광역시영도구
78벽면이용간판(가로형)정민종합상사5.5*1부산광역시 영도구 대평로 61 (대평동2가)부산광역시영도구
89벽면이용간판(가로형)(주)혜인선박5*1부산광역시 영도구 대평남로51번길 8-5 (대평동2가)부산광역시영도구
910돌출간판선화선녀신당0.5*0.5부산광역시 영도구 번영길 43 (신선동1가)부산광역시영도구
순번광고물종류업소명광고물규격표시장소도로명시도구군
335336돌출간판(주)경부산업 영도지점0.65*0.65부산광역시 영도구 봉래나루로 140 (봉래동2가)부산광역시영도구
336337벽면이용간판(가로형)신한은행 영도무인점6.0*1.0부산광역시 영도구 태종로 107 영도오션트라움 (영선동1가)부산광역시영도구
337338벽면이용간판(가로형)삼영통신10*1부산광역시 영도구 절영로 133 (영선동4가)부산광역시영도구
338339돌출간판신도rns0.8*2부산광역시 영도구 절영로 133 (영선동4가)부산광역시영도구
339340돌출간판디얼유헤어0.8*2.2부산광역시 영도구 동삼로 5 (동삼동)부산광역시영도구
340341벽면이용간판(세로형)케네디로즈1*3부산광역시 영도구 웃서발로 79 한마음빌딩 (동삼동)부산광역시영도구
341342돌출간판수빈헤어0.6*0.7부산광역시 영도구 남항새싹길 79 (영선동4가 영도대원아파트)부산광역시영도구
342343벽면이용간판(가로형)신도rns7*1부산광역시 영도구 절영로 133 (영선동4가)부산광역시영도구
343344벽면이용간판(가로형)수빈헤어6.5*1부산광역시 영도구 남항새싹길 79 (영선동4가 영도대원아파트)부산광역시영도구
344345돌출간판뉴마카오게임랜드0.7*2부산광역시 영도구 남항로31번길 52 2층 (대교동2가)부산광역시영도구