PKGN
Desktop app and command line interface to extract, transform and visualize pharmacogenetic data
Briefing
Professor Léa Payen works every day with pharmacogenetic data and needed a way to summarize, visualize and enhance all the information she got from different lab's equipment and international databases, and export it into a format suitable for the main software used at the hospital. She had initially crafted quite a complicated set of Excel workbooks with lots of macros, that she needed to feed the data manually, which was a painful and time-consuming task.
Services
What we built
PKGN is a desktop app built with web technologies that provides polymorphic drug-drug interactions computations and graphs, as well as summary tables with configurable highlighting rules, sorting and Excel export features, and more. The application works with a database that can be updated by uploading simple Excel files, which is easier to manage and share for our client. We also built a command-line interface tool which allows to parse and transform a large number of files in just a few seconds, saving Léa days of tedious, no value-added work, allowing her to focus on what's more important.
Expertise
Life of the project
2021
First version of the PKGN app
2022
New features
2023
Creation of the CLI tool
About the client
The Hospices Civils de Lyon is a group of 13 public hospitals of excellence with 24,000 healthcare professionals representing all medical and surgical disciplines. It is also the 2nd largest university hospital (CHU) in France, thanks to its 11 schools and training institutes and its close ties with Claude Bernard Lyon 1 University.
