Overview

Dataset statistics

Number of variables7
Number of observations401
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory22.5 KiB
Average record size in memory57.3 B

Variable types

Numeric1
Categorical3
DateTime2
Text1

Dataset

Description제주특별자치도 도의회에서 제공하는 인터넷 방송과 관련한 데이터로 관리번호, 대수, 방송일, 회의종류, 차수, 제목에 대한 정보를 제공합니다.* 자세한 사항은 제주특별자치도의회 홈페이지를 참고하시기 바랍니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15087623/fileData.do

Alerts

대구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
관리번호 is highly overall correlated with 회의종류High correlation
회의종류 is highly overall correlated with 관리번호High correlation
관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:13:37.652695
Analysis finished2023-12-12 07:13:38.225138
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct401
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201
Minimum1
Maximum401
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2023-12-12T16:13:38.304406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile21
Q1101
median201
Q3301
95-th percentile381
Maximum401
Range400
Interquartile range (IQR)200

Descriptive statistics

Standard deviation115.90298
Coefficient of variation (CV)0.57663172
Kurtosis-1.2
Mean201
Median Absolute Deviation (MAD)100
Skewness0
Sum80601
Variance13433.5
MonotonicityStrictly increasing
2023-12-12T16:13:38.464514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
265 1
 
0.2%
275 1
 
0.2%
274 1
 
0.2%
273 1
 
0.2%
272 1
 
0.2%
271 1
 
0.2%
270 1
 
0.2%
269 1
 
0.2%
268 1
 
0.2%
Other values (391) 391
97.5%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
401 1
0.2%
400 1
0.2%
399 1
0.2%
398 1
0.2%
397 1
0.2%
396 1
0.2%
395 1
0.2%
394 1
0.2%
393 1
0.2%
392 1
0.2%

대구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
12대
401 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row12대
2nd row12대
3rd row12대
4th row12대
5th row12대

Common Values

ValueCountFrequency (%)
12대 401
100.0%

Length

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

Common Values (Plot)

2023-12-12T16:13:38.697944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
12대 401
100.0%

방송일
Date

Distinct183
Distinct (%)45.6%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2022-07-01 00:00:00
Maximum2023-07-21 00:00:00
2023-12-12T16:13:38.797737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:13:38.937186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

회의종류
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
임시회
198 
기타회의
52 
2차 정례회
52 
1차 정례회
48 
모의의회
27 
Other values (2)
24 

Length

Max length9
Median length7
Mean length4.1895262
Min length3

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row임시회
2nd row임시회
3rd row임시회
4th row임시회
5th row임시회

Common Values

ValueCountFrequency (%)
임시회 198
49.4%
기타회의 52
 
13.0%
2차 정례회 52
 
13.0%
1차 정례회 48
 
12.0%
모의의회 27
 
6.7%
임시회 폐회중 23
 
5.7%
1차정례회 폐회중 1
 
0.2%

Length

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

Common Values (Plot)

2023-12-12T16:13:39.186333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
임시회 221
42.1%
정례회 100
19.0%
기타회의 52
 
9.9%
2차 52
 
9.9%
1차 48
 
9.1%
모의의회 27
 
5.1%
폐회중 24
 
4.6%
1차정례회 1
 
0.2%

차수
Categorical

Distinct9
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
해당없음
120 
1차
111 
2차
75 
3차
41 
4차
26 
Other values (4)
28 

Length

Max length4
Median length2
Mean length2.5985037
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1차
2nd row해당없음
3rd row2차
4th row1차
5th row1차

Common Values

ValueCountFrequency (%)
해당없음 120
29.9%
1차 111
27.7%
2차 75
18.7%
3차 41
 
10.2%
4차 26
 
6.5%
5차 14
 
3.5%
6차 6
 
1.5%
7차 5
 
1.2%
8차 3
 
0.7%

Length

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

Common Values (Plot)

2023-12-12T16:13:39.472554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 120
29.9%
1차 111
27.7%
2차 75
18.7%
3차 41
 
10.2%
4차 26
 
6.5%
5차 14
 
3.5%
6차 6
 
1.5%
7차 5
 
1.2%
8차 3
 
0.7%

제목
Text

Distinct97
Distinct (%)24.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-12T16:13:39.710743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length40
Mean length11.36409
Min length3

Characters and Unicode

Total characters4557
Distinct characters272
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique83 ?
Unique (%)20.7%

Sample

1st row본회의
2nd row제12대 제주특별자치도의회 개원식
3rd row본회의
4th row농수축경제위원회
5th row교육위원회
ValueCountFrequency (%)
본회의 44
 
5.6%
농수축경제위원회 41
 
5.2%
행정자치위원회 39
 
5.0%
환경도시위원회 37
 
4.7%
문화관광체육위원회 33
 
4.2%
교육위원회 31
 
3.9%
보건복지안전위원회 31
 
3.9%
예산결산특별위원회 29
 
3.7%
위한 26
 
3.3%
모의의회 19
 
2.4%
Other values (285) 456
58.0%
2023-12-12T16:13:40.161142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
회 438
 
9.6%
385
 
8.4%
위 306
 
6.7%
원 291
 
6.4%
의 147
 
3.2%
제 109
 
2.4%
경 96
 
2.1%
정 93
 
2.0%
교 72
 
