diff options
| -rw-r--r-- | toBlackboardCSV.py | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/toBlackboardCSV.py b/toBlackboardCSV.py new file mode 100644 index 0000000..e248978 --- /dev/null +++ b/toBlackboardCSV.py @@ -0,0 +1,28 @@ +import sys +import pandas as pd +import numpy as np +import os +import sqlite3 + +# infile = 'gb.db' +infile = sys.argv[1] +con = sqlite3.connect(infile) + +#dIn=pd.read_sql("Select * from 'GradesTable' where GroupName='student'", con) +dIn=pd.read_sql("Select * from 'GradesTable'", con) + + +dOut = dIn.copy() + +# replacing user names in accordance with BlackBoard +dOut['UserName'] = dOut['UserName'].str.replace('@.*$', '', regex=True) +dOut.rename(columns={'UserName':'Username'}, inplace=True) + +# exclude inforows +dOut = dOut.loc[ dOut['GroupName'].isin(['student']) ] + +# remove unneeded info cols +infoCol=['FirstName', 'LastName', 'GroupName', 'UserHiddenColums', 'UserHiddenGroups', 'UserHiddenGradeCategories', 'SectionNum', 'IdNum'] +dOut = dOut.drop(infoCol, axis=1) + +dOut.to_csv('BlackBoard.csv', index=False) |