ADS Capstone Chronicles Revised

‭23‬

‭Figure 17‬ ‭Most Common Reactions‬

‭Headers‬ ‭in‬ ‭all‬ ‭tables‬ ‭were‬ ‭promoted,‬ ‭and‬ ‭minor‬ ‭processing‬ ‭steps‬ ‭were‬ ‭performed‬ ‭in‬ ‭the‬‭Power‬‭Query‬‭Editor,‬‭including‬‭replacing‬ ‭negligible‬ ‭text‬ ‭characters‬ ‭and‬ ‭creating‬ ‭custom‬ ‭columns‬ ‭to‬ ‭map‬ ‭ordinal‬ ‭values‬ ‭to‬ ‭their‬ ‭categorical‬ ‭counterparts.‬ ‭Relationships‬ ‭between‬ ‭the‬ ‭tables‬ ‭were‬ ‭established‬ ‭in‬ ‭the‬ ‭model view (Figure 16).‬ ‭Figure‬ ‭16‬ ‭Power‬ ‭BI‬ ‭Model‬ ‭View‬ ‭Relationships‬

‭5.3 Model Deployment in Streamlit‬ ‭An‬ ‭application‬ ‭was‬ ‭built‬ ‭using‬ ‭Streamlit‬ ‭(app.py)‬‭by‬‭deploying‬‭the‬‭pretrained‬‭random‬ ‭forest‬ ‭model‬ ‭in‬‭an‬‭interactive‬‭application‬‭in‬ ‭the‬ ‭community‬ ‭cloud,‬ ‭increasing‬ ‭the‬ ‭accessibility‬‭of‬‭the‬‭surveillance‬‭system‬‭from‬ ‭this‬ ‭project.‬ ‭Streamlit‬ ‭allows‬ ‭seamless‬ ‭integration‬ ‭between‬ ‭GitHub‬‭repository‬‭code‬ ‭and‬ ‭app‬ ‭deployment‬ ‭on‬ ‭the‬ ‭web‬ ‭(Streamlit,‬ ‭2024).‬‭The‬‭application‬‭can‬‭be‬‭accessed‬‭here:‬ ‭https://pharma-drug-surveillance-8hihsqcwj‬ ‭6jlv6tpki4s8z.streamlit.app/‬ ‭The‬ ‭application‬ ‭contains‬ ‭two‬ ‭features:‬ ‭an‬ ‭interactive‬ ‭prediction‬ ‭of‬ ‭ADR‬ ‭outcome‬ ‭based‬ ‭on‬ ‭patient‬ ‭and‬ ‭drug‬ ‭information‬ ‭(Figure‬‭18)‬‭and‬‭a‬‭static‬‭graph‬‭display‬‭of‬‭top‬ ‭ten‬‭drugs‬‭for‬‭each‬‭outcome‬‭for‬‭the‬‭reporting‬ ‭period‬‭(Table‬‭7‬‭reports‬‭a‬‭table‬‭version‬‭of‬‭the‬ ‭top‬‭5‬‭drugs‬‭for‬‭brevity).‬‭The‬‭combination‬‭of‬ ‭these‬‭two‬‭features‬‭allow‬‭for‬‭precision‬‭health‬ ‭decisions‬ ‭and‬ ‭high-level‬ ‭public‬ ‭health‬ ‭surveillance.‬ ‭A‬‭disclaimer‬‭is‬‭included‬‭at‬‭the‬ ‭top‬ ‭of‬ ‭the‬ ‭tool:‬ ‭“This‬‭system‬‭does‬‭not‬‭store‬ ‭any‬‭information‬‭from‬‭you‬‭and‬‭should‬‭not‬‭be‬ ‭used‬ ‭to‬ ‭make‬ ‭healthcare‬ ‭decisions‬ ‭without‬ ‭guidance‬‭from‬‭a‬‭healthcare‬‭professional.‬‭By‬ ‭using‬ ‭this‬ ‭tool,‬‭you‬‭confirm‬‭you‬‭understand‬ ‭this information.”‬

‭5.2.2 Dashboard Filters‬ ‭The‬‭dashboard‬‭enables‬‭users‬‭to‬‭filter‬‭records‬ ‭and‬ ‭visuals‬ ‭based‬ ‭on‬ ‭generic‬ ‭drug‬ ‭name,‬ ‭patient‬ ‭sex,‬ ‭and‬ ‭outcome‬ ‭severity‬ ‭level.‬ ‭Users‬ ‭can‬ ‭filter‬ ‭by‬ ‭drug‬‭by‬‭either‬‭searching‬ ‭or‬ ‭scrolling‬ ‭through‬ ‭the‬ ‭dropdown‬ ‭list.‬ ‭To‬ ‭filter‬ ‭by‬ ‭sex,‬ ‭users‬ ‭select‬ ‭the‬ ‭"Female"‬ ‭or‬ ‭"Male"‬ ‭bar‬‭from‬‭the‬‭horizontal‬‭"Patient‬‭Sex‬ ‭Distribution"‬ ‭bar‬ ‭plot.‬ ‭For‬ ‭filtering‬ ‭by‬ ‭severity‬ ‭level,‬ ‭users‬ ‭choose‬ ‭the‬ ‭corresponding‬‭bar‬‭for‬‭"Serious,"‬‭"Death,"‬‭or‬ ‭"Not‬‭Serious"‬‭in‬‭the‬‭"Number‬‭of‬‭Reports‬‭by‬ ‭The‬ ‭most‬ ‭common‬ ‭adverse‬ ‭reactions‬ ‭reported‬ ‭in‬ ‭the‬ ‭dataset‬ ‭include‬ ‭"off‬ ‭label‬ ‭use"‬‭(9.4%‬‭of‬‭all‬‭reports),‬‭"nausea"‬‭(6.9%‬‭of‬ ‭all‬ ‭reports),‬ ‭and‬ ‭"diarrhea"‬ ‭(6.3%‬ ‭of‬ ‭all‬ ‭reports;‬ ‭Figure‬ ‭17).‬ ‭When‬ ‭filtering‬ ‭by‬ ‭sex,‬ ‭the‬‭top‬‭three‬‭reactions‬‭for‬‭females‬‭were‬‭“off‬ ‭label‬‭use,"‬‭"nausea,"‬‭and‬‭"fatigue,"‬‭while‬‭for‬ ‭males,‬‭the‬‭top‬‭three‬‭reactions‬‭were‬‭"off‬‭label‬ ‭use," "pyrexia," and "diarrhea."‬ ‭Severity Level" bar plot.‬ ‭5.2.3 Dashboard Insights‬

173