Overview

Dataset statistics

Number of variables6
Number of observations182
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.8 KiB
Average record size in memory49.7 B

Variable types

Numeric1
Categorical4
Text1

Dataset

Description경상남도 창원시의 2023년 상반기 시민 정보화 교육의 교육 일정입니다. 항목은 구, 교육시설, 교육명, 기수, 접수일자, 교육일자 입니다.
Author경상남도 창원시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15117234

Alerts

기수 is highly overall correlated with 접수기간 and 1 other fieldsHigh correlation
교육기간 is highly overall correlated with 기수 and 1 other fieldsHigh correlation
접수기간 is highly overall correlated with 기수 and 1 other fieldsHigh correlation
번호 is highly overall correlated with 교육시설High correlation
교육시설 is highly overall correlated with 번호High correlation
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 22:58:18.808595
Analysis finished2023-12-10 22:58:19.348090
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct182
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean95.373626
Minimum1
Maximum190
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-11T07:58:19.450854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.05
Q148.25
median95.5
Q3142.75
95-th percentile180.95
Maximum190
Range189
Interquartile range (IQR)94.5

Descriptive statistics

Standard deviation55.199217
Coefficient of variation (CV)0.57876815
Kurtosis-1.1975106
Mean95.373626
Median Absolute Deviation (MAD)47.5
Skewness0.0017753313
Sum17358
Variance3046.9536
MonotonicityStrictly increasing
2023-12-11T07:58:19.625111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
121 1
 
0.5%
123 1
 
0.5%
124 1
 
0.5%
125 1
 
0.5%
126 1
 
0.5%
127 1
 
0.5%
128 1
 
0.5%
129 1
 
0.5%
130 1
 
0.5%
Other values (172) 172
94.5%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
190 1
0.5%
189 1
0.5%
188 1
0.5%
187 1
0.5%
186 1
0.5%
185 1
0.5%
184 1
0.5%
183 1
0.5%
182 1
0.5%
181 1
0.5%

교육시설
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
마산합포구/마산합포구청
32 
성산구/가음정교육장 1강의실
22 
의창구/의창교육장
21 
성산구/가음정교육장 2강의실
18 
마산회원구/내서교육장
18 
Other values (4)
71 

Length

Max length15
Median length12
Mean length11.637363
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성산구/가음정교육장 1강의실
2nd row성산구/가음정교육장 1강의실
3rd row성산구/가음정교육장 1강의실
4th row성산구/가음정교육장 1강의실
5th row성산구/가음정교육장 1강의실

Common Values

ValueCountFrequency (%)
마산합포구/마산합포구청 32
17.6%
성산구/가음정교육장 1강의실 22
12.1%
의창구/의창교육장 21
11.5%
성산구/가음정교육장 2강의실 18
9.9%
마산회원구/내서교육장 18
9.9%
마산회원구/구암교육장 18
9.9%
진해구/향군회관교육장 18
9.9%
진해구/웅동2동교육장 18
9.9%
의창구/사림교육장 17
9.3%

Length

2023-12-11T07:58:20.084013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:58:20.226419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성산구/가음정교육장 40
18.0%
마산합포구/마산합포구청 32
14.4%
1강의실 22
9.9%
의창구/의창교육장 21
9.5%
2강의실 18
8.1%
마산회원구/내서교육장 18
8.1%
마산회원구/구암교육장 18
8.1%
진해구/향군회관교육장 18
8.1%
진해구/웅동2동교육장 18
8.1%
의창구/사림교육장 17
7.7%

교육명
Text

Distinct111
Distinct (%)61.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-11T07:58:20.517193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length17
Mean length10.340659
Min length7

Characters and Unicode

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

Unique

Unique60 ?
Unique (%)33.0%

Sample

