Overview

Dataset statistics

Number of variables6
Number of observations23
Missing cells1
Missing cells (%)0.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory54.7 B

Variable types

Numeric1
Text4
Categorical1

Dataset

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

Alerts

영업장전화번호 has 1 (4.3%) missing valuesMissing
순번 has unique valuesUnique
업소명 has unique valuesUnique
성명 has unique valuesUnique
영업장도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:03:54.773748
Analysis finished2023-12-10 16:03:55.484209
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12
Minimum1
Maximum23
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size339.0 B
2023-12-11T01:03:55.562951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.1
Q16.5
median12
Q317.5
95-th percentile21.9
Maximum23
Range22
Interquartile range (IQR)11

Descriptive statistics

Standard deviation6.78233
Coefficient of variation (CV)0.56519417
Kurtosis-1.2
Mean12
Median Absolute Deviation (MAD)6
Skewness0
Sum276
Variance46
MonotonicityStrictly increasing
2023-12-11T01:03:55.717957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
1 1
 
4.3%
2 1
 
4.3%
23 1
 
4.3%
22 1
 
4.3%
21 1
 
4.3%
20 1
 
4.3%
19 1
 
4.3%
18 1
 
4.3%
17 1
 
4.3%
16 1
 
4.3%
Other values (13) 13
56.5%
ValueCountFrequency (%)
1 1
4.3%
2 1
4.3%
3 1
4.3%
4 1
4.3%
5 1
4.3%
6 1
4.3%
7 1
4.3%
8 1
4.3%
9 1
4.3%
10 1
4.3%
ValueCountFrequency (%)
23 1
4.3%
22 1
4.3%
21 1
4.3%
20 1
4.3%
19 1
4.3%
18 1
4.3%
17 1
4.3%
16 1
4.3%
15 1
4.3%
14 1
4.3%

업소명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-11T01:03:55.981429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.0434783
Min length2

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row광고하우스
2nd row동이광고
3rd row국봉광고산업
4th row대신종합공사
5th row다움애드
ValueCountFrequency (%)
광고하우스 1
 
4.0%
충무광고기획 1
 
4.0%
월드 1
 
4.0%
디자인캠프 1
 
4.0%
삼보상사 1
 
4.0%
명진기획 1
 
4.0%
대우애드 1
 
4.0%
상명애드 1
 
4.0%
금강 1
 
4.0%
시대광고사 1
 
4.0%
Other values (15) 15
60.0%
2023-12-11T01:03:56.414342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 6
 
5.2%
고 6
 
5.2%
드 6
 
5.2%
애 5
 
4.3%
사 4
 
3.4%
디 4
 
3.4%
우 3
 
2.6%
대 3
 
2.6%
인 3
 
2.6%
자 3
 
2.6%
Other values (61) 73
62.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 109
94.0%
Uppercase Letter 3
 
2.6%
Space Separator 2
 
1.7%
Open Punctuation 1
 
0.9%
Close Punctuation 1
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 6
 
5.5%
고 6
 
5.5%
드 6
 
5.5%
애 5
 
4.6%
사 4
 
3.7%
디 4
 
3.7%
우 3
 
2.8%
대 3
 
2.8%
인 3
 
2.8%
자 3
 
2.8%
Other values (55) 66
60.6%
Uppercase Letter
ValueCountFrequency (%)
L 1
33.3%
E 1
33.3%
D 1
33.3%
Space Separator
ValueCountFrequency (%)
2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 109
94.0%
Common 4
 
3.4%
Latin 3
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 6
 
5.5%
고 6
 
5.5%
드 6
 
5.5%
애 5
 
4.6%
사 4
 
3.7%
디 4
 
3.7%
우 3
 
2.8%
대 3
 
2.8%
인 3
 
2.8%
자 3
 
2.8%
Other values (55) 66
60.6%
Common
ValueCountFrequency (%)
2
50.0%
( 1
25.0%
) 1
25.0%
Latin
ValueCountFrequency (%)
L 1
33.3%
E 1
33.3%
D 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 109
94.0%
ASCII 7
 
6.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 6
 
5.5%
고 6
 
5.5%
드 6
 
5.5%
애 5
 
4.6%
사 4
 
3.7%
디 4
 
3.7%
우 3
 
2.8%
대 3
 
2.8%
인 3
 
