Overview

Dataset statistics

Number of variables4
Number of observations61
Missing cells16
Missing cells (%)6.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory35.2 B

Variable types

Numeric1
Text3

Dataset

Description부산광역시남구_옥외광고사업자현황_20210928
Author부산광역시 남구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15055984

Alerts

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

Reproduction

Analysis started2023-12-10 17:43:48.529931
Analysis finished2023-12-10 17:43:50.004800
Duration1.47 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31
Minimum1
Maximum61
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2023-12-11T02:43:50.206892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4
Q116
median31
Q346
95-th percentile58
Maximum61
Range60
Interquartile range (IQR)30

Descriptive statistics

Standard deviation17.752934
Coefficient of variation (CV)0.57267529
Kurtosis-1.2
Mean31
Median Absolute Deviation (MAD)15
Skewness0
Sum1891
Variance315.16667
MonotonicityStrictly increasing
2023-12-11T02:43:50.551535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
47 1
 
1.6%
34 1
 
1.6%
35 1
 
1.6%
36 1
 
1.6%
37 1
 
1.6%
38 1
 
1.6%
39 1
 
1.6%
40 1
 
1.6%
41 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
1 1
1.6%
2 1
1.6%
3 1
1.6%
4 1
1.6%
5 1
1.6%
6 1
1.6%
7 1
1.6%
8 1
1.6%
9 1
1.6%
10 1
1.6%
ValueCountFrequency (%)
61 1
1.6%
60 1
1.6%
59 1
1.6%
58 1
1.6%
57 1
1.6%
56 1
1.6%
55 1
1.6%
54 1
1.6%
53 1
1.6%
52 1
1.6%

업소명
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-11T02:43:51.147924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length5.5901639
Min length2

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row(주)아티어스 디자인
2nd row(주)디자인엑스투
3rd row햇빛디자인
4th row와우미디어
5th row부성애드
ValueCountFrequency (%)
디자인 2
 
2.9%
광고기획 2
 
2.9%
가람광고기획 1
 
1.5%
혜인plus 1
 
1.5%
돼랑 1
 
1.5%
서린 1
 
1.5%
종합광고 1
 
1.5%
해인디자인 1
 
1.5%
제일애드 1
 
1.5%
수애드 1
 
1.5%
Other values (56) 56
82.4%
2023-12-11T02:43:52.110979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 24
 
7.0%
고 24
 
7.0%
기 17
 
5.0%
획 15
 
4.4%
인 14
 
4.1%
사 13
 
3.8%
디 13
 
3.8%
드 11
 
3.2%
자 11
 
3.2%
주 8
 
2.3%
Other values (114) 191
56.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 309
90.6%
Uppercase Letter 10
 
2.9%
Open Punctuation 7
 
2.1%
Close Punctuation 7
 
2.1%
Space Separator 7
 
2.1%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 24
 
7.8%
고 24
 
7.8%
기 17
 
5.5%
획 15
 
4.9%
인 14
 
4.5%
사 13
 
4.2%
디 13
 
4.2%
드 11
 
3.6%
자 11
 
3.6%
주 8
 
2.6%
Other values (102) 159
51.5%
Uppercase Letter
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
E 1
10.0%
P 1
10.0%
L 1
10.0%
U 1
10.0%
S 1
10.0%
M 1
10.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 309
90.6%
Common 22
 
6.5%
Latin 10
 
2.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 24
 
7.8%
고 24
 
7.8%
기 17
 
5.5%
획 15
 
4.9%
인 14
 
4.5%
사 13
 
4.2%
디 13
 
4.2%
드 11
 
3.6%
자 11
 
3.6%
주 8
 
2.6%
Other values (102) 159
51.5%
Latin
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
E 1
10.0%
P 1
10.0%
L 1
10.0%
U 1
10.0%
S 1
10.0%
M 1
10.0%
Common
ValueCountFrequency (%)
( 7
31.8%
) 7
31.8%
7
31.8%
, 1
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 309
90.6%
ASCII 32
 
9.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 24
 
7.8%
고 24
 
7.8%
기 17
 
5.5%
획 15
 
4.9%
인 14
 
4.5%
사 13
 
4.2%
디 13
 
4.2%
드 11
 
3.6%
자 11
 
3.6%
주 8
 
