Overview

Dataset statistics

Number of variables11
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory94.4 B

Variable types

Numeric2
Categorical6
Text3

Dataset

Description췌장암 라이브러리 췌장암_병리_외과 메타정보( 제공 되어질 데이터 항목, 타입, 사이즈, 항목설명, 항목별건수, 표시형식 등)를 제공
Author국립암센터
URLhttps://www.data.go.kr/data/15091779/fileData.do

Alerts

분류아이디 has constant value ""Constant
분류명 has constant value ""Constant
테이블아이디 has constant value ""Constant
테이블명 has constant value ""Constant
순번 is highly overall correlated with 컬럼데이터수High correlation
컬럼데이터수 is highly overall correlated with 순번High correlation
데이터타입 is highly overall correlated with 표시형식High correlation
표시형식 is highly overall correlated with 데이터타입High correlation
순번 has unique valuesUnique
컬럼아이디 has unique valuesUnique
컬럼명 has unique valuesUnique
컬럼설명 has unique valuesUnique
컬럼데이터수 has 6 (20.0%) zerosZeros

Reproduction

Analysis started2023-12-12 21:08:40.349040
Analysis finished2023-12-12 21:08:41.283435
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.5
Minimum1
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-13T06:08:41.351154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.45
Q18.25
median15.5
Q322.75
95-th percentile28.55
Maximum30
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.56796183
Kurtosis-1.2
Mean15.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum465
Variance77.5
MonotonicityStrictly increasing
2023-12-13T06:08:41.485728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
1 1
 
3.3%
17 1
 
3.3%
30 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
10 1
3.3%
ValueCountFrequency (%)
30 1
3.3%
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%

분류아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
PTH
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
PTH 30
100.0%

Length

2023-12-13T06:08:41.599674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:41.676831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pth 30
100.0%

분류명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
병리
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row병리
2nd row병리
3rd row병리
4th row병리
5th row병리

Common Values

ValueCountFrequency (%)
병리 30
100.0%

Length

2023-12-13T06:08:41.757969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:41.837581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
병리 30
100.0%

테이블아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
PNCT_PTH_SRGC
30 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
PNCT_PTH_SRGC 30
100.0%

Length

2023-12-13T06:08:42.180089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:42.260745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pnct_pth_srgc 30
100.0%

테이블명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
췌장암_병리_외과
30 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row췌장암_병리_외과
2nd row췌장암_병리_외과
3rd row췌장암_병리_외과
4th row췌장암_병리_외과
5th row췌장암_병리_외과

Common Values

ValueCountFrequency (%)
췌장암_병리_외과 30
100.0%

Length

2023-12-13T06:08:42.348536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:42.436362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
췌장암_병리_외과 30
100.0%

컬럼아이디
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T06:08:42.643170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length17.533333
Min length7

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st rowCENTER_CD
2nd rowIRB_APRV_NO
3rd rowPT_SBST_NO
4th rowSGPT_ACPT_YMD
5th rowSGPT_SEQ
ValueCountFrequency (%)
center_cd 1
 
3.3%
irb_aprv_no 1
 
3.3%
sgpt_patl_m_stag_vl 1
 
3.3%
sgpt_patl_n_stag_vl 1
 
3.3%
sgpt_patl_t_stag_vl 1
 
3.3%
sgpt_patl_stag_vl 1
 
3.3%
sgpt_crtv_srmv_dgre_cont 1
 
3.3%
sgpt_dsnt_mtst_site_cont 1
 
3.3%
sgpt_dsnt_mtst_yn 1
 
3.3%
sgpt_cell_diff_etc_cont 1
 
3.3%
Other values (20) 20
66.7%
2023-12-13T06:08:43.046442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 90
17.1%
T 81
15.4%
S 49
9.3%
N 39
 
7.4%
P 36
 
6.8%
G 35
 
6.7%
C 27
 
5.1%
O 22
 
4.2%
L 21
 
4.0%
R 20
 
3.8%
Other values (14) 106
20.2%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 436
82.9%
Connector Punctuation 90
 
17.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
T 81
18.6%
S 49
11.2%
N 39
8.9%
P 36
8.3%
G 35
 
8.0%
C 27
 
6.2%
O 22
 
5.0%
L 21
 
4.8%
R 20
 
4.6%
A 17
 
3.9%
Other values (13) 89
20.4%
Connector Punctuation
ValueCountFrequency (%)
_ 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 436
82.9%
Common 90
 