2.8%
자 3
 
2.8%
Other values (55) 66
60.6%
ASCII
ValueCountFrequency (%)
2
28.6%
( 1
14.3%
) 1
14.3%
L 1
14.3%
E 1
14.3%
D 1
14.3%

성명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-11T01:03:56.658940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters69
Distinct characters50
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

Unique23 ?
Unique (%)100.0%

Sample

1st row윤진석
2nd row신환옥
3rd row안준기
4th row이영수
5th row김주동
ValueCountFrequency (%)
윤진석 1
 
4.3%
민옥순 1
 
4.3%
최낙정 1
 
4.3%
강용원 1
 
4.3%
금동국 1
 
4.3%
황채윤 1
 
4.3%
이상권 1
 
4.3%
심경란 1
 
4.3%
박주원 1
 
4.3%
김바다 1
 
4.3%
Other values (13) 13
56.5%
2023-12-11T01:03:57.031551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 4
 
5.8%
이 3
 
4.3%
영 3
 
4.3%
윤 2
 
2.9%
수 2
 
2.9%
원 2
 
2.9%
권 2
 
2.9%
성 2
 
2.9%
경 2
 
2.9%
동 2
 
2.9%
Other values (40) 45
65.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 69
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 4
 
5.8%
이 3
 
4.3%
영 3
 
4.3%
윤 2
 
2.9%
수 2
 
2.9%
원 2
 
2.9%
권 2
 
2.9%
성 2
 
2.9%
경 2
 
2.9%
동 2
 
2.9%
Other values (40) 45
65.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 69
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 4
 
5.8%
이 3
 
4.3%
영 3
 
4.3%
윤 2
 
2.9%
수 2
 
2.9%
원 2
 
2.9%
권 2
 
2.9%
성 2
 
2.9%
경 2
 
2.9%
동 2
 
2.9%
Other values (40) 45
65.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 69
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 4
 
5.8%
이 3
 
4.3%
영 3
 
4.3%
윤 2
 
2.9%
수 2
 
2.9%
원 2
 
2.9%
권 2
 
2.9%
성 2
 
2.9%
경 2
 
2.9%
동 2
 
2.9%
Other values (40) 45
65.2%

영업장전화번호
Text

MISSING 

Distinct22
Distinct (%)100.0%
Missing1
Missing (%)4.3%
Memory size316.0 B
2023-12-11T01:03:57.333420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.090909
Min length12

Characters and Unicode

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

Unique22 ?
Unique (%)100.0%

Sample

1st row051-242-7066
2nd row051-242-8277
3rd row051-248-8382
4th row051-245-6560
5th row051-253-2341
ValueCountFrequency (%)
051-242-7066 1
 
4.2%
051-242-8277 1
 
4.2%
051-240-6728 1
 
4.2%
051-254-7837 1
 
4.2%
051-255-9597 1
 
4.2%
051-255-0909 1
 
4.2%
245-8930 1
 
4.2%
051 1
 
4.2%
051-255-9750 1
 
4.2%
051-241-6995 1
 
4.2%
Other values (14) 14
58.3%
2023-12-11T01:03:57.792019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 44
16.5%
5 43
16.2%
0 37
13.9%
1 30
11.3%
2 30
11.3%
4 22
8.3%
7 16
 
6.0%
9 15
 
5.6%
3 10
 
3.8%
8 9
 
3.4%
Other values (2) 10
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 220
82.7%
Dash Punctuation 44
 
16.5%
Space Separator 2
 
0.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 43
19.5%
0 37
16.8%
1 30
13.6%
2 30
13.6%
4 22
10.0%
7 16
 
7.3%
9 15
 
6.8%
3 10
 
4.5%
8 9
 
4.1%
6 8
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 266
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 44
16.5%
5 43
16.2%
0 37
13.9%
1 30
11.3%
2 30
11.3%
4 22
8.3%
7 16
 
6.0%
9 15
 
5.6%
3 10
 
3.8%
8 9
 
3.4%
Other values (2) 10
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 266
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 44
16.5%
5 43
16.2%
0 37
13.9%
1 30
11.3%
2 30
11.3%
4 22
8.3%
7 16
 
6.0%
9 15
 
5.6%
3 10
 
3.8%
8 9
 
3.4%
Other values (2) 10
 
3.8%

