Overview

Dataset statistics

Number of variables7
Number of observations224
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.8 KiB
Average record size in memory58.6 B

Variable types

Text2
Categorical2
Numeric1
Boolean1
DateTime1

Dataset

Description한국사학진흥재단 경영정보시스템 메뉴 정보(메뉴 아이디, 메뉴 레벨, 상위 메뉴 아이디, 메뉴명, 메뉴 순서, 사용여부, 등록일)에 대한 데이터입니다.
URLhttps://www.data.go.kr/data/15121014/fileData.do

Alerts

메뉴 레벨 is highly overall correlated with 상위 메뉴 아이디High correlation
상위 메뉴 아이디 is highly overall correlated with 메뉴 레벨High correlation
사용여부 is highly imbalanced (92.6%)Imbalance
메뉴 아이디 has unique valuesUnique
메뉴 순서 has 9 (4.0%) zerosZeros

Reproduction

Analysis started2023-12-12 22:18:38.207199
Analysis finished2023-12-12 22:18:38.900771
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

메뉴 아이디
Text

UNIQUE 

Distinct224
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-13T07:18:39.098455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters2240
Distinct characters15
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique224 ?
Unique (%)100.0%

Sample

1st rowMENU_00081
2nd rowMENU_00082
3rd rowMENU_00084
4th rowMENU_00085
5th rowMENU_00086
ValueCountFrequency (%)
menu_00081 1
 
0.4%
menu_00082 1
 
0.4%
menu_00342 1
 
0.4%
menu_00442 1
 
0.4%
menu_00448 1
 
0.4%
menu_00346 1
 
0.4%
menu_00369 1
 
0.4%
menu_00407 1
 
0.4%
menu_00418 1
 
0.4%
menu_00417 1
 
0.4%
Other values (214) 214
95.5%
2023-12-13T07:18:39.480204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 550
24.6%
M 224
10.0%
E 224
10.0%
N 224
10.0%
U 224
10.0%
_ 224
10.0%
3 127
 
5.7%
4 121
 
5.4%
2 74
 
3.3%
8 46
 
2.1%
Other values (5) 202
 
9.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1120
50.0%
Uppercase Letter 896
40.0%
Connector Punctuation 224
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 550
49.1%
3 127
 
11.3%
4 121
 
10.8%
2 74
 
6.6%
8 46
 
4.1%
1 45
 
4.0%
5 44
 
3.9%
6 41
 
3.7%
7 37
 
3.3%
9 35
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
M 224
25.0%
E 224
25.0%
N 224
25.0%
U 224
25.0%
Connector Punctuation
ValueCountFrequency (%)
_ 224
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1344
60.0%
Latin 896
40.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 550
40.9%
_ 224
16.7%
3 127
 
9.4%
4 121
 
9.0%
2 74
 
5.5%
8 46
 
3.4%
1 45
 
3.3%
5 44
 
3.3%
6 41
 
3.1%
7 37
 
2.8%
Latin
ValueCountFrequency (%)
M 224
25.0%
E 224
25.0%
N 224
25.0%
U 224
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2240
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 550
24.6%
M 224
10.0%
E 224
10.0%
N 224
10.0%
U 224
10.0%
_ 224
10.0%
3 127
 
5.7%
4 121
 
5.4%
2 74
 
3.3%
8 46
 
2.1%
Other values (5) 202
 
9.0%

메뉴 레벨
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
3
172 
2
42 
1
 
10

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 172
76.8%
2 42
 
18.8%
1 10
 
4.5%

Length

2023-12-13T07:18:39.610097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:18:39.997307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 172
76.8%
2 42
 
18.8%
1 10
 
4.5%

상위 메뉴 아이디
Categorical

HIGH CORRELATION 

Distinct42
Distinct (%)18.8%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
MENU_00279
 
16
MENU_00288
 
12
MENU_00287
 
11
MENU_00269
 
11
MENU_00009
 
10
Other values (37)
164 

Length

Max length10
Median length10
Mean length9.7321429
Min length4

Unique

Unique3 ?
Unique (%)1.3%

Sample

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

Common Values

ValueCountFrequency (%)
MENU_00279 16
 
7.1%
MENU_00288 12
 
5.4%
MENU_00287 11
 
4.9%
MENU_00269 11
 
4.9%
MENU_00009 10
 
4.5%
MENU_00025 10
 
4.5%
MENU_00003 10
 
4.5%
ROOT 10
 
