Overview

Dataset statistics

Number of variables5
Number of observations101
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory44.3 B

Variable types

Text2
Numeric3

Dataset

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

Alerts

메뉴번호 is highly overall correlated with 상위메뉴번호High correlation
상위메뉴번호 is highly overall correlated with 메뉴번호High correlation
메뉴번호 has unique valuesUnique
상위메뉴번호 has 12 (11.9%) zerosZeros
메뉴순서 has 2 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-12 06:58:06.154611
Analysis finished2023-12-12 06:58:07.623445
Duration1.47 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

메뉴명
Text

Distinct92
Distinct (%)91.1%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-12T15:58:07.838176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.029703
Min length2

Characters and Unicode

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

Unique

Unique84 ?
Unique (%)83.2%

Sample

1st row전체
2nd row전체
3rd row갤러리
4th row드림주니어
5th row진로교육 자료
ValueCountFrequency (%)
전체 3
 
2.5%
학부모교육 3
 
2.5%
갤러리 2
 
1.7%
학부모on누리 2
 
1.7%
자료 2
 
1.7%
교육뉴스 2
 
1.7%
초등학교 2
 
1.7%
및 2
 
1.7%
강의실 2
 
1.7%
나의 2
 
1.7%
Other values (95) 99
81.8%
2023-12-12T15:58:08.289784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 25
 
4.9%
20
 
3.9%
교 18
 
3.5%
부 14
 
2.8%
원 13
 
2.6%
전 12
 
2.4%
모 12
 
2.4%
육 11
 
2.2%
지 10
 
2.0%
도 10
 
2.0%
Other values (155) 363
71.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 460
90.6%
Space Separator 20
 
3.9%
Lowercase Letter 15
 
3.0%
Connector Punctuation 5
 
1.0%
Other Punctuation 4
 
0.8%
Dash Punctuation 2
 
0.4%
Uppercase Letter 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 25
 
5.4%
교 18
 
3.9%
부 14
 
3.0%
원 13
 
2.8%
전 12
 
2.6%
모 12
 
2.6%
육 11
 
2.4%
지 10
 
2.2%
도 10
 
2.2%
터 9
 
2.0%
Other values (141) 326
70.9%
Lowercase Letter
ValueCountFrequency (%)
e 6
40.0%
n 2
 
13.3%
o 2
 
13.3%
b 1
 
6.7%
t 1
 
6.7%
r 1
 
6.7%
a 1
 
6.7%
k 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
· 3
75.0%
/ 1
 
25.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
O 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 460
90.6%
Common 31
 
6.1%
Latin 17
 
3.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 25
 
5.4%
교 18
 
3.9%
부 14
 
3.0%
원 13
 
2.8%
전 12
 
2.6%
모 12
 
2.6%
육 11
 
2.4%
지 10
 
2.2%
도 10
 
2.2%
터 9
 
2.0%
Other values (141) 326
70.9%
Latin
ValueCountFrequency (%)
e 6
35.3%
O 2
 
11.8%
n 2
 
11.8%
o 2
 
11.8%
b 1
 
5.9%
t 1
 
5.9%
r 1
 
5.9%
a 1
 
5.9%
k 1
 
5.9%
Common
ValueCountFrequency (%)
20
64.5%
_ 5
 
16.1%
· 3
 
9.7%
- 2
 
6.5%
/ 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 460
90.6%
ASCII 45
 
8.9%
None 3
 
0.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 25
 
5.4%
교 18
 
3.9%
부 14
 
3.0%
원 13
 
2.8%
전 12
 
2.6%
모 12
 
2.6%
육 11
 
2.4%
지 10
 
2.2%
도 10
 
2.2%
터 9
 
2.0%
Other values (141) 326
70.9%
ASCII
ValueCountFrequency (%)
20
44.4%
e 6
 
13.3%
_ 5
 
11.1%
- 2
 
4.4%
O 2
 
4.4%
n 2
 
4.4%
o 2
 
4.4%
b 1
 
2.2%
t 1
 
2.2%
r 1
 
2.2%
Other values (3) 3
 
6.7%
None
ValueCountFrequency (%)
· 3
100.0%

메뉴번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3602206.6
Minimum0
Maximum10320000
Zeros1
Zeros (%)1.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T15:58:08.517754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1010400
Q11060107
median3020000
Q35050000
95-th percentile9020000
Maximum10320000
Range10320000
Interquartile range (IQR)3989893

Descriptive statistics

Standard deviation2748358.6
Coefficient of variation (CV)0.76296528
Kurtosis-0.39947196
Mean3602206.6
Median Absolute Deviation (MAD)1959899
Skewness0.82719758
Sum3.6382287 × 108
Variance7.5534751 × 1012
MonotonicityNot monotonic
2023-12-12T15:58:08.689371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1060118 1
 
1.0%
1010000 1
 
