Overview

Dataset statistics

Number of variables6
Number of observations46
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory53.9 B

Variable types

Numeric3
Text1
Categorical1
Boolean1

Dataset

Description충청남도 영상물통합관리시스템 메뉴입니다. 메뉴 고유 값, 메뉴이름, 상위 메뉴값, 메뉴 순서, 메뉴 상대, 사용여부, 순서 등으로 구성되어 있습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=15&beforeMenuCd=DOM_000000201001001000&publicdatapk=15122605

Alerts

메뉴 상대 has constant value ""Constant
메뉴 고유 값 is highly overall correlated with 상위 메뉴값 and 1 other fieldsHigh correlation
상위 메뉴값 is highly overall correlated with 메뉴 고유 값 and 1 other fieldsHigh correlation
순서 is highly overall correlated with 메뉴 고유 값 and 1 other fieldsHigh correlation
사용여부 is highly imbalanced (84.9%)Imbalance
메뉴 고유 값 has unique valuesUnique
순서 has unique valuesUnique
상위 메뉴값 has 1 (2.2%) zerosZeros
순서 has 1 (2.2%) zerosZeros

Reproduction

Analysis started2024-01-09 21:44:53.194563
Analysis finished2024-01-09 21:44:54.005154
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

메뉴 고유 값
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.5
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2024-01-10T06:44:54.062592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.25
Q112.25
median23.5
Q334.75
95-th percentile43.75
Maximum46
Range45
Interquartile range (IQR)22.5

Descriptive statistics

Standard deviation13.422618
Coefficient of variation (CV)0.57117522
Kurtosis-1.2
Mean23.5
Median Absolute Deviation (MAD)11.5
Skewness0
Sum1081
Variance180.16667
MonotonicityNot monotonic
2024-01-10T06:44:54.166513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
46 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (36) 36
78.3%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
46 1
2.2%
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%

메뉴이름
Text

Distinct44
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size500.0 B
2024-01-10T06:44:54.341533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length4.8478261
Min length2

Characters and Unicode

Total characters223
Distinct characters96
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique42 ?
Unique (%)91.3%

Sample

1st row삭제현황
2nd rowMCMS
3rd row콘텐츠서비스
4th row콘텐츠서비스
5th row콘텐츠관리
ValueCountFrequency (%)
공지사항 2
 
4.3%
콘텐츠서비스 2
 
4.3%
카테고리관리 1
 
2.2%
시스템관리 1
 
2.2%
워터마크설정 1
 
2.2%
프리셋설정 1
 
2.2%
광고관리 1
 
2.2%
환경설정 1
 
2.2%
메타데이터관리 1
 
2.2%
기본메타데이터 1
 
2.2%
Other values (34) 34
73.9%
2024-01-10T06:44:54.618884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
리 10
 
4.5%
관 7
 
3.1%
이 6
 
2.7%
설 6
 
2.7%
정 6
 
2.7%
록 6
 
2.7%
등 6
 
2.7%
터 5
 
2.2%
어 5
 
2.2%
인 5
 
2.2%
Other values (86) 161
72.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 216
96.9%
Uppercase Letter 7
 
3.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 10
 
4.6%
관 7
 
3.2%
이 6
 
2.8%
설 6
 
2.8%
정 6
 
2.8%
록 6
 
2.8%
등 6
 
2.8%
터 5
 
2.3%
어 5
 
2.3%
인 5
 
2.3%
Other values (81) 154
71.3%
Uppercase Letter
ValueCountFrequency (%)
M 2
28.6%
C 2
28.6%
T 1
14.3%
S 1
14.3%
E 1
14.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 216
96.9%
Latin 7
 
3.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 10
 
4.6%
관 7
 
3.2%
이 6
 
2.8%
설 6
 
2.8%
정 6
 
2.8%
록 6
 
2.8%
등 6
 
2.8%
터 5
 
2.3%
어 5
 
2.3%
인 5
 
2.3%
Other values (81) 154
71.3%
Latin
ValueCountFrequency (%)
M 2
28.6%
C 2
28.6%
T 1
14.3%
S 1
14.3%
E 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 216
96.9%
ASCII 7
 
3.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
리 10
 
4.6%
관 7
 
3.2%
이 6
 
2.8%
설 6
 
2.8%
정 6
 
2.8%
록 6
 
2.8%
등 6
 
2.8%
터 5
 
2.3%
어 5
 
2.3%
인 5
 
