Overview

Dataset statistics

Number of variables15
Number of observations828
Missing cells7981
Missing cells (%)64.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory101.2 KiB
Average record size in memory125.2 B

Variable types

Categorical1
Text1
DateTime8
Unsupported5

Dataset

Description한국보훈복지의료공단 부산보훈병원의 병동별 투약시간 기본정보에 대한 데이터로 병동별, 용도별, 투약 회차 등의 항목을 포함하고 있습니다.
Author한국보훈복지의료공단
URLhttps://www.data.go.kr/data/15088571/fileData.do

Alerts

투여시간2회차 has 306 (37.0%) missing valuesMissing
투여시간3회차 has 489 (59.1%) missing valuesMissing
투여시간4회차 has 672 (81.2%) missing valuesMissing
투여시간5회차 has 778 (94.0%) missing valuesMissing
투여시간6회차 has 786 (94.9%) missing valuesMissing
투여시간7회차 has 810 (97.8%) missing valuesMissing
투여시간8회차 has 828 (100.0%) missing valuesMissing
투여시간9회차 has 828 (100.0%) missing valuesMissing
투여시간10회차 has 828 (100.0%) missing valuesMissing
투여시간11회차 has 828 (100.0%) missing valuesMissing
투여시간12회차 has 828 (100.0%) missing valuesMissing
투여시간8회차 is an unsupported type, check if it needs cleaning or further analysisUnsupported
투여시간9회차 is an unsupported type, check if it needs cleaning or further analysisUnsupported
투여시간10회차 is an unsupported type, check if it needs cleaning or further analysisUnsupported
투여시간11회차 is an unsupported type, check if it needs cleaning or further analysisUnsupported
투여시간12회차 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 21:56:21.740003
Analysis finished2023-12-12 21:56:22.698891
Duration0.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

병동코드명
Categorical

Distinct17
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
53병동
88 
중환자실
73 
응급병동
67 
인공신장실
67 
외래
67 
Other values (12)
466 

Length

Max length5
Median length4
Mean length3.7512077
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row응급병동
2nd row응급병동
3rd row응급병동
4th row응급병동
5th row응급병동

Common Values

ValueCountFrequency (%)
53병동 88
10.6%
중환자실 73
8.8%
응급병동 67
 
8.1%
인공신장실 67
 
8.1%
외래 67
 
8.1%
수술장 67
 
8.1%
주사실 67
 
8.1%
65병동 60
 
7.2%
61병동 50
 
6.0%
63병동 42
 
5.1%
Other values (7) 180
21.7%

Length

2023-12-13T06:56:22.793925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
53병동 88
10.6%
중환자실 73
8.8%
응급병동 67
 
8.1%
인공신장실 67
 
8.1%
외래 67
 
8.1%
수술장 67
 
8.1%
주사실 67
 
8.1%
65병동 60
 
7.2%
61병동 50
 
6.0%
63병동 42
 
5.1%
Other values (7) 180
21.7%

용법코드명
Text

Distinct150
Distinct (%)18.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
2023-12-13T06:56:23.092810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length26
Mean length21.148551
Min length10

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)3.3%

Sample

1st row1일 1회 오전 10시에 복용하세요
2nd row1일 4회 5시간마다 복용하세요
3rd row1일 5회 4시간마다 복용하세요
4th row1일 6회 매 식전 1시간,매 식후 1시간에 복용하세요
5th row1일 6회 4시간마다 복용하세요
ValueCountFrequency (%)
1일 748
19.1%
복용하세요 616
15.8%
1회 283
 
7.2%
3회 189
 
4.8%
2회 180
 
4.6%
주사하세요 174
 
4.5%
30분에 146
 
3.7%
매 116
 
3.0%
4회 104
 
2.7%
30분,취침전에 82
 
2.1%
Other values (111) 1270
32.5%
2023-12-13T06:56:23.532961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3719
21.2%
1 1195
 
6.8%
요 843
 