1.6%
육 68
 
1.5%
Other values (262) 2552
56.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3956
86.8%
Space Separator 385
 
8.4%
Decimal Number 143
 
3.1%
Other Punctuation 31
 
0.7%
Close Punctuation 18
 
0.4%
Open Punctuation 18
 
0.4%
Control 5
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
회 438
 
11.1%
위 306
 
7.7%
원 291
 
7.4%
의 147
 
3.7%
제 109
 
2.8%
경 96
 
2.4%
정 93
 
2.4%
교 72
 
1.8%
육 68
 
1.7%
도 68
 
1.7%
Other values (244) 2268
57.3%
Decimal Number
ValueCountFrequency (%)
2 58
40.6%
3 26
18.2%
0 23
 
16.1%
4 13
 
9.1%
1 11
 
7.7%
8 4
 
2.8%
7 3
 
2.1%
6 2
 
1.4%
5 2
 
1.4%
9 1
 
0.7%
Other Punctuation
ValueCountFrequency (%)
. 25
80.6%
· 5
 
16.1%
& 1
 
3.2%
Space Separator
ValueCountFrequency (%)
385
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Control
ValueCountFrequency (%)
5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3952
86.7%
Common 601
 
13.2%
Han 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
회 438
 
11.1%
위 306
 
7.7%
원 291
 
7.4%
의 147
 
3.7%
제 109
 
2.8%
경 96
 
2.4%
정 93
 
2.4%
교 72
 
1.8%
육 68
 
1.7%
도 68
 
1.7%
Other values (240) 2264
57.3%
Common
ValueCountFrequency (%)
385
64.1%
2 58
 
9.7%
3 26
 
4.3%
. 25
 
4.2%
0 23
 
3.8%
) 18
 
3.0%
( 18
 
3.0%
4 13
 
2.2%
1 11
 
1.8%
· 5
 
0.8%
Other values (8) 19
 
3.2%
Han
ValueCountFrequency (%)
思 1
25.0%
情 1
25.0%
談 1
25.0%
會 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3952
86.7%
ASCII 596
 
13.1%
None 5
 
0.1%
CJK 4
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
회 438
 
11.1%
위 306
 
7.7%
원 291
 
7.4%
의 147
 
3.7%
제 109
 
2.8%
경 96
 
2.4%
정 93
 
2.4%
교 72
 
1.8%
육 68
 
1.7%
도 68
 
1.7%
Other values (240) 2264
57.3%
ASCII
ValueCountFrequency (%)
385
64.6%
2 58
 
9.7%
3 26
 
4.4%
. 25
 
4.2%
0 23
 
3.9%
) 18
 
3.0%
( 18
 
3.0%
4 13
 
2.2%
1 11
 
1.8%
5
 
0.8%
Other values (7) 14
 
2.3%
None
ValueCountFrequency (%)
· 5
100.0%
CJK
ValueCountFrequency (%)
思 1
25.0%
情 1
25.0%
談 1
25.0%
會 1
25.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2023-07-24 00:00:00
Maximum2023-07-24 00:00:00
2023-12-12T16:13:40.552405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:13:40.659946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T16:13:37.933443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:13:40.746686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호회의종류차수제목
관리번호1.0000.7430.4580.398
회의종류0.7431.0000.5820.801
차수0.4580.5821.0000.000
제목0.3980.8010.0001.000
2023-12-12T16:13:40.856329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차수회의종류
차수1.0000.355
회의종류0.3551.000
2023-12-12T16:13:40.950493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호회의종류차수
관리번호1.0000.5010.231
회의종류0.5011.0000.355
차수0.2310.3551.000

Missing values

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

관리번호대구분방송일회의종류차수제목데이터기준일자
0112대2022-07-01임시회1차본회의2023-07-24
1212대2022-07-04임시회해당없음제12대 제주특별자치도의회 개원식2023-07-24
2312대2022-07-04임시회2차본회의2023-07-24
3412대2022-07-05임시회1차농수축경제위원회2023-07-24
4512대2022-07-05임시회1차교육위원회2023-07-24
5612대2022-07-05임시회1차행정자치위원회2023-07-24
6712대2022-07-05임시회1차보건복지안전위원회2023-07-24
7812대2022-07-05임시회1차환경도시위원회2023-07-24
8912대2022-07-05임시회1차문화관광체육위원회2023-07-24
91012대2022-07-05임시회1차의회운영위원회2023-07-24
관리번호대구분방송일회의종류차수제목데이터기준일자
39139212대2023-07-14임시회1차교육위원회2023-07-24
39239312대2023-07-17임시회1차보건복지안전위원회2023-07-24
39339412대2023-07-17임시회1차환경도시위원회2023-07-24
39439512대2023-07-17임시회2차농수축경제위원회2023-07-24
39539612대2023-07-17임시회2차교육위원회2023-07-24
39639712대2023-07-18임시회1차행정자치위원회2023-07-24
39739812대2023-07-18기타회의해당없음제주 사람중심 교통체계 조성방안을 위한 토론회2023-07-24
39839912대2023-07-19임시회1차의회운영위원회2023-07-24
39940012대2023-07-19임시회2차본회의2023-07-24
40040112대2023-07-21모의의회해당없음2023년 청소년의회 의정체험 모의의회(표선고등학교)2023-07-24