4.5%
MENU_00281 9
 
4.0%
MENU_00011 9
 
4.0%
Other values (32) 116
51.8%

Length

2023-12-13T07:18:40.087533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
menu_00279 16
 
7.1%
menu_00288 12
 
5.4%
menu_00287 11
 
4.9%
menu_00269 11
 
4.9%
menu_00009 10
 
4.5%
menu_00025 10
 
4.5%
menu_00003 10
 
4.5%
root 10
 
4.5%
menu_00281 9
 
4.0%
menu_00011 9
 
4.0%
Other values (32) 116
51.8%

메뉴명
Text

Distinct218
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-13T07:18:40.327561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length8.2678571
Min length4

Characters and Unicode

Total characters1852
Distinct characters187
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique215 ?
Unique (%)96.0%

Sample

1st row사이트관리
2nd row권한그룹관리
3rd row메뉴 관리
4th row프로그램 관리
5th row사용자별 메뉴권한관리
ValueCountFrequency (%)
관리 42
 
10.3%
조회 26
 
6.4%
등록 21
 
5.1%
전표 7
 
1.7%
기준정보관리 5
 
1.2%
계정과목 5
 
1.2%
월별 4
 
1.0%
연구회계 4
 
1.0%
국고 4
 
1.0%
국가재무제표 4
 
1.0%
Other values (238) 287
70.2%
2023-12-13T07:18:40.703484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
185
 
10.0%
관 102
 
5.5%
리 102
 
5.5%
계 52
 
2.8%
정 49
 
2.6%
조 43
 
2.3%
회 42
 
2.3%
산 38
 
2.1%
록 36
 
1.9%
등 33
 
1.8%
Other values (177) 1170
63.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1632
88.1%
Space Separator 185
 
10.0%
Close Punctuation 13
 
0.7%
Open Punctuation 13
 
0.7%
Uppercase Letter 6
 
0.3%
Other Punctuation 2
 
0.1%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 102
 
6.2%
리 102
 
6.2%
계 52
 
3.2%
정 49
 
3.0%
조 43
 
2.6%
회 42
 
2.6%
산 38
 
2.3%
록 36
 
2.2%
등 33
 
2.0%
기 30
 
