kitestring / detectorstressquantification Goto Github PK

View Code? Open in Web Editor NEW

ETL flat data exported from a Chemical Analyzer instrument (TOF-MS). While the data is still in memory, data is cleansed and linked so that primary and foreign keys can be generated prior to loading into a Postgres managed database using a Star schema. A CLI is implemented to query the DB to generate customizable data visualizations.

Python 99.47% Shell 0.27% Batchfile 0.27%

detectorstressquantification's Introduction

DetectorStressQuantification

Application Dependencies

Python 3.6.4
Linux cinnamon 18.3 or Windows10 64 bit
pandas==0.22.0
numpy==1.14.0
matplotlib==2.1.2
psycopg2==2.7.4
os
pprint
datetime
re
math

Application Description

ETL flat data exported from a Chemical Analyzer instrument (TOF-MS). While the data is still in memory data is cleansed and linked so that primary and foreign keys can be generated prior to loading into a Postgres managed database using a Snowflake schema. A CLI is implemented to query the DB to generate customizable data visualizations.

Database Schema

Command Line Interface (CLI) Example

To maintain confidentiality the data examples shown below are not “real” and are simulated data sets.

Detector Measurement Ion Statistics Plot examle

System Performance vs Detector Voltage Offset

Recommend Projects

kitestring / detectorstressquantification Goto Github PK