Overview

Dataset statistics

Number of variables10
Number of observations819
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory68.9 KiB
Average record size in memory86.2 B

Variable types

Categorical7
Numeric3

Dataset

Description3급 장애인재활상담사 국가시험 응시자의 성적 현황을 분석할 수 있는 정보(연도, 직종, 회차, 일련번호, 과목명, 과목별 점수, 총점, 합격여부, 성별, 연령대)를 제공합니다. 3급 장애인재활상담사는 2021년도까지만 시행하여 이후 데이터는 없습니다.
URLhttps://www.data.go.kr/data/15083531/fileData.do

Alerts

직종 has constant value ""Constant
연도 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
합격여부 is highly overall correlated with 과목별점수 and 1 other fieldsHigh correlation
합격여부 is highly imbalanced (53.8%)Imbalance
과목별점수 has 31 (3.8%) zerosZeros
총점 has 28 (3.4%) zerosZeros

Reproduction

Analysis started2023-12-12 08:34:04.645701
Analysis finished2023-12-12 08:34:06.235994
Duration1.59 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
2018
462 
2020
231 
2019
70 
2021
56 

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 (%)
2018 462
56.4%
2020 231
28.2%
2019 70
 
8.5%
2021 56
 
6.8%

Length

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

Common Values (Plot)

2023-12-12T17:34:06.420973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018 462
56.4%
2020 231
28.2%
2019 70
 
8.5%
2021 56
 
6.8%

직종
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
3급 장애인재활상담사
819 

Length

Max length31
Median length31
Mean length31
Min length31

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3급 장애인재활상담사
2nd row3급 장애인재활상담사
3rd row3급 장애인재활상담사
4th row3급 장애인재활상담사
5th row3급 장애인재활상담사

Common Values

ValueCountFrequency (%)
3급 장애인재활상담사 819
100.0%

Length

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

Common Values (Plot)

2023-12-12T17:34:06.632777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3급 819
50.0%
장애인재활상담사 819
50.0%

회차
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
2
273 
4
231 
1
189 
3
70 
5
56 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 273
33.3%
4 231
28.2%
1 189
23.1%
3 70
 
8.5%
5 56
 
6.8%

Length

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

Common Values (Plot)

2023-12-12T17:34:06.870101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 273
33.3%
4 231
28.2%
1 189
23.1%
3 70
 
8.5%
5 56
 
6.8%

일련번호
Real number (ℝ)

HIGH CORRELATION 

Distinct117
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59
Minimum1
Maximum117
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-12T17:34:07.033745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6
Q130
median59
Q388
95-th percentile112
Maximum117
Range116
Interquartile range (IQR)58

Descriptive statistics

Standard deviation33.794395
Coefficient of variation (CV)0.57278635
Kurtosis-1.2001728
Mean59
Median Absolute Deviation (MAD)29
Skewness0
Sum48321
Variance1142.0611
MonotonicityIncreasing
2023-12-12T17:34:07.203592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 7
 
0.9%
75 7
 
0.9%
87 7
 
0.9%
86 7
 
0.9%
85 7
 
0.9%
84 7
 
0.9%
83 7
 
0.9%
82 7
 
0.9%
81 7
 
0.9%
80 7
 
0.9%
Other values (107) 749
91.5%
ValueCountFrequency (%)
1 7
0.9%
2 7
0.9%
3 7
0.9%
4 7
0.9%
5 7
0.9%
6 7
0.9%
7 7
0.9%
8 7
0.9%
9 7
0.9%
10 7
0.9%
ValueCountFrequency (%)
117 7
0.9%
116 7
0.9%
115 7
0.9%
114 7
0.9%
113 7
0.9%
112 7
0.9%
111 7
0.9%
110 7
0.9%
109 7
0.9%
108 7
0.9%

과목명
Categorical

Distinct7
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
직업재활개론
117 
재활사례관리
117 
직업평가
117 
직무개발과 배치
117 
재활상담
117 
Other values (2)
234 

Length

Max length8
Median length4
Mean length5.1428571
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row직업재활개론
2nd row재활사례관리
3rd row직업평가
4th row직무개발과 배치
5th row재활상담

Common Values

