Python Scripting
Python Pandas Numpy Matplot lib PyoDBC SQL
Multivariate Comparisons
Initially the analysis looked to compare two analytical results results with one another. I needed to know how well features compare between two tests, and how well did the magnitude of the features correlate.
Though comparison across the entire feature set was important, each test was composed of several different sub categories that needed to be compared in isolation as well.
Data was stored in a SQL database, and the list of comparisons was held in a basic excel file. The below code allowed for me to query appropriate data from SQL and excel,
iterate over the list of comparisons, perform all the necessary calculations, and produce a dataframe that holds every calculated comparison variable across every evaluated pair inclusive of the subcategories important to each comparison.
I then wanted to evaluate how the metrics changed when features under a specific magnitude were removed from the evaluation. The below function LimitTest() allowed iteration over threshold values and the set average of each metric was captured through each threshold limit.
The below commented code reveals how these objectives were achieved.
