Overview

Dataset statistics

Number of variables3
Number of observations75
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory26.8 B

Variable types

Numeric1
Text2

Dataset

Description부산광역시연제구_옥외광고업현황_20210915
Author부산광역시 연제구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3039595

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:01:09.401785
Analysis finished2023-12-10 16:01:10.580862
Duration1.18 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct75
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean69.386667
Minimum1
Maximum168
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size807.0 B
2023-12-11T01:01:10.661347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.1
Q127.5
median67
Q3100.5
95-th percentile149.3
Maximum168
Range167
Interquartile range (IQR)73

Descriptive statistics

Standard deviation46.583228
Coefficient of variation (CV)0.67135705
Kurtosis-0.92637205
Mean69.386667
Median Absolute Deviation (MAD)35
Skewness0.33928652
Sum5204
Variance2169.9971
MonotonicityStrictly increasing
2023-12-11T01:01:10.856994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
87 1
 
1.3%
100 1
 
1.3%
99 1
 
1.3%
98 1
 
1.3%
93 1
 
1.3%
92 1
 
1.3%
89 1
 
1.3%
88 1
 
1.3%
85 1
 
1.3%
Other values (65) 65
86.7%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
7 1
1.3%
8 1
1.3%
10 1
1.3%
11 1
1.3%
12 1
1.3%
13 1
1.3%
ValueCountFrequency (%)
168 1
1.3%
152 1
1.3%
151 1
1.3%
150 1
1.3%
149 1
1.3%
148 1
1.3%
147 1
1.3%
146 1
1.3%
142 1
1.3%
141 1
1.3%

업소명
Text

Distinct74
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-11T01:01:11.125960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length10
Mean length6.1466667
Min length2

Characters and Unicode

Total characters461
Distinct characters143
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

Unique73 ?
Unique (%)97.3%

Sample

1st row온누리광고
2nd row주호디자인오피스
3rd row주식회사 로오
4th row모든디자인
5th row일지광고사
ValueCountFrequency (%)
보임광고디자인 2
 
2.3%
디자인 2
 
2.3%
주식회사 2
 
2.3%
평화애드기획 1
 
1.2%
세진건설광고 1
 
1.2%
광고기획 1
 
1.2%
애드컴 1
 
1.2%
영 1
 
1.2%
썬코리아 1
 
1.2%
동경광고기획 1
 
1.2%
Other values (73) 73
84.9%
2023-12-11T01:01:11.528343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
디 23
 
5.0%
인 23
 
5.0%
광 21
 
4.6%
자 21
 
4.6%
고 19
 
4.1%
드 16
 
3.5%
주 15
 
3.3%
애 15
 
3.3%
) 12
 
2.6%
기 11
 
2.4%
Other values (133) 285
61.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 404
87.6%
Uppercase Letter 17
 
3.7%
Close Punctuation 12
 
2.6%
Space Separator 11
 
2.4%
Open Punctuation 11
 
2.4%
Other Punctuation 5
 
1.1%
Decimal Number 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
디 23
 
5.7%
인 23
 
5.7%
광 21
 
5.2%
자 21
 
5.2%
고 19
 
4.7%
드 16
 
4.0%
주 15
 
3.7%
애 15
 
3.7%
기 11
 
2.7%
스 11
 
2.7%
Other values (116) 229
56.7%
Uppercase Letter
ValueCountFrequency (%)
K 2
11.8%
S 2
11.8%
I 2
11.8%
O 2
11.8%
D 2
11.8%
T 2
11.8%
B 1
5.9%
L 1
5.9%
C 1
5.9%
N 1
5.9%
Other Punctuation
ValueCountFrequency (%)
. 3
60.0%
& 2
40.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 404
87.6%
Common 40
 
8.7%
Latin 17
 
3.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
디 23
 
5.7%
인 23
 
5.7%
광 21
 
5.2%
자 21
 
5.2%
고 19
 
4.7%
드 16
 
4.0%
주 15
 
3.7%
애 15
 
3.7%
기 11
 
2.7%
스 11
 
2.7%
Other values (116) 229
56.7%
Latin
ValueCountFrequency (%)
K 2
11.8%
S 2
11.8%
I 2
11.8%
O 2
11.8%
D 2
11.8%
T 2
11.8%
B 1
5.9%
L 1
5.9%
C 1
5.9%
N 1
5.9%
Common
ValueCountFrequency (%)
) 12
30.0%
11
27.5%
( 11
27.5%
. 3
 
7.5%
& 2
 
5.0%
2 1
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 404
87.6%
ASCII 57
 
12.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
디 23
 
5.7%
인 23
 
5.7%
광 21
 
5.2%
자 21
 
5.2%
고 19
 
4.7%
드 16
 
4.0%
주 15
 
3.7%
애 15
 
3.7%
기 11
 
2.7%
스 11
 
2.7%
Other values (116) 229
56.7%
ASCII
ValueCountFrequency (%)
) 12
21.1%
11
19.3%
( 11
19.3%
. 3
 
5.3%
K 2
 
3.5%
S 2
 
3.5%
I 2
 
3.5%
O 2
 
3.5%
& 2
 
3.5%
D 2
 
3.5%
Other values (7) 8
14.0%

영업장도로명주소
Text

Distinct73
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-11T01:01:11.850045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length38
Mean length26.84
Min length21

Characters and Unicode

Total characters2013
Distinct characters79
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

Unique71 ?
Unique (%)94.7%

Sample

1st row부산광역시 연제구 마곡천로 38 (연산동)
2nd row부산광역시 연제구 연동로 17, 1층 (연산동)
3rd row부산광역시 연제구 월드컵대로114번길 11, 3층 (연산동)
4th row부산광역시 연제구 과정로348번길 6 (연산동)
5th row부산광역시 연제구 쌍미천로 71 (연산동)
ValueCountFrequency (%)
부산광역시 75
18.8%
연제구 74
18.5%
연산동 60
 
15.0%
거제동 11
 
2.8%
과정로 7
 
1.8%
고분로 6
 
1.5%
1층 4
 
1.0%
거제천로 4
 
1.0%
거제대로 4
 
1.0%
20 4
 
1.0%
Other values (120) 151
37.8%
2023-12-11T01:01:12.283979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
334
 
16.6%
연 148
 
7.4%
산 138
 
6.9%
제 98
 
4.9%
동 81
 
4.0%
시 76
 
3.8%
로 76
 
3.8%
) 75
 