1.0%
7030000 1
 
1.0%
7020000 1
 
1.0%
7010000 1
 
1.0%
7000000 1
 
1.0%
4050000 1
 
1.0%
1060100 1
 
1.0%
1060000 1
 
1.0%
6020000 1
 
1.0%
Other values (91) 91
90.1%
ValueCountFrequency (%)
0 1
1.0%
1010000 1
1.0%
1010100 1
1.0%
1010200 1
1.0%
1010300 1
1.0%
1010400 1
1.0%
1010500 1
1.0%
1010510 1
1.0%
1010520 1
1.0%
1010530 1
1.0%
ValueCountFrequency (%)
10320000 1
1.0%
10010000 1
1.0%
10000000 1
1.0%
9040000 1
1.0%
9030000 1
1.0%
9020000 1
1.0%
9010000 1
1.0%
9000000 1
1.0%
8050000 1
1.0%
8040000 1
1.0%

상위메뉴번호
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct21
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3030661.4
Minimum0
Maximum10300000
Zeros12
Zeros (%)11.9%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T15:58:09.228894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11040000
median2000000
Q34110000
95-th percentile9000000
Maximum10300000
Range10300000
Interquartile range (IQR)3070000

Descriptive statistics

Standard deviation2714219.8
Coefficient of variation (CV)0.89558663
Kurtosis0.016410869
Mean3030661.4
Median Absolute Deviation (MAD)2000000
Skewness0.96839423
Sum3.060968 × 108
Variance7.3669893 × 1012
MonotonicityNot monotonic
2023-12-12T15:58:09.398292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1060100 18
17.8%
0 12
11.9%
4000000 9
 
8.9%
5000000 9
 
8.9%
2000000 6
 
5.9%
8000000 5
 
5.0%
3000000 5
 
5.0%
1000000 5
 
5.0%
1010500 4
 
4.0%
1010000 4
 
4.0%
Other values (11) 24
23.8%
ValueCountFrequency (%)
0 12
11.9%
1000000 5
 
5.0%
1010000 4
 
4.0%
1010500 4
 
4.0%
1040000 2
 
2.0%
1060000 1
 
1.0%
1060100 18
17.8%
2000000 6
 
5.9%
2030000 3
 
3.0%
3000000 5
 
5.0%
ValueCountFrequency (%)
10300000 1
 
1.0%
10000000 1
 
1.0%
9000000 4
4.0%
8000000 5
5.0%
7000000 3
 
3.0%
6000000 2
 
2.0%
5000000 9
8.9%
4110000 3
 
3.0%
4021000 3
 
3.0%
4000000 9
8.9%

메뉴순서
Real number (ℝ)

ZEROS 

Distinct23
Distinct (%)22.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean114.20792
Minimum0
Maximum9999
Zeros2
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T15:58:09.536882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q36
95-th percentile17
Maximum9999
Range9999
Interquartile range (IQR)4

Descriptive statistics

Standard deviation998.34672
Coefficient of variation (CV)8.741484
Kurtosis98.962641
Mean114.20792
Median Absolute Deviation (MAD)2
Skewness9.9082714
Sum11535
Variance996696.17
MonotonicityNot monotonic
2023-12-12T15:58:09.675834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
1 20
19.8%
3 16
15.8%
2 15
14.9%
4 12
11.9%
5 7
 
6.9%
6 6
 
5.9%
8 4
 
4.0%
7 3
 
3.0%
9 3
 
3.0%
0 2
 
2.0%
Other values (13) 13
12.9%
ValueCountFrequency (%)
0 2
 
2.0%
1 20
19.8%
2 15
14.9%
3 16
15.8%
4 12
11.9%
5 7
 
6.9%
6 6
 
5.9%
7 3
 
3.0%
8 4
 
4.0%
9 3
 
3.0%
ValueCountFrequency (%)
9999 1
1.0%
999 1
1.0%
55 1
1.0%
44 1
1.0%
33 1
1.0%
17 1
1.0%
16 1
1.0%
15 1
1.0%
14 1
1.0%
13 1
1.0%

관계이미지경로
Text

Distinct94
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-12T15:58:09.957384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length5.2178218
Min length2

Characters and Unicode

Total characters527
Distinct characters166
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique88 ?
Unique (%)87.1%

Sample

1st row전체
2nd row전체
3rd row갤러리
4th row드림주니어
5th row진로교육 자료
ValueCountFrequency (%)
전체 3
 
2.4%
및 3
 
2.4%
학부모교육 3
 
2.4%
자료 2
 
1.6%
학부모 2
 
1.6%
e-도서관 2
 
1.6%
학부모on누리 2
 
1.6%
안내 2
 
1.6%
초등학교 2
 
1.6%
학습후기 2
 
1.6%
Other values (97) 100
81.3%
2023-12-12T15:58:10.401649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 26
 
4.9%
22
 
