Overview

Dataset statistics

Number of variables4
Number of observations80
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)1.2%
Total size in memory2.6 KiB
Average record size in memory33.6 B

Variable types

Categorical2
Text2

Dataset

Description제주특별자치도 서귀포시 관내에 위치한 옥외광고업체 현황에 관한 데이터로 업소명, 주소, 위도, 경도 정보를 제공합니다.
Author제주특별자치도 서귀포시
URLhttps://www.data.go.kr/data/15056350/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (1.2%) duplicate rowsDuplicates
상태 is highly imbalanced (90.3%)Imbalance

Reproduction

Analysis started2023-12-12 14:59:22.156110
Analysis finished2023-12-12 14:59:22.564227
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상태
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size772.0 B
영업
79 
<NA>
 
1

Length

Max length4
Median length2
Mean length2.025
Min length2

Unique

Unique1 ?
Unique (%)1.2%

Sample

1st row영업
2nd row영업
3rd row영업
4th row영업
5th row영업

Common Values

ValueCountFrequency (%)
영업 79
98.8%
<NA> 1
 
1.2%

Length

2023-12-12T23:59:22.662257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:59:22.776529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 79
98.8%
na 1
 
1.2%

업소명
Text

Distinct79
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size772.0 B
2023-12-12T23:59:23.047606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length5.85
Min length2

Characters and Unicode

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

Unique

Unique78 ?
Unique (%)97.5%

Sample

1st row대홍광고
2nd row힘찬간판
3rd row비타광고
4th row(주)늘푸른
5th row(주)성보기업
ValueCountFrequency (%)
주식회사 3
 
3.4%
비타광고 2
 
2.2%
디자인 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 (75) 75
84.3%
2023-12-12T23:59:23.525788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 34
 
7.3%
고 32
 
6.8%
주 18
 
3.8%
기 17
 
3.6%
획 16
 
3.4%
인 14
 
3.0%
사 12
 
2.6%
디 12
 
2.6%
자 11
 
