Overview

Dataset statistics

Number of variables15
Number of observations831
Missing cells8874
Missing cells (%)71.2%
Duplicate rows12
Duplicate rows (%)1.4%
Total size in memory98.3 KiB
Average record size in memory121.2 B

Variable types

Text8
Boolean3
DateTime3
Unsupported1

Dataset

Description산림복지서비스이용권시스템에서 추출한 시스템관리용정보입니다.
Author한국산림복지진흥원
URLhttps://www.data.go.kr/data/15088991/fileData.do

Alerts

공통코드명(CL_CODE_NM) has constant value ""Constant
공통코드설명(CL_CODE_DC) has constant value ""Constant
사용여부(USE_AT) has constant value ""Constant
등록일자(FRST_REGISTER_PNTTM) has constant value ""Constant
수정일자(LAST_UPDUSR_PNTTM) has constant value ""Constant
사용여부(USE_AT).2 has constant value ""Constant
등록일자(FRST_REGISTER_PNTTM).2 has constant value ""Constant
Dataset has 12 (1.4%) duplicate rowsDuplicates
사용여부(USE_AT).1 is highly imbalanced (63.0%)Imbalance
공통코드명(CL_CODE_NM) has 830 (99.9%) missing valuesMissing
공통코드설명(CL_CODE_DC) has 830 (99.9%) missing valuesMissing
사용여부(USE_AT) has 830 (99.9%) missing valuesMissing
등록일자(FRST_REGISTER_PNTTM) has 830 (99.9%) missing valuesMissing
수정일자(LAST_UPDUSR_PNTTM) has 830 (99.9%) missing valuesMissing
코드설명(CODE_DC) has 22 (2.6%) missing valuesMissing
등록일자(FRST_REGISTER_PNTTM).1 has 239 (28.8%) missing valuesMissing
수정일자(LAST_UPDUSR_PNTTM).1 has 320 (38.5%) missing valuesMissing
템플릿명(TMPLAT_NM) has 828 (99.6%) missing valuesMissing
사용여부(USE_AT).2 has 828 (99.6%) missing valuesMissing
등록일자(FRST_REGISTER_PNTTM).2 has 828 (99.6%) missing valuesMissing
수정일자(LAST_UPDUSR_PNTTM).2 has 831 (100.0%) missing valuesMissing
템플릿 개별코드(TMPLAT_SE_CODE) has 828 (99.6%) missing valuesMissing
수정일자(LAST_UPDUSR_PNTTM).2 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 08:05:39.970758
Analysis finished2023-12-12 08:05:41.418309
Duration1.45 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공통코드명(CL_CODE_NM)
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing830
Missing (%)99.9%
Memory size6.6 KiB
2023-12-12T17:05:41.504355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

Total characters16
Distinct characters15
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

Unique1 ?
Unique (%)100.0%

Sample

1st row전자정부 프레임워크 공통서비스
ValueCountFrequency (%)
전자정부 1
33.3%
프레임워크 1
33.3%
공통서비스 1
33.3%
2023-12-12T17:05:41.804677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2
 
12.5%
전 1
 
6.2%
자 1
 
6.2%
정 1
 
6.2%
부 1
 
6.2%
프 1
 
6.2%
레 1
 
6.2%
임 1
 
6.2%
워 1
 
6.2%
크 1
 
6.2%
Other values (5) 5
31.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14
87.5%
Space Separator 2
 
12.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14
87.5%
Common 2
 
12.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14
87.5%
ASCII 2
 
12.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2
100.0%
Hangul
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%

공통코드설명(CL_CODE_DC)
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing830
Missing (%)99.9%
Memory size6.6 KiB
2023-12-12T17:05:41.979466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

Total characters16
Distinct characters15
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

Unique1 ?
Unique (%)100.0%

Sample

1st row전자정부 프레임워크 공통서비스
ValueCountFrequency (%)
전자정부 1
33.3%
프레임워크 1
33.3%
공통서비스 1
33.3%
2023-12-12T17:05:42.282510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2
 
