This project, the PyShinyDataTable app, revolutionises data collection and display in healthcare settings like hospitals or clinics. This Shiny-Express app empowers users to collect patient data in Excel files efficiently, store it in an SQLite database, and effortlessly display the records in a dynamic Data Table using the iTables JavaScript python library. Key Features: 1. Data Upload: The app allows users to upload Excel data files to the SQLite database. Users can choose the file, specify headers, and load the data with a single click. The uploaded data is instantly displayed in an interactive Data Table for easy access. 2. Duplicate Record Handling: To maintain data integrity, the app includes logic to prevent duplication of records. The app filters out duplicate entries by checking for existing hospital numbers in the database, ensuring a clean and accurate data repository. 3. Interactive Data Table: The Data Table powered by the iTables package offers advanced functionalities such as conditional formatting, data filtering, and export options. Users can seamlessly filter data based on conditions, copy data to CSV or Excel formats, and even print the data directly from the table interface.
-
Notifications
You must be signed in to change notification settings - Fork 0
Enhancing Data Collection and Display with PyShinyDataTable
License
AbdulrahamanMusa/PyshinyDataTable
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Enhancing Data Collection and Display with PyShinyDataTable
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published