Overview

Dataset statistics

Number of variables4
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory880.0 B
Average record size in memory40.0 B

Variable types

Numeric2
Categorical1
Text1

Dataset

Description학부모 상담결과 관련 CSV
Author국가평생교육진흥원
URLhttps://www.data.go.kr/data/15071854/fileData.do

Alerts

번호 is highly overall correlated with 상담분류코드 and 1 other fieldsHigh correlation
상담분류코드 is highly overall correlated with 번호 and 1 other fieldsHigh correlation
분류1 is highly overall correlated with 번호 and 1 other fieldsHigh correlation
번호 has unique valuesUnique
분류2 has unique valuesUnique

Reproduction

Analysis started2023-12-12 13:31:49.902481
Analysis finished2023-12-12 13:31:50.449953
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.5
Minimum1
Maximum22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-12T22:31:50.500683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.05
Q16.25
median11.5
Q316.75
95-th percentile20.95
Maximum22
Range21
Interquartile range (IQR)10.5

Descriptive statistics

Standard deviation6.4935866
Coefficient of variation (CV)0.5646597
Kurtosis-1.2
Mean11.5
Median Absolute Deviation (MAD)5.5
Skewness0
Sum253
Variance42.166667
MonotonicityStrictly increasing
2023-12-12T22:31:50.590360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
1 1
 
4.5%
13 1
 
4.5%
22 1
 
4.5%
21 1
 
4.5%
20 1
 
4.5%
19 1
 
4.5%
18 1
 
4.5%
17 1
 
4.5%
16 1
 
4.5%
15 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
1 1
4.5%
2 1
4.5%
3 1
4.5%
4 1
4.5%
5 1
4.5%
6 1
4.5%
7 1
4.5%
8 1
4.5%
9 1
4.5%
10 1
4.5%
ValueCountFrequency (%)
22 1
4.5%
21 1
4.5%
20 1
4.5%
19 1
4.5%
18 1
4.5%
17 1
4.5%
16 1
4.5%
15 1
4.5%
14 1
4.5%
13 1
4.5%

분류1
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
학부모 학교참여
6 
학교행정
6 
자녀상담
4 
학부모정책
3 
교육과정
3 

Length

Max length8
Median length4
Mean length5.2272727
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row학부모정책
2nd row학부모정책
3rd row학부모정책
4th row학부모 학교참여
5th row학부모 학교참여

Common Values

ValueCountFrequency (%)
학부모 학교참여 6
27.3%
학교행정 6
27.3%
자녀상담 4
18.2%
학부모정책 3
13.6%
교육과정 3
13.6%

Length

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

Common Values (Plot)

2023-12-12T22:31:50.801461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학부모 6
21.4%
학교참여 6
21.4%
학교행정 6
21.4%
자녀상담 4
14.3%
학부모정책 3
10.7%
교육과정 3
10.7%

분류2
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T22:31:50.961452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9.5
Mean length7.2727273
Min length4

Characters and Unicode

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

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row학부모 지원 정책
2nd row학부모 교육 지원
3rd row학부모회 지원
4th row운영위원회 운영
5th row학부모회 운영
ValueCountFrequency (%)
학부모 3
 
6.4%
자녀 3
 
6.4%
지원 3
 
6.4%
운영 2
 
4.3%
및 2
 
4.3%
학교 2
 
4.3%
학부모회 2
 
4.3%
운영위원회 1
 
2.1%
학교선택 1
 
2.1%
창의적 1
 
2.1%
Other values (27) 27
57.4%
2023-12-12T22:31:51.256754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25
 
15.6%
학 16
 
10.0%
부 8
 
5.0%
교 8
 
5.0%
모 6
 
3.8%
원 6
 
3.8%
지 5
 
3.1%
정 5
 
3.1%
자 5
 
3.1%
회 4
 
2.5%
Other values (44) 72
45.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 135
84.4%
Space Separator 25
 
15.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 16
 
11.9%
부 8
 
5.9%
교 8
 
