Overview

Dataset statistics

Number of variables11
Number of observations231
Missing cells236
Missing cells (%)9.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.4 KiB
Average record size in memory90.6 B

Variable types

Numeric1
Categorical6
Text3
Unsupported1

Dataset

Description전립선암 레지스트리 메타정보( 제공 되어질 데이터 항목, 타입, 사이즈, 항목별건수, 샘플데이터 등)를 제공
Author국립암센터
URLhttps://www.data.go.kr/data/15048688/fileData.do

Alerts

tblNm is highly overall correlated with NUM and 4 other fieldsHigh correlation
dispFormat is highly overall correlated with NUM and 5 other fieldsHigh correlation
gpNm is highly overall correlated with NUM and 4 other fieldsHigh correlation
gpId is highly overall correlated with NUM and 4 other fieldsHigh correlation
tblId is highly overall correlated with NUM and 4 other fieldsHigh correlation
dataType is highly overall correlated with dispFormatHigh correlation
NUM is highly overall correlated with gpId and 4 other fieldsHigh correlation
dataType is highly imbalanced (71.7%)Imbalance
colDesc has 5 (2.2%) missing valuesMissing
colCnt has 231 (100.0%) missing valuesMissing
NUM has unique valuesUnique
colCnt is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 04:39:59.308562
Analysis finished2023-12-12 04:40:00.429805
Duration1.12 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

NUM
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct231
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean116
Minimum1
Maximum231
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-12T13:40:00.517921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.5
Q158.5
median116
Q3173.5
95-th percentile219.5
Maximum231
Range230
Interquartile range (IQR)115

Descriptive statistics

Standard deviation66.828138
Coefficient of variation (CV)0.57610464
Kurtosis-1.2
Mean116
Median Absolute Deviation (MAD)58
Skewness0
Sum26796
Variance4466
MonotonicityStrictly increasing
2023-12-12T13:40:00.698605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
160 1
 
0.4%
148 1
 
0.4%
149 1
 
0.4%
150 1
 
0.4%
151 1
 
0.4%
152 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
Other values (221) 221
95.7%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
231 1
0.4%
230 1
0.4%
229 1
0.4%
228 1
0.4%
227 1
0.4%
226 1
0.4%
225 1
0.4%
224 1
0.4%
223 1
0.4%
222 1
0.4%

gpId
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)3.9%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
MR_PRST_HLTH
66 
PE_PRST_NHT
35 
RG_CNDX_PRST
34 
PE_PRST_LAB
34 
PE_PRST_REBX
18 
Other values (4)
44 

Length

Max length13
Median length12
Mean length11.714286
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
MR_PRST_HLTH 66
28.6%
PE_PRST_NHT 35
15.2%
RG_CNDX_PRST 34
14.7%
PE_PRST_LAB 34
14.7%
PE_PRST_REBX 18
 
7.8%
PE_PRST_MIEX 18
 
7.8%
PE_PRST_PINFO 12
 
5.2%
PE_PRST_PSA 9
 
3.9%
PT_PRST_DEAD 5
 
2.2%

Length

2023-12-12T13:40:00.863357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:40:01.019719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mr_prst_hlth 66
28.6%
pe_prst_nht 35
15.2%
rg_cndx_prst 34
14.7%
pe_prst_lab 34
14.7%
pe_prst_rebx 18
 
7.8%
pe_prst_miex 18
 
7.8%
pe_prst_pinfo 12
 
5.2%
pe_prst_psa 9
 
3.9%
pt_prst_dead 5
 
2.2%

gpNm
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)3.9%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
기타건강정보
66 
수술정보
35 
진단정보
34 
진단검사
34 
약물치료
18 
Other values (4)
44 

Length

Max length9
Median length4
Mean length5.1861472
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
기타건강정보 66
28.6%
수술정보 35
15.2%
진단정보 34
14.7%
진단검사 34
14.7%
약물치료 18
 
7.8%
전이 및 재발 18
 
7.8%
Summary 12
 