4.2%
교 20
 
3.8%
부 16
 
3.0%
모 14
 
2.7%
육 13
 
2.5%
원 12
 
2.3%
전 12
 
2.3%
터 10
 
1.9%
도 10
 
1.9%
Other values (156) 372
70.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 474
89.9%
Space Separator 22
 
4.2%
Lowercase Letter 15
 
2.8%
Connector Punctuation 5
 
0.9%
Other Punctuation 4
 
0.8%
Uppercase Letter 3
 
0.6%
Dash Punctuation 2
 
0.4%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 26
 
5.5%
교 20
 
4.2%
부 16
 
3.4%
모 14
 
3.0%
육 13
 
2.7%
원 12
 
2.5%
전 12
 
2.5%
터 10
 
2.1%
도 10
 
2.1%
지 10
 
2.1%
Other values (139) 331
69.8%
Lowercase Letter
ValueCountFrequency (%)
e 6
40.0%
n 2
 
13.3%
o 2
 
13.3%
b 1
 
6.7%
t 1
 
6.7%
a 1
 
6.7%
k 1
 
6.7%
r 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
· 3
75.0%
/ 1
 
25.0%
Uppercase Letter
ValueCountFrequency (%)
O 2
66.7%
N 1
33.3%
Space Separator
ValueCountFrequency (%)
22
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 474
89.9%
Common 35
 
6.6%
Latin 18
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 26
 
5.5%
교 20
 
4.2%
부 16
 
3.4%
모 14
 
3.0%
육 13
 
2.7%
원 12
 
2.5%
전 12
 
2.5%
터 10
 
2.1%
도 10
 
2.1%
지 10
 
2.1%
Other values (139) 331
69.8%
Latin
ValueCountFrequency (%)
e 6
33.3%
n 2
 
11.1%
o 2
 
11.1%
O 2
 
11.1%
N 1
 
5.6%
b 1
 
5.6%
t 1
 
5.6%
a 1
 
5.6%
k 1
 
5.6%
r 1
 
5.6%
Common
ValueCountFrequency (%)
22
62.9%
_ 5
 
14.3%
· 3
 
8.6%
- 2
 
5.7%
( 1
 
2.9%
) 1
 
2.9%
/ 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 473
89.8%
ASCII 50
 
9.5%
None 3
 
0.6%
Compat Jamo 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 26
 
5.5%
교 20
 
4.2%
부 16
 
3.4%
모 14
 
3.0%
육 13
 
2.7%
원 12
 
2.5%
전 12
 
2.5%
터 10
 
2.1%
도 10
 
2.1%
지 10
 
2.1%
Other values (138) 330
69.8%
ASCII
ValueCountFrequency (%)
22
44.0%
e 6
 
12.0%
_ 5
 
10.0%
n 2
 
4.0%
o 2
 
4.0%
O 2
 
4.0%
- 2
 
4.0%
N 1
 
2.0%
( 1
 
2.0%
) 1
 
2.0%
Other values (6) 6
 
12.0%
None
ValueCountFrequency (%)
· 3
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅇ 1
100.0%

Interactions

2023-12-12T15:58:07.271588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:06.828782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:07.053443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:07.340622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:06.909361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:07.128225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:07.416642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:06.980309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:07.199482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:58:10.500048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴명메뉴번호상위메뉴번호메뉴순서관계이미지경로
메뉴명1.0000.8790.3110.0001.000
메뉴번호0.8791.0000.9940.3590.947
상위메뉴번호0.3110.9941.0000.0000.444
메뉴순서0.0000.3590.0001.0001.000
관계이미지경로1.0000.9470.4441.0001.000
2023-12-12T15:58:10.590379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴번호상위메뉴번호메뉴순서
메뉴번호1.0000.706-0.018
상위메뉴번호0.7061.000-0.146
메뉴순서-0.018-0.1461.000

Missing values

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

메뉴명메뉴번호상위메뉴번호메뉴순서관계이미지경로
0전체106011810601000전체
1전체301010030100001전체
2갤러리305000030000003갤러리
3드림주니어410000041100004드림주니어
4진로교육 자료411000040000006진로교육 자료
5학부모On누리 웹진408000040000004학부모On누리 웹진
6드림레터407000041100001드림레터
7진로레시피_bak409000041100003진로레시피_bak
8전국학부모지원센터_e402110040210001전국학부모지원센터_e
9지역학부모지원센터_e402120040210002지역학부모지원센터_e
메뉴명메뉴번호상위메뉴번호메뉴순서관계이미지경로
91강원도1060110106010010강원도
92충남1060111106010011충남
93충북1060112106010012충북
94경남1060113106010013경남
95경북1060114106010014경북
96전남1060115106010015전남
97전북1060116106010016전북
98제주1060117106010017제주
99학부모자녀교육정보101050010000001학부모자녀교육정보
100대전106010210601002대전