Overview

Dataset statistics

Number of variables4
Number of observations1105
Missing cells0
Missing cells (%)0.0%
Duplicate rows81
Duplicate rows (%)7.3%
Total size in memory36.8 KiB
Average record size in memory34.1 B

Variable types

Categorical3
Numeric1

Dataset

Description한국청소년상담복지개발원 에서 진행하는 청소년상담사 연수 과목별 수업 정보 테이블로 연수년도, 과목명, 수업멱, 취득시수를 포함하는 데이터
URLhttps://www.data.go.kr/data/15120963/fileData.do

Alerts

Dataset has 81 (7.3%) duplicate rowsDuplicates
과목명 is highly overall correlated with 취득시수 and 1 other fieldsHigh correlation
수업명 is highly overall correlated with 취득시수 and 2 other fieldsHigh correlation
취득시수 is highly overall correlated with 연수년도 and 2 other fieldsHigh correlation
연수년도 is highly overall correlated with 취득시수 and 1 other fieldsHigh correlation
취득시수 has 110 (10.0%) zerosZeros

Reproduction

Analysis started2023-12-12 09:19:54.183380
Analysis finished2023-12-12 09:19:54.802273
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연수년도
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size8.8 KiB
2020
680 
2019
282 
2018
143 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 680
61.5%
2019 282
25.5%
2018 143
 
12.9%

Length

2023-12-12T18:19:54.911566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:19:55.052350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 680
61.5%
2019 282
25.5%
2018 143
 
12.9%

과목명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size8.8 KiB
특강
239 
발달문제
151 
매체상담
138 
상담현장론
101 
청소년위기개입 1
92 
Other values (12)
384 

Length

Max length11
Median length9
Mean length5.0307692
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row청소년상담수퍼비전
2nd row청소년상담수퍼비전
3rd row청소년상담프로그램개발
4th row청소년상담프로그램개발
5th row청소년문제세미나

Common Values

ValueCountFrequency (%)
특강 239
21.6%
발달문제 151
13.7%
매체상담 138
12.5%
상담현장론 101
9.1%
청소년위기개입 1 92
 
8.3%
지역사회상담 84
 
7.6%
부모상담 56
 
5.1%
청소년상담과정과 기법 56
 
5.1%
집단상담 50
 
4.5%
개인상담 32
 
2.9%
Other values (7) 106
9.6%

Length

2023-12-12T18:19:55.207764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
특강 239
18.2%
발달문제 151
11.5%
매체상담 138
10.5%
상담현장론 101
7.7%
청소년위기개입 98
7.5%
1 92
 
7.0%
지역사회상담 84
 
6.4%
청소년 56
 
4.3%
부모상담 56
 
4.3%
청소년상담과정과 56
 
4.3%
Other values (10) 244
18.6%

수업명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size8.8 KiB
인권특강(이러닝)
104 
이론(이러닝)
100 
양성평등(이러닝)
96 
부모상담 사전과제
 
56
지역사회상담 사전과제
 
56
Other values (26)
693 

Length

Max length22
Median length18
Mean length11.825339
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row청소년상담수퍼비전 사전과제
2nd row청소년상담수퍼비전 사전과제
3rd row청소년상담프로그램개발 사전과제
4th row청소년상담프로그램개발 사전과제
5th row청소년문제세미나 사전과제

Common Values

ValueCountFrequency (%)
인권특강(이러닝) 104
 
9.4%
이론(이러닝) 100
 
9.0%
양성평등(이러닝) 96
 
8.7%
부모상담 사전과제 56
 
5.1%
지역사회상담 사전과제 56
 
5.1%
청소년상담과정과 기법 사전과제 56
 
5.1%
성문제(이러닝) 50
 
4.5%
분석보고서(과제) 50
 
4.5%
사이버상담 체험(과제) 50
 
4.5%
학교폭력(이러닝) 50
 
4.5%
Other values (21) 437
39.5%

Length

2023-12-12T18:19:55.426466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사전과제 274
 
14.7%
및 122
 
