-
Notifications
You must be signed in to change notification settings - Fork 0
/
3_exam_schedule_extractor.py
57 lines (48 loc) · 1.77 KB
/
3_exam_schedule_extractor.py
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
"""
Accepts an Excel file + List of courses and gives the dates and times for exams.
"""
import sys
import getopt
import pandas
import re
from datetime import datetime
def main(argv):
courses = []
inputfile = ""
try:
opts, args = getopt.getopt(argv, "hc:i:", ["courses=", "file="])
except getopt.GetoptError:
print('Usage: -c <courses> -i <inputfile>')
sys.exit(2)
if len(opts) == 0:
sys.exit()
for opt, arg in opts:
if opt == '-h':
print('Usage: -c <courses> -i <inputfile>')
sys.exit()
elif opt in ("-c", "--courses"):
courses = [i.strip() for i in arg.split(',')]
elif opt in ("-i", "--file"):
inputfile = arg
schedule = pandas.read_excel(io=inputfile)
days = [schedule[i] for i in schedule.columns]
courses_with_dates = {}
for i, course in enumerate(courses):
for day in days:
if course in day.values:
time = []
to_append = None
for cell in day.values:
match = re.search(r"[0-9]{2}:[0-9]{2}:[0-9]{2}", str(cell))
if match:
to_append = match[0]
elif course in str(cell):
time.append(to_append)
to_append = None
day[0] = day[0].replace(chr(10), ' ')
date = datetime.strptime(day[0][:day[0].index(' ')], "%d.%m.%Y").date()
courses_with_dates[course] = [day[0], time, date]
courses_with_dates = sorted(courses_with_dates.items(), key=lambda a:str(a[1][2]) + ' '.join(a[1][1]))
for k, v in courses_with_dates: print(f"{k} @ {v[0]}. Time: {v[1]}")
if __name__ == '__main__':
main(sys.argv[1:])