4.8%
세 836
 
4.8%
하 825
 
4.7%
회 812
 
4.6%
일 787
 
4.5%
복 617
 
3.5%
용 616
 
3.5%
에 610
 
3.5%
Other values (83) 6651
38.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10983
62.7%
Space Separator 3719
 
21.2%
Decimal Number 2488
 
14.2%
Other Punctuation 301
 
1.7%
Close Punctuation 10
 
0.1%
Open Punctuation 10
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
요 843
 
7.7%
세 836
 
7.6%
하 825
 
7.5%
회 812
 
7.4%
일 787
 
7.2%
복 617
 
5.6%
용 616
 
5.6%
에 610
 
5.6%
식 595
 
5.4%
전 416
 
3.8%
Other values (69) 4026
36.7%
Decimal Number
ValueCountFrequency (%)
1 1195
48.0%
3 481
19.3%
0 285
 
11.5%
2 269
 
10.8%
4 149
 
6.0%
6 37
 
1.5%
8 26
 
1.0%
7 24
 
1.0%
5 22
 
0.9%
Other Punctuation
ValueCountFrequency (%)
, 296
98.3%
. 5
 
1.7%
Space Separator
ValueCountFrequency (%)
3719
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10983
62.7%
Common 6528
37.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
요 843
 
7.7%
세 836
 
7.6%
하 825
 
7.5%
회 812
 
7.4%
일 787
 
7.2%
복 617
 
5.6%
용 616
 
5.6%
에 610
 
5.6%
식 595
 
5.4%
전 416
 
3.8%
Other values (69) 4026
36.7%
Common
ValueCountFrequency (%)
3719
57.0%
1 1195
 
18.3%
3 481
 
7.4%
, 296
 
4.5%
0 285
 
4.4%
2 269
 
4.1%
4 149
 
2.3%
6 37
 
0.6%
8 26
 
0.4%
7 24
 
0.4%
Other values (4) 47
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10983
62.7%
ASCII 6528
37.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3719
57.0%
1 1195
 
18.3%
3 481
 
7.4%
, 296
 
4.5%
0 285
 
4.4%
2 269
 
4.1%
4 149
 
2.3%
6 37
 
0.6%
8 26
 
0.4%
7 24
 
0.4%
Other values (4) 47
 
0.7%
Hangul
ValueCountFrequency (%)
요 843
 
7.7%
세 836
 
7.6%
하 825
 
7.5%
회 812
 
7.4%
일 787
 
7.2%
복 617
 
5.6%
용 616
 
5.6%
에 610
 
5.6%
식 595
 
5.4%
전 416
 
3.8%
Other values (69) 4026
36.7%

투여시간1회차
Date

Distinct34
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 22:00:00
2023-12-13T06:56:23.671515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:23.806019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)

투여시간2회차
Date

MISSING 

Distinct28
Distinct (%)5.4%
Missing306
Missing (%)37.0%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 22:00:00
2023-12-13T06:56:23.930452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:24.050403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

투여시간3회차
Date

MISSING 

Distinct21
Distinct (%)6.2%
Missing489
Missing (%)59.1%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 23:00:00
2023-12-13T06:56:24.174857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:24.273661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

투여시간4회차
Date

MISSING 

Distinct14
Distinct (%)9.0%
Missing672
Missing (%)81.2%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 23:00:00
2023-12-13T06:56:24.362741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:24.467276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

투여시간5회차
Date

MISSING 

Distinct8
Distinct (%)16.0%
Missing778
Missing (%)94.0%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 23:00:00
2023-12-13T06:56:24.557844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:24.664148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)

투여시간6회차
Date

MISSING 

Distinct8
Distinct (%)19.0%
Missing786
Missing (%)94.9%
Memory size6.6 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 22:00:00
2023-12-13T06:56:24.752628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:24.860280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)

투여시간7회차
Date

MISSING 

