1 files changed, 18 insertions, 10 deletions
diff --git a/toBlackboardCSV.py b/toBlackboardCSV.py
index 7837ea7..019158c 100755
--- a/toBlackboardCSV.py
+++ b/toBlackboardCSV.py
@@ -10,24 +10,32 @@ import sqlite3
 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)
+# 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)
+dOut["UserName"] = dOut["UserName"].str.replace("@.*$", "", regex=True)
+dOut.rename(columns={"UserName": "Username"}, inplace=True)
 
 # exclude inforows
-dOut = dOut.loc[ dOut['GroupName'].isin(['student']) ]
+dOut = dOut.loc[dOut["GroupName"].isin(["student"])]
 
 # remove unneeded info cols
-infoCol=['FirstName', 'LastName', 'GroupName', 'UserHiddenColums', 'UserHiddenGroups', 'UserHiddenGradeCategories', 'SectionNum', 'IdNum']
+infoCol = [
+    "FirstName",
+    "LastName",
+    "GroupName",
+    "UserHiddenColums",
+    "UserHiddenGroups",
+    "UserHiddenGradeCategories",
+    "SectionNum",
+    "IdNum",
+]
 dOut = dOut.drop(infoCol, axis=1)
 
-fout = 'BlackBoard.csv'
-dOut.to_csv('BlackBoard.csv', index=False)
-print(f'Data was exported to {fout}')
-
+fout = "BlackBoard.csv"
+dOut.to_csv("BlackBoard.csv", index=False)
+print(f"Data was exported to {fout}")