{"repo":"Madgrades/madgrades-extractor-legacy","free":true,"listed":false,"github":"https://github.com/Madgrades/madgrades-extractor-legacy","clone":"git clone https://github.com/Madgrades/madgrades-extractor-legacy.git","description":"UW-Madison course and grade distribution data extraction tool.","language":"Java","stars":18,"topics":["uw-madison","pdf-extractor","csv","sql","java-8","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"madgrades-extractor This project reads UW Madison grade distribution and course report PDF files (published by the UW Madison Office of the Registrar) and converts them into CSV or SQL dump files. You will find published, update-to-date datasets at Kaggle. You can also find up to date datasets at UW-Madison's Office of the Registrar. Conversion The conversion process for a single term is as follows: 1. Open DIR report for the term. a. Extract table from PDF (using tabula) b. Read each row, adding new section per row. c. Collate section info as necessary (i.e. 2 instructors for 1 single section) d. Collate courses which appear to be cross-listed (based on similarity between sections offered) 2. Open grades report for the term. a. Extract table from PDF b. Read each row, add add each section grade data to course data added by the DIR report process Typically all terms are extracted so this process repeats for each term. Command Line Usage Build it yourself with mvn clean install or grab a release from the releases page. Examples: java -jar madgrades-final-1.0-SNAPSHOT.jar : will fetch every term and output files to the current directory java -jar madgrades-final-1.0-SNAPSHOT.jar -t 1082 : will fetch just term 1082 java -jar madgrades-final-1.0-SNAPSHOT.jar -o ../ -t 1082,1072 : will fetch terms 1072 and 1082, output to ../ Relational Diagram The CSV or SQL dumps are in the format of a collection of relational entities modeled something like this:","default_branch":null,"files":null,"tree":[],"storefront":"/r/Madgrades","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Madgrades/madgrades-extractor-legacy/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}