Overview

Dataset statistics

Number of variables4
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory34.8 B

Variable types

Text1
Categorical3

Dataset

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

Alerts

매핑파일경로 has constant value ""Constant
매핑생성ID has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:04:58.720320
Analysis finished2023-12-12 06:04:59.081548
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

매핑생성ID
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-12T15:04:59.273188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length12.395833
Min length9

Characters and Unicode

Total characters595
Distinct characters24
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

Unique48 ?
Unique (%)100.0%

Sample

1st rowROLE_ANONYMOUS
2nd rowROLE_ANONYMOUS1
3rd rowROLE_USER
4th rowROLE_ADMIN
5th rowROLE_ANONYMOUS2
ValueCountFrequency (%)
role_anonymous 1
 
2.1%
role_anonymous1 1
 
2.1%
role_user11 1
 
2.1%
role_admin7 1
 
2.1%
role_user8 1
 
2.1%
role_anonymous11 1
 
2.1%
role_user9 1
 
2.1%
role_admin8 1
 
2.1%
role_anonymous12 1
 
2.1%
role_user10 1
 
2.1%
Other values (38) 38
79.2%
2023-12-12T15:04:59.755579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
O 84
14.1%
R 65
10.9%
E 64
10.8%
N 49
8.2%
L 48
8.1%
_ 48
8.1%
U 33
 
5.5%
S 33
 
5.5%
M 32
 
5.4%
A 31
 
5.2%
Other values (14) 108
18.2%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 486
81.7%
Decimal Number 61
 
10.3%
Connector Punctuation 48
 
8.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
O 84
17.3%
R 65
13.4%
E 64
13.2%
N 49
10.1%
L 48
9.9%
U 33
 
6.8%
S 33
 
6.8%
M 32
 
6.6%
A 31
 
6.4%
Y 17
 
3.5%
Other values (3) 30
 
6.2%
Decimal Number
ValueCountFrequency (%)
1 23
37.7%
2 6
 
9.8%
3 6
 
9.8%
4 5
 
8.2%
5 5
 
8.2%
6 4
 
6.6%
9 3
 
4.9%
7 3
 
4.9%
8 3
 
4.9%
0 3
 
4.9%
Connector Punctuation
ValueCountFrequency (%)
_ 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 486
81.7%
Common 109
 
18.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
O 84
17.3%
R 65
13.4%
E 64
13.2%
N 49
10.1%
L 48
9.9%
U 33
 
6.8%
S 33
 
6.8%
M 32
 
6.6%
A 31
 
6.4%
Y 17
 
3.5%
Other values (3) 30
 
6.2%
Common
ValueCountFrequency (%)
_ 48
44.0%
1 23
21.1%
2 6
 
5.5%
3 6
 
5.5%
4 5
 
4.6%
5 5
 
4.6%
6 4
 
3.7%
9 3
 
2.8%
7 3
 
2.8%
8 3
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 595
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
O 84
14.1%
R 65
10.9%
E 64
10.8%
N 49
8.2%
L 48
8.1%
_ 48
8.1%
U 33
 
5.5%
S 33
 
5.5%
M 32
 
5.4%
A 31
 
5.2%
Other values (14) 108
18.2%

생성자ID
Categorical

Distinct2
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size516.0 B
onion
41 
admin
7 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
onion 41
85.4%
admin 7
 
14.6%

Length

2023-12-12T15:04:59.914524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:05:00.032890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
onion 41
85.4%
admin 7
 
14.6%

매핑파일명
Categorical

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
ROLE_ANONYMOUS_SiteMap.jsp
17 
ROLE_USER_SiteMap.jsp
16 
ROLE_ADMIN_SiteMap.jsp
14 
ROLE_MONITOR_SiteMap.jsp
 
1

Length

Max length26
Median length24
Mean length23.125
Min length21

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st rowROLE_ANONYMOUS_SiteMap.jsp
2nd rowROLE_ANONYMOUS_SiteMap.jsp
3rd rowROLE_USER_SiteMap.jsp
4th rowROLE_ADMIN_SiteMap.jsp
5th rowROLE_ANONYMOUS_SiteMap.jsp

Common Values

ValueCountFrequency (%)
ROLE_ANONYMOUS_SiteMap.jsp 17
35.4%
ROLE_USER_SiteMap.jsp 16
33.3%
ROLE_ADMIN_SiteMap.jsp 14
29.2%
ROLE_MONITOR_SiteMap.jsp 1
 
2.1%

Length

2023-12-12T15:05:00.152132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:05:00.250731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
role_anonymous_sitemap.jsp 17
35.4%
role_user_sitemap.jsp 16
33.3%
role_admin_sitemap.jsp 14
29.2%
role_monitor_sitemap.jsp 1
 
2.1%

매핑파일경로
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size516.0 B
/html/egovframework/com/sym/mnu/mcm/
48 

Length

Max length36
Median length36
Mean length36
Min length36

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row/html/egovframework/com/sym/mnu/mcm/
2nd row/html/egovframework/com/sym/mnu/mcm/
3rd row/html/egovframework/com/sym/mnu/mcm/
4th row/html/egovframework/com/sym/mnu/mcm/
5th row/html/egovframework/com/sym/mnu/mcm/

Common Values

ValueCountFrequency (%)
/html/egovframework/com/sym/mnu/mcm/ 48
100.0%

Length

2023-12-12T15:05:00.384082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:05:00.488884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
html/egovframework/com/sym/mnu/mcm 48
100.0%

Correlations

2023-12-12T15:05:00.555475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
매핑생성ID생성자ID매핑파일명
매핑생성ID1.0001.0001.000
생성자ID1.0001.0000.000
매핑파일명1.0000.0001.000
2023-12-12T15:05:00.650589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
생성자ID매핑파일명
생성자ID1.0000.000
매핑파일명0.0001.000
2023-12-12T15:05:00.757020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
생성자ID매핑파일명
생성자ID1.0000.000
매핑파일명0.0001.000

Missing values

2023-12-12T15:04:58.918452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:04:59.037410image/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

매핑생성ID생성자ID매핑파일명매핑파일경로
0ROLE_ANONYMOUSadminROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
1ROLE_ANONYMOUS1adminROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
2ROLE_USERadminROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
3ROLE_ADMINadminROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
4ROLE_ANONYMOUS2adminROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
5ROLE_ADMIN1adminROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
6ROLE_USER1adminROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
7ROLE_USER2onionROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
8ROLE_ADMIN2onionROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
9ROLE_ANONYMOUS3onionROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
매핑생성ID생성자ID매핑파일명매핑파일경로
38ROLE_USER12onionROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
39ROLE_ANONYMOUS15onionROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
40ROLE_USER13onionROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
41ROLE_ADMIN11onionROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
42ROLE_USER14onionROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
43ROLE_ADMIN12onionROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
44ROLE_ANONYMOUS16onionROLE_ANONYMOUS_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
45ROLE_USER15onionROLE_USER_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
46ROLE_ADMIN13onionROLE_ADMIN_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/
47ROLE_MONITORonionROLE_MONITOR_SiteMap.jsp/html/egovframework/com/sym/mnu/mcm/