Overview

Dataset statistics

Number of variables11
Number of observations415
Missing cells2289
Missing cells (%)50.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory35.8 KiB
Average record size in memory88.3 B

Variable types

Categorical1
Text1
DateTime9

Dataset

Description대구보훈병원에서 개방하는 병동별 투약시간 기본정보 데이터로 병동코드명, 용법코드명, 투여시간1회차, 투여시간2회차, 투여시간3회차, 투여시간4회차, 투여시간5회차, 투여시간6회차, 투여시간7회차, 투여시간8회차, 수정일시가 반영된 데이터입니다.
Author한국보훈복지의료공단
URLhttps://www.data.go.kr/data/15116644/fileData.do

Alerts

투여시간8회차 has constant value ""Constant
투여시간2회차 has 131 (31.6%) missing valuesMissing
투여시간3회차 has 212 (51.1%) missing valuesMissing
투여시간4회차 has 333 (80.2%) missing valuesMissing
투여시간5회차 has 394 (94.9%) missing valuesMissing
투여시간6회차 has 397 (95.7%) missing valuesMissing
투여시간7회차 has 407 (98.1%) missing valuesMissing
투여시간8회차 has 413 (99.5%) missing valuesMissing

Reproduction

Analysis started2023-12-12 22:53:44.877757
Analysis finished2023-12-12 22:53:45.835658
Duration0.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

병동코드명
Categorical

Distinct12
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
71병동
82 
51병동
52 
22병동
47 
62병동
41 
21병동
38 
Other values (7)
155 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row31병동
2nd row71병동
3rd row71병동
4th row71병동
5th row71병동

Common Values

ValueCountFrequency (%)
71병동 82
19.8%
51병동 52
12.5%
22병동 47
11.3%
62병동 41
9.9%
21병동 38
9.2%
31병동 30
 
7.2%
61병동 29
 
7.0%
41병동 28
 
6.7%
중환자실 22
 
5.3%
52병동 18
 
4.3%
Other values (2) 28
 
6.7%

Length

2023-12-13T07:53:45.887565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
71병동 82
19.8%
51병동 52
12.5%
22병동 47
11.3%
62병동 41
9.9%
21병동 38
9.2%
31병동 30
 
7.2%
61병동 29
 
7.0%
41병동 28
 
6.7%
중환자실 22
 
5.3%
52병동 18
 
4.3%
Other values (2) 28
 
6.7%

용법코드명
Text

Distinct114
Distinct (%)27.5%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2023-12-13T07:53:46.087014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length24
Mean length19.896386
Min length12

Characters and Unicode

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

Unique

Unique37 ?
Unique (%)8.9%

Sample

1st row1일 1회 24시간마다 주사하세요
2nd row격일로 48시간마다 주사하세요
3rd row3일 1회 주사하세요
4th row3일 1회 72시간마다 주사하세요
5th row1일 1회 관류하세요
ValueCountFrequency (%)
1일 348
18.3%
복용하세요 268
 
14.1%
1회 124
 
6.5%
3회 102
 
5.4%
주사하세요 86
 
4.5%
2회 76
 
4.0%
4회 59
 
3.1%
직후에 56
 
2.9%
식사 48
 
2.5%
매 44
 
2.3%
Other values (90) 691
36.3%
2023-12-13T07:53:46.436130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1807
21.9%
1 559
 
6.8%
요 424
 
5.1%
세 422
 
5.1%
하 416
 
5.0%
회 389
 
4.7%
일 367
 
4.4%
용 269
 
3.3%
복 268
 
3.2%
에 260
 
3.1%
Other values (67) 3076
37.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5311
64.3%
Space Separator 1807
 
21.9%
Decimal Number 1005
 
12.2%
Other Punctuation 134
 
1.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
요 424
 
8.0%
세 422
 
7.9%
하 416
 
7.8%
회 389
 
7.3%
일 367
 
6.9%
용 269
 
5.1%
복 268
 
5.0%
에 260
 
4.9%
사 258
 
4.9%
식 241
 
4.5%
Other values (56) 1997
37.6%
Decimal Number
ValueCountFrequency (%)
1 559
55.6%
3 143
 
