Overview

Dataset statistics

Number of variables4
Number of observations75
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory34.8 B

Variable types

Numeric1
Text3

Dataset

Description대전광역시 동구에 위치한 옥외광고업소 등록현황에 관한 데이터입니다.대전광역시 동구 옥외광고업소 현황(업소명, 주소, 영업내용)
Author대전광역시 동구
URLhttps://www.data.go.kr/data/15067209/fileData.do

Alerts

순번 has unique valuesUnique
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:00:57.299242
Analysis finished2023-12-12 18:00:57.946553
Duration0.65 seconds
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%
Mean38
Minimum1
Maximum75
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size807.0 B
2023-12-13T03:00:58.015319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.7
Q119.5
median38
Q356.5
95-th percentile71.3
Maximum75
Range74
Interquartile range (IQR)37

Descriptive statistics

Standard deviation21.794495
Coefficient of variation (CV)0.57353933
Kurtosis-1.2
Mean38
Median Absolute Deviation (MAD)19
Skewness0
Sum2850
Variance475
MonotonicityStrictly increasing
2023-12-13T03:00:58.165705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
49 1
 
1.3%
56 1
 
1.3%
55 1
 
1.3%
54 1
 
1.3%
53 1
 
1.3%
52 1
 
1.3%
51 1
 
1.3%
50 1
 
1.3%
48 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%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%
70 1
1.3%
69 1
1.3%
68 1
1.3%
67 1
1.3%
66 1
1.3%

업소명
Text

UNIQUE 

Distinct75
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-13T03:00:58.438976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.8666667
Min length2

Characters and Unicode

Total characters440
Distinct characters145
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

Unique75 ?
Unique (%)100.0%

Sample

1st row디자인플러스
2nd row나로기획인쇄
3rd row디에스애드
4th row오시오광고기획
5th row미림종합인쇄/미림그래픽
ValueCountFrequency (%)
주식회사 5
 
5.6%
디자인 3
 
3.4%
주 2
 
2.2%
공간 1
 
1.1%
새롬디자인 1
 
1.1%
주)위즈 1
 
1.1%
로고스 1
 
1.1%
미전산업 1
 
1.1%
레어웍스 1
 
1.1%
시티페인팅 1
 
1.1%
Other values (72) 72
80.9%
2023-12-13T03:00:58.815375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
인 21
 
4.8%
디 20
 
4.5%
주 19
 
4.3%
광 19
 
4.3%
고 17
 
3.9%
자 16
 
3.6%
( 15
 
3.4%
) 15
 
3.4%
14
 
3.2%
획 13
 
3.0%
Other values (135) 271
61.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 388
88.2%
Open Punctuation 15
 
3.4%
Close Punctuation 15
 
3.4%
Space Separator 14
 
3.2%
Uppercase Letter 6
 
1.4%
Other Punctuation 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 21
 
5.4%
디 20
 
5.2%
주 19
 
4.9%
광 19
 
4.9%
고 17
 
4.4%
자 16
 
4.1%
획 13
 
3.4%
기 13
 
3.4%
사 10
 
2.6%
스 9
 
2.3%
Other values (125) 231
59.5%
Uppercase Letter
ValueCountFrequency (%)
C 2
33.3%
A 1
16.7%
F 1
16.7%
E 1
16.7%
P 1
16.7%
Other Punctuation
ValueCountFrequency (%)
/ 1
50.0%
& 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 388
88.2%
Common 46
 
10.5%
Latin 6
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 21
 
5.4%
디 20
 
5.2%
주 19
 
4.9%
광 19
 
4.9%
고 17
 
4.4%
자 16
 
4.1%
획 13
 
3.4%
기 13
 
3.4%
사 10
 
2.6%
스 9
 
2.3%
Other values (125) 231
59.5%
Common
ValueCountFrequency (%)
( 15
32.6%
) 15
32.6%
14
30.4%
/ 1
 
2.2%
& 1
 
2.2%
Latin
ValueCountFrequency (%)
C 2
33.3%
A 1
16.7%
F 1
16.7%
E 1
16.7%
P 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 388
88.2%
ASCII 52
 
11.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
인 21
 
5.4%
디 20
 
5.2%
주 19
 
4.9%
광 19
 
4.9%
고 17
 
4.4%
자 16
 
4.1%
획 13
 
3.4%
기 13
 
3.4%
사 10
 
2.6%
스 9
 
2.3%
Other values (125) 231
59.5%
ASCII
ValueCountFrequency (%)
( 15
28.8%
) 15
28.8%
14
26.9%
C 2
 
3.8%
A 1
 
1.9%
F 1
 
1.9%
E 1
 
1.9%
/ 1
 
