Overview

Dataset statistics

Number of variables5
Number of observations125
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.1 KiB
Average record size in memory42.1 B

Variable types

Categorical3
Text1
DateTime1

Dataset

Description제주특별자치도 제주ON 홈페이지에서 제공하는 각종 영상 자료의 해당연도, 카테고리, 영상명, 등록일 정보를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15071611/fileData.do

Alerts

해당연도 is highly overall correlated with 데이터기준일자High correlation
카테고리 is highly overall correlated with 데이터기준일자High correlation
데이터기준일자 is highly overall correlated with 해당연도 and 1 other fieldsHigh correlation
해당연도 is highly imbalanced (51.8%)Imbalance

Reproduction

Analysis started2023-12-12 19:29:25.559965
Analysis finished2023-12-12 19:29:26.132667
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

해당연도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2022
112 
2023
13 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022
2nd row2022
3rd row2022
4th row2022
5th row2022

Common Values

ValueCountFrequency (%)
2022 112
89.6%
2023 13
 
10.4%

Length

2023-12-13T04:29:26.217717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:29:26.335670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 112
89.6%
2023 13
 
10.4%

카테고리
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
제주 VOD-제주홍보영상
49 
영상뉴스-영상뉴스 보기
46 
제주 VOD-정책/홍보
17 
제주 VOD-재난/안전
13 

Length

Max length13
Median length12
Mean length12.392
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주 VOD-제주홍보영상
2nd row제주 VOD-제주홍보영상
3rd row제주 VOD-정책/홍보
4th row제주 VOD-정책/홍보
5th row제주 VOD-정책/홍보

Common Values

ValueCountFrequency (%)
제주 VOD-제주홍보영상 49
39.2%
영상뉴스-영상뉴스 보기 46
36.8%
제주 VOD-정책/홍보 17
 
13.6%
제주 VOD-재난/안전 13
 
10.4%

Length

2023-12-13T04:29:26.479922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:29:26.597608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주 79
31.6%
vod-제주홍보영상 49
19.6%
영상뉴스-영상뉴스 46
18.4%
보기 46
18.4%
vod-정책/홍보 17
 
6.8%
vod-재난/안전 13
 
5.2%

영상명
Text

Distinct124
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-13T04:29:26.969191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length31
Mean length24.072
Min length6

Characters and Unicode

Total characters3009
Distinct characters371
Distinct categories14 ?
Distinct scripts4 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique123 ?
Unique (%)98.4%

Sample

1st row2022 양성평등 스팟영상_무음
2nd row재난상황 대피시설 홍보 영상(최종)
3rd row제15강 계약분야 감사사례
4th row제14강 계약상대자 제재
5th row제13강 협상에 의한 계약
ValueCountFrequency (%)
오영훈 25
 
3.7%
지사 22
 
3.3%
극복 21
 
3.1%
인구위기 20
 
3.0%
도민공감 19
 
2.8%
희망 19
 
2.8%
프로젝트 19
 
2.8%
홍보 7
 
1.0%
영상 7
 
1.0%
2022 7
 
1.0%
Other values (423) 509
75.4%
2023-12-13T04:29:27.572138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
550
 
18.3%
제 71
 
2.4%
도 54
 
1.8%
영 52
 
1.7%
사 48
 
1.6%
지 47
 
1.6%
2 47
 
1.6%
상 44
 
1.5%
주 43
 
1.4%
) 43
 
1.4%
Other values (361) 2010
66.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2070
68.8%
Space Separator 550
 
18.3%
Decimal Number 151
 
5.0%
Other Punctuation 79
 
2.6%
Close Punctuation 43
 
1.4%
Open Punctuation 43
 
1.4%
Uppercase Letter 21
 
0.7%
Final Punctuation 15
 
0.5%
Initial Punctuation 15
 
0.5%
Lowercase Letter 10
 
0.3%
Other values (4) 12
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 71
 
3.4%
도 54
 
2.6%
영 52
 
2.5%
사 48
 
2.3%
지 47
 
2.3%
상 44
 
2.1%
주 43
 
2.1%
기 40
 
1.9%
인 37
 
1.8%
민 35
 
1.7%
Other values (315) 1599
77.2%
Decimal Number
ValueCountFrequency (%)
2 47
31.1%
1 33
21.9%
0 22
14.6%
3 14
 
9.3%
4 10
 
6.6%
9 9
 
6.0%
5 5
 
3.3%
7 4
 
2.6%
8 4
 
2.6%
6 3
 
2.0%
Uppercase Letter
ValueCountFrequency (%)
C 7
33.3%
V 3
14.3%
T 3
14.3%
J 2
 
9.5%
M 1
 
4.8%
B 1
 
4.8%
P 1
 
4.8%
E 1
 
4.8%
U 1
 
4.8%
H 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
. 31
39.2%
! 20
25.3%
· 12
 
15.2%
… 8
 
10.1%
? 3
 
3.8%
" 2
 
2.5%
' 2
 
2.5%
: 1
 
1.3%
Lowercase Letter
ValueCountFrequency (%)
e 2
20.0%
a 2
20.0%
l 2
20.0%
i 1
10.0%
n 1
10.0%
g 1
10.0%
c 1
10.0%
Final Punctuation
ValueCountFrequency (%)
” 11
73.3%
’ 4
 
26.7%
Initial Punctuation
ValueCountFrequency (%)
“ 11
73.3%
‘ 4
 
26.7%
Space Separator
ValueCountFrequency (%)
550
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2068
68.7%
Common 907
30.1%
Latin 31
 
1.0%
Han 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 71
 
3.4%
도 54
 
2.6%
영 52
 
2.5%
사 48
 
2.3%
지 47
 
2.3%
상 44
 
2.1%
주 43
 