5.2%
PSA_F/U 9
 
3.9%
사망 및 치료평가 5
 
2.2%

Length

2023-12-12T13:40:01.204545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:40:01.353776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타건강정보 66
23.8%
수술정보 35
12.6%
진단정보 34
12.3%
진단검사 34
12.3%
및 23
 
8.3%
약물치료 18
 
6.5%
전이 18
 
6.5%
재발 18
 
6.5%
summary 12
 
4.3%
psa_f/u 9
 
3.2%
Other values (2) 10
 
3.6%

tblId
Categorical

HIGH CORRELATION 

Distinct33
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
PE_PRST_SPR
27 
MR_PRST_HLTH_1
15 
RG_PRST_ESMP_1
 
14
MR_PRST_HLTH_7
 
14
PE_PRST_FRBX_2
 
13
Other values (28)
148 

Length

Max length19
Median length14
Mean length13.536797
Min length11

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st rowPE_PRST_CNST_V
2nd rowPE_PRST_CNST_V
3rd rowPE_PRST_CNST_V
4th rowPE_PRST_GSSC_V
5th rowPE_PRST_GSSC_V

Common Values

ValueCountFrequency (%)
PE_PRST_SPR 27
 
11.7%
MR_PRST_HLTH_1 15
 
6.5%
RG_PRST_ESMP_1 14
 
6.1%
MR_PRST_HLTH_7 14
 
6.1%
PE_PRST_FRBX_2 13
 
5.6%
PE_PRST_FRBX_1 11
 
4.8%
MR_PRST_HLTH_5 9
 
3.9%
MR_PRST_HLTH_2 9
 
3.9%
MR_PRST_HLTH_3 9
 
3.9%
MR_PRST_HLTH_4 9
 
3.9%
Other values (23) 101
43.7%

Length

2023-12-12T13:40:01.546403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
pe_prst_spr 27
 
11.7%
mr_prst_hlth_1 15
 
6.5%
rg_prst_esmp_1 14
 
6.1%
mr_prst_hlth_7 14
 
6.1%
pe_prst_frbx_2 13
 
5.6%
pe_prst_frbx_1 11
 
4.8%
mr_prst_hlth_5 9
 
3.9%
mr_prst_hlth_2 9
 
3.9%
mr_prst_hlth_3 9
 
3.9%
mr_prst_hlth_4 9
 
3.9%
Other values (23) 101
43.7%

tblNm
Categorical

HIGH CORRELATION 

Distinct33
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
외과병리보고서
27 
기타건강정보
15 
전자설문
 
14
과거력
 
14
원내 Initial 조직검사
 
13
Other values (28)
148 

Length

Max length27
Median length21
Mean length8.017316
Min length2

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st rowCancer Stage
2nd rowCancer Stage
3rd rowCancer Stage
4th rowInitial Gleason Score
5th rowInitial Gleason Score

Common Values

ValueCountFrequency (%)
외과병리보고서 27
 
11.7%
기타건강정보 15
 
6.5%
전자설문 14
 
6.1%
과거력 14
 
6.1%
원내 Initial 조직검사 13
 
5.6%
외부 Initial 조직검사 11
 
4.8%
가족력(형제/자매) 9
 
3.9%
가족력(부) 9
 
3.9%
가족력(모) 9
 
3.9%
가족력(자녀) 9
 
3.9%
Other values (23) 101
43.7%

Length

2023-12-12T13:40:01.737788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
initial 40
 
12.0%
외과병리보고서 27
 
8.1%
조직검사 24
 
7.2%
psa 15
 
4.5%
기타건강정보 15
 
4.5%
과거력 14
 
4.2%
전자설문 14
 
4.2%
원내 13
 
3.9%
외부 11
 
3.3%
clinical 11
 
3.3%
Other values (30) 149
44.7%

colId
Text

Distinct223
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T13:40:02.070554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length15
Mean length11.359307
Min length5

Characters and Unicode

Total characters2624
Distinct characters35
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