Distinct5
Distinct (%)27.8%
Missing810
Missing (%)97.8%
Memory size6.6 KiB
Minimum2023-12-13 03:00:00
Maximum2023-12-13 23:00:00
2023-12-13T06:56:24.987061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:25.100274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

투여시간8회차
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

투여시간9회차
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

투여시간10회차
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

투여시간11회차
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

투여시간12회차
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

수정일시
Date

Distinct498
Distinct (%)60.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
Minimum2007-01-01 00:00:00
Maximum2021-02-18 08:51:17
2023-12-13T06:56:25.568146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:56:25.720317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2023-12-13T06:56:25.821126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
병동코드명투여시간1회차투여시간2회차투여시간3회차투여시간4회차투여시간5회차투여시간6회차투여시간7회차
병동코드명1.0000.6380.5090.5520.3330.6860.8260.653
투여시간1회차0.6381.0000.9460.9750.8130.8961.0000.787
투여시간2회차0.5090.9461.0000.9630.8600.9031.0000.976
투여시간3회차0.5520.9750.9631.0000.9690.9721.0001.000
투여시간4회차0.3330.8130.8600.9691.0000.9761.0001.000
투여시간5회차0.6860.8960.9030.9720.9761.0001.0001.000
투여시간6회차0.8261.0001.0001.0001.0001.0001.0001.000
투여시간7회차0.6530.7870.9761.0001.0001.0001.0001.000

Missing values

2023-12-13T06:56:22.248194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:56:22.448917image/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-13T06:56:22.609357image/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회차투여시간9회차투여시간10회차투여시간11회차투여시간12회차수정일시
0응급병동1일 1회 오전 10시에 복용하세요10:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
1응급병동1일 4회 5시간마다 복용하세요08:0013:0018:0023:00<NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
2응급병동1일 5회 4시간마다 복용하세요05:0009:0013:0017:0021:0001:00<NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
3응급병동1일 6회 매 식전 1시간,매 식후 1시간에 복용하세요07:0009:0011:0013:0017:0019:00<NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
4응급병동1일 6회 4시간마다 복용하세요05:0009:0013:0017:0021:0001:0005:00<NA><NA><NA><NA><NA>2007-01-01 00:00:00
5응급병동1일 1회 오전 7시에 복용하세요07:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
6응급병동1일 7회 식전,식후 1시간과 취침전에 복용하세요07:0009:0011:0013:0017:0019:0022:00<NA><NA><NA><NA><NA>2007-01-01 00:00:00
7응급병동1일 7회 3시간마다 복용하세요05:0008:0011:0014:0017:0020:0023:00<NA><NA><NA><NA><NA>2007-01-01 00:00:00
8응급병동1일 1회 오후 7시에 복용하세요19:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
9응급병동1일 1회 오전 8시에 복용하세요08:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
병동코드명용법코드명투여시간1회차투여시간2회차투여시간3회차투여시간4회차투여시간5회차투여시간6회차투여시간7회차투여시간8회차투여시간9회차투여시간10회차투여시간11회차투여시간12회차수정일시
818수술장1일 3회 식전 1시간에 복용하세요07:0011:0017:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
819수술장1일 3회 식전 2시간에 복용하세요06:0010:0016:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
820수술장1일 3회 점심,저녁식후 30분,취침전에 복용하세요13:0019:0022:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
821수술장1일 3회 아침,점심식후 30분,취침전에 복용하세요09:0013:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
822수술장1일 3회 아침,저녁식후 30분,취침전에 복용하세요09:0019:0022:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
823수술장1일 3회 식후 1시간에 복용하세요 복용하세요09:0013:0019:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
824수술장1일 3회 매 식후 2시간에 복용하세요10:0014:0020:00<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
825수술장1일 3회 매 식사직전에 복용하세요07:5011:5017:50<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
826수술장1일 3회 식사직후에 복용하세요08:3012:3018:30<NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00
827수술장1주 1회 아침식전 30분에 복용하세요07:00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2007-01-01 00:00:00