Interns

Introduction

In this homework you will practice

• reading data from CSV files,
• reading data from JSON files, and
• using classes and objects.

General Instructions

This is an individual assignment.

Collaboration at a reasonable level will not result in substantially similar code. Students may only collaborate with fellow students currently taking this course, the TAs and the lecturer. Collaboration means talking through problems, assisting with debugging, explaining a concept, etc. You should not exchange code or write code for others.

Notes:

• Include a comment with your name and canvasID at the top of all Python files.
• Do not wait until the last minute to do this assignment in case you run into problems.
• Pay close attention to whether problems require you to print or return the results! Printing instead of returning or vice versa will result in a point deduction.
• Name all functions as specified in the instructions.
• Unless otherwise stated, you can assume inputs will be valid in this assignment (i.e. error checking is not required).
• In a Python module you must define a value (such as a function) before referencing it. So if you call function A from function B, the definition of function A must come before the definition of function B in the file.

Problem Description

Congrats! You are the Supply Chain Manager at a major company, and you’re tasked with deciding your intern team for the Summer. Luckily, HR has summarized applicant data for you, and your job is to decide whom to hire and their offer details.

Solution Description

HR provies you with CSV and JSON files containing candidate information:

• A CSV file of academic records with candidate names, IDs, email addresses, completed semester hours, GPA, and grade in CS 2316, if they took CS 2316. Sample: academics.csv

• A JSON dictionary mapping candidate IDs to their interview scores, where interview scores are represents as 2-element lists where the first element is the technical interview score and the second is the behavioral interview score. Sample: interviews.json

Create a module called interns that reads these data files and generates rankings of candidates for use in hiring decisions. Your module should define a Candidate class which includes/overrides the following methods:

• a __init__ method which take parameters that initialize the following instance variables:

  • id – a unique identifier for the student
  • name – the student’s name
  • gpa – the cumulative GPA of the student
  • cs2316grade – the grade the student earned in CS 2316, e.g., 'A', 'B', etc., or None if the student didn’t take CS 2316
  • technical – the student’s technical interview score
  • behavioral – the student’s behavioral interview score
• a magic method that prodcues a string representation of a Candidate instance when an instance is printed or when an instance’s value is echoed in an interactive Python interpreter. The string representation should include the candidate’s id and name, e.g. rfarva3 - Rodney Farva.
• a magic method that, when instances of Candidate are sorted, produces an ordering based on a composite score calcualted by gpa + technical + behavioral + CS 23126 grade point, where grade point is 4 for A, 3 for B, etc. For example, a student with a 3.0 GPA, 10 techincal intervew and 10 behavioral interview and a B in CS 2316 would have a composite score of 3.0 + 10 + 10 + 3 = 26.

In addition to the Candidate class, include the following functions:

• rank_composite(candidates) which takes a list of candidates and returns another list with the same elements but sorted in descending order by the composite score described for the “makes Candidate instances sortable” magic method described above.

• rank_academics(candidates) which takes a list of candidates and returns another list with the same elements but sorted in descending order by gpa + CS 2316 grade point. For example, a candidate with a 3.2 GPA and an A in CS 2316 (4.0 CS 2316 grade point) would be ranked above a candidate with a 4.0 GPA and a B in CS 2316.

• rank_technical(candidates) which takes a list of candidates and returns another list with the same elements but sorted in descending order by the candidates’ techincal interview scores.

• rank_behavioral(candidates) which takes a list of candidates and returns another list with the same elements but sorted in descending order by the candidates’ behavioral interview scores.

When the interns module is imported as a module it should only make the class and function definitions described above. When the interns module is run as a script it should take two mandatory and one optional command line arguments. The first command line argument is the name of a CSV file organized exactly like academics.csv, the second command line argument is the name of a file organized exactly like interviews.json, and the third (optional) command line argument is a ranking criterion. The interviews JSON file should contain interview scores for all the students in the academics CSV file. When the script is run without the third command line argument, the students are printed in order as ranked by their composite scores. If the third command line argument is given, it should specify one of the other rank orders from the module functions listed above: academics, technical, or behavioral. If the user supplies a third command line argument that is not one of the specified rank order options, print the students ranked by composite score.

Example script runs:

$ python interns.py academics.csv interviews.json
id              name                         gpa cs2316grade technical  behavioral
aramathorn3     Ramathorn, Arcot             3.9          A         10         10
jchimpo39       Chimpo, Johnny               4.0                    10         10
uhanson3        Hanson, Ursula               4.0                    10         10
johagen3        O'Hagen, John                3.0          C         10          7
jfoster3        Foster, Jeff                 3.6          B          6          9
mwomack3        Womack, MacIntyre            2.9          C          7          9
rroto3          Roto, Robert                 2.8          B          7          8
ljoshnson3      Johnson, Larry               3.2                     7          9
bgrady3         Grady, Bruce                 1.9                     8          5
fgalikanokus3   Galikanokus, Frank           2.0                     6          5
rfarva3         Farva, Rodney                2.1                     5          4
ssmy3           Smy, Samuel                  2.8                     4          4
jrando3         Rando, Jim                   2.0                     4          4
jburton3        Burton, Jack                 2.9                     4          3