1.8%
Other values (166) 1105
67.7%
Uppercase Letter
ValueCountFrequency (%)
G 2
33.3%
F 2
33.3%
S 2
33.3%
Close Punctuation
ValueCountFrequency (%)
) 8
61.5%
] 5
38.5%
Open Punctuation
ValueCountFrequency (%)
( 8
61.5%
[ 5
38.5%
Other Punctuation
ValueCountFrequency (%)
/ 1
50.0%
, 1
50.0%
Space Separator
ValueCountFrequency (%)
185
100.0%
Decimal Number
ValueCountFrequency (%)
5 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1632
88.1%
Common 214
 
11.6%
Latin 6
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
관 102
 
6.2%
리 102
 
6.2%
계 52
 
3.2%
정 49
 
3.0%
조 43
 
2.6%
회 42
 
2.6%
산 38
 
2.3%
록 36
 
2.2%
등 33
 
2.0%
기 30
 
1.8%
Other values (166) 1105
67.7%
Common
ValueCountFrequency (%)
185
86.4%
) 8
 
3.7%
( 8
 
3.7%
] 5
 
2.3%
[ 5
 
2.3%
/ 1
 
0.5%
, 1
 
0.5%
5 1
 
0.5%
Latin
ValueCountFrequency (%)
G 2
33.3%
F 2
33.3%
S 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1632
88.1%
ASCII 220
 
11.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
185
84.1%
) 8
 
3.6%
( 8
 
3.6%
] 5
 
2.3%
[ 5
 
2.3%
G 2
 
0.9%
F 2
 
0.9%
S 2
 
0.9%
/ 1
 
0.5%
, 1
 
0.5%
Hangul
ValueCountFrequency (%)
관 102
 
6.2%
리 102
 
6.2%
계 52
 
3.2%
정 49
 
3.0%
조 43
 
2.6%
회 42
 
2.6%
산 38
 
2.3%
록 36
 
2.2%
등 33
 
2.0%
기 30
 
1.8%
Other values (166) 1105
67.7%

메뉴 순서
Real number (ℝ)

ZEROS 

Distinct16
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.1785714
Minimum0
Maximum15
Zeros9
Zeros (%)4.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-13T07:18:40.822100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q36
95-th percentile10
Maximum15
Range15
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.1372613
Coefficient of variation (CV)0.75079759
Kurtosis0.42600511
Mean4.1785714
Median Absolute Deviation (MAD)2
Skewness0.97282506
Sum936
Variance9.8424087
MonotonicityNot monotonic
2023-12-13T07:18:40.934299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
1 39
17.4%
2 37
16.5%
3 30
13.4%
4 27
12.1%
5 18
8.0%
6 16
7.1%
8 11
 
4.9%
7 10
 
4.5%
9 10
 
4.5%
0 9
 
4.0%
Other values (6) 17
7.6%
ValueCountFrequency (%)
0 9
 
4.0%
1 39
17.4%
2 37
16.5%
3 30
13.4%
4 27
12.1%
5 18
8.0%
6 16
7.1%
7 10
 
4.5%
8 11
 
4.9%
9 10
 
4.5%
ValueCountFrequency (%)
15 1
 
0.4%
14 1
 
0.4%
13 2
 
0.9%
12 1
 
0.4%
11 4
 
1.8%
10 8
3.6%
9 10
4.5%
8 11
4.9%
7 10
4.5%
6 16
7.1%

사용여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size356.0 B
True
222 
False
 
2
ValueCountFrequency (%)
True 222
99.1%
False 2
 
0.9%
2023-12-13T07:18:41.064970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일
Date

Distinct55
Distinct (%)24.6%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
Minimum2021-05-27 00:00:00
Maximum2022-02-22 00:00:00
2023-12-13T07:18:41.166613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:18:41.290902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T07:18:38.627566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:18:41.373983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴 레벨상위 메뉴 아이디메뉴 순서사용여부등록일
메뉴 레벨1.0001.0000.0000.1280.922
상위 메뉴 아이디1.0001.0000.0000.0000.956
메뉴 순서0.0000.0001.0000.2090.594
사용여부0.1280.0000.2091.0000.000
등록일0.9220.9560.5940.0001.000
2023-12-13T07:18:41.486321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용여부메뉴 레벨상위 메뉴 아이디
사용여부1.0000.2110.000
메뉴 레벨0.2111.0000.907
상위 메뉴 아이디0.0000.9071.000
2023-12-13T07:18:41.607670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴 순서메뉴 레벨상위 메뉴 아이디사용여부
메뉴 순서1.0000.0000.0000.195
메뉴 레벨0.0001.0000.9070.211
상위 메뉴 아이디0.0000.9071.0000.000
사용여부0.1950.2110.0001.000

Missing values

2023-12-13T07:18:38.754313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:18:38.861594image/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

메뉴 아이디메뉴 레벨상위 메뉴 아이디메뉴명메뉴 순서사용여부등록일
0MENU_000812MENU_00009사이트관리1Y2021-05-31
1MENU_000822MENU_00009권한그룹관리5Y2021-05-31
2MENU_000842MENU_00009메뉴 관리4Y2021-06-04
3MENU_000852MENU_00009프로그램 관리4Y2021-06-04
4MENU_000862MENU_00009사용자별 메뉴권한관리7Y2021-06-04
5MENU_000872MENU_00009시스템이력조회8N2021-06-04
6MENU_002192MENU_00009사용자관리2Y2021-06-09
7MENU_002292MENU_00009권한별 메뉴권한관리6Y2021-06-10
8MENU_002392MENU_00009공지사항관리9Y2021-06-11
9MENU_002692MENU_00005월정급여관리1Y2021-06-15
메뉴 아이디메뉴 레벨상위 메뉴 아이디메뉴명메뉴 순서사용여부등록일
214MENU_000443MENU_00025기금집행실적8Y2021-05-28
215MENU_000453MENU_00025기금운용계획 변경9Y2021-05-28
216MENU_000463MENU_00025기금운용계획변경 수신10Y2021-05-28
217MENU_000473MENU_00026국고 및 연구회계 수입코드1Y2021-05-28
218MENU_000483MENU_00026국고 및 연구회계 지출코드2Y2021-05-28
219MENU_000493MENU_00026국고 및 연구회계 수입지출매핑3Y2021-05-28
220MENU_000503MENU_00026확정예산등록4Y2021-05-28
221MENU_000513MENU_00026배정계획등록5Y2021-05-28
222MENU_000523MENU_00026월별 계획대비 실적조회6Y2021-05-28
223MENU_000531ROOT가이드 디자인10N2021-05-28