14.2%
2 117
 
11.6%
4 87
 
8.7%
0 36
 
3.6%
6 31
 
3.1%
8 25
 
2.5%
7 4
 
0.4%
5 3
 
0.3%
Space Separator
ValueCountFrequency (%)
1807
100.0%
Other Punctuation
ValueCountFrequency (%)
, 134
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5311
64.3%
Common 2946
35.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
요 424
 
8.0%
세 422
 
7.9%
하 416
 
7.8%
회 389
 
7.3%
일 367
 
6.9%
용 269
 
5.1%
복 268
 
5.0%
에 260
 
4.9%
사 258
 
4.9%
식 241
 
4.5%
Other values (56) 1997
37.6%
Common
ValueCountFrequency (%)
1807
61.3%
1 559
 
19.0%
3 143
 
4.9%
, 134
 
4.5%
2 117
 
4.0%
4 87
 
3.0%
0 36
 
1.2%
6 31
 
1.1%
8 25
 
0.8%
7 4
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5311
64.3%
ASCII 2946
35.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1807
61.3%
1 559
 
19.0%
3 143
 
4.9%
, 134
 
4.5%
2 117
 
4.0%
4 87
 
3.0%
0 36
 
1.2%
6 31
 
1.1%
8 25
 
0.8%
7 4
 
0.1%
Hangul
ValueCountFrequency (%)
요 424
 
8.0%
세 422
 
7.9%
하 416
 
7.8%
회 389
 
7.3%
일 367
 
6.9%
용 269
 
5.1%
복 268
 
5.0%
에 260
 
4.9%
사 258
 
4.9%
식 241
 
4.5%
Other values (56) 1997
37.6%

투여시간1회차
Date

Distinct32
Distinct (%)7.7%
Missing2
Missing (%)0.5%
Memory size3.4 KiB
Minimum2023-12-13 01:00:00
Maximum2023-12-13 21:00:00
2023-12-13T07:53:46.572148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:46.687875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)

투여시간2회차
Date

MISSING 

Distinct33
Distinct (%)11.6%
Missing131
Missing (%)31.6%
Memory size3.4 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 22:00:00
2023-12-13T07:53:46.810668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:46.916645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)

투여시간3회차
Date

MISSING 

Distinct23
Distinct (%)11.3%
Missing212
Missing (%)51.1%
Memory size3.4 KiB
Minimum2023-12-13 07:00:00
Maximum2023-12-13 23:55:00
2023-12-13T07:53:47.016619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:47.110990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

투여시간4회차
Date

MISSING 

Distinct14
Distinct (%)17.1%
Missing333
Missing (%)80.2%
Memory size3.4 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 23:59:00
2023-12-13T07:53:47.217432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:47.297313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

투여시간5회차
Date

MISSING 

Distinct7
Distinct (%)33.3%
Missing394
Missing (%)94.9%
Memory size3.4 KiB
Minimum2023-12-13 13:00:00
Maximum2023-12-13 22:00:00
2023-12-13T07:53:47.379511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:47.485212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)

투여시간6회차
Date

MISSING 

Distinct7
Distinct (%)38.9%
Missing397
Missing (%)95.7%
Memory size3.4 KiB
Minimum2023-12-13 02:00:00
Maximum2023-12-13 22:00:00
2023-12-13T07:53:47.600553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:47.711902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)

투여시간7회차
Date

MISSING 

Distinct4
Distinct (%)50.0%
Missing407
Missing (%)98.1%
Memory size3.4 KiB
Minimum2023-12-13 18:00:00
Maximum2023-12-13 22:30:00
2023-12-13T07:53:47.843414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:47.975016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

투여시간8회차
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)50.0%
Missing413
Missing (%)99.5%
Memory size3.4 KiB
Minimum2023-12-13 22:00:00
Maximum2023-12-13 22:00:00
2023-12-13T07:53:48.083675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:48.205725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

수정일시
Date