ValueCountFrequency (%)
직업재활개론 117
14.3%
재활사례관리 117
14.3%
직업평가 117
14.3%
직무개발과 배치 117
14.3%
재활상담 117
14.3%
재활정책 117
14.3%
재활행정 117
14.3%

Length

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

Common Values (Plot)

2023-12-12T17:34:07.516623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
직업재활개론 117
12.5%
재활사례관리 117
12.5%
직업평가 117
12.5%
직무개발과 117
12.5%
배치 117
12.5%
재활상담 117
12.5%
재활정책 117
12.5%
재활행정 117
12.5%

과목별점수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct25
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.29304
Minimum0
Maximum25
Zeros31
Zeros (%)3.8%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-12T17:34:07.707029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.9
Q18
median12
Q317
95-th percentile21
Maximum25
Range25
Interquartile range (IQR)9

Descriptive statistics

Standard deviation5.5439641
Coefficient of variation (CV)0.45098397
Kurtosis-0.73061105
Mean12.29304
Median Absolute Deviation (MAD)5
Skewness-0.16044672
Sum10068
Variance30.735538
MonotonicityNot monotonic
2023-12-12T17:34:07.875795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
17 71
 
8.7%
8 59
 
7.2%
7 55
 
6.7%
9 55
 
6.7%
18 50
 
6.1%
6 47
 
5.7%
11 44
 
5.4%
19 44
 
5.4%
13 43
 
5.3%
16 42
 
5.1%
Other values (15) 309
37.7%
ValueCountFrequency (%)
0 31
3.8%
2 1
 
0.1%
3 9
 
1.1%
4 11
 
1.3%
5 26
3.2%
6 47
5.7%
7 55
6.7%
8 59
7.2%
9 55
6.7%
10 38
4.6%
ValueCountFrequency (%)
25 2
 
0.2%
24 2
 
0.2%
23 6
 
0.7%
22 11
 
1.3%
21 22
 
2.7%
20 32
3.9%
19 44
5.4%
18 50
6.1%
17 71
8.7%
16 42
5.1%

총점
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct48
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean86.051282
Minimum0
Maximum114
Zeros28
Zeros (%)3.4%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-12T17:34:08.040907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile61
Q179
median90
Q398
95-th percentile107
Maximum114
Range114
Interquartile range (IQR)19

Descriptive statistics

Standard deviation20.260765
Coefficient of variation (CV)0.23544989
Kurtosis8.5556421
Mean86.051282
Median Absolute Deviation (MAD)9
Skewness-2.5361937
Sum70476
Variance410.49859
MonotonicityNot monotonic
2023-12-12T17:34:08.215409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
95 42
 
5.1%
101 42
 
5.1%
91 35
 
4.3%
92 35
 
4.3%
85 28
 
3.4%
0 28
 
3.4%
87 28
 
3.4%
84 28
 
3.4%
90 28
 
3.4%
98 28
 
3.4%
Other values (38) 497
60.7%
ValueCountFrequency (%)
0 28
3.4%
60 7
 
0.9%
61 7
 
0.9%
62 7
 
0.9%
65 7
 
0.9%
66 14
1.7%
67 21
2.6%
68 7
 
0.9%
70 7
 
0.9%
72 7
 
0.9%
ValueCountFrequency (%)
114 14
1.7%
110 7
 
0.9%
109 7
 
0.9%
108 7
 
0.9%
107 14
1.7%
106 21
2.6%
105 21
2.6%
104 7
 
0.9%
103 14
1.7%
102 7
 
0.9%

합격여부
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
합격
658 
불합격
119 
결시
 
28
응시결격
 
14

Length

Max length4
Median length2
Mean length2.1794872
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row불합격
2nd row불합격
3rd row불합격
4th row불합격
5th row불합격

Common Values

ValueCountFrequency (%)
합격 658
80.3%
불합격 119
 
14.5%
결시 28
 
3.4%
응시결격 14
 
1.7%

Length

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

Common Values (Plot)

2023-12-12T17:34:08.567578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
합격 658
80.3%
불합격 119
 
14.5%
결시 28
 
3.4%
응시결격 14
 
1.7%

성별
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
여
630 
남
189 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row여
2nd row여
3rd row여
4th row여
5th row여

Common Values

ValueCountFrequency (%)
여 630
76.9%
남 189
 