2.6%
Other values (102) 159
51.5%
ASCII
ValueCountFrequency (%)
( 7
21.9%
) 7
21.9%
7
21.9%
C 2
 
6.2%
A 2
 
6.2%
E 1
 
3.1%
P 1
 
3.1%
L 1
 
3.1%
U 1
 
3.1%
, 1
 
3.1%
Other values (2) 2
 
6.2%

영업장전화번호
Text

MISSING 

Distinct45
Distinct (%)100.0%
Missing16
Missing (%)26.2%
Memory size620.0 B
2023-12-11T02:43:52.582857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.888889
Min length12

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row051 -803 -8586
2nd row051 -742 -0143
3rd row051 -919 -8567
4th row051-817- 9114
5th row051 -621 -3800
ValueCountFrequency (%)
051 42
32.3%
628 5
 
3.8%
626 5
 
3.8%
633 3
 
2.3%
621 2
 
1.5%
4404 2
 
1.5%
634 2
 
1.5%
622 2
 
1.5%
647 2
 
1.5%
611 2
 
1.5%
Other values (60) 63
48.5%
2023-12-11T02:43:53.338465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 90
14.4%
85
13.6%
1 77
12.3%
0 72
11.5%
5 65
10.4%
6 58
9.3%
2 40
6.4%
4 35
 
5.6%
3 33
 
5.3%
8 31
 
5.0%
Other values (2) 39
6.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 450
72.0%
Dash Punctuation 90
 
14.4%
Space Separator 85
 
13.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 77
17.1%
0 72
16.0%
5 65
14.4%
6 58
12.9%
2 40
8.9%
4 35
7.8%
3 33
7.3%
8 31
6.9%
9 22
 
4.9%
7 17
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%
Space Separator
ValueCountFrequency (%)
85
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 625
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 90
14.4%
85
13.6%
1 77
12.3%
0 72
11.5%
5 65
10.4%
6 58
9.3%
2 40
6.4%
4 35
 
5.6%
3 33
 
5.3%
8 31
 
5.0%
Other values (2) 39
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 625
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 90
14.4%
85
13.6%
1 77
12.3%
0 72
11.5%
5 65
10.4%
6 58
9.3%
2 40
6.4%
4 35
 
5.6%
3 33
 
5.3%
8 31
 
5.0%
Other values (2) 39
6.2%

영업장도로명주소
Text

Distinct60
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-11T02:43:53.872004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length39
Mean length28.098361
Min length21

Characters and Unicode

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

Unique

Unique59 ?
Unique (%)96.7%

Sample

1st row부산광역시 남구 유엔로120번가길 7, 2층 (대연동)
2nd row부산광역시 남구 신선로 365, 6공학관 209호 부경대학교용당캠퍼스 (용당동)
3rd row부산광역시 남구 유엔평화로 157 (용당동)
4th row부산광역시 남구 유엔평화로76번길 26, 가람빌딩 701호 (대연동)
5th row부산광역시 남구 유엔로 226 (대연동)
ValueCountFrequency (%)
부산광역시 61
17.8%
남구 61
17.8%
대연동 28
 
8.2%
문현동 14
 
4.1%
용호동 8
 
2.3%
유엔평화로 6
 
1.7%
수영로 6
 
1.7%
용당동 5
 
1.5%
못골로 3
 
0.9%
2층 3
 
0.9%
Other values (129) 148
43.1%
2023-12-11T02:43:54.772502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
282
 
16.5%
동 75
 
4.4%
시 63
 
3.7%
부 62
 
3.6%
로 62
 
3.6%
산 62
 
3.6%
( 62
 
3.6%
) 62
 
3.6%
남 62
 
3.6%
역 61
 
3.6%
Other values (114) 861
50.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1007
58.8%
Space Separator 282
 
16.5%
Decimal Number 264
 
15.4%
Open Punctuation 62
 
3.6%
Close Punctuation 62
 
3.6%
Other Punctuation 25
 
1.5%
Dash Punctuation 12
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 75
 
7.4%
시 63
 
6.3%
부 62
 
6.2%
로 62
 
6.2%
산 62
 
6.2%
남 62
 
6.2%
역 61
 
6.1%
광 61
 
6.1%
구 61
 
6.1%
대 33
 
