Overview

Dataset statistics

Number of variables5
Number of observations64
Missing cells20
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory43.1 B

Variable types

Numeric1
Text4

Dataset

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

Alerts

영업장전화번호 has 20 (31.2%) missing valuesMissing
순번 has unique valuesUnique
성명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 17:43:27.999465
Analysis finished2023-12-10 17:43:29.504505
Duration1.51 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.5
Minimum1
Maximum64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2023-12-11T02:43:29.640362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.15
Q116.75
median32.5
Q348.25
95-th percentile60.85
Maximum64
Range63
Interquartile range (IQR)31.5

Descriptive statistics

Standard deviation18.618987
Coefficient of variation (CV)0.5728919
Kurtosis-1.2
Mean32.5
Median Absolute Deviation (MAD)16
Skewness0
Sum2080
Variance346.66667
MonotonicityStrictly increasing
2023-12-11T02:43:29.930492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
34 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%
42 1
 
1.6%
43 1
 
1.6%
Other values (54) 54
84.4%
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 (%)
64 1
1.6%
63 1
1.6%
62 1
1.6%
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%

업소명
Text

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

Length

Max length10
Median length8
Mean length5.40625
Min length2

Characters and Unicode

Total characters346
Distinct characters125
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

Unique62 ?
Unique (%)96.9%

Sample

1st row지음
2nd row거성광고
3rd row플로스
4th row우리디자인
5th row유진테크
ValueCountFrequency (%)
거성광고 2
 
2.9%
광고기획 2
 
2.9%
가람광고기획 1
 
1.4%
돼랑 1
 
1.4%
서린 1
 
1.4%
종합광고 1
 
1.4%
해인디자인 1
 
1.4%
제일애드 1
 
1.4%
수애드 1
 
1.4%
혜인plus 1
 
1.4%
Other values (58) 58
82.9%
2023-12-11T02:43:31.384152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 25
 
7.2%
고 25
 
7.2%
기 17
 
4.9%
획 15
 
4.3%
인 14
 
4.0%
사 13
 
3.8%
디 13
 
3.8%
자 11
 
3.2%
드 11
 
3.2%
주 7
 
2.0%
Other values (115) 195
56.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 317
91.6%
Uppercase Letter 10
 
2.9%
Space Separator 6
 
1.7%
Open Punctuation 6
 
1.7%
Close Punctuation 6
 
1.7%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 25
 
7.9%
고 25
 
7.9%
기 17
 
5.4%
획 15
 
4.7%
인 14
 
4.4%
사 13
 
4.1%
디 13
 
4.1%
자 11
 
3.5%
드 11
 
3.5%
주 7
 
2.2%
Other values (103) 166
52.4%
Uppercase Letter
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
E 1
10.0%
P 1
10.0%
S 1
10.0%
U 1
10.0%
L 1
10.0%
M 1
10.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 317
91.6%
Common 19
 
5.5%
Latin 10
 
2.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 25
 
7.9%
고 25
 
7.9%
기 17
 
5.4%
획 15
 
4.7%
인 14
 
4.4%
사 13
 
4.1%
디 13
 
4.1%
자 11
 
3.5%
드 11
 
3.5%
주 7
 
2.2%
Other values (103) 166
52.4%
Latin
ValueCountFrequency (%)
C 2
20.0%
A 2
20.0%
E 1
10.0%
P 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 317
91.6%
ASCII 29
 
8.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 25
 
7.9%
고 25
 
7.9%
기 17
 
5.4%
획 15
 
4.7%
인 14
 
4.4%
사 13
 
4.1%
디 13
 
4.1%
자 11
 
3.5%
드 11
 
3.5%
주 7
 
2.2%
Other values (103) 166
52.4%
ASCII
ValueCountFrequency (%)
6
20.7%
( 6
20.7%
) 6
20.7%
C 2
 
6.9%
A 2
 
6.9%
E 1
 
3.4%
P 1
 
3.4%
, 1
 
3.4%
S 1
 
3.4%
U 1
 
3.4%
Other values (2) 2
 
6.9%

성명
Text

UNIQUE 

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

Length

Max length3
Median length3
Mean length2.953125
Min length2

Characters and Unicode

Total characters189
Distinct characters81
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique64 ?
Unique (%)100.0%

