1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
#!/usr/bin/python3
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)
fout = 'BlackBoard.csv'
dOut.to_csv('BlackBoard.csv', index=False)
print(f'Data was exported to {fout}')
|
