Making UCL PHAS results better
Project description
resultr
Makes UCL PHAS results better
note it's very possible that I made mistakes so take what this gives with a bucketload of salt.
UCL Physics and Astronomy publishes the results for every year as a pdf with this format:
Candidate Number | Devcom | Module1 | Mark | Module2 | Mark | Module3 | Mark | Module4 | Mark | Module5 | Mark | Module6 | Mark | Module7 | Mark | Module8 | Mark | Provisional outcome |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ABCD0 | 100 | PHAS0000 | 99 | PHAS0001 | 98 | PHAS0002 | 97 | PHAS0003 | 96 | PHAS0004 | 95 | PHAS0005 | 94 | PHAS0006 | 93 | PHAS0007 | 92 | P |
ABCD1 | 24 | PHAS0003 | 93 | PHAS0001 | 55 | PHAS0004 | 43 | PHAS0007 | 40 | PHAS0002 | 34 | PHAS0006 | 25 | PHAS0005 | 15 | PHAS0000 | 3 | >> |
resultr lets you:
- get your weighted average for a year
- get your rank in your year
- plot a histogram of the results for a module in the bins: (0,40), (40,50), (50, 60), (60, 70), (80, 90), (90, 100)
- re-format the results by module (as below) and output to csv
output format:
Devcom | PHAS0000 | PHAS0001 | PHAS0002 | PHAS0003 | PHAS0004 | PHAS0005 | PHAS0006 | PHAS0007 | Averages |
---|---|---|---|---|---|---|---|---|---|
100 | 99 | 98 | 97 | 96 | 95 | 94 | 93 | 92 | 95.5 |
24 | 3 | 55 | 34 | 93 | 43 | 15 | 25 | 40 | 39 |
Usage example
Requires:
- Python 3
- pandas and matplotlib for plotting
- python-inquirer for the user input
Making the PDF usable
You're going to need to convert the .pdf given by UCL into a csv, delimited with ','. To do this I used smallpdf's PDF to Excel converter (this makes an xlsx with a sheet for every page of the page of the pdf). Then I used Google Docs to export each sheet as a csv, and combined them in a texteditor (note though that you should remove the heading lines (cand, devcom, module1, etc) from all pages apart from the first)
Running resultr
You can run interact with resultr using inquirer prompts:
Or equivalently by passing arguments when you run resultr:
$ python resultr.py -h
usage: resultr.py [-h] [--input INPUT] [--format FORMAT] [--plot]
[--exportplots EXPORTPLOTS] [--showplots] [--my]
[--year YEAR] [--rank] [--candidate CANDIDATE]
Makes UCL PHAS results better
optional arguments:
-h, --help show this help message and exit
--input, -i INPUT
csv file to import
--format, -f FORMAT
reformats results by module and exports it to file
specified
--plot, -p plot the module results
--exportplots, -ep EXPORTPLOTS
export all plots to /path/you/want/
--showplots, -sp show all plots
--my, -m returns your weighted average for the year
--year, -y YEAR specify your year
--rank, -r returns your rank in the year
--candidate, -c CANDIDATE
specify your candidate number
Release History
- 0.1.3
- fixed inquirer version
- 0.1.2
- added pip
- 0.1.1
- Moved prompt and cli code from
'__main__'
tomain()
- Changed name to resultr cause cool
- Moved prompt and cli code from
- 0.1.0
- The first proper release
Meta
Hayk Khachatryan – hi@hayk.io
Distributed under the MIT license. See LICENSE
for more information.
Contributing
- Fork it (https://github.com/haykkh/resultr/fork)
- Create your feature branch (
git checkout -b feature/fooBar
) - Commit your changes (
git commit -am 'Add some fooBar'
) - Push to the branch (
git push origin feature/fooBar
) - Create a new Pull Request
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.