Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory410.2 KiB
Average record size in memory42.0 B

Variable types

Numeric2
Categorical1
DateTime1

Dataset

Description한국기술교육대학교 온라인평생교육원 스마트 직업훈련 플랫폼 (STEP)에 대한 과목 관리자와 관련된 내용을 제공합니다.
Author한국기술교육대학교
URLhttps://www.data.go.kr/data/15091093/fileData.do

Alerts

과정 아이디 is highly overall correlated with 등록 국가High correlation
등록 국가 is highly overall correlated with 과정 아이디High correlation

Reproduction

Analysis started2023-12-11 23:44:01.702526
Analysis finished2023-12-11 23:44:02.495207
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

과정 아이디
Real number (ℝ)

HIGH CORRELATION 

Distinct9356
Distinct (%)93.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean93112.73
Minimum32
Maximum383290
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:44:02.562253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum32
5-th percentile1276
Q18544.5
median41048
Q3169052
95-th percentile311139.4
Maximum383290
Range383258
Interquartile range (IQR)160507.5

Descriptive statistics

Standard deviation103696.64
Coefficient of variation (CV)1.1136677
Kurtosis-0.058812184
Mean93112.73
Median Absolute Deviation (MAD)37217.5
Skewness1.0416089
Sum9.311273 × 108
Variance1.0752993 × 1010
MonotonicityNot monotonic
2023-12-12T08:44:02.693310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1136 6
 
0.1%
1400 5
 
0.1%
811 5
 
0.1%
1168 5
 
0.1%
839 5
 
0.1%
1193 4
 
< 0.1%
547 4
 
< 0.1%
32 4
 
< 0.1%
665 4
 
< 0.1%
623 4
 
< 0.1%
Other values (9346) 9954
99.5%
ValueCountFrequency (%)
32 4
< 0.1%
33 1
 
< 0.1%
50 1
 
< 0.1%
167 1
 
< 0.1%
248 1
 
< 0.1%
308 1
 
< 0.1%
312 1
 
< 0.1%
327 1
 
< 0.1%
333 1
 
< 0.1%
334 1
 
< 0.1%
ValueCountFrequency (%)
383290 1
< 0.1%
383146 1
< 0.1%
382870 1
< 0.1%
382723 1
< 0.1%
382654 1
< 0.1%
382627 1
< 0.1%
382597 1
< 0.1%
382564 1
< 0.1%
382474 1
< 0.1%
382438 1
< 0.1%

관리자 계정 인덱스
Real number (ℝ)

Distinct788
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1934754.4
Minimum770
Maximum34755565
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:44:02.824375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum770
5-th percentile41350
Q176501
median110190
Q3549993
95-th percentile17153523
Maximum34755565
Range34754795
Interquartile range (IQR)473492

Descriptive statistics

Standard deviation5589751.1
Coefficient of variation (CV)2.8891269
Kurtosis11.86337
Mean1934754.4
Median Absolute Deviation (MAD)67385
Skewness3.5277675
Sum1.9347544 × 1010
Variance3.1245317 × 1013
MonotonicityNot monotonic
2023-12-12T08:44:02.949925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1044952 311
 
3.1%
78288 192
 
1.9%
76344 145
 
1.5%
76642 142
 
1.4%
76850 142
 
1.4%
81563 139
 
1.4%
76493 138
 
1.4%
79911 123
 
1.2%
482794 103
 
1.0%
76393 97
 
1.0%
Other values (778) 8468
84.7%
ValueCountFrequency (%)
770 1
 
< 0.1%
4818 1
 
< 0.1%
4825 73
0.7%
4838 40
0.4%
4857 23
 
0.2%
4876 5
 
0.1%
4883 18
 
0.2%
4896 1
 
< 0.1%
4909 1
 
< 0.1%
4928 4
 
< 0.1%
ValueCountFrequency (%)
34755565 4
< 0.1%
33878388 1
 
< 0.1%
33568614 1
 
< 0.1%
33567618 2
< 0.1%
33566709 2
< 0.1%
33560691 1
 
< 0.1%
33558180 1
 
< 0.1%
33501124 1
 
< 0.1%
33462687 1
 
< 0.1%
33397033 1
 
< 0.1%

등록 국가
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
KR
8232 
UNKNOWN
1768 

Length

Max length7
Median length2
Mean length2.884
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowUNKNOWN
2nd rowKR
3rd rowKR
4th rowKR
5th rowKR

Common Values

ValueCountFrequency (%)
KR 8232
82.3%
UNKNOWN 1768
 
17.7%

Length

2023-12-12T08:44:03.064050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:44:03.146706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kr 8232
82.3%
unknown 1768
 
17.7%

등록 일시
Date

Distinct5726
Distinct (%)57.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-03-24 18:17:21
Maximum2023-09-15 10:44:59
2023-12-12T08:44:03.244281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:44:03.372039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T08:44:02.147408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:44:01.923915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:44:02.247818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:44:02.021731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:44:03.456161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과정 아이디관리자 계정 인덱스등록 국가
과정 아이디1.0000.5250.652
관리자 계정 인덱스0.5251.0000.085
등록 국가0.6520.0851.000
2023-12-12T08:44:03.540297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과정 아이디관리자 계정 인덱스등록 국가
과정 아이디1.0000.3790.506
관리자 계정 인덱스0.3791.0000.091
등록 국가0.5060.0911.000

Missing values

2023-12-12T08:44:02.379369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:44:02.459126image/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

과정 아이디관리자 계정 인덱스등록 국가등록 일시
29961167687145199UNKNOWN2021-03-03 09:31:07
3213819439792734KR2021-09-15 10:28:59
376722825652068459KR2023-03-02 11:13:06
75176781317008KR2016-01-25 16:03:05
13333113574825KR2016-11-10 11:19:39
207104838176344KR2018-07-02 11:23:03
2938615585416379692KR2020-11-03 16:35:48
3143310376360KR2015-06-24 17:11:21
38811327838481783KR2023-06-01 11:23:23
1514015347107739KR2017-02-21 13:58:29
과정 아이디관리자 계정 인덱스등록 국가등록 일시
249468944068687KR2019-11-01 08:17:47
45204506133122KR2015-09-09 11:31:33
3666927096188258UNKNOWN2023-01-02 11:39:29
212655318379911KR2018-09-17 10:55:04
218375747576269KR2018-11-01 11:03:45
3354346084976KR2015-07-21 16:01:50
1469102845410KR2015-03-31 00:00:00
22066594011768271KR2018-11-15 14:10:25
236067525981546KR2019-05-02 10:55:08
4912480344145KR2015-08-25 09:25:54