12.5%
전 1
 
6.2%
자 1
 
6.2%
정 1
 
6.2%
부 1
 
6.2%
프 1
 
6.2%
레 1
 
6.2%
임 1
 
6.2%
워 1
 
6.2%
크 1
 
6.2%
Other values (5) 5
31.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14
87.5%
Space Separator 2
 
12.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14
87.5%
Common 2
 
12.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14
87.5%
ASCII 2
 
12.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2
100.0%
Hangul
ValueCountFrequency (%)
전 1
 
7.1%
자 1
 
7.1%
정 1
 
7.1%
부 1
 
7.1%
프 1
 
7.1%
레 1
 
7.1%
임 1
 
7.1%
워 1
 
7.1%
크 1
 
7.1%
공 1
 
7.1%
Other values (4) 4
28.6%

사용여부(USE_AT)
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing830
Missing (%)99.9%
Memory size1.8 KiB
True
 
1
(Missing)
830 
ValueCountFrequency (%)
True 1
 
0.1%
(Missing) 830
99.9%
2023-12-12T17:05:42.423910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일자(FRST_REGISTER_PNTTM)
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing830
Missing (%)99.9%
Memory size6.6 KiB
Minimum2023-12-12 18:31:00
Maximum2023-12-12 18:31:00
2023-12-12T17:05:42.527052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:05:42.653301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

수정일자(LAST_UPDUSR_PNTTM)
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing830
Missing (%)99.9%
Memory size6.6 KiB
Minimum2023-12-12 18:31:00
Maximum2023-12-12 18:31:00
2023-12-12T17:05:42.762138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:05:42.884643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

코드명(CODE_NM)
Text

Distinct715
Distinct (%)86.0%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
2023-12-12T17:05:43.220768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length6.6907341
Min length1

Characters and Unicode

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

Unique

Unique666 ?
Unique (%)80.1%

Sample

1st row커뮤니티 글쓰기 롤
2nd row커뮤니티 글 수정/삭제 롤
3rd row파일 업로드 롤
4th row일반 회원 유형
5th row기업 회원 유형
ValueCountFrequency (%)
롤 34
 
2.6%
경기도 31
 
2.4%
서울특별시 25
 
1.9%
경상북도 23
 
1.8%
전라남도 22
 
1.7%
강원도 18
 
1.4%
경상남도 18
 
1.4%
부산광역시 16
 
1.2%
충청남도 15
 
1.2%
전라북도 14
 
1.1%
Other values (732) 1070
83.2%
2023-12-12T17:05:43.748548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
455
 
8.2%
시 221
 
4.0%
도 169
 
3.0%
기 117
 
2.1%
상 108
 
1.9%
경 99
 
1.8%
자 89
 
1.6%
구 89
 
1.6%
군 86
 
1.5%
수 81
 
1.5%
Other values (395) 4046
72.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4683
84.2%
Space Separator 455
 
8.2%
Lowercase Letter 138
 
2.5%
Decimal Number 77
 
1.4%
Uppercase Letter 64
 
1.2%
Dash Punctuation 59
 
1.1%
Other Punctuation 42
 
0.8%
Close Punctuation 20
 
0.4%
Open Punctuation 20
 
0.4%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 221
 
4.7%
도 169
 
3.6%
기 117
 
2.5%
상 108
 
2.3%
경 99
 
2.1%
자 89
 
1.9%
구 89
 
1.9%
군 86
 
1.8%
수 81
 
1.7%
급 77
 
1.6%
Other values (333) 3547
75.7%
Lowercase Letter
ValueCountFrequency (%)
o 21
15.2%
m 20
14.5%
c 17
12.3%
a 16
11.6%
e 9
6.5%
l 9
6.5%
n 7
 
5.1%
h 7
 
5.1%
r 6
 
4.3%
i 6
 
