Overview

Dataset statistics

Number of variables11
Number of observations1178
Missing cells1178
Missing cells (%)9.1%
Duplicate rows58
Duplicate rows (%)4.9%
Total size in memory108.3 KiB
Average record size in memory94.1 B

Variable types

Categorical3
Text2
Numeric5
Unsupported1

Dataset

Description건강보험심사평가원 약가마스터 한약제제급여목록 및 급여상한금액표(건강보험심사평가원 홈페이지 > 제도정책 > 보험인정기준 메뉴에서 확인 가능)
URLhttps://www.data.go.kr/data/15067460/fileData.do

Alerts

Dataset has 58 (4.9%) duplicate rowsDuplicates
제품코드 is highly overall correlated with 업체명High correlation
규격 is highly overall correlated with 원료생약의 총함량(g) and 2 other fieldsHigh correlation
원료생약의 총함량(g) is highly overall correlated with 규격 and 3 other fieldsHigh correlation
원료생약의 엑스함량(g) is highly overall correlated with 규격 and 3 other fieldsHigh correlation
상한금액(원) is highly overall correlated with 규격 and 3 other fieldsHigh correlation
구분 is highly overall correlated with 원료생약의 총함량(g) and 2 other fieldsHigh correlation
업체명 is highly overall correlated with 제품코드High correlation
단위 is highly imbalanced (68.9%)Imbalance
비고 has 1178 (100.0%) missing valuesMissing
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 17:12:30.867002
Analysis finished2023-12-12 17:12:35.082815
Duration4.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
단미엑스제제
864 
단미엑스혼합제
314 

Length

Max length7
Median length6
Mean length6.2665535
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단미엑스제제
2nd row단미엑스제제
3rd row단미엑스제제
4th row단미엑스제제
5th row단미엑스제제

Common Values

ValueCountFrequency (%)
단미엑스제제 864
73.3%
단미엑스혼합제 314
 
26.7%

Length

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

Common Values (Plot)

2023-12-13T02:12:35.242286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단미엑스제제 864
73.3%
단미엑스혼합제 314
 
26.7%

처방코드
Text

Distinct165
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2023-12-13T02:12:35.520896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length9
Mean length9
Min length9

Characters and Unicode

Total characters10602
Distinct characters18
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

Unique1 ?
Unique (%)0.1%

Sample

1st row1001S1APD
2nd row1001S1APD
3rd row1001S1APD
4th row1001S1APD
5th row1001S1APD
ValueCountFrequency (%)
1063s1apd 17
 
1.4%
1062s1apd 15
 
1.3%
1064s1apd 15
 
1.3%
1065s1apd 15
 
1.3%
1061s1apd 15
 
1.3%
1066s1apd 15
 
1.3%
1067s1apd 15
 
1.3%
1060s1apd 15
 
1.3%
2027m1apd 14
 
1.2%
2054m1apd 12
 
1.0%
Other values (155) 1030
87.4%
2023-12-13T02:12:36.010289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 2005
18.9%
0 1453
13.7%
A 1178
11.1%
2 991
9.3%
P 933
8.8%
D 933
8.8%
S 718
 
6.8%
M 639
 
6.0%
4 330
 
3.1%
5 279
 
2.6%
Other values (8) 1143
10.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5890
55.6%
Uppercase Letter 4712
44.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 2005
34.0%
0 1453
24.7%
2 991
16.8%
4 330
 
5.6%
5 279
 
4.7%
6 270
 
4.6%
3 252
 
4.3%
9 115
 
2.0%
7 106
 
1.8%
8 89
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
A 1178
25.0%
P 933
19.8%
D 933
19.8%
S 718
15.2%
M 639
13.6%
X 179
 
3.8%
T 66
 
1.4%
B 66
 
1.4%

Most occurring scripts

ValueCountFrequency (%)
Common 5890
55.6%
Latin 4712
44.4%

Most frequent character per script

Common
ValueCountFrequency (%)
1 2005
34.0%
0 1453
24.7%
2 991
16.8%
4 330
 
5.6%
5 279
 
4.7%
6 270
 
4.6%
3 252
 