2.1%
기 40
 
1.9%
인 37
 
1.8%
민 35
 
1.7%
Other values (314) 1597
77.2%
Common
ValueCountFrequency (%)
550
60.6%
2 47
 
5.2%
) 43
 
4.7%
( 43
 
4.7%
1 33
 
3.6%
. 31
 
3.4%
0 22
 
2.4%
! 20
 
2.2%
3 14
 
1.5%
· 12
 
1.3%
Other values (18) 92
 
10.1%
Latin
ValueCountFrequency (%)
C 7
22.6%
V 3
9.7%
T 3
9.7%
e 2
 
6.5%
a 2
 
6.5%
l 2
 
6.5%
J 2
 
6.5%
M 1
 
3.2%
B 1
 
3.2%
i 1
 
3.2%
Other values (7) 7
22.6%
Han
ValueCountFrequency (%)
高 2
66.7%
新 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2067
68.7%
ASCII 888
29.5%
Punctuation 38
 
1.3%
None 13
 
0.4%
CJK 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
550
61.9%
2 47
 
5.3%
) 43
 
4.8%
( 43
 
4.8%
1 33
 
3.7%
. 31
 
3.5%
0 22
 
2.5%
! 20
 
2.3%
3 14
 
1.6%
4 10
 
1.1%
Other values (29) 75
 
8.4%
Hangul
ValueCountFrequency (%)
제 71
 
3.4%
도 54
 
2.6%
영 52
 
2.5%
사 48
 
2.3%
지 47
 
2.3%
상 44
 
2.1%
주 43
 
2.1%
기 40
 
1.9%
인 37
 
1.8%
민 35
 
1.7%
Other values (313) 1596
77.2%
None
ValueCountFrequency (%)
· 12
92.3%
㈜ 1
 
7.7%
Punctuation
ValueCountFrequency (%)
” 11
28.9%
“ 11
28.9%
… 8
21.1%
’ 4
 
10.5%
‘ 4
 
10.5%
CJK
ValueCountFrequency (%)
高 2
66.7%
新 1
33.3%

등록일
Date

Distinct68
Distinct (%)54.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2022-01-24 00:00:00
Maximum2023-06-26 00:00:00
2023-12-13T04:29:27.735253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:29:28.189425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2022-10-14
94 
2023-07-28
31 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-14
2nd row2022-10-14
3rd row2022-10-14
4th row2022-10-14
5th row2022-10-14

Common Values

ValueCountFrequency (%)
2022-10-14 94
75.2%
2023-07-28 31
 
24.8%

Length

2023-12-13T04:29:28.320362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:29:28.444284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-14 94
75.2%
2023-07-28 31
 
24.8%

Correlations

2023-12-13T04:29:28.525885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당연도카테고리등록일데이터기준일자
해당연도1.0000.6891.0000.769
카테고리0.6891.0000.9710.833
등록일1.0000.9711.0001.000
데이터기준일자0.7690.8331.0001.000
2023-12-13T04:29:28.663833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당연도카테고리데이터기준일자
해당연도1.0000.4830.558
카테고리0.4831.0000.622
데이터기준일자0.5580.6221.000
2023-12-13T04:29:28.774889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당연도카테고리데이터기준일자
해당연도1.0000.4830.558
카테고리0.4831.0000.622
데이터기준일자0.5580.6221.000

Missing values

2023-12-13T04:29:25.952345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:29:26.080101image/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

해당연도카테고리영상명등록일데이터기준일자
02022제주 VOD-제주홍보영상2022 양성평등 스팟영상_무음2022-01-242022-10-14
12022제주 VOD-제주홍보영상재난상황 대피시설 홍보 영상(최종)2022-04-212022-10-14
22022제주 VOD-정책/홍보제15강 계약분야 감사사례2022-04-252022-10-14
32022제주 VOD-정책/홍보제14강 계약상대자 제재2022-04-252022-10-14
42022제주 VOD-정책/홍보제13강 협상에 의한 계약2022-04-252022-10-14
52022제주 VOD-정책/홍보제12강 수의계약 운영요령2 (2인견적 수의계약)2022-04-252022-10-14
62022제주 VOD-정책/홍보제11강 수의계약 운영요령(1인견적 수의계약)2022-04-252022-10-14
72022제주 VOD-정책/홍보제10강 설계변경2022-04-252022-10-14
82022제주 VOD-정책/홍보제9강 제3자 및 다수계약2022-04-252022-10-14
92022제주 VOD-정책/홍보제8강 학술·일반용역2022-04-252022-10-14
해당연도카테고리영상명등록일데이터기준일자
1152023제주 VOD-재난/안전전 좌석 안전띠 착용 생활화 미니다큐2023-01-272023-07-28
1162023제주 VOD-재난/안전안전신고 우수사례 홍보 동영상(40초)2023-03-152023-07-28
1172023제주 VOD-정책/홍보(환경부) 1회용품 사용줄이기(출근편)2023-03-152023-07-28
1182023제주 VOD-정책/홍보(환경부) 1회용품 사용줄이기(등교편)2023-03-152023-07-28
1192023제주 VOD-재난/안전2023 안전문화운동 발대식2023-03-202023-07-28
1202023제주 VOD-제주홍보영상재난상황 대피시설 홍보 영상2023-04-102023-07-28
1212023제주 VOD-재난/안전음주문화 개선 홍보영상2023-05-032023-07-28
1222023제주 VOD-재난/안전범도민 음주문화 개선 안전문화 캠페인2023-05-032023-07-28
1232023제주 VOD-제주홍보영상절주 홍보영상(해야되여)2023-06-222023-07-28
1242023제주 VOD-제주홍보영상CCTV 안전비상벨 홍보 영상2023-06-262023-07-28