Overview

Dataset statistics

Number of variables6
Number of observations28
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory54.7 B

Variable types

Categorical3
Text1
Numeric2

Dataset

Description충청남도개발공사의 청렴교육 이수 현황에 대한 정보 제공 교육일자, 교육명, 교육 장소, 이수인원 등의 항목으로 구성
URLhttps://www.data.go.kr/data/15118438/fileData.do

Alerts

시간 is highly overall correlated with 이수인원High correlation
이수인원 is highly overall correlated with 시간High correlation
일자 is highly overall correlated with 장소High correlation
대상 is highly overall correlated with 장소High correlation
장소 is highly overall correlated with 일자 and 1 other fieldsHigh correlation
교육명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:30:21.637749
Analysis finished2023-12-12 12:30:22.574346
Duration0.94 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일자
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2022-01-01~2022-12-31
16 
2022-06-01
5 
2022-03-01
3 
2022-01-01
 
1
2022-02-01
 
1
Other values (2)
2 

Length

Max length21
Median length21
Mean length16.285714
Min length10

Unique

Unique4 ?
Unique (%)14.3%

Sample

1st row2022-01-01~2022-12-31
2nd row2022-01-01
3rd row2022-01-01~2022-12-31
4th row2022-01-01~2022-12-31
5th row2022-01-01~2022-12-31

Common Values

ValueCountFrequency (%)
2022-01-01~2022-12-31 16
57.1%
2022-06-01 5
 
17.9%
2022-03-01 3
 
10.7%
2022-01-01 1
 
3.6%
2022-02-01 1
 
3.6%
2022-09-01 1
 
3.6%
2022-11-01 1
 
3.6%

Length

2023-12-12T21:30:22.655603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:30:22.839507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-01-01~2022-12-31 16
57.1%
2022-06-01 5
 
17.9%
2022-03-01 3
 
10.7%
2022-01-01 1
 
3.6%
2022-02-01 1
 
3.6%
2022-09-01 1
 
3.6%
2022-11-01 1
 
3.6%

교육명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-12T21:30:23.116709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length22.5
Mean length17.928571
Min length9

Characters and Unicode

Total characters502
Distinct characters150
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

Unique28 ?
Unique (%)100.0%

Sample

1st row행복한동행 공공기관 청렴 반부패 캠페인
2nd row이해충돌방지법 바로알기 교육
3rd row공직유관단체 직원 대상 이해출돌방지법 길잡이
4th row제1기 권익구제와 옴부즈만
5th row제1기 세상을 바꾸는 힘 공익신고
ValueCountFrequency (%)
청렴 6
 
4.9%
교육 6
 
4.9%
반부패 4
 
3.3%
이해충돌방지법 4
 
3.3%
및 4
 
3.3%
캠페인 3
 
2.5%
공공기관 3
 
2.5%
쉬운 2
 
1.6%
제1기 2
 
1.6%
갑질 2
 
1.6%
Other values (80) 86
70.5%
2023-12-12T21:30:23.610919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
94
 
18.7%
기 17
 
3.4%
청 17
 
3.4%
렴 14
 
2.8%
공 13
 
2.6%
지 11
 
2.2%
이 10
 
2.0%
방 9
 
1.8%
직 9
 
1.8%
육 9
 
1.8%
Other values (140) 299
59.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 397
79.1%
Space Separator 94
 
18.7%
Decimal Number 4
 
0.8%
Close Punctuation 3
 
0.6%
Open Punctuation 3
 
0.6%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 17
 
4.3%
청 17
 
4.3%
렴 14
 
3.5%
공 13
 
3.3%
지 11
 
2.8%
이 10
 
2.5%
방 9
 
2.3%
직 9
 
2.3%
육 9
 
2.3%
교 9
 