4.3%
9 115
 
2.0%
7 106
 
1.8%
8 89
 
1.5%
Latin
ValueCountFrequency (%)
A 1178
25.0%
P 933
19.8%
D 933
19.8%
S 718
15.2%
M 639
13.6%
X 179
 
3.8%
T 66
 
1.4%
B 66
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10602
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 2005
18.9%
0 1453
13.7%
A 1178
11.1%
2 991
9.3%
P 933
8.8%
D 933
8.8%
S 718
 
6.8%
M 639
 
6.0%
4 330
 
3.1%
5 279
 
2.6%
Other values (8) 1143
10.8%

제품코드
Real number (ℝ)

HIGH CORRELATION 

Distinct807
Distinct (%)68.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.6005093 × 108
Minimum6.2300251 × 108
Maximum6.9420626 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2023-12-13T02:12:36.255411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6.2300251 × 108
5-th percentile6.2300309 × 108
Q16.5500642 × 108
median6.6130036 × 108
Q36.6240465 × 108
95-th percentile6.9420407 × 108
Maximum6.9420626 × 108
Range71203750
Interquartile range (IQR)7398235

Descriptive statistics

Standard deviation19724773
Coefficient of variation (CV)0.029883713
Kurtosis0.17694902
Mean6.6005093 × 108
Median Absolute Deviation (MAD)6293805
Skewness-0.12784758
Sum7.7754 × 1011
Variance3.8906666 × 1014
MonotonicityNot monotonic
2023-12-13T02:12:36.473532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
694204070 2
 
0.2%
623003440 2
 
0.2%
661304960 2
 
0.2%
661304150 2
 
0.2%
661304160 2
 
0.2%
623003630 2
 
0.2%
694203940 2
 
0.2%
655006250 2
 
0.2%
658105530 2
 
0.2%
669605350 2
 
0.2%
Other values (797) 1158
98.3%
ValueCountFrequency (%)
623002510 1
0.1%
623002520 1
0.1%
623002530 1
0.1%
623002540 1
0.1%
623002550 1
0.1%
623002560 1
0.1%
623002570 1
0.1%
623002580 1
0.1%
623002590 1
0.1%
623002600 1
0.1%
ValueCountFrequency (%)
694206260 1
0.1%
694206210 2
0.2%
694205970 2
0.2%
694205880 2
0.2%
694205820 2
0.2%
694205750 2
0.2%
694205630 2
0.2%
694205500 2
0.2%
694205260 2
0.2%
694205250 2
0.2%

제품명
Text

Distinct838
Distinct (%)71.1%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2023-12-13T02:12:36.775301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length12.783531
Min length4

Characters and Unicode

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

Unique

Unique498 ?
Unique (%)42.3%

Sample

1st row경방갈근엑스산
2nd row신텍스갈근엑스산
3rd row아이월드갈근엑스산
4th row정우갈근엑스산
5th row인스팜갈근엑스산
ValueCountFrequency (%)
인스팜행인엑스산 2
 