Sample

1st row박경태
2nd row안성민
3rd row문지영
4th row이지수
5th row장태진
ValueCountFrequency (%)
박경태 1
 
1.6%
안성민 1
 
1.6%
허열 1
 
1.6%
김강조 1
 
1.6%
황선호 1
 
1.6%
이헌운 1
 
1.6%
구본열 1
 
1.6%
노기석 1
 
1.6%
김태오 1
 
1.6%
김수민 1
 
1.6%
Other values (54) 54
84.4%
2023-12-11T02:43:33.472405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 20
 
10.6%
영 10
 
5.3%
수 9
 
4.8%
태 7
 
3.7%
이 7
 
3.7%
성 6
 
3.2%
박 4
 
2.1%
조 4
 
2.1%
민 4
 
2.1%
기 4
 
2.1%
Other values (71) 114
60.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 189
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 20
 
10.6%
영 10
 
5.3%
수 9
 
4.8%
태 7
 
3.7%
이 7
 
3.7%
성 6
 
3.2%
박 4
 
2.1%
조 4
 
2.1%
민 4
 
2.1%
기 4
 
2.1%
Other values (71) 114
60.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 189
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 20
 
10.6%
영 10
 
5.3%
수 9
 
4.8%
태 7
 
3.7%
이 7
 
3.7%
성 6
 
3.2%
박 4
 
2.1%
조 4
 
2.1%
민 4
 
2.1%
기 4
 
2.1%
Other values (71) 114
60.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 189
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 20
 
10.6%
영 10
 
5.3%
수 9
 
4.8%
태 7
 
3.7%
이 7
 
3.7%
성 6
 
3.2%
박 4
 
2.1%
조 4
 
2.1%
민 4
 
2.1%
기 4
 
2.1%
Other values (71) 114
60.3%

영업장전화번호
Text

MISSING 

Distinct44
Distinct (%)100.0%
Missing20
Missing (%)31.2%
Memory size644.0 B
2023-12-11T02:43:33.962941image/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:34.938820image/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

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

Length

Max length49
Median length40
Mean length28
Min length21

Characters and Unicode

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

Unique62 ?
Unique (%)96.9%

Sample

1st row부산광역시 남구 유엔로201번길 48 (대연동)
2nd row부산광역시 남구 우암로 248-1 (우암동)
3rd row부산광역시 남구 신선로 428, 동명대학교 학생복지관 333호 (용당동)
4th row부산광역시 남구 유엔평화로 122 (대연동)
5th row부산광역시 남구 전포대로 122 (문현동)
ValueCountFrequency (%)
부산광역시 64
17.8%
남구 64
17.8%
대연동 28
 
7.8%
문현동 15
 
4.2%
용호동 8
 
2.2%
용당동 6
 
1.7%
유엔평화로 6
 
1.7%
수영로 6
 
1.7%
못골로 3
 
0.8%
14 3
 
0.8%
Other values (135) 156
43.5%
2023-12-11T02:43:36.806767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
295
 
16.5%
동 79
 
4.4%
시 66
 
3.7%
부 65
 
3.6%
산 65
 
3.6%
) 65
 
3.6%
남 65
 
3.6%
( 65
 
3.6%
로 65
 
3.6%
1 64
 
3.6%
Other values (114) 898
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1051
58.6%
Space Separator 295
 
16.5%
Decimal Number 279
 
15.6%
Close Punctuation 65
 
3.6%
Open Punctuation 65
 
3.6%
Other Punctuation 24
 
1.3%
Dash Punctuation 13
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 79
 
7.5%
시 66
 
6.3%
부 65
 
6.2%
산 65
 
6.2%
남 65
 
6.2%
로 65
 
6.2%
구 64
 
6.1%
역 64
 
6.1%
광 64
 
6.1%
대 35
 
3.3%
Other values (99) 419
39.9%
Decimal Number
ValueCountFrequency (%)
1 64
22.9%
2 46
16.5%
3 31
11.1%
0 31
11.1%
4 22
 
7.9%
6 21
 
7.5%
9 19
 
6.8%
5 16
 
5.7%
8 15
 
5.4%
7 14
 
5.0%
Space Separator
ValueCountFrequency (%)
295
100.0%
Close Punctuation
ValueCountFrequency (%)
) 65
100.0%
Open Punctuation
ValueCountFrequency (%)
( 65
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1051
58.6%
Common 741
41.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 79
 
7.5%
시 66
 
6.3%
부 65
 
6.2%
산 65
 
6.2%
남 65
 
6.2%
로 65
 
6.2%
구 64
 
6.1%
역 64
 
6.1%
광 64
 
6.1%
대 35
 
3.3%
Other values (99) 419
39.9%
Common
ValueCountFrequency (%)
295
39.8%
) 65
 