2.3%
Other values (131) 279
70.3%
Decimal Number
ValueCountFrequency (%)
1 2
50.0%
8 1
25.0%
6 1
25.0%
Close Punctuation
ValueCountFrequency (%)
] 2
66.7%
) 1
33.3%
Open Punctuation
ValueCountFrequency (%)
[ 2
66.7%
( 1
33.3%
Space Separator
ValueCountFrequency (%)
94
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 397
79.1%
Common 105
 
20.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 17
 
4.3%
청 17
 
4.3%
렴 14
 
3.5%
공 13
 
3.3%
지 11
 
2.8%
이 10
 
2.5%
방 9
 
2.3%
직 9
 
2.3%
육 9
 
2.3%
교 9
 
2.3%
Other values (131) 279
70.3%
Common
ValueCountFrequency (%)
94
89.5%
] 2
 
1.9%
1 2
 
1.9%
[ 2
 
1.9%
8 1
 
1.0%
6 1
 
1.0%
, 1
 
1.0%
) 1
 
1.0%
( 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 397
79.1%
ASCII 105
 
20.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
94
89.5%
] 2
 
1.9%
1 2
 
1.9%
[ 2
 
1.9%
8 1
 
1.0%
6 1
 
1.0%
, 1
 
1.0%
) 1
 
1.0%
( 1
 
1.0%
Hangul
ValueCountFrequency (%)
기 17
 
4.3%
청 17
 
4.3%
렴 14
 
3.5%
공 13
 
3.3%
지 11
 
2.8%
이 10
 
2.5%
방 9
 
2.3%
직 9
 
2.3%
육 9
 
2.3%
교 9
 
2.3%
Other values (131) 279
70.3%

대상
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size356.0 B
전직원
21 
청렴감사부
 
2
신규임용자
 
2
신규임용 및 승진자
 
1
명예감사관
 
1

Length

Max length13
Median length3
Mean length3.9642857
Min length3

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row전직원
2nd row전직원
3rd row전직원
4th row전직원
5th row전직원

Common Values

ValueCountFrequency (%)
전직원 21
75.0%
청렴감사부 2
 
7.1%
신규임용자 2
 
7.1%
신규임용 및 승진자 1
 
3.6%
명예감사관 1
 
3.6%
신규임용자 및 청렴감사부 1
 
3.6%

Length

2023-12-12T21:30:23.801450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:30:23.916957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전직원 21
65.6%
청렴감사부 3
 
9.4%
신규임용자 3
 
9.4%
및 2
 
6.2%
신규임용 1
 
3.1%
승진자 1
 
3.1%
명예감사관 1
 
3.1%

장소
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)35.7%
Missing0
Missing (%)0.0%
Memory size356.0 B
온라인(국민권익위원회)
10 
온라인
4 
온라인(지방공기업평가원)
3 
온라인(청렴연수원)
2 
업무빌딩 10층 대회의실
2 
Other values (5)
7 

Length

Max length13
Median length12
Mean length10.071429
Min length3

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row온라인(지방공기업평가원)
2nd row온라인(청렴연수원)
3rd row온라인(청렴연수원)
4th row온라인
5th row온라인

Common Values

ValueCountFrequency (%)
온라인(국민권익위원회) 10
35.7%
온라인 4
 
14.3%
온라인(지방공기업평가원) 3
 
10.7%
온라인(청렴연수원) 2
 
7.1%
업무빌딩 10층 대회의실 2
 
7.1%
온라인(zoom) 2
 
7.1%
업무빌딩 8층 중회의실 2
 
7.1%
온라인(한국생산성본부) 1
 
3.6%
아산 현충사 1
 
3.6%
청렴연수원 1
 
3.6%

Length

2023-12-12T21:30:24.064012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:30:24.188689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
온라인(국민권익위원회 10
27.0%
온라인 4
 
10.8%
업무빌딩 4
 
10.8%
온라인(지방공기업평가원 3
 
8.1%
온라인(청렴연수원 2
 
5.4%
10층 2
 
5.4%
대회의실 2
 
5.4%
온라인(zoom 2
 
5.4%
8층 2
 
5.4%
중회의실 2
 
5.4%
Other values (4) 4
 
10.8%

시간
Real number (ℝ)

HIGH CORRELATION 

Distinct9
Distinct (%)32.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.2857143
Minimum2
Maximum14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2023-12-12T21:30:24.329935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q12
median3.5
Q38
95-th percentile11.3
Maximum14
Range12
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.6296836
Coefficient of variation (CV)0.6866969
Kurtosis-0.47590258
Mean5.2857143
Median Absolute Deviation (MAD)1.5
Skewness0.77274484
Sum148
Variance13.174603
MonotonicityNot monotonic
2023-12-12T21:30:24.461136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2 11
39.3%
3 3
 
10.7%
10 3
 
10.7%
8 3
 
10.7%
7 3
 
10.7%
6 2
 
7.1%
4 1
 
3.6%
14 1
 
3.6%
12 1
 
3.6%
ValueCountFrequency (%)
2 11
39.3%
3 3
 
10.7%
4 1
 
3.6%
6 2
 
7.1%
7 3
 
10.7%
8 3
 
10.7%
10 3
 
10.7%
12 1
 
3.6%
14 1
 
3.6%
ValueCountFrequency (%)
14 1
 
3.6%
12 1
 
3.6%
10 3
 
10.7%
8 3
 
10.7%
7 3
 
10.7%
6 2
 
7.1%
4 1
 
3.6%
3 3
 
10.7%
2 11
39.3%

이수인원
Real number (ℝ)

HIGH CORRELATION 

Distinct12
Distinct (%)42.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.8571429
Minimum1
Maximum62
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2023-12-12T21:30:24.590649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q311
95-th percentile24.6
Maximum62
Range61
Interquartile range (IQR)10

Descriptive statistics

Standard deviation12.595456
Coefficient of variation (CV)1.603058
Kurtosis12.767208
Mean7.8571429
Median Absolute Deviation (MAD)1
Skewness3.264356
Sum220
Variance158.6455
MonotonicityNot monotonic
2023-12-12T21:30:24.712518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 11
39.3%
2 4
 
14.3%
11 2
 
7.1%
3 2
 
7.1%
14 2
 
7.1%
6 1
 
3.6%
10 1
 
3.6%
22 1
 
3.6%
62 1
 
3.6%
7 1
 
3.6%
Other values (2) 2
 
7.1%
ValueCountFrequency (%)
1 11
39.3%
2 4
 
14.3%
3 2
 
7.1%
6 1
 
3.6%
7 1
 
3.6%
10 1
 
3.6%
11 2
 
7.1%
12 1
 
3.6%
14 2
 
7.1%
22 1
 
3.6%
ValueCountFrequency (%)
62 1
3.6%
26 1
3.6%
22 1
3.6%
14 2
7.1%
12 1
3.6%
11 2
7.1%
10 1
3.6%
7 1
3.6%
6 1
3.6%
3 2
7.1%

Interactions

2023-12-12T21:30:22.150374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:30:21.952862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:30:22.262313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:30:22.060684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:30:24.837574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자교육명대상장소시간이수인원
일자1.0001.0000.6880.9040.3170.408
교육명1.0001.0001.0001.0001.0001.000
대상0.6881.0001.0000.8370.0000.571
장소0.9041.0000.8371.0000.0000.743
시간0.3171.0000.0000.0001.0000.000
이수인원0.4081.0000.5710.7430.0001.000
2023-12-12T21:30:25.300348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대상일자장소
대상1.0000.4800.574
일자0.4801.0000.698
장소0.5740.6981.000
2023-12-12T21:30:25.391814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간이수인원일자대상장소
시간1.000-0.5500.2560.0000.129
이수인원-0.5501.0000.2330.2200.452
일자0.2560.2331.0000.4800.698
대상0.0000.2200.4801.0000.574
장소0.1290.4520.6980.5741.000

Missing values

2023-12-12T21:30:22.409575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:30:22.534029image/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-01-01~2022-12-31행복한동행 공공기관 청렴 반부패 캠페인전직원온라인(지방공기업평가원)36
12022-01-01이해충돌방지법 바로알기 교육전직원온라인(청렴연수원)210
22022-01-01~2022-12-31공직유관단체 직원 대상 이해출돌방지법 길잡이전직원온라인(청렴연수원)222
32022-01-01~2022-12-31제1기 권익구제와 옴부즈만전직원온라인101
42022-01-01~2022-12-31제1기 세상을 바꾸는 힘 공익신고전직원온라인81
52022-01-01~2022-12-31사례로 배우는 청탁금지법전직원온라인711
62022-02-01[건강한 조직 만들기]공공기관 청렴 반부패 캠페인전직원온라인(지방공기업평가원)21
72022-03-01[슬기로운 직장생활] 공공기관 청렴 반부패 캠페인전직원온라인(지방공기업평가원)23
82022-03-01청탁금지 툰, 청렴한 일터만들기전직원온라인(한국생산성본부)31
92022-03-01공직자의 이해충돌방지법 특별 대면교육전직원업무빌딩 10층 대회의실262
일자교육명대상장소시간이수인원
182022-01-01~2022-12-31이순신 장군의 청렴 리더쉽전직원온라인(국민권익위원회)81
192022-06-01신규임용 및 승진자 반부패 청렴교육신규임용 및 승진자업무빌딩 8층 중회의실214
202022-06-01갑질 등 사전예방 및 대처요령 교육전직원업무빌딩 10층 대회의실226
212022-06-01청렴명예감사관 워크숍명예감사관온라인(zoom)31
222022-01-01~2022-12-31문화와 생활 속 청렴전직원온라인(국민권익위원회)211
232022-01-01~2022-12-31제6기 신규자 과정 교육신규임용자온라인(국민권익위원회)63
242022-01-01~2022-12-31공직자를 위한 신목민심서전직원온라인(국민권익위원회)71
252022-06-01신규임용 직원대상 이해충돌방지법 및 직장내 갑질 예방 교육신규임용자업무빌딩 8층 중회의실212
262022-09-01청렴도 향상 및 청렴문화 제고를 위한 청렴 유적지 탐방 체험 교육신규임용자 및 청렴감사부아산 현충사214
272022-11-01제8기 청렴윤리경영 담당자 과정교육청렴감사부청렴연수원121