$ python interns.py academics.csv interviews.json academics
id              name                         gpa cs2316grade technical  behavioral
aramathorn3     Ramathorn, Arcot             3.9          A         10         10
jfoster3        Foster, Jeff                 3.6          B          6          9
rroto3          Roto, Robert                 2.8          B          7          8
johagen3        O'Hagen, John                3.0          C         10          7
mwomack3        Womack, MacIntyre            2.9          C          7          9
jchimpo39       Chimpo, Johnny               4.0                    10         10
uhanson3        Hanson, Ursula               4.0                    10         10
ljoshnson3      Johnson, Larry               3.2                     7          9
jburton3        Burton, Jack                 2.9                     4          3
ssmy3           Smy, Samuel                  2.8                     4          4
rfarva3         Farva, Rodney                2.1                     5          4
fgalikanokus3   Galikanokus, Frank           2.0                     6          5
jrando3         Rando, Jim                   2.0                     4          4
bgrady3         Grady, Bruce                 1.9                     8          5

$ python interns.py academics.csv interviews.json technical
id              name                         gpa cs2316grade technical  behavioral
johagen3        O'Hagen, John                3.0          C         10          7
aramathorn3     Ramathorn, Arcot             3.9          A         10         10
jchimpo39       Chimpo, Johnny               4.0                    10         10
uhanson3        Hanson, Ursula               4.0                    10         10
bgrady3         Grady, Bruce                 1.9                     8          5
rroto3          Roto, Robert                 2.8          B          7          8
mwomack3        Womack, MacIntyre            2.9          C          7          9
ljoshnson3      Johnson, Larry               3.2                     7          9
jfoster3        Foster, Jeff                 3.6          B          6          9
fgalikanokus3   Galikanokus, Frank           2.0                     6          5
rfarva3         Farva, Rodney                2.1                     5          4
jrando3         Rando, Jim                   2.0                     4          4
ssmy3           Smy, Samuel                  2.8                     4          4
jburton3        Burton, Jack                 2.9                     4          3

$ python interns.py academics.csv interviews.json behavioral
id              name                         gpa cs2316grade technical  behavioral
aramathorn3     Ramathorn, Arcot             3.9          A         10         10
jchimpo39       Chimpo, Johnny               4.0                    10         10
uhanson3        Hanson, Ursula               4.0                    10         10
jfoster3        Foster, Jeff                 3.6          B          6          9
mwomack3        Womack, MacIntyre            2.9          C          7          9
ljoshnson3      Johnson, Larry               3.2                     7          9
rroto3          Roto, Robert                 2.8          B          7          8
johagen3        O'Hagen, John                3.0          C         10          7
fgalikanokus3   Galikanokus, Frank           2.0                     6          5
bgrady3         Grady, Bruce                 1.9                     8          5
rfarva3         Farva, Rodney                2.1                     5          4
jrando3         Rando, Jim                   2.0                     4          4
ssmy3           Smy, Samuel                  2.8                     4          4
jburton3        Burton, Jack                 2.9                     4          3

Don’t worry about ties, and don’t worry about error checking.

Tips and Considerations

• Remember that the data you get from a CSV file is textual.
• What data types do you get from JSON files read by the json module?
• You can do each of the ranking functions in one line.
• Printing the reports with justification and alignment is easy with string interpolation.

Grading

TBD

Submission Instructions

Attach your interns.py file to your Canvas assignment submission.

Verify the Success of Your Submission to Canvas

Practice safe submission! Verify that your HW files were truly submitted correctly, the upload was successful, and that your program runs with no syntax or runtime errors. It is solely your responsibility to turn in your homework and practice this safe submission safeguard.

• After submitting the files to Canvas, return to the Assignment menu option and this homework. It should show the submitted files.
• Download copies of your submitted files from the Canvas Assignment page placing them in a new folder.
• Re-run and test the files you downloaded from Canvas to make sure it’s what you expect.

• This procedure helps guard against a few things.

  • It helps insure that you turn in the correct files.
  • It helps you realize if you omit a file or files.\footnote{Missing files will not be given any credit, and non-compiling homework solutions will receive few to zero points. Also recall that late homework will not be accepted regardless of excuse. Treat the due date with respect. Do not wait until the last minute! (If you do discover that you omitted a file, submit all of your files again, not just the missing one.)
  • Helps find syntax errors or runtime errors that you may have added after you last tested your code.