17.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
T 81
18.6%
S 49
11.2%
N 39
8.9%
P 36
8.3%
G 35
 
8.0%
C 27
 
6.2%
O 22
 
5.0%
L 21
 
4.8%
R 20
 
4.6%
A 17
 
3.9%
Other values (13) 89
20.4%
Common
ValueCountFrequency (%)
_ 90
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 526
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 90
17.1%
T 81
15.4%
S 49
9.3%
N 39
 
7.4%
P 36
 
6.8%
G 35
 
6.7%
C 27
 
5.1%
O 22
 
4.2%
L 21
 
4.0%
R 20
 
3.8%
Other values (14) 106
20.2%

컬럼명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T06:08:43.295403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length10
Min length4

Characters and Unicode

Total characters300
Distinct characters84
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

Unique30 ?
Unique (%)100.0%

Sample

1st row센터코드
2nd rowIRB승인번호
3rd row환자대체번호
4th row외과병리접수일자
5th row외과병리순번
ValueCountFrequency (%)
센터코드 1
 
3.3%
irb승인번호 1
 
3.3%
외과병리병리학적m병기값 1
 
3.3%
외과병리병리학적n병기값 1
 
3.3%
외과병리병리학적t병기값 1
 
3.3%
외과병리병리학적병기값 1
 
3.3%
외과병리완치절제정도내용 1
 
3.3%
외과병리원격전이부위내용 1
 
3.3%
외과병리원격전이여부 1
 
3.3%
외과병리세포분화기타내용 1
 
3.3%
Other values (20) 20
66.7%
2023-12-13T06:08:43.721932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
병 35
 
11.7%
리 30
 
10.0%
과 27
 
9.0%
외 26
 
8.7%
내 17
 
5.7%
용 16
 
5.3%
절 9
 
3.0%
기 8
 
2.7%
학 5
 
1.7%
제 5
 
1.7%
Other values (74) 122
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 294
98.0%
Uppercase Letter 6
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
병 35
 
11.9%
리 30
 
10.2%
과 27
 
9.2%
외 26
 
8.8%
내 17
 
5.8%
용 16
 
5.4%
절 9
 
3.1%
기 8
 
2.7%
학 5
 
1.7%
제 5
 
1.7%
Other values (68) 116
39.5%
Uppercase Letter
ValueCountFrequency (%)
M 1
16.7%
N 1
16.7%
T 1
16.7%
I 1
16.7%
R 1
16.7%
B 1
16.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 294
98.0%
Latin 6
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
병 35
 
11.9%
리 30
 
10.2%
과 27
 
9.2%
외 26
 
8.8%
내 17
 
5.8%
용 16
 
5.4%
절 9
 
3.1%
기 8
 
2.7%
학 5
 
1.7%
제 5
 
1.7%
Other values (68) 116
39.5%
Latin
ValueCountFrequency (%)
M 1
16.7%
N 1
16.7%
T 1
16.7%
I 1
16.7%
R 1
16.7%
B 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 294
98.0%
ASCII 6
 
2.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
병 35
 
11.9%
리 30
 
10.2%
과 27
 
9.2%
외 26
 
8.8%
내 17
 
5.8%
용 16
 
5.4%
절 9
 
3.1%
기 8
 
2.7%
학 5
 
1.7%
제 5
 
1.7%
Other values (68) 116
39.5%
ASCII
ValueCountFrequency (%)
M 1
16.7%
N 1
16.7%
T 1
16.7%
I 1
16.7%
R 1
16.7%
B 1
16.7%

데이터타입
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
VARCHAR(8000)
16 
VARCHAR(100)
3 
VARCHAR(200)
3 
VARCHAR(20)
2 
VARCHAR(8)
2 
Other values (4)
4 

Length

Max length13
Median length13
Mean length12.033333
Min length8

Unique

Unique4 ?
Unique (%)13.3%

Sample

1st rowVARCHAR(20)
2nd rowVARCHAR(50)
3rd rowVARCHAR(10)
4th rowVARCHAR(8)
5th rowNUMBER(3)

Common Values

ValueCountFrequency (%)
VARCHAR(8000) 16
53.3%
VARCHAR(100) 3
 
10.0%
VARCHAR(200) 3
 
10.0%
VARCHAR(20) 2
 
6.7%
VARCHAR(8) 2
 
6.7%
VARCHAR(50) 1
 
3.3%
VARCHAR(10) 1
 