4.3%
Other values (12) 20
14.5%
Uppercase Letter
ValueCountFrequency (%)
L 13
20.3%
N 9
14.1%
U 8
12.5%
M 6
9.4%
S 6
9.4%
T 3
 
4.7%
I 3
 
4.7%
P 3
 
4.7%
O 2
 
3.1%
C 2
 
3.1%
Other values (8) 9
14.1%
Decimal Number
ValueCountFrequency (%)
1 20
26.0%
0 11
14.3%
3 10
13.0%
2 10
13.0%
4 8
 
10.4%
5 7
 
9.1%
6 5
 
6.5%
7 3
 
3.9%
9 2
 
2.6%
8 1
 
1.3%
Other Punctuation
ValueCountFrequency (%)
. 15
35.7%
? 13
31.0%
, 7
16.7%
/ 6
 
14.3%
@ 1
 
2.4%
Close Punctuation
ValueCountFrequency (%)
) 13
65.0%
] 7
35.0%
Open Punctuation
ValueCountFrequency (%)
( 13
65.0%
[ 7
35.0%
Space Separator
ValueCountFrequency (%)
455
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 59
100.0%
Math Symbol
ValueCountFrequency (%)
= 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4683
84.2%
Common 675
 
12.1%
Latin 202
 
3.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 221
 
4.7%
도 169
 
3.6%
기 117
 
2.5%
상 108
 
2.3%
경 99
 
2.1%
자 89
 
1.9%
구 89
 
1.9%
군 86
 
1.8%
수 81
 
1.7%
급 77
 
1.6%
Other values (333) 3547
75.7%
Latin
ValueCountFrequency (%)
o 21
 
10.4%
m 20
 
9.9%
c 17
 
8.4%
a 16
 
7.9%
L 13
 
6.4%
e 9
 
4.5%
N 9
 
4.5%
l 9
 
4.5%
U 8
 
4.0%
n 7
 
3.5%
Other values (30) 73
36.1%
Common
ValueCountFrequency (%)
455
67.4%
- 59
 
8.7%
1 20
 
3.0%
. 15
 
2.2%
? 13
 
1.9%
) 13
 
1.9%
( 13
 
1.9%
0 11
 
1.6%
3 10
 
1.5%
2 10
 
1.5%
Other values (12) 56
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4683
84.2%
ASCII 877
 
15.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
455
51.9%
- 59
 
6.7%
o 21
 
2.4%
1 20
 
2.3%
m 20
 
2.3%
c 17
 
1.9%
a 16
 
1.8%
. 15
 
1.7%
? 13
 
1.5%
) 13
 
1.5%
Other values (52) 228
26.0%
Hangul
ValueCountFrequency (%)
시 221
 
4.7%
도 169
 
3.6%
기 117
 
2.5%
상 108
 
2.3%
경 99
 
2.1%
자 89
 
1.9%
구 89
 
1.9%
군 86
 
1.8%
수 81
 
1.7%
급 77
 
1.6%
Other values (333) 3547
75.7%

코드설명(CODE_DC)
Text

MISSING 

Distinct474
Distinct (%)58.6%
Missing22
Missing (%)2.6%
Memory size6.6 KiB
2023-12-12T17:05:44.055599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length5.9394314
Min length1

Characters and Unicode

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

Unique

Unique425 ?
Unique (%)52.5%

Sample

1st row커뮤니티 글쓰기 롤
2nd row커뮤니티 글 수정/삭제 롤
3rd row파일 업로드 롤
4th row일반 회원 유형
5th row기업 회원 유형
ValueCountFrequency (%)
발급사유코드 53
 
4.8%
롤 34
 
3.1%
경기도 31
 
2.8%
서울특별시 25
 
2.3%
경상북도 23
 
2.1%
전라남도 22
 
2.0%
강원도 18
 
1.6%
통계사용순서 18
 
1.6%
경상남도 18
 
1.6%
부산광역시 16
 
1.5%
Other values (515) 842
76.5%
2023-12-12T17:05:44.534623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
292
 
6.1%
도 171
 
3.6%
시 144
 
3.0%
사 131
 
2.7%
경 104
 
2.2%
상 84
 
1.7%
자 83
 
1.7%
서 77
 
1.6%
기 76
 
1.6%
급 71
 
1.5%
Other values (364) 3572
74.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4080
84.9%
Space Separator 292
 
6.1%
Lowercase Letter 156
 
3.2%
Uppercase Letter 86
 
1.8%
Other Punctuation 82
 
1.7%
Decimal Number 75
 
1.6%
Close Punctuation 16
 
0.3%
Open Punctuation 16
 
0.3%
Connector Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 171
 
4.2%
시 144
 
3.5%
사 131
 
3.2%
경 104
 
2.5%
상 84
 
2.1%
자 83
 
2.0%
서 77
 
1.9%
기 76
 
1.9%
급 71
 
1.7%
발 68
 
1.7%
Other values (303) 3071
75.3%
Lowercase Letter
ValueCountFrequency (%)
o 22
14.1%
m 21
13.5%
c 18
11.5%
a 16
10.3%
e 11
 
7.1%
l 9
 
5.8%
h 8
 
5.1%
n 8
 
5.1%
r 7
 
4.5%
i 7
 
4.5%
Other values (12) 29
18.6%
Uppercase Letter
ValueCountFrequency (%)
J 8
 
9.3%
M 7
 
8.1%
S 7
 
8.1%
I 6
 
7.0%
G 5
 
5.8%
A 5
 
5.8%
C 5
 
5.8%
E 5
 
5.8%
F 5
 
5.8%
P 4
 
4.7%
Other values (11) 29
33.7%
Decimal Number
ValueCountFrequency (%)
1 18
24.0%
3 11
14.7%
4 10
13.3%
0 10
13.3%
2 9
12.0%
5 7
 
9.3%
6 5
 
6.7%
7 3
 
4.0%
9 1
 
1.3%
8 1
 
1.3%
Other Punctuation
ValueCountFrequency (%)
. 55
67.1%
? 13
 
15.9%
/ 7
 
8.5%
, 7
 
8.5%
Space Separator
ValueCountFrequency (%)
292
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4080
84.9%
Common 483
 
10.1%
Latin 242
 
5.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 171
 
4.2%
시 144
 
3.5%
사 131
 
3.2%
경 104
 
2.5%
상 84
 
2.1%
자 83
 
2.0%
서 77
 
1.9%
기 76
 
1.9%
급 71
 
1.7%
발 68
 
1.7%
Other values (303) 3071
75.3%
Latin
ValueCountFrequency (%)
o 22
 
9.1%
m 21
 
8.7%
c 18
 
7.4%
a 16
 
6.6%
e 11
 
4.5%
l 9
 
3.7%
J 8
 
3.3%
h 8
 
3.3%
n 8
 
3.3%
M 7
 
2.9%
Other values (33) 114
47.1%
Common
ValueCountFrequency (%)
292
60.5%
. 55
 
11.4%
1 18
 
3.7%
) 16
 