Unique218 ?
Unique (%)94.4%

Sample

1st rowSTAG_TYPE
2nd rowSTAG_YMD
3rd rowSTAG_VL
4th rowGLSN_FRST_SCR
5th rowGLSN_SCND_SCR
ValueCountFrequency (%)
glsn_frst_scr 3
 
1.3%
glsn_scnd_scr 3
 
1.3%
glsn_sum_scr 3
 
1.3%
prnr_invs 2
 
0.9%
max_tumr_len 2
 
0.9%
clrc1_part 1
 
0.4%
last_pt_stts 1
 
0.4%
clrc1_ymd 1
 
0.4%
clrc1_prgr_yn 1
 
0.4%
clrc1_seq 1
 
0.4%
Other values (213) 213
92.2%
2023-12-12T13:40:02.653164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 421
16.0%
S 222
 
8.5%
T 197
 
7.5%
M 179
 
6.8%
N 160
 
6.1%
C 155
 
5.9%
R 146
 
5.6%
D 127
 
4.8%
L 114
 
4.3%
H 113
 
4.3%
Other values (25) 790
30.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 2188
83.4%
Connector Punctuation 421
 
16.0%
Decimal Number 15
 
0.6%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
S 222
 
10.1%
T 197
 
9.0%
M 179
 
8.2%
N 160
 
7.3%
C 155
 
7.1%
R 146
 
6.7%
D 127
 
5.8%
L 114
 
5.2%
H 113
 
5.2%
Y 92
 
4.2%
Other values (16) 683
31.2%
Decimal Number
ValueCountFrequency (%)
1 7
46.7%
2 2
 
13.3%
3 1
 
6.7%
4 1
 
6.7%
5 1
 
6.7%
6 1
 
6.7%
7 1
 
6.7%
8 1
 
6.7%
Connector Punctuation
ValueCountFrequency (%)
_ 421
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2188
83.4%
Common 436
 
16.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
S 222
 
10.1%
T 197
 
9.0%
M 179
 
8.2%
N 160
 
7.3%
C 155
 
7.1%
R 146
 
6.7%
D 127
 
5.8%
L 114
 
5.2%
H 113
 
5.2%
Y 92
 
4.2%
Other values (16) 683
31.2%
Common
ValueCountFrequency (%)
_ 421
96.6%
1 7
 
1.6%
2 2
 
0.5%
3 1
 
0.2%
4 1
 
0.2%
5 1
 
0.2%
6 1
 
0.2%
7 1
 
0.2%
8 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2624
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 421
16.0%
S 222
 
8.5%
T 197
 
7.5%
M 179
 
6.8%
N 160
 
6.1%
C 155
 
5.9%
R 146
 
5.6%
D 127
 
4.8%
L 114
 
4.3%
H 113
 
4.3%
Other values (25) 790
30.1%

colNm
Text

Distinct204
Distinct (%)88.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T13:40:03.034055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length24
Mean length10.757576
Min length1

Characters and Unicode

Total characters2485
Distinct characters179
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

Unique186 ?
Unique (%)80.5%

Sample

1st row구분
2nd row일자
3rd row값
4th rowFirst Score
5th rowSecond Score
ValueCountFrequency (%)
과거력 14
 
3.1%
score 14
 
3.1%
tumor 13
 
2.9%
검사 12
 
2.7%
영상 12
 
2.7%
psa 11
 
2.4%
date 11
 
2.4%
gleason 9
 
2.0%
ipss 8
 
1.8%
bx 7
 
1.5%
Other values (225) 341
75.4%
2023-12-12T13:40:03.794346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
221
 
8.9%
e 132
 
5.3%
o 113
 
4.5%
t 82
 
3.3%
a 81
 
3.3%
n 75
 
3.0%
s 75
 
3.0%
i 68
 
2.7%
r 67
 
2.7%
) 67
 
2.7%
Other values (169) 1504
60.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1010
40.6%
Other Letter 748
30.1%
Uppercase Letter 314
 