3.3%
Other values (99) 405
40.2%
Decimal Number
ValueCountFrequency (%)
1 61
23.1%
2 41
15.5%
0 31
11.7%
3 28
10.6%
6 21
 
8.0%
4 20
 
7.6%
9 19
 
7.2%
5 16
 
6.1%
7 15
 
5.7%
8 12
 
4.5%
Space Separator
ValueCountFrequency (%)
282
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 25
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1007
58.8%
Common 707
41.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 75
 
7.4%
시 63
 
6.3%
부 62
 
6.2%
로 62
 
6.2%
산 62
 
6.2%
남 62
 
6.2%
역 61
 
6.1%
광 61
 
6.1%
구 61
 
6.1%
대 33
 
3.3%
Other values (99) 405
40.2%
Common
ValueCountFrequency (%)
282
39.9%
( 62
 
8.8%
) 62
 
8.8%
1 61
 
8.6%
2 41
 
5.8%
0 31
 
4.4%
3 28
 
4.0%
, 25
 
3.5%
6 21
 
3.0%
4 20
 
2.8%
Other values (5) 74
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1007
58.8%
ASCII 707
41.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
282
39.9%
( 62
 
8.8%
) 62
 
8.8%
1 61
 
8.6%
2 41
 
5.8%
0 31
 
4.4%
3 28
 
4.0%
, 25
 
3.5%
6 21
 
3.0%
4 20
 
2.8%
Other values (5) 74
 
10.5%
Hangul
ValueCountFrequency (%)
동 75
 
7.4%
시 63
 
6.3%
부 62
 
6.2%
로 62
 
6.2%
산 62
 
6.2%
남 62
 
6.2%
역 61
 
6.1%
광 61
 
6.1%
구 61
 
6.1%
대 33
 
3.3%
Other values (99) 405
40.2%

Interactions

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

Correlations

2023-12-11T02:43:55.014507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명영업장전화번호영업장도로명주소
순번1.0001.0001.0000.945
업소명1.0001.0001.0001.000
영업장전화번호1.0001.0001.0001.000
영업장도로명주소0.9451.0001.0001.000

Missing values

2023-12-11T02:43:49.613209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:43:49.893338image/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 -803 -8586부산광역시 남구 유엔로120번가길 7, 2층 (대연동)
12(주)디자인엑스투051 -742 -0143부산광역시 남구 신선로 365, 6공학관 209호 부경대학교용당캠퍼스 (용당동)
23햇빛디자인<NA>부산광역시 남구 유엔평화로 157 (용당동)
34와우미디어051 -919 -8567부산광역시 남구 유엔평화로76번길 26, 가람빌딩 701호 (대연동)
45부성애드<NA>부산광역시 남구 유엔로 226 (대연동)
56에이엠씨(AMC)051-817- 9114부산광역시 남구 수영로 12, 상가동 106호 (문현동, 세종그랑시아아파트)
67광고기획 영051 -621 -3800부산광역시 남구 용호로110번길 10 (용호동)
78광고기획 밝은터051 -642 -0090부산광역시 남구 문현로 70 (문현동)
89광고공사예전051 -633 -8060부산광역시 남구 우암로362번길 2 (문현동)
910창운애드051 -647 -4835부산광역시 남구 석포로 47 (감만동)
순번업소명영업장전화번호영업장도로명주소
5152신광고사051 -626 -4463부산광역시 남구 동명로158번길 123 (용호동)
5253이왕광고기획,현수막051 -636 -8489부산광역시 남구 자성로 149 (문현동)
5354오색기획051 -626 -2722부산광역시 남구 유엔평화로 113-1 (대연동)
5455(주)시드애드컴051 -611 -9496부산광역시 남구 황령대로353번길 9-32 (대연동)
5556해바라기광고사051 -628 -5300부산광역시 남구 수영로366번길 14 (대연동)
5657사인탤051 -624 -6535부산광역시 남구 동명로112번길 14 (용호동)
5758착한디자인051 -647 -9199부산광역시 남구 석포로 20 (감만동)
5859해오름광고051 -644 -5411부산광역시 남구 고동골로 55-1 (문현동)
5960대구광고사051 -627 -5858부산광역시 남구 유엔평화로 40 (대연동)
6061성산광고기획051 -622 -2058부산광역시 남구 천제등로 35 (대연동)