3.3%
( 16
 
3.3%
? 13
 
2.7%
3 11
 
2.3%
4 10
 
2.1%
0 10
 
2.1%
2 9
 
1.9%
Other values (8) 33
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4080
84.9%
ASCII 725
 
15.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
292
40.3%
. 55
 
7.6%
o 22
 
3.0%
m 21
 
2.9%
1 18
 
2.5%
c 18
 
2.5%
a 16
 
2.2%
) 16
 
2.2%
( 16
 
2.2%
? 13
 
1.8%
Other values (51) 238
32.8%
Hangul
ValueCountFrequency (%)
도 171
 
4.2%
시 144
 
3.5%
사 131
 
3.2%
경 104
 
2.5%
상 84
 
2.1%
자 83
 
2.0%
서 77
 
1.9%
기 76
 
1.9%
급 71
 
1.7%
발 68
 
1.7%
Other values (303) 3071
75.3%

사용여부(USE_AT).1
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size963.0 B
True
772 
False
 
59
ValueCountFrequency (%)
True 772
92.9%
False 59
 
7.1%
2023-12-12T17:05:44.701546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일자(FRST_REGISTER_PNTTM).1
Text

MISSING 

Distinct239
Distinct (%)40.4%
Missing239
Missing (%)28.8%
Memory size6.6 KiB
2023-12-12T17:05:44.870563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

Total characters4144
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique203 ?
Unique (%)34.3%

Sample

1st row18:33.0
2nd row18:33.0
3rd row18:33.0
4th row18:33.0
5th row18:33.0
ValueCountFrequency (%)
18:34.0 71
 
12.0%
18:32.0 66
 
11.1%
18:33.0 52
 
8.8%
00:00.0 44
 
7.4%
16:04.0 29
 
4.9%
21:48.0 16
 
2.7%
05:05.0 12
 
2.0%
18:35.0 10
 
1.7%
22:34.0 7
 
1.2%
22:39.0 7
 
1.2%
Other values (229) 278
47.0%
2023-12-12T17:05:45.295723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 956
23.1%
: 592
14.3%
. 592
14.3%
3 424
10.2%
1 408
9.8%
2 301
 
7.3%
8 263
 
6.3%
4 262
 
6.3%
5 158
 
3.8%
6 79
 
1.9%
Other values (2) 109
 
2.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2960
71.4%
Other Punctuation 1184
 
28.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 956
32.3%
3 424
14.3%
1 408
13.8%
2 301
 
10.2%
8 263
 
8.9%
4 262
 
8.9%
5 158
 
5.3%
6 79
 
2.7%
9 57
 
1.9%
7 52
 
1.8%
Other Punctuation
ValueCountFrequency (%)
: 592
50.0%
. 592
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4144
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 956
23.1%
: 592
14.3%
. 592
14.3%
3 424
10.2%
1 408
9.8%
2 301
 
7.3%
8 263
 
6.3%
4 262
 
6.3%
5 158
 
3.8%
6 79
 
1.9%
Other values (2) 109
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4144
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 956
23.1%
: 592
14.3%
. 592
14.3%
3 424
10.2%
1 408
9.8%
2 301
 
7.3%
8 263
 
6.3%
4 262
 
6.3%
5 158
 
3.8%
6 79
 
1.9%
Other values (2) 109
 
2.6%

수정일자(LAST_UPDUSR_PNTTM).1
Text

MISSING 

Distinct220
Distinct (%)43.1%
Missing320
Missing (%)38.5%
Memory size6.6 KiB
2023-12-12T17:05:45.511941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

Total characters3577
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique195 ?
Unique (%)38.2%

Sample

1st row18:33.0
2nd row18:33.0
3rd row18:33.0
4th row18:33.0
5th row18:33.0
ValueCountFrequency (%)
18:34.0 71
 
13.9%
18:32.0 66
 
12.9%
18:33.0 51
 
10.0%
16:04.0 29
 
5.7%
00:00.0 16
 
3.1%
18:35.0 10
 
2.0%
22:39.0 7
 
1.4%
22:34.0 7
 
1.4%
22:35.0 6
 
1.2%
22:37.0 6
 
1.2%
Other values (210) 242
47.4%
2023-12-12T17:05:45.893441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 740
20.7%
: 511
14.3%
. 511
14.3%
3 398
11.1%
1 357
10.0%
2 276
 
7.7%
8 256
 
7.2%
4 222
 
6.2%
5 130
 
3.6%
6 69
 
1.9%
Other values (2) 107
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2555
71.4%
Other Punctuation 1022
 
28.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 740
29.0%
3 398
15.6%
1 357
14.0%
2 276
 
10.8%
8 256
 
10.0%
4 222
 
8.7%
5 130
 
5.1%
6 69
 
2.7%
9 60
 
2.3%
7 47
 
1.8%
Other Punctuation
ValueCountFrequency (%)
: 511
50.0%
. 511
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3577
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 740
20.7%
: 511
14.3%
. 511
14.3%
3 398
11.1%
1 357
10.0%
2 276
 
7.7%
8 256
 
7.2%
4 222
 
6.2%
5 130
 
3.6%
6 69
 
1.9%
Other values (2) 107
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3577
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 740
20.7%
: 511
14.3%
. 511
14.3%
3 398
11.1%
1 357
10.0%
2 276
 
7.7%
8 256
 
7.2%
4 222
 
6.2%
5 130
 
3.6%
6 69
 
1.9%
Other values (2) 107
 
3.0%

템플릿명(TMPLAT_NM)
Text

MISSING 

Distinct3
Distinct (%)100.0%
Missing828
Missing (%)99.6%
Memory size6.6 KiB
2023-12-12T17:05:46.097701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length9.3333333
Min length9

Characters and Unicode

Total characters28
Distinct characters16
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

Unique3 ?
Unique (%)100.0%

Sample

1st row게시판 기본템플릿
2nd row커뮤니티 기본템플릿
3rd row동호회 기본템플릿
ValueCountFrequency (%)
기본템플릿 3
50.0%
게시판 1
 
16.7%
커뮤니티 1
 
16.7%
동호회 1
 
16.7%
2023-12-12T17:05:46.420481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3
10.7%
기 3
10.7%
본 3
10.7%
템 3
10.7%
플 3
10.7%
릿 3
10.7%
게 1
 
3.6%
시 1
 
3.6%
판 1
 
3.6%
커 1
 
3.6%
Other values (6) 6
21.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 25
89.3%
Space Separator 3
 
10.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 3
12.0%
본 3
12.0%
템 3
12.0%
플 3
12.0%
릿 3
12.0%
게 1
 
4.0%
시 1
 
4.0%
판 1
 
4.0%
커 1
 
4.0%
뮤 1
 
4.0%
Other values (5) 5
20.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 25
89.3%
Common 3
 
10.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 3
12.0%
본 3
12.0%
템 3
12.0%
플 3
12.0%
릿 3
12.0%
게 1
 
4.0%
시 1
 
4.0%
판 1
 
4.0%
커 1
 
4.0%
뮤 1
 
4.0%
Other values (5) 5
20.0%
Common
ValueCountFrequency (%)
3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 25
89.3%
ASCII 3
 
10.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3
100.0%
Hangul
ValueCountFrequency (%)
기 3
12.0%
본 3
12.0%
템 3
12.0%
플 3
12.0%
릿 3
12.0%
게 1
 
4.0%
시 1
 
4.0%
판 1
 
4.0%
커 1
 
4.0%
뮤 1
 
4.0%
Other values (5) 5
20.0%

사용여부(USE_AT).2
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)33.3%
Missing828
Missing (%)99.6%
Memory size1.8 KiB
True
 
