Overview

Dataset statistics

Number of variables10
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory86.4 B

Variable types

Categorical5
Numeric1
DateTime4

Dataset

Description논산시 정보화교육에 대한 교육관리DB입니다.
Author충청남도 논산시
URLhttps://www.data.go.kr/data/15039973/fileData.do

Alerts

연도 has constant value ""Constant
기수 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 overall correlated with 교육정원High correlation
교육정원 is highly overall correlated with 기수 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 08:31:02.386895
Analysis finished2023-12-12 08:31:03.204448
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
2019
39 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2019 39
100.0%

Length

2023-12-12T17:31:03.282540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:03.411107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 39
100.0%

기수
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)53.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.2307692
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-12T17:31:03.562374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median7
Q311.5
95-th percentile19.1
Maximum21
Range20
Interquartile range (IQR)7.5

Descriptive statistics

Standard deviation5.7099246
Coefficient of variation (CV)0.69372916
Kurtosis-0.40434418
Mean8.2307692
Median Absolute Deviation (MAD)4
Skewness0.75585121
Sum321
Variance32.603239
MonotonicityNot monotonic
2023-12-12T17:31:03.751037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1 3
 
7.7%
3 3
 
7.7%
4 3
 
7.7%
5 3
 
7.7%
6 3
 
7.7%
7 3
 
7.7%
8 3
 
7.7%
9 3
 
7.7%
2 3
 
7.7%
16 1
 
2.6%
Other values (11) 11
28.2%
ValueCountFrequency (%)
1 3
7.7%
2 3
7.7%
3 3
7.7%
4 3
7.7%
5 3
7.7%
6 3
7.7%
7 3
7.7%
8 3
7.7%
9 3
7.7%
10 1
 
2.6%
ValueCountFrequency (%)
21 1
2.6%
20 1
2.6%
19 1
2.6%
18 1
2.6%
17 1
2.6%
16 1
2.6%
15 1
2.6%
14 1
2.6%
13 1
2.6%
12 1
2.6%

교육과정
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)30.8%
Missing0
Missing (%)0.0%
Memory size444.0 B
컴퓨터 및 인터넷 기초
7 
한글 2010
5 
파워포인트 2010
4 
인터넷 활용
4 
엑셀 2010
4 
Other values (7)
15 

Length

Max length12
Median length11
Mean length8.5897436
Min length6

Unique

Unique1 ?
Unique (%)2.6%

Sample

1st row컴퓨터 및 인터넷 기초
2nd row컴퓨터 및 인터넷 기초
3rd row파워포인트 2010
4th row컴퓨터 및 인터넷 기초
5th row인터넷 활용

Common Values

ValueCountFrequency (%)
컴퓨터 및 인터넷 기초 7
17.9%
한글 2010 5
12.8%
파워포인트 2010 4
10.3%
인터넷 활용 4
10.3%
엑셀 2010 4
10.3%
스마트폰 활용 4
10.3%
한글 입문반 2
 
5.1%
IT 경진 대비반 2
 
5.1%
나만의 블로그 제작 2
 
5.1%
워드프로세서 자격증반 2
 
5.1%
Other values (2) 3
7.7%

Length

2023-12-12T17:31:03.959935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2010 13
13.5%
인터넷 11
11.5%
한글 9
9.4%
활용 8
 
8.3%
컴퓨터 7
 
7.3%
기초 7
 
7.3%
및 7
 
7.3%
엑셀 5
 
5.2%
파워포인트 4
 
4.2%
스마트폰 4
 
4.2%
Other values (11) 21
21.9%

교육시간
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size444.0 B
10:00~12:00
27 
13:00~15:00
9 
15:00~17:00
 
2
19:00~21:00
 
1

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique1 ?
Unique (%)2.6%

Sample

1st row10:00~12:00
2nd row10:00~12:00
3rd row13:00~15:00
4th row10:00~12:00
5th row10:00~12:00

Common Values

ValueCountFrequency (%)
10:00~12:00 27
69.2%
13:00~15:00 9
 
23.1%
15:00~17:00 2
 
5.1%
19:00~21:00 1
 
2.6%

Length

2023-12-12T17:31:04.117437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:04.268246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10:00~12:00 27
69.2%
13:00~15:00 9
 
23.1%
15:00~17:00 2
 
5.1%
19:00~21:00 1
 
2.6%

교육장소
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size444.0 B
농업인회관 정보화상설교육장
21 
연무도서관 정보화교육장
9 
강경도서관 정보화교육장
9 

Length

Max length14
Median length14
Mean length13.076923
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row연무도서관 정보화교육장
2nd row농업인회관 정보화상설교육장
3rd row농업인회관 정보화상설교육장
4th row강경도서관 정보화교육장
5th row강경도서관 정보화교육장

Common Values

ValueCountFrequency (%)
농업인회관 정보화상설교육장 21
53.8%
연무도서관 정보화교육장 9
23.1%
강경도서관 정보화교육장 9
23.1%

Length

2023-12-12T17:31:04.431355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:04.570618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농업인회관 21
26.9%
정보화상설교육장 21
26.9%
정보화교육장 18
23.1%
연무도서관 9
11.5%
강경도서관 9
11.5%

교육정원
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size444.0 B
30
20 
40
19 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row30
2nd row40
3rd row40
4th row30
5th row30

Common Values

ValueCountFrequency (%)
30 20
51.3%
40 19
48.7%