12.6%
Space Separator 221
 
8.9%
Close Punctuation 67
 
2.7%
Open Punctuation 67
 
2.7%
Other Punctuation 23
 
0.9%
Decimal Number 23
 
0.9%
Dash Punctuation 6
 
0.2%
Connector Punctuation 6
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
력 52
 
7.0%
가 42
 
5.6%
족 37
 
4.9%
자 31
 
4.1%
부 27
 
3.6%
과 24
 
3.2%
일 22
 
2.9%
사 22
 
2.9%
검 22
 
2.9%
기 16
 
2.1%
Other values (106) 453
60.6%
Lowercase Letter
ValueCountFrequency (%)
e 132
13.1%
o 113
11.2%
t 82
 
8.1%
a 81
 
8.0%
n 75
 
7.4%
s 75
 
7.4%
i 68
 
6.7%
r 67
 
6.6%
l 52
 
5.1%
c 43
 
4.3%
Other values (13) 222
22.0%
Uppercase Letter
ValueCountFrequency (%)
S 46
14.6%
P 45
14.3%
I 26
 
8.3%
T 23
 
7.3%
B 19
 
6.1%
R 17
 
5.4%
C 16
 
5.1%
A 16
 
5.1%
E 13
 
4.1%
D 12
 
3.8%
Other values (12) 81
25.8%
Decimal Number
ValueCountFrequency (%)
1 6
26.1%
2 5
21.7%
0 4
17.4%
5 3
13.0%
4 1
 
4.3%
3 1
 
4.3%
6 1
 
4.3%
8 1
 
4.3%
7 1
 
4.3%
Other Punctuation
ValueCountFrequency (%)
/ 14
60.9%
% 5
 
21.7%
* 2
 
8.7%
. 2
 
8.7%
Space Separator
ValueCountFrequency (%)
221
100.0%
Close Punctuation
ValueCountFrequency (%)
) 67
100.0%
Open Punctuation
ValueCountFrequency (%)
( 67
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1324
53.3%
Hangul 748
30.1%
Common 413
 
16.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
력 52
 
7.0%
가 42
 
5.6%
족 37
 
4.9%
자 31
 
4.1%
부 27
 
3.6%
과 24
 
3.2%
일 22
 
2.9%
사 22
 
2.9%
검 22
 
2.9%
기 16
 
2.1%
Other values (106) 453
60.6%
Latin
ValueCountFrequency (%)
e 132
 
10.0%
o 113
 
8.5%
t 82
 
6.2%
a 81
 
6.1%
n 75
 
5.7%
s 75
 
5.7%
i 68
 
5.1%
r 67
 
5.1%
l 52
 
3.9%
S 46
 
3.5%
Other values (35) 533
40.3%
Common
ValueCountFrequency (%)
221
53.5%
) 67
 
16.2%
( 67
 
16.2%
/ 14
 
3.4%
- 6
 
1.5%
1 6
 
1.5%
_ 6
 
1.5%
2 5
 
1.2%
% 5
 
1.2%
0 4
 
1.0%
Other values (8) 12
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1737
69.9%
Hangul 748
30.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
221
 
12.7%
e 132
 
7.6%
o 113
 
6.5%
t 82
 
4.7%
a 81
 
4.7%
n 75
 
4.3%
s 75
 
4.3%
i 68
 
3.9%
r 67
 
3.9%
) 67
 
3.9%
Other values (53) 756
43.5%
Hangul
ValueCountFrequency (%)
력 52
 
7.0%
가 42
 
5.6%
족 37
 
4.9%
자 31
 
4.1%
부 27
 
3.6%
과 24
 
3.2%
일 22
 
2.9%
사 22
 
2.9%
검 22
 
2.9%
기 16
 
2.1%
Other values (106) 453
60.6%

dataType
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct8
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
<NA>
203 
STRING
 
7
DATE
 
6
String
 
5
Date
 
4
Other values (3)
 
6

Length