영업장도로명주소
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-11T01:03:58.133105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length33
Mean length28.391304
Min length21

Characters and Unicode

Total characters653
Distinct characters70
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

Unique23 ?
Unique (%)100.0%

Sample

1st row부산광역시 서구 충무대로 154, 105호 (남부민동)
2nd row부산광역시 서구 망양로 155, 1동 1층 109호 (동대신동2가, 영산아파트)
3rd row부산광역시 서구 보수대로193번길 20 (동대신동2가)
4th row부산광역시 서구 망양로 100 (동대신동3가)
5th row부산광역시 서구 해돋이로 273, 아미동새마을금고 2층 (아미동2가)
ValueCountFrequency (%)
부산광역시 23
18.4%
서구 23
18.4%
동대신동2가 6
 
4.8%
동대신동3가 4
 
3.2%
대영로 3
 
2.4%
부민동1가 3
 
2.4%
보수대로 3
 
2.4%
서대신동2가 3
 
2.4%
남부민동 2
 
1.6%
구덕로 2
 
1.6%
Other values (51) 53
42.4%
2023-12-11T01:03:58.665991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
102
 
15.6%
동 36
 
5.5%
부 28
 
4.3%
구 27
 
4.1%
1 27
 
4.1%
대 26
 
4.0%
서 26
 
4.0%
산 25
 
3.8%
시 23
 
3.5%
역 23
 
3.5%
Other values (60) 310
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 386
59.1%
Decimal Number 106
 
16.2%
Space Separator 102
 
15.6%
Close Punctuation 23
 
3.5%
Open Punctuation 23
 
3.5%
Other Punctuation 7
 
1.1%
Dash Punctuation 6
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 36
 
9.3%
부 28
 
7.3%
구 27
 
7.0%
대 26
 
6.7%
서 26
 
6.7%
산 25
 
6.5%
시 23
 
6.0%
역 23
 
6.0%
광 23
 
6.0%
로 21
 
5.4%
Other values (45) 128
33.2%
Decimal Number
ValueCountFrequency (%)
1 27
25.5%
3 19
17.9%
2 19
17.9%
0 8
 
7.5%
8 7
 
6.6%
5 7
 
6.6%
9 5
 
4.7%
7 5
 
4.7%
4 5
 
4.7%
6 4
 
3.8%
Space Separator
ValueCountFrequency (%)
102
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 386
59.1%
Common 267
40.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 36
 
9.3%
부 28
 
7.3%
구 27
 
7.0%
대 26
 
6.7%
서 26
 
6.7%
산 25
 
6.5%
시 23
 
6.0%
역 23
 
6.0%
광 23
 
6.0%
로 21
 
5.4%
Other values (45) 128
33.2%
Common
ValueCountFrequency (%)
102
38.2%
1 27
 
10.1%
) 23
 
8.6%
( 23
 
8.6%
3 19
 
7.1%
2 19
 
7.1%
0 8
 
3.0%
8 7
 
2.6%
, 7
 
2.6%
5 7
 
2.6%
Other values (5) 25
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 386
59.1%
ASCII 267
40.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
102
38.2%
1 27
 
10.1%
) 23
 