3
(Missing)
828 
ValueCountFrequency (%)
True 3
 
0.4%
(Missing) 828
99.6%
2023-12-12T17:05:46.571476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일자(FRST_REGISTER_PNTTM).2
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)33.3%
Missing828
Missing (%)99.6%
Memory size6.6 KiB
Minimum2023-12-12 18:42:00
Maximum2023-12-12 18:42:00
2023-12-12T17:05:46.656324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:05:46.774420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

수정일자(LAST_UPDUSR_PNTTM).2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing831
Missing (%)100.0%
Memory size7.4 KiB

템플릿 개별코드(TMPLAT_SE_CODE)
Text

MISSING 

Distinct3
Distinct (%)100.0%
Missing828
Missing (%)99.6%
Memory size6.6 KiB
2023-12-12T17:05:46.923596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

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

Unique

Unique3 ?
Unique (%)100.0%

Sample

1st rowTMPT01
2nd rowTMPT02
3rd rowTMPT03
ValueCountFrequency (%)
tmpt01 1
33.3%
tmpt02 1
33.3%
tmpt03 1
33.3%
2023-12-12T17:05:47.191859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
T 6
33.3%
M 3
16.7%
P 3
16.7%
0 3
16.7%
1 1
 
5.6%
2 1
 
5.6%
3 1
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 12
66.7%
Decimal Number 6
33.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 3
50.0%
1 1
 