6.5%
인권특강(이러닝 104
 
5.6%
이론(이러닝 100
 
5.4%
양성평등(이러닝 96
 
5.1%
위기개입i 92
 
4.9%
세미나 60
 
3.2%
부모상담 56
 
3.0%
지역사회상담 56
 
3.0%
청소년상담과정과 56
 
3.0%
Other values (32) 852
45.6%

취득시수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct13
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.4977376
Minimum0
Maximum14
Zeros110
Zeros (%)10.0%
Negative0
Negative (%)0.0%
Memory size9.8 KiB
2023-12-12T18:19:55.599100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13
median4
Q38
95-th percentile11
Maximum14
Range14
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.4750983
Coefficient of variation (CV)0.63209607
Kurtosis-0.58739363
Mean5.4977376
Median Absolute Deviation (MAD)2
Skewness0.45434004
Sum6075
Variance12.076308
MonotonicityNot monotonic
2023-12-12T18:19:55.748512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
4 243
22.0%
3 198
17.9%
6 176
15.9%
10 150
13.6%
0 110
10.0%
11 75
 
6.8%
5 38
 
3.4%
8 37
 
3.3%
2 29
 
2.6%
14 22
 
2.0%
Other values (3) 27
 
2.4%
ValueCountFrequency (%)
0 110
10.0%
2 29
 
2.6%
3 198
17.9%
4 243
22.0%
5 38
 
3.4%
6 176
15.9%
8 37
 
3.3%
9 18
 
1.6%
10 150
13.6%
11 75
 
6.8%
ValueCountFrequency (%)
14 22
 
2.0%
13 6
 
0.5%
12 3
 
0.3%
11 75
 
6.8%
10 150
13.6%
9 18
 
1.6%
8 37
 
3.3%
6 176
15.9%
5 38
 
3.4%
4 243
22.0%

Interactions

2023-12-12T18:19:54.428879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:19:55.864616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연수년도과목명수업명취득시수
연수년도1.0000.3950.8430.712
과목명0.3951.0000.9980.844
수업명0.8430.9981.0000.960
취득시수0.7120.8440.9601.000
2023-12-12T18:19:55.985297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과목명연수년도수업명
과목명1.0000.2310.972
연수년도0.2311.0000.644
수업명0.9720.6441.000
2023-12-12T18:19:56.128522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
취득시수연수년도과목명수업명
취득시수1.0000.5700.5350.764
연수년도0.5701.0000.2310.644
과목명0.5350.2311.0000.972
수업명0.7640.6440.9721.000

Missing values

2023-12-12T18:19:54.617548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:19:54.747591image/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

연수년도과목명수업명취득시수
02018청소년상담수퍼비전청소년상담수퍼비전 사전과제10
12018청소년상담수퍼비전청소년상담수퍼비전 사전과제10
22018청소년상담프로그램개발청소년상담프로그램개발 사전과제10
32018청소년상담프로그램개발청소년상담프로그램개발 사전과제10
42018청소년문제세미나청소년문제세미나 사전과제10
52018청소년문제세미나청소년문제세미나 사전과제10
62018특강인권특강2
72018특강인권특강2
82018부모상담부모상담 사전과제10
92018부모상담부모상담 사전과제10
연수년도과목명수업명취득시수
10952020상담현장론(온라인)상담현장론-세미나4
10962020상담현장론(온라인)상담현장론-세미나4
10972020상담현장론(온라인)상담현장론-세미나4
10982020상담현장론(온라인)상담현장론-세미나4
10992020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)0
11002020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)4
11012020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)4
11022020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)0
11032020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)0
11042020청소년상담프로그램개발청소년상담프로그램 개발(이러닝)4

Duplicate rows

Most frequently occurring

연수년도과목명수업명취득시수# duplicates
802020특강인권특강(이러닝)361
782020특강양성평등(이러닝)357
322019특강인권특강(이러닝)338
312019특강양성평등(이러닝)336
142018특강인권특강229
362020매체상담사이버상담 체험(과제)629
382020매체상담이론(이러닝)429
422020발달문제성문제(이러닝)629
442020발달문제학교폭력(이러닝)629
492020상담현장론분석보고서(과제)1129