Drug Analysis with Syncropath Data

#print(combined_df)
print(files)
## [1] "syncropatch-trace-220116.xlsx"
# Run the Shiny App
shinyApp(ui, server)
print(dataCI)
##                             drug    IC50s.nM. IC50_95CI.nM.    hillslop
## 1             Bepridil-220622-PT 4.885688e+01  1.351843e+01   0.9767036
## 2          Domperidone-220622-PT 2.623134e+01  6.017404e+00   1.1388606
## 3             Bepridil-220706-RT 9.350272e+01  6.193937e+01   1.1217055
## 4          Domperidone-220706-RT 2.521412e+01  4.266940e+00   1.5385836
## 5           Metoprolol-220715-RT 6.867198e+04  8.766676e+03   1.4946637
## 6          Ondansetron-220721-RT 1.012001e+03  1.555919e+02   0.9688301
## 7             Pimozide-220722-RT 5.741816e+00  3.744995e+00   0.5769636
## 8            Quinidine-220824-RT 3.077033e+02  1.265662e+02   1.1327911
## 9            Tamoxifen-220824-RT 3.590879e+02  5.536170e+01   1.4159866
## 10           Quinidine-220825-RT 3.135022e+02  3.329300e+01   2.4217085
## 11      Clarithromycin-220826-RT 2.139137e+04  6.649923e+03   1.0577066
## 12          Vandetanib-220826-RT 1.165588e+02  7.049729e+01   0.6645615
## 13           Cisapride-220921-RT 1.927788e+01  7.738065e+00   0.8919397
## 14           Ibutilide-220923-RT 5.425573e+00  2.046104e+00   1.0692605
## 15           Ritonavir-220923-RT 1.631416e+04  9.031619e+03   0.4633567
## 16           Lopinavir-220927-RT 2.124112e+06  2.068658e+10 601.2917234
## 17          Loratadine-220927-RT 4.756640e+03  6.545100e+02   1.9429341
## 18           Ritonavir-220928-RT 7.849353e+03  2.127497e+03   0.6770874
## 19           Verapamil-220928-RT 1.843840e+02  6.119223e+01   0.8290549
## 20           Lopinavir-220929-PT 7.419745e+03  1.243497e+03   0.6808149
## 21           Ritonavir-220929-PT 5.173268e+03  4.471089e+02   1.2035313
## 22           Clozapine-221004-RT 3.251865e+02  4.303384e+01   1.2829110
## 23           Azimilide-221005-RT 9.045838e+01  2.493380e+01   1.1160949
## 24         Risperidone-221005-RT 5.338578e+01  2.761186e+01   0.9435173
## 25          Ranolazine-221006-RT 4.115187e+03  1.085511e+03   1.3015217
## 26          Mexiletine-221006-RT 2.488880e+04  7.253586e+03   1.5166631
## 27           Dialtizem-221006-RT 7.533889e+03  1.717272e+03   1.6337864
## 28          Droperidol-221007-RT 9.051735e+01  2.695403e+01   0.9810192
## 29          Astemizole-221007-RT 2.084623e+00  3.347879e-01   1.4121805
## 30          Dofetilide-221007-RT 2.574123e+01  5.860449e+00   1.4673812
## 31             Sotalol-221012-RT 3.834263e+05  1.245978e+05   1.0368378
## 32        Disopyramide-221012-RT 4.455249e+03  1.665263e+03   1.0805146
## 33      Chlorpromazine-221013-RT 6.895614e+02  2.418029e+02   1.6619269
## 34         Terfenadine-221013-RT 4.268341e+01  9.817500e+00   1.0933183
## 35        Nitrendipine-221013-RT 2.030403e+04  4.162675e+03   1.3517673
## 36        Moxifloxacin-221014-RT 3.171760e+01  5.707326e+00   0.9335854
## 37          Droperidol-221014-RT 9.082063e+04  1.580663e+04   1.2152153
## 38            Diltizem-221014-RT 1.258392e+04  2.163663e+03   0.9181545
## 39          Nifedipine-221014-RT 1.449648e+05  3.670432e+04   0.8425180
## 40           Azimilide-221018-PT 8.358950e+01  2.095352e+01   1.0100823
## 41           Clozapine-221018-PT 5.714562e+02  9.377698e+01   1.1206037
## 42         Risperidone-221018-PT 1.388798e+02  2.973551e+01   0.8224714
## 43          Astemizole-221027-PT 2.696054e+01  1.390988e+01   0.4391140
## 44          Droperidol-221102-PT 8.676046e+01  2.519211e+01   0.7528039
## 45          Astemizole-221102-PT 3.224241e+01  1.720511e+01   0.6369430
## 46          Dofetilide-221102-PT 1.005049e+01  1.940414e+00   1.3880191
## 47          Droperidol-221116-PT 9.221568e+01  3.519028e+01   1.4387064
## 48          Astemizole-221116-PT 5.036354e+01  2.289145e+01   0.9150534
## 49          Ranolazine-221201-PT 7.471008e+03  1.126068e+03   1.2538181
## 50          Mexiletine-221201-PT 3.104919e+04  5.568933e+03   1.2353562
## 51           Dialtizem-221201-PT 5.329082e+03  1.328526e+03   1.0463801
## 52          Vandetanib-221208-PT 2.145921e+02  2.050778e+02   0.5102792
## 53      Clarithromycin-221213-PT 2.504859e+04  3.111549e+03   1.1266880
## 54           Cisapride-221213-PT 4.534742e+01  9.410386e+00   1.2045969
## 55           Quinidine-221214-PT 8.947946e+02  2.764672e+02   1.6843474
## 56           Tamoxifen-221214-PT 2.463798e+03  2.878060e+03   0.8264827
## 57          Pitolisant-221214-PT 4.558926e+02  4.940229e+01   1.3982097
## 58           Quinidine-221216-PT 1.013400e+03  1.372799e+02   1.3583616
## 59           Tamoxifen-221216-PT 1.719206e+03  1.666158e+03   0.9785962
## 60           Ibutilide-221220-PT 5.890533e+00  1.374558e+00   1.2921780
## 61            Bepridil-221221-PT 2.267586e+01  3.823618e+00   2.0844724
## 62         Domperidone-221221-PT 8.309650e+01  2.379199e+02   0.4702810
## 63          Astemizole-230111-PT 7.022854e+01  7.933984e+01   0.3951869
## 64 Astemizole+0.01%BSA-230111-PT 1.081801e+01  2.546796e+00   1.2827337
## 65         Ondansetron-230210-PT 1.217630e+03  4.378533e+02   1.1003415
## 66          Metoprolol-230210-PT 1.055972e+05  4.169621e+04   0.8538252
## 67             Sotalol-230214-PT 1.967065e+05  3.761341e+04   1.0031243
## 68        Disopyramide-230214-PT 4.731713e+03  7.554070e+02   1.1334365
## 69        Moxifloxacin-230215-PT 4.334647e+04  4.591441e+03   0.8602868
## 70            Pimozide-230215-PT 1.304383e+01  1.212544e+01   0.2910208
## 71          Loratadine-230217-PT 2.489877e+03  5.385801e+02   0.8101485
## 72        Nitrendipine-230217-PT 3.553256e+03  5.213363e+02   1.5155520
## 73      Chlorpromazine-230228-PT 3.234738e+02  2.392554e+01   1.3776542
## 74         Terfenadine-230228-PT 7.419625e+00  1.829104e+00   1.9719712
## 75           Verapamil-231005-PT 2.160059e+02  5.571326e+01   1.1536932
## 76         Ondansetron-231005-PT 6.356823e+02  1.701486e+02   1.1461913
## 77        Disopyramide-231214-RT 2.602929e+04  3.626793e+03   2.7706145
## 78             Sotalol-231215-RT 1.611701e+06  5.114057e+05   1.1582530
## 79          Pitolisant-231215-RT 2.975593e+02  4.245434e+01   1.3274916
##      slop_95CI    pIC50 pIC50_95CI pIC50_slop pIC50_slop_95CI             Cells
## 1   0.32390034 7.311887 0.11198251 -17.112352       5.2950827    9 | 4 | 10 | 7
## 2   0.27289982 7.569091 0.10038744 -19.594250       4.6692217   5 | 11 | 4 | 10
## 3   0.67629349 7.041772 0.26388304 -19.430538      11.3628817    3 | 7 | 11 | 6
## 4   0.39108147 7.593000 0.07463256 -27.072302       7.0384418     5 | 6 | 7 | 5
## 5   0.33575538 4.157898 0.05406822 -14.840637       3.2583723  8 | 15 | 15 | 18
## 6   0.17075053 5.983013 0.06514988 -13.266825       2.3055657     8 | 9 | 7 | 3
## 7   0.33261897 8.235610 0.27060816 -11.429585       6.4736785     2 | 4 | 4 | 5
## 8   0.76752354 6.512964 0.19153364 -15.872309      11.5186257         6 | 3 | 9
## 9   0.37571365 6.439996 0.06546678 -20.955572       5.3763925  8 | 11 | 12 | 14
## 10  0.68231132 6.503021 0.04798972 -34.863415       9.8245859   4 | 10 | 8 | 11
## 11  0.34383346 4.651853 0.13381082 -11.426334       3.6822043    9 | 10 | 8 | 3
## 12  0.28738309 6.907139 0.26022642 -10.508087       4.4234367     5 | 8 | 5 | 6
## 13  0.34552281 7.711855 0.16973564 -16.364296       6.3359455     4 | 6 | 6 | 5
## 14  0.47505644 8.256383 0.16983280 -19.584244       8.7693059     6 | 8 | 6 | 6
## 15  0.21991217 4.791956 0.19949714  -5.973218       2.5904094     5 | 4 | 5 | 9
## 16 20.68657610 4.763533 0.16490262 -10.843230       2.9838150    4 | 10 | 7 | 4
## 17  0.44577906 5.316125 0.05957244 -23.660709       5.2546327     1 | 4 | 6 | 7
## 18  0.17941308 5.090639 0.11095053  -8.264531       2.1053980     6 | 8 | 5 | 6
## 19  0.18602567 6.705154 0.14088950 -12.466832       2.6581310     4 | 5 | 4 | 8
## 20  0.09051268 5.135708 0.06293466  -8.842862       1.0805810 24 | 31 | 25 | 18
## 21  0.12494812 5.273479 0.03705088 -14.610528       1.4674795  18 | 25 | 9 | 15
## 22  0.25785858 6.486842 0.06031020 -18.203516       3.7472439  16 | 12 | 12 | 7
## 23  0.35781203 7.034501 0.11486242 -17.966277       5.6551843     4 | 5 | 4 | 4
## 24  0.37286195 7.261501 0.22700945 -15.168679       5.9106584     3 | 2 | 8 | 2
## 25  0.39629420 5.374684 0.12439886 -16.393631       5.7471940     5 | 3 | 4 | 4
## 26  0.64688637 4.594423 0.13159336 -15.963102       7.4239995     6 | 4 | 4 | 3
## 27  0.85265183 5.123341 0.09792912 -20.035097      10.4232865     3 | 7 | 3 | 1
## 28  0.32130449 7.032198 0.12772136 -15.910183       5.1561194         5 | 3 | 4
## 29  0.29821843 8.674585 0.06881203 -27.996955       5.8848024    10 | 6 | 6 | 1
## 30  0.46144258 7.583242 0.09749104 -25.748698       8.0890626         9 | 5 | 3
## 31  0.40414101 3.397995 0.14070588  -7.891600       3.0617821     3 | 6 | 5 | 3
## 32  0.50017259 5.339344 0.16255033 -13.149909       6.0739684     4 | 7 | 4 | 4
## 33  1.06423020 6.160763 0.15074860 -23.039074      14.7275254     1 | 8 | 3 | 4
## 34  0.34342119 7.362193 0.10045988 -18.340563       5.7272379    6 | 17 | 6 | 5
## 35  0.34621813 4.679779 0.08888746 -14.193266       3.7831241    9 | 6 | 4 | 11
## 36  0.16970921 7.485508 0.07955441 -15.850733       2.9518647   14 | 10 | 6 | 9
## 37  0.27334878 4.027586 0.07257712 -11.245114       2.3640332  7 | 11 | 14 | 17
## 38  0.18882569 4.890107 0.07379613 -10.608007       2.0976532    9 | 9 | 14 | 5
## 39  0.19798148 3.817523 0.10834520  -7.833357       1.8546531    7 | 8 | 7 | 11
## 40  0.28187111 7.074046 0.10873875 -15.998829       4.4314697    2 | 8 | 13 | 5
## 41  0.14794832 6.226064 0.07384293 -15.504764       2.0470690            3 | 10
## 42  0.19179757 6.848664 0.09318833 -12.772836       2.9845034    2 | 4 | 11 | 4
## 43  0.13281127 7.581326 0.19971685  -8.341080       2.4238713     6 | 7 | 5 | 5
## 44  0.20186349 7.045286 0.12202589 -12.264880       3.1730953    1 | 4 | 3 | 10
## 45  0.28157485 7.503135 0.20892205 -11.922868       5.0607500     5 | 7 | 7 | 8
## 46  0.44515964 7.998207 0.08701982 -24.641395       8.0138683     9 | 9 | 4 | 3
## 47  0.84878141 7.031621 0.16487833 -23.755316      14.4856165     8 | 6 | 1 | 3
## 48  0.49269131 7.301410 0.18448525 -16.243018       8.4564218     1 | 6 | 8 | 8
## 49  0.19609774 5.107965 0.06391218 -14.492685       2.2488278     8 | 2 | 4 | 4
## 50  0.28977962 4.497844 0.08186574 -12.369109       3.0596208     3 | 7 | 8 | 5
## 51  0.31891301 5.261440 0.10468748 -12.814720       3.8677282     7 | 7 | 6 | 3
## 52  0.34948682 6.667443 0.38487780  -8.397730       5.6634915     4 | 5 | 3 | 4
## 53  0.13982425 4.581254 0.05451444 -11.984536       1.5274245 20 | 11 | 15 | 11
## 54  0.30665477 7.338076 0.08755664 -20.820747       5.0258889   14 | 14 | 9 | 5
## 55  0.45689634 6.027484 0.13517326 -23.297202       6.3798946         8 | 6 | 4
## 56  0.65722491 5.639008 0.44818747 -11.951968       9.3236421    3 | 13 | 6 | 9
## 57  0.22968637 6.334891 0.04831642 -19.872772       3.3746900    12 | 8 | 9 | 5
## 58  0.21846618 5.983213 0.05744705 -18.673293       2.9728890   14 | 9 | 11 | 8
## 59  0.83895187 5.784415 0.37867205 -14.312017      12.0619301     4 | 8 | 3 | 6
## 60  0.38973529 8.220439 0.10460140 -23.658776       7.2912445         3 | 4 | 9
## 61  0.60352613 7.639638 0.07415424 -36.072197      10.5416601     6 | 5 | 8 | 4
## 62  0.79665564 7.094994 1.15244948  -8.336895      14.1802697         4 | 4 | 4
## 63  0.25695866 7.173284 0.44850924  -7.175272       4.6521764     3 | 2 | 7 | 5
## 64  0.41397245 7.959347 0.10328109 -23.374649       7.5722710     4 | 6 | 5 | 6
## 65  0.45767046 5.902631 0.15093224 -14.928557       6.0215222     4 | 4 | 4 | 2
## 66  0.36632330 3.980436 0.15809841  -8.531985       3.6394887     1 | 4 | 2 | 4
## 67  0.20012709 3.686408 0.08880365  -7.965211       1.7027051     7 | 4 | 7 | 5
## 68  0.21685432 5.312550 0.06811883 -13.827509       2.5993584  10 | 12 | 10 | 8
## 69  0.08333217 4.343625 0.04333270  -8.204834       0.7486366 12 | 15 | 14 | 16
## 70  0.09892887 7.938817 0.35214569  -6.031158       2.0221260  14 | 13 | 13 | 5
## 71  0.20832717 5.591705 0.09087219 -10.468189       2.5762534   2 | 13 | 12 | 8
## 72  0.43048261 5.446237 0.06675556 -18.291472       5.3348958     5 | 4 | 2 | 1
## 73  0.11550394 6.476988 0.03203193 -20.153578       1.6894384     9 | 2 | 7 | 3
## 74  1.24336180 8.131730 0.11098430 -35.962193      23.1906208     9 | 6 | 6 | 5
## 75  0.24277096 6.643888 0.11480889 -17.195057       3.6188391     1 | 4 | 5 | 4
## 76  0.31010880 6.186250 0.11785640 -15.933354       4.4138995     3 | 3 | 7 | 4
## 77  1.78110300 4.582563 0.05848445 -29.945181      19.0735485     1 | 7 | 4 | 7
## 78  0.49002002 2.774812 0.13661557  -7.787206       3.1977056     2 | 2 | 4 | 5
## 79  0.27811091 6.518650 0.06020747 -20.182681       4.2388886         4 | 9 | 2