26 Metadata Lookup App
Instructions
For this project we will be developing a web app for our lab that will allow us to look up and track samples that we have processed (the lab and samples are made up). We will review and normalize the data in preparation for moving it into an SQL database and set up the web app.
The raw data contain both clinical and sample data, and data were collected over several clinical visits (these data are available for download on Blackboard). Don’t work too hard to make sense of the data, as the simulation isn’t very sophisticated, but there are some missing values that will need to be handled appropriately.
Assignment
Complete the following tasks and submit a link to your GitHub repository on Blackboard.
- Clean the data as needed
- Normalize the clinical and metadata in preparation for the creation of an SQL database
- Create an SQLite database with the cleaned, normalized data
- Create a web app that can be used to look up patient and sample information
- Include appropriate documentation and tests