search

jyn514 / GradeForge

Courses available from my.sc.edu
GNU General Public License v3.0
1 stars 0 forks source link

improve data quality #61

Closed jyn514 closed 6 years ago

jyn514 commented 6 years ago

Before:

$ sqlite3 gradeforge/classes.sql 'select distinct exam_date from exam'
Dec 9
Dec 5
Dec 7
Dec 6
Dec 8
Dec 10
Dec 11
Dec 13
Dec 15
Dec 14
Dec 12
Dec 16
Oct 18
Oct 17
Wednesday
Tuesday
May 14
May 27
May 28
June 17
June 18
July 29
July 30
June 24
June 25
Aug 6
Aug 8
June 30
July 1
Aug 5
Aug 14
Aug 15
June 23
Aug 11
Aug 12
May 26
July 21
Augu 4
Augu 5
TBA
June 22
Aug 3
Aug 4
June 1
July 13
May 1
April 28
April 26
May 2
April 27
April 29
Satuay
Mar 1
Feb 28
Friday
Moay
Thursday
March 7
March 6

After:

$ sqlite3 gradeforge/classes.sql 'select distinct exam_date from exam'
Dec 9
Dec 5
Dec 7
Dec 6
Dec 8
Dec 10
Dec 11
Dec 13
Dec 15
Dec 14
Dec 12
Dec 16
Oct 18
Oct 17
Wednesday
Tuesday
May 14
May 27
May 28
June 17
June 18
July 29
July 30
June 24
June 25
Aug 6
Aug 8
June 30
July 1
Aug 5
Aug 14
Aug 15
June 23
Aug 11
Aug 12
May 26
July 21
August 4
August 5
TBA
June 22
Aug 3
Aug 4
June 1
July 13
May 1
April 28
April 26
May 2
April 27
April 29
Saturday
Mar 1
Feb 28
Friday
Monday
Thursday
March 7
March 6

TODO: replace relative dates (Mon, Tues) with absolute dates (March 7)