Our re-creation of Chase's tool to build the discrepancy report for the infauna data
The file called ChasesTool.ipynb is a jupyter notebook that has the code we are using along with line by line explanations, as well as the output that it gives. It also gives a report of the differences between the original discrepancy report and the python generated one. Click on it to check it out.
The file called DiscrepancyReport-Python.csv is the actual output from our python code re-creation of Chase's tool. Again, you can just click on it and github will display it.
The file called Original_Data.csv is one of the dataframes we used to build the report. It is also the same as the first tab of the Infauna_QC_B13_OCSD.xlsm excel workbook. You can click on it and github will display it.
The file called QC_Data.csv is the other dataframe we used to build the report. It is also the same as the second tab of the Infauna_QC_B13_OCSD.xlsm excel workbook. You can click on it and github will display it.
The file called DiscrepancyReport-Original.csv is the original discrepancy report that was given to us and which was created by Chase's excel tool. It is also the same as the third tab of the Infauna_QC_B13_OCSD.xlsm excel workbook. You can click on it and github will display it.
DiscrepancyReport-Original-Sorted.csv is the original report sorted in the same way as the python report, so that it is easier to compare the two.
The file called Infauna_QC_B13_OCSD.xlsm is the original initial and QC Data used to build the report that we created. This excel workbook also contains the original output from Chase's actual tool that was built in excel (the 3rd tab, called Discrepancy_Report). You cannot click to display it. This file needs to be downloaded.
chaseapp.py is the original python script that I worked with to create all this stuff.