8.8%
( 65
 
8.8%
1 64
 
8.6%
2 46
 
6.2%
3 31
 
4.2%
0 31
 
4.2%
, 24
 
3.2%
4 22
 
3.0%
6 21
 
2.8%
Other values (5) 77
 
10.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1051
58.6%
ASCII 741
41.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
295
39.8%
) 65
 
8.8%
( 65
 
8.8%
1 64
 
8.6%
2 46
 
6.2%
3 31
 
4.2%
0 31
 
4.2%
, 24
 
3.2%
4 22
 
3.0%
6 21
 
2.8%
Other values (5) 77
 
10.4%
Hangul
ValueCountFrequency (%)
동 79
 
7.5%
시 66
 
6.3%
부 65
 
6.2%
산 65
 
6.2%
남 65
 
6.2%
로 65
 
6.2%
구 64
 
6.1%
역 64
 
6.1%
광 64
 
6.1%
대 35
 
3.3%
Other values (99) 419
39.9%

Interactions

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

Correlations

2023-12-11T02:43:37.061877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명성명영업장전화번호영업장도로명주소
순번1.0000.9371.0001.0000.937
업소명0.9371.0001.0001.0000.998
성명1.0001.0001.0001.0001.000
영업장전화번호1.0001.0001.0001.0001.000
영업장도로명주소0.9370.9981.0001.0001.000

Missing values

2023-12-11T02:43:29.195218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:43:29.422274image/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>부산광역시 남구 유엔로201번길 48 (대연동)
12거성광고안성민<NA>부산광역시 남구 우암로 248-1 (우암동)
23플로스문지영<NA>부산광역시 남구 신선로 428, 동명대학교 학생복지관 333호 (용당동)
34우리디자인이지수<NA>부산광역시 남구 유엔평화로 122 (대연동)
45유진테크장태진<NA>부산광역시 남구 전포대로 122 (문현동)
56와우미디어조성영051 -919 -8567부산광역시 남구 유엔평화로76번길 26, 가람빌딩 701호 (대연동)
67(주)디자인엑스투김광051 -742 -0143부산광역시 남구 신선로 365, 6공학관 209호 부경대학교용당캠퍼스 (용당동)
78햇빛디자인김성태<NA>부산광역시 남구 유엔평화로 157 (용당동)
89부성애드최종열<NA>부산광역시 남구 유엔로 226 (대연동)
910에이엠씨(AMC)서룡051-817-9114부산광역시 남구 수영로 12, 상가동 106호 (문현동, 세종그랑시아아파트)
순번업소명성명영업장전화번호영업장도로명주소
5455신광고사신상채051 -626 -4463부산광역시 남구 동명로158번길 123 (용호동)
5556이왕광고기획,현수막김상일051 -636 -8489부산광역시 남구 자성로 149 (문현동)
5657오색기획나현숙051 -626 -2722부산광역시 남구 유엔평화로 113-1 (대연동)
5758(주)시드애드컴강문봉051 -611 -9496부산광역시 남구 황령대로353번길 9-32 (대연동)
5859해바라기광고사황지근051 -628 -5300부산광역시 남구 수영로366번길 14 (대연동)
5960사인탤우수현051 -624 -6535부산광역시 남구 동명로112번길 14 (용호동)
6061착한디자인정은애051 -647 -9199부산광역시 남구 석포로 20 (감만동)
6162해오름광고오민수051 -644 -5411부산광역시 남구 고동골로 55-1 (문현동)
6263대구광고사이용희051 -627 -5858부산광역시 남구 유엔평화로 40 (대연동)
6364성산광고기획조성호051 -622 -2058부산광역시 남구 천제등로 35 (대연동)