Distinct315
Distinct (%)75.9%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
Minimum2010-02-11 09:31:00
Maximum2023-06-28 07:14:00
2023-12-13T07:53:48.348599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:48.522297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2023-12-13T07:53:48.638971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
병동코드명투여시간1회차투여시간2회차투여시간3회차투여시간4회차투여시간5회차투여시간6회차투여시간7회차
병동코드명1.0000.1740.0000.0000.0000.0000.0000.629
투여시간1회차0.1741.0000.9870.9730.9220.9860.9501.000
투여시간2회차0.0000.9871.0000.9930.9320.9440.9861.000
투여시간3회차0.0000.9730.9931.0000.9430.9971.0001.000
투여시간4회차0.0000.9220.9320.9431.0001.0001.0001.000
투여시간5회차0.0000.9860.9440.9971.0001.0001.0001.000
투여시간6회차0.0000.9500.9861.0001.0001.0001.0001.000
투여시간7회차0.6291.0001.0001.0001.0001.0001.0001.000

Missing values

2023-12-13T07:53:45.216043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:53:45.631236image/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-13T07:53:45.752960image/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

병동코드명용법코드명투여시간1회차투여시간2회차투여시간3회차투여시간4회차투여시간5회차투여시간6회차투여시간7회차투여시간8회차수정일시
031병동1일 1회 24시간마다 주사하세요09:00<NA><NA><NA><NA><NA><NA><NA>2022-08-10 07:13
171병동격일로 48시간마다 주사하세요10:00<NA><NA><NA><NA><NA><NA><NA>2010-02-11 09:31
271병동3일 1회 주사하세요09:00<NA><NA><NA><NA><NA><NA><NA>2016-02-16 11:29
371병동3일 1회 72시간마다 주사하세요10:00<NA><NA><NA><NA><NA><NA><NA>2010-02-11 09:32
471병동1일 1회 관류하세요09:00<NA><NA><NA><NA><NA><NA><NA>2010-08-15 00:53
562병동1일4회 1번씩 흡입 하세요07:3000:0016:0021:00<NA><NA><NA><NA>2016-02-16 08:33
662병동1일 3회 1번씩 흡입하세요07:3013:0018:00<NA><NA><NA><NA><NA>2016-02-16 08:32
731병동1일 6회 4시간마다 주사하세요02:0006:0010:0014:0018:0022:00<NA><NA>2012-09-06 10:16
831병동1일 1회 아침식전 30분에 복용하세요07:00<NA><NA><NA><NA><NA><NA><NA>2010-02-23 08:48
962병동1주 4회 주사하세요09:0015:0021:0003:00<NA><NA><NA><NA>2011-03-22 14:18
병동코드명용법코드명투여시간1회차투여시간2회차투여시간3회차투여시간4회차투여시간5회차투여시간6회차투여시간7회차투여시간8회차수정일시
40522병동아침, 저녁식사 직후에 복용하세요08:0018:00<NA><NA><NA><NA><NA><NA>2021-12-24 08:20
40641병동1일 3회 관류하세요09:0015:0021:00<NA><NA><NA><NA><NA>2022-10-31 08:36
40721병동1일 4회 관류하세요06:0012:0018:0023:59<NA><NA><NA><NA>2022-01-28 07:50
40821병동격일로 48시간마다 1회 복용하세요07:30<NA><NA><NA><NA><NA><NA><NA>2022-04-18 12:29
40941병동1일 4회 6시간마다 복용하세요06:0012:0018:0023:59<NA><NA><NA><NA>2022-10-27 16:20
41051병동1일 1회 흡입하세요08:00<NA><NA><NA><NA><NA><NA><NA>2023-03-09 10:45
41121병동1일 1회 아침 식사직전에 주사하세요06:50<NA><NA><NA><NA><NA><NA><NA>2023-04-21 10:24
41221병동1일 6회 매 식전 1시간,매 식후 1시간에 복용하세요06:3008:0011:0013:0016:0018:00<NA><NA>2023-04-21 10:25
41321병동월 1회 아침식전 30분에 복용하세요06:30<NA><NA><NA><NA><NA><NA><NA>2023-04-21 10:25
41421병동1일 6회 의사지시대로 주사하세요03:0009:0015:0021:00<NA><NA><NA><NA>2023-06-09 16:47