1.9%
& 1
 
1.9%
P 1
 
1.9%

영업장도로명주소
Text

Distinct74
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-13T03:00:59.063107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length29
Mean length25.2
Min length20

Characters and Unicode

Total characters1890
Distinct characters99
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

Unique73 ?
Unique (%)97.3%

Sample

1st row대전광역시 동구 태전로 115, 1층 (삼성동)
2nd row대전광역시 동구 태전로 50 (삼성동)
3rd row대전광역시 동구 대전로987번길 49, 1층 (삼성동)
4th row대전광역시 동구 우암로 79, 1층 (삼성동)
5th row대전광역시 동구 중앙로203번길 56-2 (정동)
ValueCountFrequency (%)
대전광역시 75
19.0%
동구 75
19.0%
삼성동 28
 
7.1%
우암로 12
 
3.0%
가양동 10
 
2.5%
1층 7
 
1.8%
태전로 5
 
1.3%
계족로 5
 
1.3%
대전천동로 4
 
1.0%
홍도동 4
 
1.0%
Other values (138) 169
42.9%
2023-12-13T03:00:59.450360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
319
16.9%
동 162
 
8.6%
전 102
 
5.4%
대 98
 
5.2%
광 76
 
4.0%
시 76
 
4.0%
구 76
 
4.0%
( 75
 
4.0%
역 75
 
4.0%
) 75
 
4.0%
Other values (89) 756
40.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1088
57.6%
Space Separator 319
 
16.9%
Decimal Number 295
 
15.6%
Open Punctuation 75
 
4.0%
Close Punctuation 75
 
4.0%
Other Punctuation 24
 
1.3%
Dash Punctuation 14
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 162
14.9%
전 102
 
9.4%
대 98
 
9.0%
광 76
 
7.0%
시 76
 
7.0%
구 76
 
7.0%
역 75
 
6.9%
로 74
 
6.8%
성 32
 
2.9%
삼 30
 
2.8%
Other values (73) 287
26.4%
Decimal Number
ValueCountFrequency (%)
1 59
20.0%
2 37
12.5%
3 36
12.2%
0 30
10.2%
7 27
9.2%
5 25
8.5%
4 23
 
7.8%
6 21
 
7.1%
8 19
 
6.4%
9 18
 
6.1%
Other Punctuation
ValueCountFrequency (%)
, 20
83.3%
? 4
 
16.7%
Space Separator
ValueCountFrequency (%)
319
100.0%
Open Punctuation
ValueCountFrequency (%)
( 75
100.0%
Close Punctuation
ValueCountFrequency (%)
) 75
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1088
57.6%
Common 802
42.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 162
14.9%
전 102
 
9.4%
대 98
 
9.0%
광 76
 
7.0%
시 76
 
7.0%
구 76
 
7.0%
역 75
 
6.9%
로 74
 
6.8%
성 32
 
2.9%
삼 30
 
2.8%
Other values (73) 287
26.4%
Common
ValueCountFrequency (%)
319
39.8%
( 75
 
9.4%
) 75
 
9.4%
1 59
 
7.4%
2 37
 
4.6%
3 36
 
4.5%
0 30
 
3.7%
7 27
 
3.4%
5 25
 
3.1%
4 23
 
2.9%
Other values (6) 96
 
12.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1088
57.6%
ASCII 802
42.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
319
39.8%
( 75
 
9.4%
) 75
 
9.4%
1 59
 
7.4%
2 37
 
4.6%
3 36
 
4.5%
0 30
 
3.7%
7 27
 
3.4%
5 25
 
3.1%
4 23
 
2.9%
Other values (6) 96
 
12.0%
Hangul
ValueCountFrequency (%)
동 162
14.9%
전 102
 
9.4%
대 98
 
9.0%
광 76
 
7.0%
시 76
 
7.0%
구 76
 
7.0%
역 75
 
6.9%
로 74
 
6.8%
성 32
 
2.9%
삼 30
 
2.8%
Other values (73) 287
26.4%

영업내용
Text

Distinct52
Distinct (%)69.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-13T03:00:59.691407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length19
Mean length10.506667
Min length2

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)57.3%

Sample

1st row옥외광고물 제작+설치
2nd row간판 및 옥내외 광고물 제작 및 설치
3rd row인쇄, 광고+현수막+교통안내판+전시대
4th row옥외광고사업+광고기획+간판+현수막
5th row옥외광고+인쇄+광고대행
ValueCountFrequency (%)
및 27
15.8%
제작 22
 
12.9%
옥외광고물 19
 
11.1%
설치 18
 
10.5%
간판 8
 
4.7%
광고물 6
 
3.5%
간판제작 5
 
2.9%
옥외광고 4
 