1st row컴퓨터기초(1기)
2nd row스마트폰기초&키오스크(1기)
3rd row인터넷기초&키오스크(2기)
4th row포토샵(2기)
5th row한글기초(3기)
ValueCountFrequency (%)
인터넷기초&키오스크(2기 6
 
3.3%
컴퓨터기초(1기 5
 
2.7%
한글기초(4기 4
 
2.2%
한글중급(5기 4
 
2.2%
스마트폰기초&키오스크(3기 4
 
2.2%
한글중급(8기 4
 
2.2%
인터넷기초&키오스크(8기 3
 
1.6%
엑셀기초(7기 3
 
1.6%
스마트폰기초&키오스크(1기 3
 
1.6%
인터넷기초&키오스크(4기 3
 
1.6%
Other values (103) 145
78.8%
2023-12-11T07:58:20.950964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 286
 
15.2%
) 187
 
9.9%
( 187
 
9.9%
초 89
 
4.7%
스 75
 
4.0%
크 47
 
2.5%
& 47
 
2.5%
키 47
 
2.5%
오 47
 
2.5%
트 45
 
2.4%
Other values (61) 825
43.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1278
67.9%
Close Punctuation 187
 
9.9%
Open Punctuation 187
 
9.9%
Decimal Number 181
 
9.6%
Other Punctuation 47
 
2.5%
Space Separator 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 286
22.4%
초 89
 
7.0%
스 75
 
5.9%
크 47
 
3.7%
키 47
 
3.7%
오 47
 
3.7%
트 45
 
3.5%
터 39
 
3.1%
급 39
 
3.1%
인 38
 
3.0%
Other values (48) 526
41.2%
Decimal Number
ValueCountFrequency (%)
8 22
12.2%
9 22
12.2%
7 21
11.6%
6 20
11.0%
5 20
11.0%
4 19
10.5%
3 19
10.5%
1 19
10.5%
2 19
10.5%
Close Punctuation
ValueCountFrequency (%)
) 187
100.0%
Open Punctuation
ValueCountFrequency (%)
( 187
100.0%
Other Punctuation
ValueCountFrequency (%)
& 47
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1278
67.9%
Common 604
32.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 286
22.4%
초 89
 
7.0%
스 75
 
5.9%
크 47
 
3.7%
키 47
 
3.7%
오 47
 
3.7%
트 45
 
3.5%
터 39
 
3.1%
급 39
 
3.1%
인 38
 
3.0%
Other values (48) 526
41.2%
Common
ValueCountFrequency (%)
) 187
31.0%
( 187
31.0%
& 47
 
7.8%
8 22
 
3.6%
9 22
 
3.6%
7 21
 
3.5%
6 20
 
3.3%
5 20
 
3.3%
4 19
 
3.1%
3 19
 
3.1%
Other values (3) 40
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1278
67.9%
ASCII 604
32.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 286
22.4%
초 89
 
7.0%
스 75
 
5.9%
크 47
 
3.7%
키 47
 
3.7%
오 47
 
3.7%
트 45
 
3.5%
터 39
 
3.1%
급 39
 
3.1%
인 38
 
3.0%
Other values (48) 526
41.2%
ASCII
ValueCountFrequency (%)
) 187
31.0%
( 187
31.0%
& 47
 
7.8%
8 22
 
3.6%
9 22
 
3.6%
7 21
 
3.5%
6 20
 
3.3%
5 20
 
3.3%
4 19
 
3.1%
3 19
 
3.1%
Other values (3) 40
 
6.6%

기수
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023년 8기
22 
2023년 9기
22 
2023년 7기
21 
2023년 5기
20 
2023년 6기
20 
Other values (5)
77 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row2023년 1기
2nd row2023년 1기
3rd row2023년 2기
4th row2023년 2기
5th row2023년 3기

Common Values

ValueCountFrequency (%)
2023년 8기 22
12.1%
2023년 9기 22
12.1%
2023년 7기 21
11.5%
2023년 5기 20
11.0%
2023년 6기 20
11.0%
2023년 1기 19
10.4%
2023년 2기 19
10.4%
2023년 3기 19
10.4%
2023년 4기 19
10.4%
2023년 0기 1
 
0.5%

Length

2023-12-11T07:58:21.095820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:58:21.215006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023년 182
50.0%
8기 22
 
6.0%
9기 22
 
6.0%
7기 21
 
5.8%
5기 20
 
5.5%
6기 20
 
5.5%
1기 19
 
5.2%
2기 19
 
5.2%
3기 19
 
5.2%
4기 19
 
5.2%

접수기간
Categorical

HIGH CORRELATION 

Distinct28
Distinct (%)15.4%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-01-16 ~2023-02-12
16 
2023-02-20 ~2023-03-19
16 
2023-05-15 ~2023-06-04
16 
2023-02-20 ~2023-03-05
16 
2023-05-15 ~2023-06-18
14 
Other values (23)
104 

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique4 ?
Unique (%)2.2%

Sample

1st row2023-01-16 ~2023-02-12
2nd row2023-01-16 ~2023-02-12
3rd row2023-02-20 ~2023-03-05
4th row2023-02-20 ~2023-03-05
5th row2023-02-20 ~2023-03-19

Common Values

ValueCountFrequency (%)
2023-01-16 ~2023-02-12 16
 
8.8%
2023-02-20 ~2023-03-19 16
 
8.8%
2023-05-15 ~2023-06-04 16
 
8.8%
2023-02-20 ~2023-03-05 16
 
8.8%
2023-05-15 ~2023-06-18 14
 
7.7%
2023-04-17 ~2023-04-30 12
 
6.6%
2023-03-20 ~2023-04-16 11
 
6.0%
2023-04-17 ~2023-05-14 10
 
5.5%
2023-03-20 ~2023-03-31 9
 
4.9%
2023-04-17 ~2023-05-12 8
 
4.4%
Other values (18) 54
29.7%

Length

2023-12-11T07:58:21.389055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2023-05-15 45
12.4%
2023-04-17 42
11.5%
2023-03-20 39
 
10.7%
2023-02-20 38
 
10.4%
2023-01-16 19
 
5.2%
2023-03-19 16
 
4.4%
2023-06-04 16
 
4.4%
2023-03-05 16
 
4.4%
2023-02-12 16
 
4.4%
2023-06-18 14
 
3.8%
Other values (20) 103
28.3%

교육기간
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-06-05~2023-06-16
22 
2023-06-19~2023-06-30
22 
2023-05-15~2023-05-26
21 
2023-04-17~2023-04-28
20 
2023-05-01~2023-05-12
20 
Other values (5)
77 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row2023-02-13~2023-02-24
2nd row2023-02-13~2023-02-24
3rd row2023-03-06~2023-03-17
4th row2023-03-06~2023-03-17
5th row2023-03-20~2023-03-31

Common Values

ValueCountFrequency (%)
2023-06-05~2023-06-16 22
12.1%
2023-06-19~2023-06-30 22
12.1%
2023-05-15~2023-05-26 21
11.5%
2023-04-17~2023-04-28 20
11.0%
2023-05-01~2023-05-12 20
11.0%
2023-02-13~2023-02-24 19
10.4%
2023-03-06~2023-03-17 19
10.4%
2023-03-20~2023-03-31 19
10.4%
2023-04-03~2023-04-14 19
10.4%
2023-06-16~2023-06-16 1
 
0.5%

Length

2023-12-11T07:58:21.511891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:58:21.638799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-05~2023-06-16 22
12.1%
2023-06-19~2023-06-30 22
12.1%
2023-05-15~2023-05-26 21
11.5%
2023-04-17~2023-04-28 20
11.0%
2023-05-01~2023-05-12 20
11.0%
2023-02-13~2023-02-24 19
10.4%
2023-03-06~2023-03-17 19
10.4%
2023-03-20~2023-03-31 19
10.4%
2023-04-03~2023-04-14 19
10.4%
2023-06-16~2023-06-16 1
 
0.5%

Interactions

2023-12-11T07:58:19.077676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T07:58:21.747749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호교육시설기수접수기간교육기간
번호1.0000.9740.0000.6100.000
교육시설0.9741.0000.0000.5410.000
기수0.0000.0001.0001.0001.000
접수기간0.6100.5411.0001.0001.000
교육기간0.0000.0001.0001.0001.000
2023-12-11T07:58:21.854102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기수교육기간접수기간교육시설
기수1.0001.0000.9460.000
교육기간1.0001.0000.9460.000
접수기간0.9460.9461.0000.219
교육시설0.0000.0000.2191.000
2023-12-11T07:58:21.949570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호교육시설기수접수기간교육기간
번호1.0000.9020.0000.2520.000
교육시설0.9021.0000.0000.2190.000
기수0.0000.0001.0000.9461.000
접수기간0.2520.2190.9461.0000.946
교육기간0.0000.0001.0000.9461.000

Missing values

2023-12-11T07:58:19.193511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:58:19.306890image/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성산구/가음정교육장 1강의실컴퓨터기초(1기)2023년 1기2023-01-16 ~2023-02-122023-02-13~2023-02-24
12성산구/가음정교육장 1강의실스마트폰기초&키오스크(1기)2023년 1기2023-01-16 ~2023-02-122023-02-13~2023-02-24
23성산구/가음정교육장 1강의실인터넷기초&키오스크(2기)2023년 2기2023-02-20 ~2023-03-052023-03-06~2023-03-17
34성산구/가음정교육장 1강의실포토샵(2기)2023년 2기2023-02-20 ~2023-03-052023-03-06~2023-03-17
45성산구/가음정교육장 1강의실한글기초(3기)2023년 3기2023-02-20 ~2023-03-192023-03-20~2023-03-31
56성산구/가음정교육장 1강의실사진편집(3기)2023년 3기2023-02-20 ~2023-03-192023-03-20~2023-03-31
67성산구/가음정교육장 1강의실한글중급(4기)2023년 4기2023-03-20 ~2023-04-022023-04-03~2023-04-14
78성산구/가음정교육장 1강의실동영상제작(4기)2023년 4기2023-03-20 ~2023-04-022023-04-03~2023-04-14
89성산구/가음정교육장 1강의실스마트폰기초&키오스크(5기)2023년 5기2023-03-20 ~2023-04-162023-04-17~2023-04-28
910성산구/가음정교육장 1강의실블로그만들기(5기)2023년 5기2023-03-20 ~2023-04-172023-04-17~2023-04-28
번호교육시설교육명기수접수기간교육기간
172181진해구/웅동2동교육장한글중급(5기)2023년 5기2023-03-20 ~2023-04-142023-04-17~2023-04-28
173182진해구/웅동2동교육장동영상제작(스마트폰활용)(5기)2023년 5기2023-03-20 ~2023-04-162023-04-17~2023-04-28
174183진해구/웅동2동교육장파워포인트기초(6기)2023년 6기2023-04-17 ~2023-04-282023-05-01~2023-05-12
175184진해구/웅동2동교육장블로그만들기(6기)2023년 6기2023-04-17 ~2023-04-282023-05-01~2023-05-12
176185진해구/웅동2동교육장파워포인트중급(7기)2023년 7기2023-04-17 ~2023-05-122023-05-15~2023-05-26
177186진해구/웅동2동교육장컴퓨터기초(7기)2023년 7기2023-04-17 ~2023-05-122023-05-15~2023-05-26
178187진해구/웅동2동교육장사진편집(8기)2023년 8기2023-05-15 ~2023-06-022023-06-05~2023-06-16
179188진해구/웅동2동교육장인터넷기초&키오스크(8기)2023년 8기2023-05-15 ~2023-06-022023-06-05~2023-06-16
180189진해구/웅동2동교육장동영상제작(9기)2023년 9기2023-05-15 ~2023-06-162023-06-19~2023-06-30
181190진해구/웅동2동교육장스마트폰기초&키오스크(9기)2023년 9기2023-05-15 ~2023-06-162023-06-19~2023-06-30