Overview

Dataset statistics

Number of variables3
Number of observations262
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.8 KiB
Average record size in memory26.5 B

Variable types

Numeric2
Categorical1

Dataset

Description홈페이지 관련 테이블, 우편번호, 게시판 그룹, 회원그룹, 행정코드, 게시판 구조 등의 정보입니다.
Author국가평생교육진흥원
URLhttps://www.data.go.kr/data/15072243/fileData.do

Alerts

연번 is highly overall correlated with 권한코드High correlation
권한코드 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 02:32:52.955973
Analysis finished2023-12-12 02:32:53.508186
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct262
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean131.5
Minimum1
Maximum262
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T11:32:53.572654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.05
Q166.25
median131.5
Q3196.75
95-th percentile248.95
Maximum262
Range261
Interquartile range (IQR)130.5

Descriptive statistics

Standard deviation75.777085
Coefficient of variation (CV)0.5762516
Kurtosis-1.2
Mean131.5
Median Absolute Deviation (MAD)65.5
Skewness0
Sum34453
Variance5742.1667
MonotonicityStrictly increasing
2023-12-12T11:32:53.707808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
166 1
 
0.4%
168 1
 
0.4%
169 1
 
0.4%
170 1
 
0.4%
171 1
 
0.4%
172 1
 
0.4%
173 1
 
0.4%
174 1
 
0.4%
175 1
 
0.4%
Other values (252) 252
96.2%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
262 1
0.4%
261 1
0.4%
260 1
0.4%
259 1
0.4%
258 1
0.4%
257 1
0.4%
256 1
0.4%
255 1
0.4%
254 1
0.4%
253 1
0.4%

메뉴번호
Real number (ℝ)

Distinct69
Distinct (%)26.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9804079.4
Minimum1010000
Maximum30600000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T11:32:53.843786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1010000
5-th percentile1010400
Q13010700
median8040000
Q310410000
95-th percentile30300000
Maximum30600000
Range29590000
Interquartile range (IQR)7399300

Descriptive statistics

Standard deviation8459509
Coefficient of variation (CV)0.86285602
Kurtosis1.1103031
Mean9804079.4
Median Absolute Deviation (MAD)4960000
Skewness1.4115406
Sum2.5686688 × 109
Variance7.1563292 × 1013
MonotonicityNot monotonic
2023-12-12T11:32:54.006972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7000000 4
 
1.5%
6020000 4
 
1.5%
10100000 4
 
1.5%
7010000 4
 
1.5%
10120000 4
 
1.5%
10130000 4
 
1.5%
10140000 4
 
1.5%
10200000 4
 
1.5%
10300000 4
 
1.5%
10310000 4
 
1.5%
Other values (59) 222
84.7%
ValueCountFrequency (%)
1010000 4
1.5%
1010100 4
1.5%
1010200 4
1.5%
1010400 4
1.5%
1012000 4
1.5%
2000000 4
1.5%
2010000 4
1.5%
2020000 4
1.5%
3000000 4
1.5%
3010000 4
1.5%
ValueCountFrequency (%)
30600000 4
1.5%
30500000 4
1.5%
30400000 4
1.5%
30300000 4
1.5%
30200000 4
1.5%
30100000 4
1.5%
30000000 4
1.5%
20500000 2
0.8%
20300000 2
0.8%
20200000 4
1.5%

권한코드
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
ROLE_ADMIN
66 
ROLE_ANONYMOUS
66 
ROLE_MONITOR
66 
ROLE_USER
64 

Length

Max length14
Median length12
Mean length11.267176
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
ROLE_ADMIN 66
25.2%
ROLE_ANONYMOUS 66
25.2%
ROLE_MONITOR 66
25.2%
ROLE_USER 64
24.4%

Length

2023-12-12T11:32:54.156793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:32:54.287251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
role_admin 66
25.2%
role_anonymous 66
25.2%
role_monitor 66
25.2%
role_user 64
24.4%

Interactions

2023-12-12T11:32:53.208674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:32:53.039891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:32:53.289498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:32:53.130449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:32:54.360589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번메뉴번호권한코드
연번1.0000.6430.932
메뉴번호0.6431.0000.000
권한코드0.9320.0001.000
2023-12-12T11:32:54.455643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번메뉴번호권한코드
연번1.0000.1860.832
메뉴번호0.1861.0000.000
권한코드0.8320.0001.000

Missing values

2023-12-12T11:32:53.404576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:32:53.479865image/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

연번메뉴번호권한코드
017000000ROLE_ADMIN
127010000ROLE_ADMIN
237020000ROLE_ADMIN
347030000ROLE_ADMIN
452000000ROLE_ADMIN
562010000ROLE_ADMIN
672020000ROLE_ADMIN
783000000ROLE_ADMIN
893030000ROLE_ADMIN
9103010000ROLE_ADMIN
연번메뉴번호권한코드
2522538050000ROLE_USER
2532548040000ROLE_MONITOR
2542558010000ROLE_MONITOR
2552568020000ROLE_MONITOR
2562578030000ROLE_MONITOR
2572588050000ROLE_MONITOR
2582598010000ROLE_ANONYMOUS
2592608020000ROLE_ANONYMOUS
2602618030000ROLE_ANONYMOUS
2612628050000ROLE_ANONYMOUS