Overview

Dataset statistics

Number of variables4
Number of observations61
Missing cells17
Missing cells (%)7.0%
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부산광역시남구_옥외광고사업자현황_20211213
Author부산광역시 남구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15055984

Alerts

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

Reproduction

Analysis started2023-12-10 17:43:38.502336
Analysis finished2023-12-10 17:43:39.764339
Duration1.26 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:39.941374image/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:40.296444image/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:40.882679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length5.4754098
Min length2

Characters and Unicode

Total characters334
Distinct characters123
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
 
3.0%
유진테크 1
 
1.5%
해인디자인 1
 
1.5%
지음 1
 
1.5%
혜인plus 1
 
1.5%
디자인 1
 
1.5%
돼랑 1
 
1.5%
서린 1
 
1.5%
종합광고 1
 
1.5%
제일애드 1
 
1.5%
Other values (56) 56
83.6%
2023-12-11T02:43:41.881674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 24
 
7.2%
고 24
 
7.2%
기 17
 
5.1%
획 15
 
4.5%
사 13
 
3.9%
인 13
 
3.9%
디 12
 
3.6%
드 11
 
3.3%
자 10
 
3.0%
주 7
 
2.1%
Other values (113) 188
56.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 305
91.3%
Uppercase Letter 10
 
3.0%
Open Punctuation 6
 
1.8%
Space Separator 6
 
1.8%
Close Punctuation 6
 
1.8%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 24
 
7.9%
고 24
 
7.9%
기 17
 
5.6%
획 15
 
4.9%
사 13
 
4.3%
인 13
 
4.3%
디 12
 
3.9%
드 11
 
3.6%
자 10
 
3.3%
주 7
 
2.3%
Other values (101) 159
52.1%
Uppercase Letter
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
P 1
10.0%
E 1
10.0%
S 1
10.0%
U 1
10.0%
L 1
10.0%
M 1
10.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 305
91.3%
Common 19
 
5.7%
Latin 10
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 24
 
7.9%
고 24
 
7.9%
기 17
 
5.6%
획 15
 
4.9%
사 13
 
4.3%
인 13
 
4.3%
디 12
 
3.9%
드 11
 
3.6%
자 10
 
3.3%
주 7
 
2.3%
Other values (101) 159
52.1%
Latin
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
P 1
10.0%
E 1
10.0%
S 1
10.0%
U 1
10.0%
L 1
10.0%
M 1
10.0%
Common
ValueCountFrequency (%)
( 6
31.6%
6
31.6%
) 6
31.6%
, 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 305
91.3%
ASCII 29
 
8.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 24
 
7.9%
고 24
 
7.9%
기 17
 
5.6%
획 15
 
4.9%
사 13
 
4.3%
인 13
 
4.3%
디 12
 
3.9%
드 11
 
3.6%
자 10
 
3.3%
주 7
 
2.3%
Other values (101) 159
52.1%
ASCII
ValueCountFrequency (%)
( 6
20.7%
6
20.7%
) 6
20.7%
C 2
 
6.9%
A 2
 
6.9%
P 1
 
3.4%
, 1
 
3.4%
E 1
 
3.4%
S 1
 
3.4%
U 1
 
3.4%
Other values (2) 2
 
6.9%

영업장전화번호
Text

MISSING 

Distinct44
Distinct (%)100.0%
Missing17
Missing (%)27.9%
Memory size620.0 B
2023-12-11T02:43:42.503968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.840909
Min length12

Characters and Unicode

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

Unique44 ?
Unique (%)100.0%

Sample

1st row051 -919 -8567
2nd row051 -742 -0143
3rd row051-817-9114
4th row051 -621 -3800
5th row051 -642 -0090
ValueCountFrequency (%)
051 41
32.8%
626 5
 
4.0%
628 5
 
4.0%
633 3
 
2.4%
611 2
 
1.6%
634 2
 
1.6%
621 2
 
1.6%
644 2
 
1.6%
631 2
 
1.6%
4404 2
 
1.6%
Other values (56) 59
47.2%
2023-12-11T02:43:44.755671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 88
14.4%
81
13.3%
1 76
12.5%
0 70
11.5%
5 63
10.3%
6 57
9.4%
2 40
6.6%
4 35
 