2.3%
제작+설치 3
 
1.8%
옥외광고업 2
 
1.2%
Other values (49) 57
33.3%
2023-12-13T03:01:00.048554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
96
 
12.2%
광 64
 
8.1%
고 64
 
8.1%
제 51
 
6.5%
작 49
 
6.2%
+ 43
 
5.5%
물 42
 
5.3%
판 38
 
4.8%
간 33
 
4.2%
외 32
 
4.1%
Other values (51) 276
35.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 648
82.2%
Space Separator 96
 
12.2%
Math Symbol 43
 
5.5%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 64
 
9.9%
고 64
 
9.9%
제 51
 
7.9%
작 49
 
7.6%
물 42
 
6.5%
판 38
 
5.9%
간 33
 
5.1%
외 32
 
4.9%
옥 32
 
4.9%
및 31
 
4.8%
Other values (48) 212
32.7%
Space Separator
ValueCountFrequency (%)
96
100.0%
Math Symbol
ValueCountFrequency (%)
+ 43
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 648
82.2%
Common 140
 
17.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 64
 
9.9%
고 64
 
9.9%
제 51
 
7.9%
작 49
 
7.6%
물 42
 
6.5%
판 38
 
5.9%
간 33
 
5.1%
외 32
 
4.9%
옥 32
 
4.9%
및 31
 
4.8%
Other values (48) 212
32.7%
Common
ValueCountFrequency (%)
96
68.6%
+ 43
30.7%
, 1
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 648
82.2%
ASCII 140
 
17.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
96
68.6%
+ 43
30.7%
, 1
 
0.7%
Hangul
ValueCountFrequency (%)
광 64
 
9.9%
고 64
 
9.9%
제 51
 
7.9%
작 49
 
7.6%
물 42
 
6.5%
판 38
 
5.9%
간 33
 
5.1%
외 32
 
4.9%
옥 32
 
4.9%
및 31
 
4.8%
Other values (48) 212
32.7%

Interactions

2023-12-13T03:00:57.703338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:01:00.149405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업소명영업장도로명주소영업내용
순번1.0001.0000.9270.702
업소명1.0001.0001.0001.000
영업장도로명주소0.9271.0001.0000.976
영업내용0.7021.0000.9761.000

Missing values

2023-12-13T03:00:57.823753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:00:57.912273image/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디자인플러스대전광역시 동구 태전로 115, 1층 (삼성동)옥외광고물 제작+설치
12나로기획인쇄대전광역시 동구 태전로 50 (삼성동)간판 및 옥내외 광고물 제작 및 설치
23디에스애드대전광역시 동구 대전로987번길 49, 1층 (삼성동)인쇄, 광고+현수막+교통안내판+전시대
34오시오광고기획대전광역시 동구 우암로 79, 1층 (삼성동)옥외광고사업+광고기획+간판+현수막
45미림종합인쇄/미림그래픽대전광역시 동구 중앙로203번길 56-2 (정동)옥외광고+인쇄+광고대행
56프로미나드대전광역시 동구 산내로 1302, 102호 (낭월동)옥외광고물 제작+설치
67이디스디자인대전광역시 동구 용대길 18, 1층 102호 (판암동)간판제작 및 설치
78이지배너대전광역시 동구 우암로 163-1, 2층 (성남동)스텐가공광고물제작
89녹원광고대전광역시 동구 대전천북로 4 (삼성동)간판제작
910주식회사 바로디자인대전광역시 동구 산내로1337번길 6-19 (낭월동)옥외광고물 제작 및 설치
순번업소명영업장도로명주소영업내용
6566디자인 길대전광역시 동구 대전천북로 74 (삼성동)광고물 제작+간판+판촉물+디자인 기획
6667광고타운그린대전광역시 동구 우암로50번길 9 (삼성동)옥외광고업
6768(주)영광사대전광역시 동구 선화로 188 (중동,2층)인쇄+간판+인테리어+광고대행
6869(주)미연대전광역시 동구 우암로109번길 16 (삼성동)교통안전시설물광고물등
6970후니 디자인대전광역시 동구 동서대로1730번길 43 (가양동)간판제작+디자인 및 실사출력
7071거목광고대전광역시 동구 계족로 219(신안동)광고간판
7172샘광고레이저대전광역시 동구 옛신탄진로 57? (홍도동)간판및광고물 제작
7273시대광고사대전광역시 동구 태전로161번길 55? (삼성동)광고물 제작 및 설치업
7374세손광고기획대전광역시 동구 우암로 55? (삼성동)옥외광고물등제작및설치
7475(주)예원테크대전광역시 동구 산내로560번길 131? (상소동)간판및 광고물제작+차량광고업