3.7%
( 75
 
3.7%
부 75
 
3.7%
Other values (69) 837
41.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1209
60.1%
Space Separator 334
 
16.6%
Decimal Number 291
 
14.5%
Close Punctuation 75
 
3.7%
Open Punctuation 75
 
3.7%
Other Punctuation 17
 
0.8%
Dash Punctuation 10
 
0.5%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
연 148
12.2%
산 138
11.4%
제 98
 
8.1%
동 81
 
6.7%
시 76
 
6.3%
로 76
 
6.3%
부 75
 
6.2%
구 75
 
6.2%
역 75
 
6.2%
광 75
 
6.2%
Other values (52) 292
24.2%
Decimal Number
ValueCountFrequency (%)
1 72
24.7%
2 48
16.5%
7 25
 
8.6%
5 25
 
8.6%
3 25
 
8.6%
6 23
 
7.9%
4 22
 
7.6%
0 19
 
6.5%
8 18
 
6.2%
9 14
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
334
100.0%
Close Punctuation
ValueCountFrequency (%)
) 75
100.0%
Open Punctuation
ValueCountFrequency (%)
( 75
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1209
60.1%
Common 802
39.8%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
연 148
12.2%
산 138
11.4%
제 98
 
8.1%
동 81
 
6.7%
시 76
 
6.3%
로 76
 
6.3%
부 75
 
6.2%
구 75
 
6.2%
역 75
 
6.2%
광 75
 
6.2%
Other values (52) 292
24.2%
Common
ValueCountFrequency (%)
334
41.6%
) 75
 
9.4%
( 75
 
9.4%
1 72
 
9.0%
2 48
 
6.0%
7 25
 
3.1%
5 25
 
3.1%
3 25
 
3.1%
6 23
 
2.9%
4 22
 
2.7%
Other values (5) 78
 
9.7%
Latin
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1209
60.1%
ASCII 804
39.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
334
41.5%
) 75
 
9.3%
( 75
 
9.3%
1 72
 
9.0%
2 48
 
6.0%
7 25
 
3.1%
5 25
 
3.1%
3 25
 
3.1%
6 23
 
2.9%
4 22
 
2.7%
Other values (7) 80
 
10.0%
Hangul
ValueCountFrequency (%)
연 148
12.2%
산 138
11.4%
제 98
 
8.1%
동 81
 
6.7%
시 76
 
6.3%
로 76
 
6.3%
부 75
 
6.2%
구 75
 
6.2%
역 75
 
6.2%
광 75
 
6.2%
Other values (52) 292
24.2%

Interactions

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

Correlations

2023-12-11T01:01:12.391170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명영업장도로명주소
순번1.0000.9610.976
업소명0.9611.0000.995
영업장도로명주소0.9760.9951.000

Missing values

2023-12-11T01:01:10.474400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:01:10.545759image/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온누리광고부산광역시 연제구 마곡천로 38 (연산동)
12주호디자인오피스부산광역시 연제구 연동로 17, 1층 (연산동)
23주식회사 로오부산광역시 연제구 월드컵대로114번길 11, 3층 (연산동)
34모든디자인부산광역시 연제구 과정로348번길 6 (연산동)
47일지광고사부산광역시 연제구 쌍미천로 71 (연산동)
58디자인 긱스부산광역시 연제구 고분로 111 (연산동)
610디자인메세지부산광역시 연제구 과정로276번길 8, 3층 (연산동)
711KT&B 디자인부산광역시 연제구 과정로 337, 3층 (연산동)
812메디컬광고부산광역시 연제구 월드컵대로91번가길 9, 휴먼빌 503호 (연산동)
913미루디자인부산광역시 연제구 과정로348번길 20 (연산동)
순번업소명영업장도로명주소
65141새암아트광고연구소부산광역시 연제구 과정로114번길 15 (연산동)
66142예스디자인부산광역시 연제구 거제천로118번길 3 (연산동)
67146지누애드부산광역시 연제구 반송로 68 (연산동,지누애드)
68147부강기획부산광역시 연제구 고분로32번길 58 (연산동)
69148거림기획부산광역시 연제구 고분로 54-1 (연산동)
70149(주)스타스부산광역시 연제구 반송로 9 (연산동)
71150공간간판부산광역시 연제구 연수로 187 (연산동)
72151평화애드기획부산광역시 연제구 좌수영로 297 (연산동)
73152대성기업공업사부산광역시 연제구 시청로 26 (연산동)
74168대원부산광역시 연제구 중앙대로1149번길 14 (연산동)