5.7%
3 32
 
5.3%
8 28
 
4.6%
Other values (2) 39
6.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 440
72.2%
Dash Punctuation 88
 
14.4%
Space Separator 81
 
13.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 76
17.3%
0 70
15.9%
5 63
14.3%
6 57
13.0%
2 40
9.1%
4 35
8.0%
3 32
7.3%
8 28
 
6.4%
9 22
 
5.0%
7 17
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 88
100.0%
Space Separator
ValueCountFrequency (%)
81
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 609
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 88
14.4%
81
13.3%
1 76
12.5%
0 70
11.5%
5 63
10.3%
6 57
9.4%
2 40
6.6%
4 35
 
5.7%
3 32
 
5.3%
8 28
 
4.6%
Other values (2) 39
6.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 609
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 88
14.4%
81
13.3%
1 76
12.5%
0 70
11.5%
5 63
10.3%
6 57
9.4%
2 40
6.6%
4 35
 
5.7%
3 32
 
5.3%
8 28
 
4.6%
Other values (2) 39
6.4%

영업장도로명주소
Text

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

Length

Max length49
Median length39
Mean length27.967213
Min length21

Characters and Unicode

Total characters1706
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부산광역시 남구 전포대로 122 (문현동)
2nd row부산광역시 남구 유엔평화로76번길 26, 가람빌딩 701호 (대연동)
3rd row부산광역시 남구 신선로 365, 6공학관 209호 부경대학교용당캠퍼스 (용당동)
4th row부산광역시 남구 유엔평화로 157(용당동)
5th row부산광역시 남구 유엔로 226 (대연동)
ValueCountFrequency (%)
부산광역시 61
17.9%
남구 61
17.9%
대연동 27
 
7.9%
문현동 15
 
4.4%
용호동 8
 
2.3%
수영로 6
 
1.8%
유엔평화로 6
 
1.8%
용당동 4
 
1.2%
14 3
 
0.9%
102호 3
 
0.9%
Other values (129) 147
43.1%
2023-12-11T02:43:46.645993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
280
 
16.4%
동 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) 855
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1004
58.9%
Space Separator 280
 
16.4%
Decimal Number 262
 
15.4%
Open Punctuation 62
 
3.6%
Close Punctuation 62
 
3.6%
Other Punctuation 24
 
1.4%
Dash Punctuation 12
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 75
 
7.5%
시 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) 402
40.0%
Decimal Number
ValueCountFrequency (%)
1 61
23.3%
2 41
15.6%
0 30
11.5%
3 28
10.7%
6 21
 
8.0%
4 20
 
7.6%
9 19
 
7.3%
5 16
 
6.1%
7 14
 
5.3%
8 12
 
4.6%
Space Separator
ValueCountFrequency (%)
280
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1004
58.9%
Common 702
41.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 75
 
7.5%
시 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) 402
40.0%
Common
ValueCountFrequency (%)
280
39.9%
( 62
 
8.8%
) 62
 
8.8%
1 61
 
8.7%
2 41
 
5.8%
0 30
 
4.3%
3 28
 
4.0%
, 24
 
3.4%
6 21
 
3.0%
4 20
 
2.8%
Other values (5) 73
 
10.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1004
58.9%
ASCII 702
41.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
280
39.9%
( 62
 
8.8%
) 62
 
8.8%
1 61
 
8.7%
2 41
 
5.8%
0 30
 
4.3%
3 28
 
4.0%
, 24
 
3.4%
6 21
 
3.0%
4 20
 
2.8%
Other values (5) 73
 
10.4%
Hangul
ValueCountFrequency (%)
동 75
 
7.5%
시 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) 402
40.0%

Interactions

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

Correlations

2023-12-11T02:43:46.864894image/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:39.414297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:43:39.672997image/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>부산광역시 남구 전포대로 122 (문현동)
12와우미디어051 -919 -8567부산광역시 남구 유엔평화로76번길 26, 가람빌딩 701호 (대연동)
23(주)디자인엑스투051 -742 -0143부산광역시 남구 신선로 365, 6공학관 209호 부경대학교용당캠퍼스 (용당동)
34햇빛디자인<NA>부산광역시 남구 유엔평화로 157(용당동)
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 (대연동)