0.2%
한신대화중음(단미엑스산혼합제 2
 
0.2%
신텍스반하백출천마탕(혼합단미엑스산 2
 
0.2%
한신궁하탕연조엑스(단미엑스혼합제 2
 
0.2%
한신반하백출천마탕(단미엑스산혼합제 2
 
0.2%
한풍반하백출천마탕(단미엑스산혼합제 2
 
0.2%
경방반하백출천마탕연조엑스(단미엑스혼합제 2
 
0.2%
한풍반하백출천마탕연조엑스(단미엑스혼합제 2
 
0.2%
경방반하사심탕(혼합단미엑스산 2
 
0.2%
신텍스반하사심탕(혼합단미엑스산 2
 
0.2%
Other values (828) 1158
98.3%
2023-12-13T02:12:37.276187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 1589
 
10.6%
엑 1348
 
9.0%
산 1109
 
7.4%
미 687
 
4.6%
단 648
 
4.3%
) 638
 
4.2%
( 638
 
4.2%
합 637
 
4.2%
혼 637
 
4.2%
제 474
 
3.1%
Other values (127) 6654
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13783
91.5%
Close Punctuation 638
 
4.2%
Open Punctuation 638
 
4.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 1589
 
11.5%
엑 1348
 
9.8%
산 1109
 
8.0%
미 687
 
5.0%
단 648
 
4.7%
합 637
 
4.6%
혼 637
 
4.6%
제 474
 
3.4%
탕 426
 
3.1%
한 412
 
3.0%
Other values (125) 5816
42.2%
Close Punctuation
ValueCountFrequency (%)
) 638
100.0%
Open Punctuation
ValueCountFrequency (%)
( 638
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13783
91.5%
Common 1276
 
8.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 1589
 
11.5%
엑 1348
 
9.8%
산 1109
 
8.0%
미 687
 
5.0%
단 648
 
4.7%
합 637
 
4.6%
혼 637
 
4.6%
제 474
 
3.4%
탕 426
 
3.1%
한 412
 
3.0%
Other values (125) 5816
42.2%
Common
ValueCountFrequency (%)
) 638
50.0%
( 638
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13783
91.5%
ASCII 1276
 
8.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 1589
 
11.5%
엑 1348
 
9.8%
산 1109
 
8.0%
미 687
 
5.0%
단 648
 
4.7%
합 637
 
4.6%
혼 637
 
4.6%
제 474
 
3.4%
탕 426
 
3.1%
한 412
 
3.0%
Other values (125) 5816
42.2%
ASCII
ValueCountFrequency (%)
) 638
50.0%
( 638
50.0%

업체명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
경방신약(주)
239 
(유)한풍제약
202 
(주)한국신약
199 
정우신약(주)
184 
한국신텍스제약(주)
168 
Other values (6)
186 

Length

Max length10
Median length7
Mean length7.6298812
Min length5

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row경방신약(주)
2nd row한국신텍스제약(주)
3rd row(주)아이월드제약
4th row정우신약(주)
5th row한국인스팜(주)

Common Values

ValueCountFrequency (%)
경방신약(주) 239
20.3%
(유)한풍제약 202
17.1%
(주)한국신약 199
16.9%
정우신약(주) 184
15.6%
한국신텍스제약(주) 168
14.3%
(주)아이월드제약 90
 
7.6%
한국인스팜(주) 74
 
6.3%
한중제약(주) 10
 
0.8%
경진제약사 8
 
0.7%
신화제약(주) 3
 
0.3%

Length

2023-12-13T02:12:37.463195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경방신약(주 239
20.3%
유)한풍제약 202
17.1%
주)한국신약 199
16.9%
정우신약(주 184
15.6%
한국신텍스제약(주 168
14.3%
주)아이월드제약 90
 
7.6%
한국인스팜(주 74
 
6.3%
한중제약(주 10
 
0.8%
경진제약사 8
 
0.7%
신화제약(주 3
 
0.3%

규격
Real number (ℝ)

HIGH CORRELATION 

Distinct113
Distinct (%)9.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.9458659
Minimum0.2
Maximum60
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2023-12-13T02:12:37.607345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.2
5-th percentile0.5
Q10.68
median6
Q310.95
95-th percentile30
Maximum60
Range59.8
Interquartile range (IQR)10.27

Descriptive statistics

Standard deviation11.116061
Coefficient of variation (CV)1.242592
Kurtosis1.5656348
Mean8.9458659
Median Absolute Deviation (MAD)5.32
Skewness1.5170363
Sum10538.23
Variance123.56681
MonotonicityNot monotonic
2023-12-13T02:12:37.791095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
30.0 122
 
10.4%
1.0 49
 
4.2%
0.72 43
 
3.7%
0.58 42
 
3.6%
0.64 42
 
3.6%
0.68 37
 
3.1%
0.88 37
 
3.1%
0.56 29
 
2.5%
6.0 28
 
2.4%
0.9 24
 
2.0%
Other values (103) 725
61.5%
ValueCountFrequency (%)
0.2 7
 
0.6%
0.3 7
 
0.6%
0.32 15
1.3%
0.36 7
 
0.6%
0.44 7
 
0.6%
0.48 14
1.2%
0.5 20
1.7%
0.52 7
 
0.6%
0.54 23
2.0%
0.55 7
 
0.6%
ValueCountFrequency (%)
60.0 2
 
0.2%
48.0 2
 
0.2%
45.0 9
 
0.8%
42.0 3
 
0.3%
39.0 8
 
0.7%
36.9 2
 
0.2%
36.0 12
 
1.0%
33.0 6
 
0.5%
31.5 2
 
0.2%
30.0 122
10.4%

단위
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
g
1112 
정
 
66

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
g 1112
94.4%
정 66
 
5.6%

Length

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

Common Values (Plot)

2023-12-13T02:12:38.076061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
g 1112
94.4%
정 66
 
5.6%

원료생약의 총함량(g)
Real number (ℝ)

HIGH CORRELATION 

Distinct51
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.339686
Minimum1
Maximum50.64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2023-12-13T02:12:38.216125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q12
median18.76
Q334.63
95-th percentile41.65
Maximum50.64
Range49.64
Interquartile range (IQR)32.63

Descriptive statistics

Standard deviation15.999735
Coefficient of variation (CV)0.82730066
Kurtosis-1.5386079
Mean19.339686
Median Absolute Deviation (MAD)16.49
Skewness0.19380657
Sum22782.15
Variance255.99152
MonotonicityNot monotonic
2023-12-13T02:12:38.399768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.0 291
24.7%
4.0 204
17.3%
37.52 58
 
4.9%
10.0 35
 
3.0%
31.63 30
 
2.5%
26.25 27
 
2.3%
21.27 24
 
2.0%
37.24 22
 
1.9%
31.52 22
 
1.9%
50.27 21
 
1.8%
Other values (41) 444
37.7%
ValueCountFrequency (%)
1.0 9
 
0.8%
2.0 291
24.7%
4.0 204
17.3%
10.0 35
 
3.0%
15.0 14
 
1.2%
18.38 18
 
1.5%
18.76 20
 
1.7%
21.27 24
 
2.0%
22.25 20
 
1.7%
22.9 20
 
1.7%
ValueCountFrequency (%)
50.64 10
0.8%
50.27 21
1.8%
46.94 6
 
0.5%
46.63 10
0.8%
41.65 16
1.4%
41.25 12
1.0%
40.05 14
1.2%
40.0 12
1.0%
39.52 13
1.1%
39.4 2
 
0.2%

원료생약의 엑스함량(g)
Real number (ℝ)

HIGH CORRELATION 

Distinct195
Distinct (%)16.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.4347828
Minimum0.1
Maximum21.9363
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2023-12-13T02:12:38.572909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.1
5-th percentile0.306
Q10.4215
median3.484
Q36.688
95-th percentile13.693665
Maximum21.9363
Range21.8363
Interquartile range (IQR)6.2665

Descriptive statistics

Standard deviation4.7522248
Coefficient of variation (CV)1.0715801
Kurtosis0.50351818
Mean4.4347828
Median Absolute Deviation (MAD)3.064
Skewness1.1113216
Sum5224.1742
Variance22.583641
MonotonicityNot monotonic
2023-12-13T02:12:38.735713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.54 37
 
3.1%
0.36 29
 
2.5%
0.4 28
 
2.4%
0.56 24
 
2.0%
0.2 22
 
1.9%
0.384 21
 
1.8%
0.412 16
 
1.4%
0.576 15
 
1.3%
0.396 15
 
1.3%
0.356 15
 
1.3%
Other values (185) 956
81.2%
ValueCountFrequency (%)
0.1 7
 
0.6%
0.2 22
1.9%
0.228 7
 
0.6%
0.268 7
 
0.6%
0.296 7
 
0.6%
0.3 7
 
0.6%
0.306 7
 
0.6%
0.31 7
 
0.6%
0.32 14
1.2%
0.336 7
 
0.6%
ValueCountFrequency (%)
21.9363 2
0.2%
20.653 2
0.2%
19.5732 2
0.2%
18.5841 2
0.2%
18.584 2
0.2%
17.73 4
0.3%
17.672 4
0.3%
17.67 2
0.2%
17.55 1
 
0.1%
17.4675 2
0.2%

상한금액(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct99
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean761.09932
Minimum17
Maximum2613
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2023-12-13T02:12:38.927131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum17
5-th percentile51.4
Q175
median705
Q31268
95-th percentile1969
Maximum2613
Range2596
Interquartile range (IQR)1193

Descriptive statistics

Standard deviation701.88918
Coefficient of variation (CV)0.92220445
Kurtosis-0.81068805
Mean761.09932
Median Absolute Deviation (MAD)627
Skewness0.58292398
Sum896575
Variance492648.42
MonotonicityNot monotonic
2023-12-13T02:12:39.057092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
52 29
 
2.5%
78 29
 
2.5%
75 28
 
2.4%
1424 25
 
2.1%
72 24
 
2.0%
701 24
 
2.0%
1268 23
 
2.0%
805 22
 
1.9%
1692 22
 
1.9%
2272 22
 
1.9%
Other values (89) 930
78.9%
ValueCountFrequency (%)
17 9
 
0.8%
38 7
 
0.6%
40 7
 
0.6%
42 14
1.2%
47 7
 
0.6%
48 15
1.3%
52 29
2.5%
53 7
 
0.6%
56 7
 
0.6%
58 7
 
0.6%
ValueCountFrequency (%)
2613 10
0.8%
2272 22
1.9%
2221 20
1.7%
2129 4
 
0.3%
1969 12
1.0%
1934 18
1.5%
1909 6
 
0.5%
1847 18
1.5%
1846 11
0.9%
1758 2
 
0.2%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1178
Missing (%)100.0%
Memory size10.5 KiB

Interactions

2023-12-13T02:12:34.211058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:31.478710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.133593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.763109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.698742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.331055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:31.621696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.274344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.899792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.801451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.447160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:31.762630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.420719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.026614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.891934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.577859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:31.894948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.558259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.135101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.000595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.679294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.020645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:32.670885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:33.258905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:12:34.097144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:12:39.157713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분제품코드업체명규격단위원료생약의 총함량(g)원료생약의 엑스함량(g)상한금액(원)
구분1.0000.1650.2170.4820.1490.7040.7030.703
제품코드0.1651.0000.9730.2490.1380.1890.2130.146
업체명0.2170.9731.0000.3610.1400.3140.3120.247
규격0.4820.2490.3611.0000.1020.7020.7690.651
단위0.1490.1380.1400.1021.0000.4260.3410.367
원료생약의 총함량(g)0.7040.1890.3140.7020.4261.0000.8840.901
원료생약의 엑스함량(g)0.7030.2130.3120.7690.3410.8841.0000.865
상한금액(원)0.7030.1460.2470.6510.3670.9010.8651.000
2023-12-13T02:12:39.313223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분단위업체명
구분1.0000.0950.207
단위0.0951.0000.134
업체명0.2070.1341.000
2023-12-13T02:12:39.441701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제품코드규격원료생약의 총함량(g)원료생약의 엑스함량(g)상한금액(원)구분업체명단위
제품코드1.0000.030-0.0010.0350.0050.1180.9270.099
규격0.0301.0000.8120.9660.7590.4730.1700.107
원료생약의 총함량(g)-0.0010.8121.0000.8090.8750.5480.1390.326
원료생약의 엑스함량(g)0.0350.9660.8091.0000.7710.5470.1380.261
상한금액(원)0.0050.7590.8750.7711.0000.5470.1070.281
구분0.1180.4730.5480.5470.5471.0000.2070.095
업체명0.9270.1700.1390.1380.1070.2071.0000.134
단위0.0990.1070.3260.2610.2810.0950.1341.000

Missing values

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

구분처방코드제품코드제품명업체명규격단위원료생약의 총함량(g)원료생약의 엑스함량(g)상한금액(원)비고
0단미엑스제제1001S1APD661300110경방갈근엑스산경방신약(주)0.9g2.00.56842<NA>
1단미엑스제제1001S1APD623002540신텍스갈근엑스산한국신텍스제약(주)0.9g2.00.56842<NA>
2단미엑스제제1001S1APD669600070아이월드갈근엑스산(주)아이월드제약0.9g2.00.56842<NA>
3단미엑스제제1001S1APD694202650정우갈근엑스산정우신약(주)0.9g2.00.56842<NA>
4단미엑스제제1001S1APD662402060인스팜갈근엑스산한국인스팜(주)0.9g2.00.56842<NA>
5단미엑스제제1001S1APD655001040한신갈근엑스산(주)한국신약0.9g2.00.56842<NA>
6단미엑스제제1001S1APD658101830한풍갈근엑스산(유)한풍제약0.9g2.00.56842<NA>
7단미엑스제제1002S1APD661300160경방감국엑스산경방신약(주)0.86g2.00.53675<NA>
8단미엑스제제1002S1APD623002550신텍스감국엑스산한국신텍스제약(주)0.86g2.00.53675<NA>
9단미엑스제제1002S1APD669600120아이월드감국엑스산(주)아이월드제약0.86g2.00.53675<NA>
구분처방코드제품코드제품명업체명규격단위원료생약의 총함량(g)원료생약의 엑스함량(g)상한금액(원)비고
1168단미엑스혼합제2055M1APD655006600한신형개연교탕(단미엑스산혼합제)(주)한국신약10.32g33.446.3621228<NA>
1169단미엑스혼합제2055M1APD658105380한풍형개연교탕(단미엑스산혼합제)(유)한풍제약10.32g33.446.3621228<NA>
1170단미엑스혼합제2055M1AXS661304810경방형개연교탕연조엑스(단미엑스혼합제)경방신약(주)30.0g33.4412.5271228<NA>
1171단미엑스혼합제2055M1AXS658106090한풍형개연교탕연조엑스(단미엑스혼합제)(유)한풍제약36.0g33.4411.851228<NA>
1172단미엑스혼합제2055M1AXS655006810한신형개연교탕연조엑스(단미엑스혼합제)(주)한국신약30.0g33.4412.9031228<NA>
1173단미엑스혼합제2055M1AXS694205500정우형개연교탕연조엑스(단미엑스혼합제)정우신약(주)30.0g33.4412.9031228<NA>
1174단미엑스혼합제2056M1APD661304580경방회춘양격산(혼합단미엑스산)경방신약(주)8.82g30.85.4561216<NA>
1175단미엑스혼합제2056M1APD655006640한신회춘양격산(단미엑스산혼합제)(주)한국신약8.82g30.85.4561216<NA>
1176단미엑스혼합제2056M1APD658105510한풍회춘양격산(단미엑스산혼합제)(유)한풍제약8.82g30.85.4561216<NA>
1177단미엑스혼합제2056M1AXS661305240경방회춘양격산연조엑스(단미엑스혼합제)경방신약(주)30.0g30.811.31541216<NA>

Duplicate rows

Most frequently occurring

구분처방코드제품코드제품명업체명규격단위원료생약의 총함량(g)원료생약의 엑스함량(g)상한금액(원)# duplicates
0단미엑스제제1059S1APD658103800한풍택사엑스산(유)한풍제약0.68g4.00.412932
1단미엑스제제1060S1APD623003070신텍스행인엑스산한국신텍스제약(주)0.92g4.00.576642
2단미엑스제제1060S1APD655005350한신행인엑스산(주)한국신약0.92g4.00.576642
3단미엑스제제1060S1APD658103900한풍행인엑스산(유)한풍제약0.92g4.00.576642
4단미엑스제제1060S1APD661302000경방행인엑스산경방신약(주)0.92g4.00.576642
5단미엑스제제1060S1APD662404580인스팜행인엑스산한국인스팜(주)0.92g4.00.576642
6단미엑스제제1060S1APD669602010아이월드행인엑스산(주)아이월드제약0.92g4.00.576642
7단미엑스제제1060S1APD694203000정우행인엑스산정우신약(주)0.92g4.00.576642
8단미엑스제제1061S1APD623003080신텍스향부자엑스산한국신텍스제약(주)0.64g2.00.396482
9단미엑스제제1061S1APD655005380한신향부자엑스산(주)한국신약0.64g2.00.396482