Max length7
Median length4
Mean length4.1731602
Min length4

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st rowString
2nd rowDate
3rd rowString
4th rowInteger
5th rowInteger

Common Values

ValueCountFrequency (%)
<NA> 203
87.9%
STRING 7
 
3.0%
DATE 6
 
2.6%
String 5
 
2.2%
Date 4
 
1.7%
Integer 3
 
1.3%
INTEGER 2
 
0.9%
FLOAT 1
 
0.4%

Length

2023-12-12T13:40:03.938145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:40:04.066859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 203
87.9%
string 12
 
5.2%
date 10
 
4.3%
integer 5
 
2.2%
float 1
 
0.4%

colDesc
Text

MISSING 

Distinct209
Distinct (%)92.5%
Missing5
Missing (%)2.2%
Memory size1.9 KiB
2023-12-12T13:40:04.311836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length32
Mean length14.681416
Min length5

Characters and Unicode

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

Unique

Unique195 ?
Unique (%)86.3%

Sample

1st row병기 종류
2nd row병기 기재 일자
3rd row진단 병기 값
4th row외과병리보고서의 Gleason score 1st
5th row외과병리보고서의 Gleason score 2nd
ValueCountFrequency (%)
환자 39
 
4.5%
가족력 25
 
2.9%
환자의 25
 
2.9%
관련 24
 
2.7%
유무 16
 
1.8%
psa 16
 
1.8%
검사일 15
 
1.7%
시행한 14
 
1.6%
값 14
 
1.6%
과거력 13
 
1.5%
Other values (281) 673
77.0%
2023-12-12T13:40:04.721013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
663
 
20.0%
의 144
 
4.3%
자 86
 
2.6%
환 80
 
2.4%
가 52
 
1.6%
력 51
 
1.5%
사 46
 
1.4%
부 45
 
1.4%
검 45
 
1.4%
일 42
 
1.3%
Other values (240) 2064
62.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2182
65.8%
Space Separator 663
 
20.0%
Lowercase Letter 250
 
7.5%
Uppercase Letter 184
 
5.5%
Decimal Number 21
 
0.6%
Other Punctuation 10
 
0.3%
Close Punctuation 4
 
0.1%
Open Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 144
 
6.6%
자 86
 
3.9%
환 80
 
3.7%
가 52
 
2.4%
력 51
 
2.3%
사 46
 
2.1%
부 45
 
2.1%
검 45
 
2.1%
일 42
 
1.9%
전 38
 
1.7%
Other values (192) 1553
71.2%
Uppercase Letter
ValueCountFrequency (%)
S 37
20.1%
P 29
15.8%
A 18
9.8%
I 16
8.7%
B 14
 
7.6%
G 13
 
7.1%
M 10
 
5.4%
Q 9
 
4.9%
C 9
 
4.9%
T 9
 
4.9%
Other values (8) 20
10.9%
Lowercase Letter
ValueCountFrequency (%)
o 40
16.0%
s 39
15.6%
e 37
14.8%
n 28
11.2%
a 24
9.6%
c 20
8.0%
r 15
 
6.0%
l 13
 
5.2%
i 7
 
2.8%
y 6
 
2.4%
Other values (6) 21
8.4%
Decimal Number
ValueCountFrequency (%)
1 5
23.8%
2 4
19.0%
6 3
14.3%
4 2
 
9.5%
8 2
 
9.5%
3 2
 
9.5%
5 1
 
4.8%
7 1
 
4.8%
0 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
/ 9
90.0%
% 1
 
10.0%
Space Separator
ValueCountFrequency (%)
663
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2182
65.8%
Common 702
 
21.2%
Latin 434
 
13.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 144
 
6.6%
자 86
 
3.9%
환 80
 
3.7%
가 52
 
2.4%
력 51
 
2.3%
사 46
 
2.1%
부 45
 
2.1%
검 45
 
2.1%
일 42
 
1.9%
전 38
 
1.7%
Other values (192) 1553
71.2%
Latin
ValueCountFrequency (%)
o 40
 
9.2%
s 39
 
