A Python Jupyter Notebook which generates an Excel worksheet of response rates for the BC Student Outcomes Baccalaureate Graduates Survey
Install Pandas: pip install pandas
Install Numpy: pip install numpy
Update the value of 'raw_data_path' to the response rate raw data
Run each cell in the Notebook one at a time
Look at the results in Summary report tables.xlsx
Note: this program will look for hard coded column names to extract the data from. Make sure that your raw data has these exact column names:
Make sure that the raw data contains different rows for institution totals where the PROGRAM column is "INST TOTAL" and one separate row for the grand total where the INST_NAME column is "Grand Total"
Eg:
INST | INST_NAME | PROGRAM |
---|---|---|
Grand Total | ||
BCIT | British Columbia Institute of Technology | INST TOTAL |