Now You Code 4: Exam Scores

In this example, write a program to load the exam-scores data set here: https://raw.githubusercontent.com/mafudge/datasets/master/exam-scores/exam-scores.csv into a Pandas DataFrame

It should then ask for two user inputs:

  • An Class Section (example: M01 or M02)
  • An Exam version (A, B, C, or D)

It should ONLY accept those values for Class Section and Exam Version. Any other inputs and it should print 'Invalid Entry' and not display the data frame.

With valid inputs it should filter the DataFrame to only those rows matching the input (for example section M01, version A)

And display only the Student Score and Letter Grade for each student matching the inputs.

HINT: The very last line in your code should output the dataframe variable. Set it to None in the case of invalid inputs.

Step 1: Problem Analysis for entire program

Inputs:

Outputs:

Algorithm (Steps in Program):


In [1]:
# Step 2: write code here

Step 3: Questions

  1. Pandas programs are different than typical Python programs. Explain the process by which you derived the solution?

Answer:

  1. What was the most difficult aspect of this assignment?

Answer:


In [1]:
# Sample Run, so you can see expected output

Step 4: Reflection

Reflect upon your experience completing this assignment. This should be a personal narrative, in your own voice, and cite specifics relevant to the activity as to help the grader understand how you arrived at the code you submitted. Things to consider touching upon: Elaborate on the process itself. Did your original problem analysis work as designed? How many iterations did you go through before you arrived at the solution? Where did you struggle along the way and how did you overcome it? What did you learn from completing the assignment? What do you need to work on to get better? What was most valuable and least valuable about this exercise? Do you have any suggestions for improvements?

To make a good reflection, you should journal your thoughts, questions and comments while you complete the exercise.

Keep your response to between 100 and 250 words.

--== Write Your Reflection Below Here ==--


In [ ]:
# RUN THIS CODE CELL TO TURN IN YOUR WORK!
from ist256.submission import Submission
Submission().submit()