9.0%
S 37
 
8.5%
e 37
 
8.5%
P 29
 
6.7%
n 28
 
6.5%
a 24
 
5.5%
c 20
 
4.6%
A 18
 
4.1%
I 16
 
3.7%
Other values (24) 146
33.6%
Common
ValueCountFrequency (%)
663
94.4%
/ 9
 
1.3%
1 5
 
0.7%
2 4
 
0.6%
) 4
 
0.6%
( 4
 
0.6%
6 3
 
0.4%
4 2
 
0.3%
8 2
 
0.3%
3 2
 
0.3%
Other values (4) 4
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2182
65.8%
ASCII 1136
34.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
663
58.4%
o 40
 
3.5%
s 39
 
3.4%
S 37
 
3.3%
e 37
 
3.3%
P 29
 
2.6%
n 28
 
2.5%
a 24
 
2.1%
c 20
 
1.8%
A 18
 
1.6%
Other values (38) 201
 
17.7%
Hangul
ValueCountFrequency (%)
의 144
 
6.6%
자 86
 
3.9%
환 80
 
3.7%
가 52
 
2.4%
력 51
 
2.3%
사 46
 
2.1%
부 45
 
2.1%
검 45
 
2.1%
일 42
 
1.9%
전 38
 
1.7%
Other values (192) 1553
71.2%

colCnt
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing231
Missing (%)100.0%
Memory size2.2 KiB

dispFormat
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)12.6%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
<NA>
131 
Y유 | N무
35 
텍스트
 
10
Y,유 | N,무
 
8
1 Not listed | 2 Present | 3 Not indentified
 
6
Other values (24)
41 

Length

Max length132
Median length4
Mean length11.896104
Min length2

Unique

Unique18 ?
Unique (%)7.8%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 131
56.7%
Y유 | N무 35
 
15.2%
텍스트 10
 
4.3%
Y,유 | N,무 8
 
3.5%
1 Not listed | 2 Present | 3 Not indentified 6
 
2.6%
YYYY-MM-DD 6
 
2.6%
1,유 | 2, 무 | 3, 모름 4
 
1.7%
숫자 4
 
1.7%
1, Not listed | 2,Present | 3, Not indentified 4
 
1.7%
1 위 | 2 폐 | 3 간 | 4 대장 | 5 유방 | 6 자궁 | 7 기타 | 8 갑상선 | 9 전립선 3
 
1.3%
Other values (19) 20
 
8.7%

Length

2023-12-12T13:40:04.880378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
166
22.3%
na 131
17.6%
n무 35
 
4.7%
y유 35
 
4.7%
3 32
 
4.3%
not 28
 
3.8%
2 27
 
3.6%
1 27
 
3.6%
listed 16
 
2.1%
indentified 11
 
1.5%
Other values (95) 238
31.9%

Interactions

2023-12-12T13:40:00.082025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:40:04.977750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
NUMgpIdgpNmtblIdtblNmdataTypedispFormat
NUM1.0000.9290.9290.9890.9890.3040.921
gpId0.9291.0001.0001.0001.0000.5850.994
gpNm0.9291.0001.0001.0001.0000.5850.994
tblId0.9891.0001.0001.0001.0000.7000.939
tblNm0.9891.0001.0001.0001.0000.7000.939
dataType0.3040.5850.5850.7000.7001.0001.000
dispFormat0.9210.9940.9940.9390.9391.0001.000
2023-12-12T13:40:05.128000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
tblNmdispFormatgpNmgpIdtblIddataType
tblNm1.0000.5420.9440.9441.0000.433
dispFormat0.5421.0000.7790.7790.5420.953
gpNm0.9440.7791.0001.0000.9440.408
gpId0.9440.7791.0001.0000.9440.408
tblId1.0000.5420.9440.9441.0000.433
dataType0.4330.9530.4080.4080.4331.000
2023-12-12T13:40:05.278327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
NUMgpIdgpNmtblIdtblNmdataTypedispFormat
NUM1.0000.7530.7530.8660.8660.2110.599
gpId0.7531.0001.0000.9440.9440.4080.779
gpNm0.7531.0001.0000.9440.9440.4080.779
tblId0.8660.9440.9441.0001.0000.4330.542
tblNm0.8660.9440.9441.0001.0000.4330.542
dataType0.2110.4080.4080.4330.4331.0000.953
dispFormat0.5990.7790.7790.5420.5420.9531.000