2.4%
( 10
 
2.1%
Other values (135) 292
62.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 425
90.8%
Uppercase Letter 11
 
2.4%
Open Punctuation 10
 
2.1%
Close Punctuation 10
 
2.1%
Space Separator 9
 
1.9%
Decimal Number 2
 
0.4%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 34
 
8.0%
고 32
 
7.5%
주 18
 
4.2%
기 17
 
4.0%
획 16
 
3.8%
인 14
 
3.3%
사 12
 
2.8%
디 12
 
2.8%
자 11
 
2.6%
이 10
 
2.4%
Other values (119) 249
58.6%
Uppercase Letter
ValueCountFrequency (%)
N 2
18.2%
K 1
9.1%
O 1
9.1%
G 1
9.1%
I 1
9.1%
S 1
9.1%
E 1
9.1%
D 1
9.1%
A 1
9.1%
R 1
9.1%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
8 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 425
90.8%
Common 32
 
6.8%
Latin 11
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 34
 
8.0%
고 32
 
7.5%
주 18
 
4.2%
기 17
 
4.0%
획 16
 
3.8%
인 14
 
3.3%
사 12
 
2.8%
디 12
 
2.8%
자 11
 
2.6%
이 10
 
2.4%
Other values (119) 249
58.6%
Latin
ValueCountFrequency (%)
N 2
18.2%
K 1
9.1%
O 1
9.1%
G 1
9.1%
I 1
9.1%
S 1
9.1%
E 1
9.1%
D 1
9.1%
A 1
9.1%
R 1
9.1%
Common
ValueCountFrequency (%)
( 10
31.2%
) 10
31.2%
9
28.1%
, 1
 
3.1%
1 1
 
3.1%
8 1
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 425
90.8%
ASCII 43
 
9.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 34
 
8.0%
고 32
 
7.5%
주 18
 
4.2%
기 17
 
4.0%
획 16
 
3.8%
인 14
 
3.3%
사 12
 
2.8%
디 12
 
2.8%
자 11
 
2.6%
이 10
 
2.4%
Other values (119) 249
58.6%
ASCII
ValueCountFrequency (%)
( 10
23.3%
) 10
23.3%
9
20.9%
N 2
 
4.7%
K 1
 
2.3%
O 1
 
2.3%
, 1
 
2.3%
1 1
 
2.3%
8 1
 
2.3%
G 1
 
2.3%
Other values (6) 6
14.0%

주소
Text

Distinct60
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Memory size772.0 B
2023-12-12T23:59:23.800565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length18.5125
Min length16

Characters and Unicode

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

Unique

Unique44 ?
Unique (%)55.0%

Sample

1st row제주특별자치도 서귀포시 표선면 세화강왓로
2nd row제주특별자치도 서귀포시 홍중로
3rd row제주특별자치도 서귀포시 대정읍 인안성로
4th row제주특별자치도 서귀포시 용흥로
5th row제주특별자치도 서귀포시 일주동로
ValueCountFrequency (%)
제주특별자치도 80
30.2%
서귀포시 80
30.2%
일주동로 9
 
3.4%
표선면 8
 
3.0%
대정읍 6
 
2.3%
성산읍 6
 
2.3%
중산간동로 5
 
1.9%
문부로 4
 
1.5%
번영로 3
 
1.1%
안덕면 3
 
1.1%
Other values (46) 61
23.0%
2023-12-12T23:59:24.269697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
211
14.2%
주 90
 
6.1%
서 90
 
6.1%
제 82
 
5.5%
도 81
 
5.5%
포 81
 
5.5%
귀 81
 
5.5%
치 80
 
5.4%
자 80
 
5.4%
별 80
 
5.4%
Other values (73) 525
35.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1267
85.6%
Space Separator 211
 
14.2%
Decimal Number 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 90
 
7.1%
서 90
 
7.1%
제 82
 
6.5%
도 81
 
6.4%
포 81
 
6.4%
귀 81
 
6.4%
치 80
 
6.3%
자 80
 
6.3%
별 80
 
6.3%
시 80
 
6.3%
Other values (69) 442
34.9%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
5 1
33.3%
6 1
33.3%
Space Separator
ValueCountFrequency (%)
211
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1267
85.6%
Common 214
 
14.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 90
 
7.1%
서 90
 
7.1%
제 82
 
6.5%
도 81
 
6.4%
포 81
 
6.4%
귀 81
 
6.4%
치 80
 
6.3%
자 80
 
6.3%
별 80
 
6.3%
시 80
 
6.3%
Other values (69) 442
34.9%
Common
ValueCountFrequency (%)
211
98.6%
1 1
 
0.5%
5 1
 
0.5%
6 1
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1267
85.6%
ASCII 214
 
14.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
211
98.6%
1 1
 
0.5%
5 1
 
0.5%
6 1
 
0.5%
Hangul
ValueCountFrequency (%)
주 90
 
7.1%
서 90
 
7.1%
제 82
 
6.5%
도 81
 
6.4%
포 81
 
6.4%
귀 81
 
6.4%
치 80
 
6.3%
자 80
 
6.3%
별 80
 
6.3%
시 80
 
6.3%
Other values (69) 442
34.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size772.0 B
2023-09-27
80 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-27
2nd row2023-09-27
3rd row2023-09-27
4th row2023-09-27
5th row2023-09-27

Common Values

ValueCountFrequency (%)
2023-09-27 80
100.0%

Length

2023-12-12T23:59:24.432089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:59:24.542626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-27 80
100.0%

Correlations

2023-12-12T23:59:24.622277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명주소
업소명1.0001.000
주소1.0001.000

Missing values

2023-12-12T23:59:22.402153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:59:22.513178image/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

상태업소명주소데이터기준일자
0영업대홍광고제주특별자치도 서귀포시 표선면 세화강왓로2023-09-27
1영업힘찬간판제주특별자치도 서귀포시 홍중로2023-09-27
2영업비타광고제주특별자치도 서귀포시 대정읍 인안성로2023-09-27
3영업(주)늘푸른제주특별자치도 서귀포시 용흥로2023-09-27
4영업(주)성보기업제주특별자치도 서귀포시 일주동로2023-09-27
5영업수광고기획제주특별자치도 서귀포시 동홍중앙로2023-09-27
6영업월드광고공사제주특별자치도 서귀포시 중정로2023-09-27
7영업디자인81제주특별자치도 서귀포시 성산읍 성산중앙로2023-09-27
8영업한담광고,기획제주특별자치도 서귀포시 안덕면 일주서로2023-09-27
9영업디제이디자인제주특별자치도 서귀포시 동홍서로2023-09-27
상태업소명주소데이터기준일자
70영업대우안전주식회사제주특별자치도 서귀포시 일주동로2023-09-27
71영업정방기획제주특별자치도 서귀포시 중산간동로2023-09-27
72영업오색광고사제주특별자치도 서귀포시 중앙로2023-09-27
73영업도시연출제주특별자치도 서귀포시 대포중앙로2023-09-27
74영업(주)아인산업제주특별자치도 서귀포시 남성중로2023-09-27
75영업씨티간판제주특별자치도 서귀포시 문부로2023-09-27
76영업송미사제주특별자치도 서귀포시 대정읍 신영로2023-09-27
77영업더존기획제주특별자치도 서귀포시 서홍로2023-09-27
78영업성원기획제주특별자치도 서귀포시 말질로2023-09-27
79<NA>미광제주특별자치도 서귀포시 동부로2023-09-27

Duplicate rows

Most frequently occurring

상태업소명주소데이터기준일자# duplicates
0영업비타광고제주특별자치도 서귀포시 대정읍 인안성로2023-09-272