16.7%
2 1
 
16.7%
3 1
 
16.7%
Uppercase Letter
ValueCountFrequency (%)
T 6
50.0%
M 3
25.0%
P 3
25.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 12
66.7%
Common 6
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 3
50.0%
1 1
 
16.7%
2 1
 
16.7%
3 1
 
16.7%
Latin
ValueCountFrequency (%)
T 6
50.0%
M 3
25.0%
P 3
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 18
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
T 6
33.3%
M 3
16.7%
P 3
16.7%
0 3
16.7%
1 1
 
5.6%
2 1
 
5.6%
3 1
 
5.6%

Correlations

2023-12-12T17:05:47.307639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용여부(USE_AT).1템플릿명(TMPLAT_NM)템플릿 개별코드(TMPLAT_SE_CODE)
사용여부(USE_AT).11.000NaNNaN
템플릿명(TMPLAT_NM)NaN1.0001.000
템플릿 개별코드(TMPLAT_SE_CODE)NaN1.0001.000

Missing values

2023-12-12T17:05:40.734831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:05:41.019915image/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.
2023-12-12T17:05:41.252965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

공통코드명(CL_CODE_NM)공통코드설명(CL_CODE_DC)사용여부(USE_AT)등록일자(FRST_REGISTER_PNTTM)수정일자(LAST_UPDUSR_PNTTM)코드명(CODE_NM)코드설명(CODE_DC)사용여부(USE_AT).1등록일자(FRST_REGISTER_PNTTM).1수정일자(LAST_UPDUSR_PNTTM).1템플릿명(TMPLAT_NM)사용여부(USE_AT).2등록일자(FRST_REGISTER_PNTTM).2수정일자(LAST_UPDUSR_PNTTM).2템플릿 개별코드(TMPLAT_SE_CODE)
0전자정부 프레임워크 공통서비스전자정부 프레임워크 공통서비스Y18:31.018:31.0커뮤니티 글쓰기 롤커뮤니티 글쓰기 롤Y18:33.018:33.0게시판 기본템플릿Y18:42.0<NA>TMPT01
1<NA><NA><NA><NA><NA>커뮤니티 글 수정/삭제 롤커뮤니티 글 수정/삭제 롤Y18:33.018:33.0커뮤니티 기본템플릿Y18:42.0<NA>TMPT02
2<NA><NA><NA><NA><NA>파일 업로드 롤파일 업로드 롤Y18:33.018:33.0동호회 기본템플릿Y18:42.0<NA>TMPT03
3<NA><NA><NA><NA><NA>일반 회원 유형일반 회원 유형Y18:33.018:33.0<NA><NA><NA><NA><NA>
4<NA><NA><NA><NA><NA>기업 회원 유형기업 회원 유형Y18:33.018:33.0<NA><NA><NA><NA><NA>
5<NA><NA><NA><NA><NA>업무 담당자(사용자) 유형업무 담당자(사용자) 유형Y18:33.018:33.0<NA><NA><NA><NA><NA>
6<NA><NA><NA><NA><NA>사용자 유형 최상위 롤사용자 유형 최상위 롤Y18:33.018:33.0<NA><NA><NA><NA><NA>
7<NA><NA><NA><NA><NA>남자남자Y18:33.018:33.0<NA><NA><NA><NA><NA>
8<NA><NA><NA><NA><NA>여자여자Y18:33.018:33.0<NA><NA><NA><NA><NA>
9<NA><NA><NA><NA><NA>주민등록번호 인증주민등록번호 인증Y18:33.018:33.0<NA><NA><NA><NA><NA>
공통코드명(CL_CODE_NM)공통코드설명(CL_CODE_DC)사용여부(USE_AT)등록일자(FRST_REGISTER_PNTTM)수정일자(LAST_UPDUSR_PNTTM)코드명(CODE_NM)코드설명(CODE_DC)사용여부(USE_AT).1등록일자(FRST_REGISTER_PNTTM).1수정일자(LAST_UPDUSR_PNTTM).1템플릿명(TMPLAT_NM)사용여부(USE_AT).2등록일자(FRST_REGISTER_PNTTM).2수정일자(LAST_UPDUSR_PNTTM).2템플릿 개별코드(TMPLAT_SE_CODE)
821<NA><NA><NA><NA><NA>정상<NA>Y46:47.0<NA><NA><NA><NA><NA><NA>
822<NA><NA><NA><NA><NA>암호화등록번호 NULL<NA>Y47:12.0<NA><NA><NA><NA><NA><NA>
823<NA><NA><NA><NA><NA>이용시작일자, 이용종료일자 NULL<NA>Y47:28.0<NA><NA><NA><NA><NA><NA>
824<NA><NA><NA><NA><NA>고객원장 미존재고객원장 미존재N47:38.015:10.0<NA><NA><NA><NA><NA>
825<NA><NA><NA><NA><NA>발급대기선정자추첨직후 발급대기 상태Y40:39.040:39.0<NA><NA><NA><NA><NA>
826<NA><NA><NA><NA><NA>차상위자활차상위자활근로대상자사실여부N14:08.014:08.0<NA><NA><NA><NA><NA>
827<NA><NA><NA><NA><NA>정원정원Y30:10.030:10.0<NA><NA><NA><NA><NA>
828<NA><NA><NA><NA><NA>며느리며느리Y06:14.006:14.0<NA><NA><NA><NA><NA>
829<NA><NA><NA><NA><NA>반려반려(선정이후)N16:32.047:32.0<NA><NA><NA><NA><NA>
830<NA><NA><NA><NA><NA>반려제출반려제출(선정이후)N47:59.047:59.0<NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