2.3%
Other values (81) 154
71.3%
ASCII
ValueCountFrequency (%)
M 2
28.6%
C 2
28.6%
T 1
14.3%
S 1
14.3%
E 1
14.3%

상위 메뉴값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct12
Distinct (%)26.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.782609
Minimum0
Maximum42
Zeros1
Zeros (%)2.2%
Negative0
Negative (%)0.0%
Memory size546.0 B
2024-01-10T06:44:54.722465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q14
median16
Q330
95-th percentile42
Maximum42
Range42
Interquartile range (IQR)26

Descriptive statistics

Standard deviation13.788744
Coefficient of variation (CV)0.77540616
Kurtosis-1.2200118
Mean17.782609
Median Absolute Deviation (MAD)13
Skewness0.31957487
Sum818
Variance190.12947
MonotonicityNot monotonic
2024-01-10T06:44:54.798843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 7
15.2%
34 7
15.2%
9 6
13.0%
16 5
10.9%
42 4
8.7%
4 4
8.7%
21 4
8.7%
17 3
6.5%
29 2
 
4.3%
30 2
 
4.3%
Other values (2) 2
 
4.3%
ValueCountFrequency (%)
0 1
 
2.2%
1 7
15.2%
2 1
 
2.2%
4 4
8.7%
9 6
13.0%
16 5
10.9%
17 3
6.5%
21 4
8.7%
29 2
 
4.3%
30 2
 
4.3%
ValueCountFrequency (%)
42 4
8.7%
34 7
15.2%
30 2
 
4.3%
29 2
 
4.3%
21 4
8.7%
17 3
6.5%
16 5
10.9%
9 6
13.0%
4 4
8.7%
2 1
 
2.2%

메뉴 상대
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
S
46 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
S 46
100.0%

Length

2024-01-10T06:44:54.882969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:44:54.946971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
s 46
100.0%

사용여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size178.0 B
True
45 
False
 
1
ValueCountFrequency (%)
True 45
97.8%
False 1
 
2.2%
2024-01-10T06:44:55.000192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

순서
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.5
Minimum0
Maximum45
Zeros1
Zeros (%)2.2%
Negative0
Negative (%)0.0%
Memory size546.0 B
2024-01-10T06:44:55.080313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.25
Q111.25
median22.5
Q333.75
95-th percentile42.75
Maximum45
Range45
Interquartile range (IQR)22.5

Descriptive statistics

Standard deviation13.422618
Coefficient of variation (CV)0.59656079
Kurtosis-1.2
Mean22.5
Median Absolute Deviation (MAD)11.5
Skewness0
Sum1035
Variance180.16667
MonotonicityNot monotonic
2024-01-10T06:44:55.181650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
45 1
 
2.2%
34 1
 
2.2%
25 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
Other values (36) 36
78.3%
ValueCountFrequency (%)
0 1
2.2%
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

Interactions

2024-01-10T06:44:53.711029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.373605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.546481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.765231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.436751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.600407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.821774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.491686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:44:53.655817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T06:44:55.262677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴 고유 값메뉴이름상위 메뉴값사용여부순서
메뉴 고유 값1.0000.9720.8550.2821.000
메뉴이름0.9721.0000.9651.0000.972
상위 메뉴값0.8550.9651.0000.0000.855
사용여부0.2821.0000.0001.0000.282
순서1.0000.9720.8550.2821.000
2024-01-10T06:44:55.338923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴 고유 값상위 메뉴값순서사용여부
메뉴 고유 값1.0000.7731.0000.185
상위 메뉴값0.7731.0000.7730.000
순서1.0000.7731.0000.185
사용여부0.1850.0000.1851.000

Missing values

2024-01-10T06:44:53.897560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:44:53.974092image/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

메뉴 고유 값메뉴이름상위 메뉴값메뉴 상대사용여부순서
046삭제현황42SY45
11MCMS0SY0
22콘텐츠서비스1SY1
33콘텐츠서비스2SY2
44콘텐츠관리1SY3
55동영상등록4SY4
66이미지등록4SY5
77오디오등록4SY6
88ETC등록4SY7
99통계관리1SY8
메뉴 고유 값메뉴이름상위 메뉴값메뉴 상대사용여부순서
3636사용자34SY35
3737부서34SY36
3838권한34SY37
3939금칙어34SY38
4040모니터링34SY39
4141감사추적34SN40
4242마이페이지1SY41
4343등록콘텐츠42SY42
4444다운로드내역42SY43
4545공지사항42SY44