8.6%
( 23
 
8.6%
3 19
 
7.1%
2 19
 
7.1%
0 8
 
3.0%
8 7
 
2.6%
, 7
 
2.6%
5 7
 
2.6%
Other values (5) 25
 
9.4%
Hangul
ValueCountFrequency (%)
동 36
 
9.3%
부 28
 
7.3%
구 27
 
7.0%
대 26
 
6.7%
서 26
 
6.7%
산 25
 
6.5%
시 23
 
6.0%
역 23
 
6.0%
광 23
 
6.0%
로 21
 
5.4%
Other values (45) 128
33.2%

영업내용
Categorical

Distinct10
Distinct (%)43.5%
Missing0
Missing (%)0.0%
Memory size316.0 B
간판제작
11 
옥외광고업
3 
옥외광고물 제작 등
2 
광고물제작, 광고대행
 
1
간판 및 철구조물 제작
 
1
Other values (5)
5 

Length

Max length12
Median length4
Mean length6.1304348
Min length4

Unique

Unique7 ?
Unique (%)30.4%

Sample

1st row간판제작
2nd row광고물제작, 광고대행
3rd row간판제작
4th row간판제작
5th row옥외광고업

Common Values

ValueCountFrequency (%)
간판제작 11
47.8%
옥외광고업 3
 
13.0%
옥외광고물 제작 등 2
 
8.7%
광고물제작, 광고대행 1
 
4.3%
간판 및 철구조물 제작 1
 
4.3%
광고대행 1
 
4.3%
옥외광고물 제작및 시공 1
 
4.3%
간판 실내장식 1
 
4.3%
옥외광고물 제작 설치 1
 
4.3%
광고물제작 1
 
4.3%

Length

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

Common Values (Plot)

2023-12-11T01:03:59.047117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
간판제작 11
30.6%
옥외광고물 4
 
11.1%
제작 4
 
11.1%
옥외광고업 3
 
8.3%
등 2
 
5.6%
광고물제작 2
 
5.6%
광고대행 2
 
5.6%
간판 2
 
5.6%
및 1
 
2.8%
철구조물 1
 
2.8%
Other values (4) 4
 
11.1%

Interactions

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

Correlations

2023-12-11T01:03:59.267512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명성명영업장전화번호영업장도로명주소영업내용
순번1.0001.0001.0001.0001.0000.471
업소명1.0001.0001.0001.0001.0001.000
성명1.0001.0001.0001.0001.0001.000
영업장전화번호1.0001.0001.0001.0001.0001.000
영업장도로명주소1.0001.0001.0001.0001.0001.000
영업내용0.4711.0001.0001.0001.0001.000
2023-12-11T01:03:59.400534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업내용
순번1.0000.000
영업내용0.0001.000

Missing values

2023-12-11T01:03:55.281091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:03:55.427655image/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-242-7066부산광역시 서구 충무대로 154, 105호 (남부민동)간판제작
12동이광고신환옥051-242-8277부산광역시 서구 망양로 155, 1동 1층 109호 (동대신동2가, 영산아파트)광고물제작, 광고대행
23국봉광고산업안준기051-248-8382부산광역시 서구 보수대로193번길 20 (동대신동2가)간판제작
34대신종합공사이영수051-245-6560부산광역시 서구 망양로 100 (동대신동3가)간판제작
45다움애드김주동051-253-2341부산광역시 서구 해돋이로 273, 아미동새마을금고 2층 (아미동2가)옥외광고업
56조은디자인송재영051-241-7785부산광역시 서구 보수대로 241-1 (동대신동3가)간판 및 철구조물 제작
67엄지그래픽김택우051-247-7691부산광역시 서구 보수대로 87 (부민동1가)간판제작
78신영미디어 주식회사홍신영<NA>부산광역시 서구 대청로6번길 8, 901호 (부민동1가, 천우그린빌라)광고대행
89쓰리씨커뮤니케이션이경규051-244-3533부산광역시 서구 대신공원로 7-1 (동대신동3가, 대원빌라)옥외광고물 제작및 시공
910프리애드유호성051-254-1235부산광역시 서구 대영로38번길 43-1 (서대신동2가)옥외광고업
순번업소명성명영업장전화번호영업장도로명주소영업내용
1314(주)모컴권명준051-254-9400부산광역시 서구 까치고개로208번길 19 (아미동1가)옥외광고물 제작 설치
1415블루디자인김바다051-244-3040부산광역시 서구 성산길 19 (암남동)간판제작
1516시대광고사박주원051-241-6995부산광역시 서구 구덕로132번길 7 (토성동5가)광고물제작
1617금강심경란051-255-9750부산광역시 서구 보동길 333-2 (동대신동2가)간판제작
1718상명애드이상권051 -245-8930부산광역시 서구 구덕로 153 (초장동)간판제작
1819대우애드황채윤051-255-0909부산광역시 서구 대영로 63-1 (동대신동2가)간판제작
1920명진기획금동국051-255-9597부산광역시 서구 구덕로214번길 6 (부민동1가)옥외광고물 제작 등
2021삼보상사강용원051-254-7837부산광역시 서구 구덕로 306 (동대신동2가)간판제작
2122디자인캠프최낙정051-240-6728부산광역시 서구 대영로85번길 71 (동대신동3가)옥외광고업
2223월드 LED김대인051-257-2429부산광역시 서구 보수대로 188 (동대신동2가)옥외광고물 제작 등