Missing values

2023-12-12T13:40:00.214467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:40:00.371834image/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

NUMgpIdgpNmtblIdtblNmcolIdcolNmdataTypecolDesccolCntdispFormat
01PE_PRST_PINFOSummaryPE_PRST_CNST_VCancer StageSTAG_TYPE구분String병기 종류<NA><NA>
12PE_PRST_PINFOSummaryPE_PRST_CNST_VCancer StageSTAG_YMD일자Date병기 기재 일자<NA><NA>
23PE_PRST_PINFOSummaryPE_PRST_CNST_VCancer StageSTAG_VL값String진단 병기 값<NA><NA>
34PE_PRST_PINFOSummaryPE_PRST_GSSC_VInitial Gleason ScoreGLSN_FRST_SCRFirst ScoreInteger외과병리보고서의 Gleason score 1st<NA><NA>
45PE_PRST_PINFOSummaryPE_PRST_GSSC_VInitial Gleason ScoreGLSN_SCND_SCRSecond ScoreInteger외과병리보고서의 Gleason score 2nd<NA><NA>
56PE_PRST_PINFOSummaryPE_PRST_GSSC_VInitial Gleason ScoreGLSN_SUM_SCRSum ScoreInteger외과병리보고서의 Gleason score sum<NA><NA>
67PE_PRST_PINFOSummaryPE_PRST_PSA_VPSAPSA_BX_YMDInitial DateDate최초 PSA 검사일<NA><NA>
78PE_PRST_PINFOSummaryPE_PRST_PSA_VPSAPSA_BX_VLInitial ValueString최초 PSA 검사값<NA><NA>
89PE_PRST_PINFOSummaryPE_PRST_PSA_VPSAPSA_PREOP_YMDPre OP DateDate수술 직전 PSA 검사일<NA><NA>
910PE_PRST_PINFOSummaryPE_PRST_PSA_VPSAPSA_PREOP_VLPre OP ValueString수술 직전 PSA 검사값<NA><NA>
NUMgpIdgpNmtblIdtblNmcolIdcolNmdataTypecolDesccolCntdispFormat
221222MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_DM_YN과거력 당뇨<NA>환자의 당뇨관련 과거력<NA>Y유 | N무
222223MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_DM_CTNT과거력 당뇨 상세내용<NA>환자의 당뇨관련 과거력 상세내용<NA>텍스트
223224MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_TB_YN과거력 결핵<NA>환자의 결핵 관련 과거력<NA>Y유 | N무
224225MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_LVDZ_YN과거력 간질환<NA>환자의 간질환 관련 과거력<NA>Y유 | N무
225226MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_CNCR_YN과거력 암<NA>환자의 암관련 과거력<NA>Y유 | N무
226227MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_DEPR_YN과거력 우울<NA>환자의 우울증 관련 과거력<NA>Y유 | N무
227228MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_INSM_YN과거력 불면<NA>환자의 불면증 관련 과거력<NA>Y유 | N무
228229MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_CADZ_YN과거력 심장질환<NA>환자의 심장실환 관련 과거력<NA>Y유 | N무
229230MR_PRST_HLTH기타건강정보MR_PRST_HLTH_7과거력PHIS_CADZ_CTNT과거력 심장질환 상세내용<NA>환자의 심장질환 관련 과거력 상세내용<NA>텍스트
230231MR_PRST_HLTH기타건강정보MR_PRST_HLTH_6가족력(기타)FMHS_ETC_YN가족력(기타)유무<NA>환자 의 가족력 유무<NA>Y유 | N무