3.3%
NUMBER(3) 1
 
3.3%
DATETIME 1
 
3.3%

Length

2023-12-13T06:08:43.893057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:44.075363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
varchar(8000 16
53.3%
varchar(100 3
 
10.0%
varchar(200 3
 
10.0%
varchar(20 2
 
6.7%
varchar(8 2
 
6.7%
varchar(50 1
 
3.3%
varchar(10 1
 
3.3%
number(3 1
 
3.3%
datetime 1
 
3.3%

컬럼설명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T06:08:44.346590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length191
Median length35.5
Mean length32.633333
Min length3

Characters and Unicode

Total characters979
Distinct characters125
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

Unique30 ?
Unique (%)100.0%

Sample

1st row센터코드 (5자리 : XXXXX) / 00030 : 국립암센터 예) 00030
2nd row센터별 기준에 따라 생성
3rd row개인고유번호(10자리) / 센터별 별도부여 예) RN12345678
4th row외과병리접수일자 / YYYYMMDD
5th row외과병리접수일자별 순번
ValueCountFrequency (%)
16
 
10.1%
예 9
 
5.7%
text 8
 
5.1%
free 8
 
5.1%
margin 5
 
3.2%
ln 5
 
3.2%
from 4
 
2.5%
예)present 3
 
1.9%
pancreas 2
 
1.3%
yyyymmdd 2
 
1.3%
Other values (87) 96
60.8%
2023-12-13T06:08:44.795109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
129
 
13.2%
e 68
 
6.9%
r 45
 
4.6%
a 44
 
4.5%
t 43
 
4.4%
n 32
 
3.3%
i 30
 
3.1%
c 30
 
3.1%
) 28
 
2.9%
o 27
 
2.8%
Other values (115) 503
51.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 473
48.3%
Other Letter 181
 
18.5%
Space Separator 129
 
13.2%
Uppercase Letter 62
 
6.3%
Decimal Number 54
 
5.5%
Other Punctuation 43
 
4.4%
Close Punctuation 28
 
2.9%
Open Punctuation 5
 
0.5%
Math Symbol 3
 
0.3%
Connector Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
예 23
 
12.7%
리 13
 
7.2%
외 11
 
6.1%
병 11
 
6.1%
과 11
 
6.1%
용 8
 
4.4%
내 8
 
4.4%
침 5
 
2.8%
윤 5
 
2.8%
자 5
 
2.8%
Other values (57) 81
44.8%
Lowercase Letter
ValueCountFrequency (%)
e 68
14.4%
r 45
9.5%
a 44
9.3%
t 43
 
9.1%
n 32
 
6.8%
i 30
 
6.3%
c 30
 
6.3%
o 27
 
5.7%
m 25
 
5.3%
s 20
 
4.2%
Other values (11) 109
23.0%
Uppercase Letter
ValueCountFrequency (%)
Y 10
16.1%
N 10
16.1%
L 7
11.3%
D 5
8.1%
M 5
8.1%
X 5
8.1%
P 4
 
6.5%
R 4
 
6.5%
C 2
 
3.2%
I 2
 
3.2%
Other values (7) 8
12.9%
Decimal Number
ValueCountFrequency (%)
0 18
33.3%
1 8
14.8%
3 7
 
13.0%
5 7
 
13.0%
2 7
 
13.0%
7 2
 
3.7%
6 2
 
3.7%
9 1
 
1.9%
8 1
 
1.9%
4 1
 
1.9%
Other Punctuation
ValueCountFrequency (%)
/ 17
39.5%
, 12
27.9%
: 9
20.9%
. 4
 
9.3%
# 1
 
2.3%
Space Separator
ValueCountFrequency (%)
129
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Math Symbol
ValueCountFrequency (%)
| 3
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 535
54.6%
Common 263
26.9%
Hangul 181
 
18.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
예 23
 
12.7%
리 13
 
7.2%
외 11
 
6.1%
병 11
 
6.1%
과 11
 
6.1%
용 8
 
4.4%
내 8
 
4.4%
침 5
 
2.8%
윤 5
 
2.8%
자 5
 
2.8%
Other values (57) 81
44.8%
Latin
ValueCountFrequency (%)
e 68
 
12.7%
r 45
 
8.4%
a 44
 
8.2%
t 43
 
8.0%
n 32
 
6.0%
i 30
 
5.6%
c 30
 
5.6%
o 27
 
5.0%
m 25
 
4.7%
s 20
 
3.7%
Other values (28) 171
32.0%
Common
ValueCountFrequency (%)
129
49.0%
) 28
 
10.6%
0 18
 
6.8%
/ 17
 
6.5%
, 12
 
4.6%
: 9
 
3.4%
1 8
 
3.0%
3 7
 
2.7%
5 7
 
2.7%
2 7
 
2.7%
Other values (10) 21
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 798
81.5%
Hangul 181
 
18.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
129
16.2%
e 68
 
8.5%
r 45
 
5.6%
a 44
 
5.5%
t 43
 
5.4%
n 32
 
4.0%
i 30
 
3.8%
c 30
 
3.8%
) 28
 
3.5%
o 27
 
3.4%
Other values (48) 322
40.4%
Hangul
ValueCountFrequency (%)
예 23
 
12.7%
리 13
 
7.2%
외 11
 
6.1%
병 11
 
6.1%
과 11
 
6.1%
용 8
 
4.4%
내 8
 
4.4%
침 5
 
2.8%
윤 5
 
2.8%
자 5
 
2.8%
Other values (57) 81
44.8%

컬럼데이터수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct15
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean284.96667
Minimum0
Maximum463
Zeros6
Zeros (%)20.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-13T06:08:44.946984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q115.75
median408.5
Q3427.25
95-th percentile463
Maximum463
Range463
Interquartile range (IQR)411.5

Descriptive statistics

Standard deviation197.21553
Coefficient of variation (CV)0.69206525
Kurtosis-1.4795593
Mean284.96667
Median Absolute Deviation (MAD)54.5
Skewness-0.67849938
Sum8549
Variance38893.964
MonotonicityNot monotonic
2023-12-13T06:08:45.068483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
463 7
23.3%
0 6
20.0%
416 3
10.0%
412 3
10.0%
425 1
 
3.3%
355 1
 
3.3%
2 1
 
3.3%
428 1
 
3.3%
125 1
 
3.3%
33 1
 
3.3%
Other values (5) 5
16.7%
ValueCountFrequency (%)
0 6
20.0%
2 1
 
3.3%
10 1
 
3.3%
33 1
 
3.3%
125 1
 
3.3%
315 1
 
3.3%
334 1
 
3.3%
355 1
 
3.3%
392 1
 
3.3%
405 1
 
3.3%
ValueCountFrequency (%)
463 7
23.3%
428 1
 
3.3%
425 1
 
3.3%
416 3
10.0%
412 3
10.0%
405 1
 
3.3%
392 1
 
3.3%
355 1
 
3.3%
334 1
 
3.3%
315 1
 
3.3%

표시형식
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)26.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Free 텍스트
16 
텍스트
7 
YYYYMMDD
2 
문자(5) : XXXXX
 
1
문자(10) : XXXXXXXXXX
 
1
Other values (3)
3 

Length

Max length19
Median length8
Mean length7.5666667
Min length2

Unique

Unique5 ?
Unique (%)16.7%

Sample

1st row문자(5) : XXXXX
2nd row텍스트
3rd row문자(10) : XXXXXXXXXX
4th rowYYYYMMDD
5th row숫자

Common Values

ValueCountFrequency (%)
Free 텍스트 16
53.3%
텍스트 7
23.3%
YYYYMMDD 2
 
6.7%
문자(5) : XXXXX 1
 
3.3%
문자(10) : XXXXXXXXXX 1
 
3.3%
숫자 1
 
3.3%
Y 여 | N 부 1
 
3.3%
YYYY-MM-DD HH:MI:SS 1
 
3.3%

Length

2023-12-13T06:08:45.216654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:08:45.384261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
텍스트 23
41.8%
free 16
29.1%
3
 
5.5%
yyyymmdd 2
 
3.6%
문자(5 1
 
1.8%
xxxxx 1
 
1.8%
문자(10 1
 
1.8%
xxxxxxxxxx 1
 
1.8%
숫자 1
 
1.8%
y 1
 
1.8%
Other values (5) 5
 
9.1%

Interactions

2023-12-13T06:08:40.852692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:08:40.697824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:08:40.939656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:08:40.775482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:08:45.482723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번컬럼아이디컬럼명데이터타입컬럼설명컬럼데이터수표시형식
순번1.0001.0001.0000.6221.0000.4660.610
컬럼아이디1.0001.0001.0001.0001.0001.0001.000
컬럼명1.0001.0001.0001.0001.0001.0001.000
데이터타입0.6221.0001.0001.0001.0000.0000.967
컬럼설명1.0001.0001.0001.0001.0001.0001.000
컬럼데이터수0.4661.0001.0000.0001.0001.0000.000
표시형식0.6101.0001.0000.9671.0000.0001.000
2023-12-13T06:08:45.616697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
표시형식데이터타입
표시형식1.0000.875
데이터타입0.8751.000
2023-12-13T06:08:45.719381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번컬럼데이터수데이터타입표시형식
순번1.000-0.5210.3140.312
컬럼데이터수-0.5211.0000.0000.000
데이터타입0.3140.0001.0000.875
표시형식0.3120.0000.8751.000

Missing values

2023-12-13T06:08:41.046145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:08:41.195966image/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

순번분류아이디분류명테이블아이디테이블명컬럼아이디컬럼명데이터타입컬럼설명컬럼데이터수표시형식
01PTH병리PNCT_PTH_SRGC췌장암_병리_외과CENTER_CD센터코드VARCHAR(20)센터코드 (5자리 : XXXXX) / 00030 : 국립암센터 예) 00030463문자(5) : XXXXX
12PTH병리PNCT_PTH_SRGC췌장암_병리_외과IRB_APRV_NOIRB승인번호VARCHAR(50)센터별 기준에 따라 생성463텍스트
23PTH병리PNCT_PTH_SRGC췌장암_병리_외과PT_SBST_NO환자대체번호VARCHAR(10)개인고유번호(10자리) / 센터별 별도부여 예) RN12345678463문자(10) : XXXXXXXXXX
34PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_ACPT_YMD외과병리접수일자VARCHAR(8)외과병리접수일자 / YYYYMMDD463YYYYMMDD
45PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_SEQ외과병리순번NUMBER(3)외과병리접수일자별 순번463숫자
56PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_READ_YMD외과병리판독일자VARCHAR(8)외과병리의 판독일자 / YYYYMMDD463YYYYMMDD
67PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_HTLG_TYPE_CONT외과병리조직학적유형내용VARCHAR(8000)외과병리조직학적유형내용 / free text 예) Classical adenocarcinoma0Free 텍스트
78PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_TUMR_MAX_SIZE_CONT외과병리종양최대크기내용VARCHAR(8000)외과병리종양최대크기내용 / free text 예)2.5425Free 텍스트
89PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_INVA_DGRE_CONT외과병리침윤정도내용VARCHAR(8000)외과병리침윤정도내용 / free text 예)peripancreatic soft tissue416Free 텍스트
910PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_ETC_ORGN_INVA_CONT외과병리기타장기침윤내용VARCHAR(8000)외과병리기타장기침윤내용 / free text 예)Invasion to common bile duct, ampulla of Vater and duodenum: present355Free 텍스트
순번분류아이디분류명테이블아이디테이블명컬럼아이디컬럼명데이터타입컬럼설명컬럼데이터수표시형식
2021PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_CELL_DIFF_CONT외과병리세포분화내용VARCHAR(8000)예)Moderately differentiated315Free 텍스트
2122PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_CELL_DIFF_ETC_CONT외과병리세포분화기타내용VARCHAR(8000)예) anaplasia0Free 텍스트
2223PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_DSNT_MTST_YN외과병리원격전이여부VARCHAR(20)Y, Y |N, N0Y 여 | N 부
2324PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_DSNT_MTST_SITE_CONT외과병리원격전이부위내용VARCHAR(8000)예) Lung0Free 텍스트
2425PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_CRTV_SRMV_DGRE_CONT외과병리완치절제정도내용VARCHAR(8000)R0 | R1 | R20Free 텍스트
2526PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_PATL_STAG_VL외과병리병리학적병기값VARCHAR(100)예) ypT3N1412텍스트
2627PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_PATL_T_STAG_VL외과병리병리학적T병기값VARCHAR(200)예) 3412텍스트
2728PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_PATL_N_STAG_VL외과병리병리학적N병기값VARCHAR(200)예) 1405텍스트
2829PTH병리PNCT_PTH_SRGC췌장암_병리_외과SGPT_PATL_M_STAG_VL외과병리병리학적M병기값VARCHAR(200)예) 010텍스트
2930PTH병리PNCT_PTH_SRGC췌장암_병리_외과CRTN_DT생성일시DATETIME생성일시 DEFAULT current_timestamp()463YYYY-MM-DD HH:MI:SS