5.9%
모 6
 
4.4%
원 6
 
4.4%
지 5
 
3.7%
정 5
 
3.7%
자 5
 
3.7%
회 4
 
3.0%
활 4
 
3.0%
Other values (43) 68
50.4%
Space Separator
ValueCountFrequency (%)
25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 135
84.4%
Common 25
 
15.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 16
 
11.9%
부 8
 
5.9%
교 8
 
5.9%
모 6
 
4.4%
원 6
 
4.4%
지 5
 
3.7%
정 5
 
3.7%
자 5
 
3.7%
회 4
 
3.0%
활 4
 
3.0%
Other values (43) 68
50.4%
Common
ValueCountFrequency (%)
25
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 135
84.4%
ASCII 25
 
15.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
25
100.0%
Hangul
ValueCountFrequency (%)
학 16
 
11.9%
부 8
 
5.9%
교 8
 
5.9%
모 6
 
4.4%
원 6
 
4.4%
지 5
 
3.7%
정 5
 
3.7%
자 5
 
3.7%
회 4
 
3.0%
활 4
 
3.0%
Other values (43) 68
50.4%

상담분류코드
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean293.77273
Minimum101
Maximum502
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-12T22:31:51.370359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile102.05
Q1203.25
median302.5
Q3401.75
95-th percentile501.95
Maximum502
Range401
Interquartile range (IQR)198.5

Descriptive statistics

Standard deviation126.63819
Coefficient of variation (CV)0.43107539
Kurtosis-0.86311448
Mean293.77273
Median Absolute Deviation (MAD)99.5
Skewness0.16833559
Sum6463
Variance16037.232
MonotonicityIncreasing
2023-12-12T22:31:51.482501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
502 2
 
9.1%
101 1
 
4.5%
102 1
 
4.5%
501 1
 
4.5%
404 1
 
4.5%
403 1
 
4.5%
402 1
 
4.5%
401 1
 
4.5%
306 1
 
4.5%
305 1
 
4.5%
Other values (11) 11
50.0%
ValueCountFrequency (%)
101 1
4.5%
102 1
4.5%
103 1
4.5%
201 1
4.5%
202 1
4.5%
203 1
4.5%
204 1
4.5%
205 1
4.5%
206 1
4.5%
301 1
4.5%
ValueCountFrequency (%)
502 2
9.1%
501 1
4.5%
404 1
4.5%
403 1
4.5%
402 1
4.5%
401 1
4.5%
306 1
4.5%
305 1
4.5%
304 1
4.5%
303 1
4.5%

Interactions

2023-12-12T22:31:50.182240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:31:50.025171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:31:50.243076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:31:50.100196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:31:51.623597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호분류1분류2상담분류코드
번호1.0001.0001.0000.960
분류11.0001.0001.0001.000
분류21.0001.0001.0001.000
상담분류코드0.9601.0001.0001.000
2023-12-12T22:31:51.706886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호상담분류코드분류1
번호1.0001.0000.840
상담분류코드1.0001.0000.970
분류10.8400.9701.000

Missing values

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

번호분류1분류2상담분류코드
01학부모정책학부모 지원 정책101
12학부모정책학부모 교육 지원102
23학부모정책학부모회 지원103
34학부모 학교참여운영위원회 운영201
45학부모 학교참여학부모회 운영202
56학부모 학교참여학부모 학교참여203
67학부모 학교참여소위원회 활동204
78학부모 학교참여학부모상담주간205
89학부모 학교참여자원봉사206
910학교행정입학 및 전학 편입학301
번호분류1분류2상담분류코드
1213학교행정학교복지304
1314학교행정학교선택305
1415학교행정입시정보306
1516자녀상담자녀 학교 부적응401
1617자녀상담자녀심리 상담402
1718자녀상담자녀 인성 및 적성403
1819자녀상담자녀 진학 지도404
1920교육과정교육과정 개정501
2021교육과정교과활동502
2122교육과정창의적 체험활동502