vidithm / contest-stats Goto Github PK

Purpose

• Used to determine who the top checked-in performers are in a Codeforces-hosted ACPC contest, both overall and by graduation year

How to Use

• This is an entirely offline tool. You need to download the contest sign-up spreadsheet (such as the one here) as signups.tsv. The standings page for the Codeforces contest must also be downloaded as standings.html.
• The spreadsheet must have columns for the registrant's first/last name, Codeforces handle, graduation year, degree type, and whether they checked in. The names for these columns must match the pattern *First Name*, *Last Name*, *Codeforces Handle*, *Graduation Year*, *Degree Type*, and *Checked In*, respectively. The value for the checked in column must be yes if the registrant checked in and may be anything else (including empty) otherwise.
• Download/unpack this repository and navigate to it
• Run pip install -r requirements.txt to make sure all Python dependencies are installed
• Make sure signups.tsv and standings.html are in the same directory as main.py. Now, you can simply run the script. You can also run with the -f option and provide a filename (i.e. python main.py -f data.out) to write the results to a file.

Output Format

• If everything works properly, the script will print standings by class year (for undergraduates), graduate and PhD standings, and overall standings. Each line will appear as follows: [group rank] ([general rank]): [codeforces handle], [first name] [last name]
• If a checked-in participant was not found in the standings, an error will be produced: [ERROR]: "[codeforces handle]" not found in standings!

Notes

• Make sure the spreadsheet data is not malformed for checked-in participants (this should be done when each person checks in). You will probably get incorrect results otherwise.
• In particular, make sure there is no extraneous whitespace at the end of signups.tsv, otherwise the script will not work.