Extracts and cleanses flat data exported from a Chemical Analyzer instrument (Time of Flight Mass Spectrometer), then loads data into a SQL database using a Star schema. A basic GUI is implemented to query SQL database to create data visualizations which describe instrument performance in a simple and digestible manner. The following python libraries are utilized: numpy, pandas, matplotlib, sklearn, statistics, sqlite3, os, time, & datetime. Instance data is stored in JSON format in the dicts.txt text file.
To maintain confidentiality the data examples shown below are not “real” and are simulated data sets.