공통코드명(CL_CODE_NM)공통코드설명(CL_CODE_DC)사용여부(USE_AT)등록일자(FRST_REGISTER_PNTTM)수정일자(LAST_UPDUSR_PNTTM)코드명(CODE_NM)코드설명(CODE_DC)사용여부(USE_AT).1등록일자(FRST_REGISTER_PNTTM).1수정일자(LAST_UPDUSR_PNTTM).1템플릿명(TMPLAT_NM)사용여부(USE_AT).2등록일자(FRST_REGISTER_PNTTM).2템플릿 개별코드(TMPLAT_SE_CODE)# duplicates
0<NA><NA><NA><NA><NA>기초-교육급여수급발급사유코드Y00:00.000:00.0<NA><NA><NA><NA>2
1<NA><NA><NA><NA><NA>기초-생계급여수급발급사유코드Y00:00.000:00.0<NA><NA><NA><NA>2
2<NA><NA><NA><NA><NA>기초-의료급여수급발급사유코드Y00:00.000:00.0<NA><NA><NA><NA>2
3<NA><NA><NA><NA><NA>기초-주거급여수급발급사유코드Y00:00.000:00.0<NA><NA><NA><NA>2
4<NA><NA><NA><NA><NA>기타기타Y16:04.016:04.0<NA><NA><NA><NA>2
5<NA><NA><NA><NA><NA>기타기타Y18:34.018:34.0<NA><NA><NA><NA>2
6<NA><NA><NA><NA><NA>메일링크캐시부족메일링크캐시부족Y16:04.016:04.0<NA><NA><NA><NA>2
7<NA><NA><NA><NA><NA>완료완료Y18:34.018:34.0<NA><NA><NA><NA>2
8<NA><NA><NA><NA><NA>일반게시판일반게시판Y18:32.018:32.0<NA><NA><NA><NA>2
9<NA><NA><NA><NA><NA>장애인발급사유코드N00:00.000:00.0<NA><NA><NA><NA>2