Length

2023-12-12T17:31:04.957906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:05.084880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
30 20
51.3%
40 19
48.7%

접수시작일자
Date

Distinct9
Distinct (%)23.1%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2019-01-23 00:00:00
Maximum2019-09-25 00:00:00
2023-12-12T17:31:05.208660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:05.331255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

접수종료일자
Date

Distinct9
Distinct (%)23.1%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2019-01-30 00:00:00
Maximum2019-10-02 00:00:00
2023-12-12T17:31:05.438545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:05.604070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

교육시작일자
Date

Distinct18
Distinct (%)46.2%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2019-02-11 00:00:00
Maximum2019-10-08 00:00:00
2023-12-12T17:31:05.758522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:05.893095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

교육종료일자
Date

Distinct10
Distinct (%)25.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2019-02-28 00:00:00
Maximum2019-10-25 00:00:00
2023-12-12T17:31:06.026922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:06.151611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)

Interactions

2023-12-12T17:31:02.750490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:31:06.252243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기수교육과정교육시간교육장소교육정원접수시작일자접수종료일자교육시작일자교육종료일자
기수1.0000.6230.0000.0000.6890.7030.7030.8650.819
교육과정0.6231.0000.9600.0000.0000.7020.7020.6900.641
교육시간0.0000.9601.0000.3610.7330.0000.0000.0000.000
교육장소0.0000.0000.3611.0000.6310.0000.0000.5680.000
교육정원0.6890.0000.7330.6311.0000.0000.0000.7390.000
접수시작일자0.7030.7020.0000.0000.0001.0001.0001.0001.000
접수종료일자0.7030.7020.0000.0000.0001.0001.0001.0001.000
교육시작일자0.8650.6900.0000.5680.7391.0001.0001.0000.987
교육종료일자0.8190.6410.0000.0000.0001.0001.0000.9871.000
2023-12-12T17:31:06.383373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교육정원교육시간교육과정교육장소
교육정원1.0000.5110.0000.884
교육시간0.5111.0000.6510.343
교육과정0.0000.6511.0000.000
교육장소0.8840.3430.0001.000
2023-12-12T17:31:06.495299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기수교육과정교육시간교육장소교육정원
기수1.0000.2410.0000.0000.507
교육과정0.2411.0000.6510.0000.000
교육시간0.0000.6511.0000.3430.511
교육장소0.0000.0000.3431.0000.884
교육정원0.5070.0000.5110.8841.000

Missing values

2023-12-12T17:31:02.924238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:31:03.136142image/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

연도기수교육과정교육시간교육장소교육정원접수시작일자접수종료일자교육시작일자교육종료일자
020191컴퓨터 및 인터넷 기초10:00~12:00연무도서관 정보화교육장302019-01-232019-01-302019-02-112019-02-28
120191컴퓨터 및 인터넷 기초10:00~12:00농업인회관 정보화상설교육장402019-01-232019-01-302019-02-112019-02-28
220192파워포인트 201013:00~15:00농업인회관 정보화상설교육장402019-01-232019-01-302019-02-112019-02-28
320191컴퓨터 및 인터넷 기초10:00~12:00강경도서관 정보화교육장302019-01-232019-01-302019-02-122019-02-28
420192인터넷 활용10:00~12:00강경도서관 정보화교육장302019-02-202019-02-272019-03-042019-03-29
520193한글 입문반10:00~12:00농업인회관 정보화상설교육장402019-02-202019-02-272019-03-042019-03-29
620194엑셀 201013:00~15:00농업인회관 정보화상설교육장402019-02-202019-02-272019-03-042019-03-29
720195스마트폰 활용15:00~17:00농업인회관 정보화상설교육장302019-02-202019-02-272019-03-042019-03-29
820192스마트폰 활용10:00~12:00연무도서관 정보화교육장302019-02-202019-02-272019-03-052019-03-29
920196인터넷 활용10:00~12:00농업인회관 정보화상설교육장402019-03-202019-03-272019-04-012019-04-26
연도기수교육과정교육시간교육장소교육정원접수시작일자접수종료일자교육시작일자교육종료일자
2920197인터넷 활용10:00~12:00강경도서관 정보화교육장302019-07-242019-07-312019-08-062019-08-30
3020197파워포인트 201010:00~12:00연무도서관 정보화교육장302019-07-242019-07-312019-08-072019-08-30
31201918한글 입문반10:00~12:00농업인회관 정보화상설교육장402019-08-212019-08-282019-09-022019-09-27
32201919ITQ 한글13:00~15:00농업인회관 정보화상설교육장402019-08-212019-08-282019-09-022019-09-27
3320198파워포인트 201010:00~12:00강경도서관 정보화교육장302019-08-212019-08-282019-09-032019-09-27
3420198나만의 블로그 제작10:00~12:00연무도서관 정보화교육장302019-08-212019-08-282019-09-032019-09-27
35201920한글 201010:00~12:00농업인회관 정보화상설교육장402019-09-252019-10-022019-10-072019-10-25
36201921ITQ 한글13:00~15:00농업인회관 정보화상설교육장402019-09-252019-10-022019-10-072019-10-25
3720199한글 201010:00~12:00연무도서관 정보화교육장302019-09-252019-10-022019-10-082019-10-18
3820199엑셀 201010:00~12:00강경도서관 정보화교육장302019-09-252019-10-022019-10-082019-10-25