23.1%

Length

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

Common Values (Plot)

2023-12-12T17:34:08.871621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
여 630
76.9%
남 189
 
23.1%

연령대
Categorical

Distinct5
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
20
301 
40
266 
50
168 
30
77 
60
 
7

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20 301
36.8%
40 266
32.5%
50 168
20.5%
30 77
 
9.4%
60 7
 
0.9%

Length

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

Common Values (Plot)

2023-12-12T17:34:09.175791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20 301
36.8%
40 266
32.5%
50 168
20.5%
30 77
 
9.4%
60 7
 
0.9%

Interactions

2023-12-12T17:34:05.693298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.101407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.390584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.790434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.195122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.492501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.901535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.289588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:34:05.596181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:34:09.662903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도회차일련번호과목명과목별점수총점합격여부성별연령대
연도1.0001.0000.9070.0000.1960.3960.3910.2930.306
회차1.0001.0000.9850.0000.2720.3640.2340.1590.555
일련번호0.9070.9851.0000.0000.3220.5280.4120.3530.494
과목명0.0000.0000.0001.0000.7050.0000.0000.0000.000
과목별점수0.1960.2720.3220.7051.0000.7020.7520.0000.114
총점0.3960.3640.5280.0000.7021.0000.8660.1470.327
합격여부0.3910.2340.4120.0000.7520.8661.0000.3010.223
성별0.2930.1590.3530.0000.0000.1470.3011.0000.303
연령대0.3060.5550.4940.0000.1140.3270.2230.3031.000
2023-12-12T17:34:09.905161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과목명연령대성별연도합격여부회차
과목명1.0000.0000.0000.0000.0000.000
연령대0.0001.0000.3690.2540.1840.235
성별0.0000.3691.0000.1950.2000.194
연도0.0000.2540.1951.0000.1610.999
합격여부0.0000.1840.2000.1611.0000.192
회차0.0000.2350.1940.9990.1921.000
2023-12-12T17:34:10.087499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호과목별점수총점연도회차과목명합격여부성별연령대
일련번호1.0000.1110.3360.7910.8230.0000.2570.2700.226
과목별점수0.1111.0000.3980.1140.1100.4490.5530.0410.043
총점0.3360.3981.0000.2640.2560.0000.7350.1060.228
연도0.7910.1140.2641.0000.9990.0000.1610.1950.254
회차0.8230.1100.2560.9991.0000.0000.1920.1940.235
과목명0.0000.4490.0000.0000.0001.0000.0000.0000.000
합격여부0.2570.5530.7350.1610.1920.0001.0000.2000.184
성별0.2700.0410.1060.1950.1940.0000.2001.0000.369
연령대0.2260.0430.2280.2540.2350.0000.1840.3691.000

Missing values

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

연도직종회차일련번호과목명과목별점수총점합격여부성별연령대
020183급 장애인재활상담사11직업재활개론868불합격여20
120183급 장애인재활상담사11재활사례관리1268불합격여20
220183급 장애인재활상담사11직업평가968불합격여20
320183급 장애인재활상담사11직무개발과 배치1668불합격여20
420183급 장애인재활상담사11재활상담1168불합격여20
520183급 장애인재활상담사11재활정책668불합격여20
620183급 장애인재활상담사11재활행정668불합격여20
720183급 장애인재활상담사12직업재활개론1591합격여40
820183급 장애인재활상담사12재활사례관리1591합격여40
920183급 장애인재활상담사12직업평가1191합격여40
연도직종회차일련번호과목명과목별점수총점합격여부성별연령대
80920213급 장애인재활상담사5116재활정책884합격남60
81020213급 장애인재활상담사5116재활행정784합격남60
81120213급 장애인재활상담사5116재활상담1384합격남60
81220213급 장애인재활상담사5117직업재활개론1595합격여40
81320213급 장애인재활상담사5117재활사례관리1795합격여40
81420213급 장애인재활상담사5117직업평가1095합격여40
81520213급 장애인재활상담사5117직무개발과 배치2195합격여40
81620213급 장애인재활상담사5117재활정책895합격여40
81720213급 장애인재활상담사5117재활상담1595합격여40
81820213급 장애인재활상담사5117재활행정995합격여40