Lesson goal: Data Science: Class grades

Previous: Mining geographic data | Home | Next: Introduction to Prolog: Facts and goals

Here's a common data science exercise: working with student names and class grades. A file called grades.csv contains 500 lines. Each line is in this format: last,first,grade. All grades are between 0 and 100. (All names and grades are fake.)

Here are some challenges for you:

  • Print each last,first name and a letter grade, given that: < 60 is an F, 60-69 is a D, 70-79 is a C, 80-89 is a B, and 90 or above is an A.

  • How many As, Bs, Cs, Ds, and Fs did the class end up with (Ans: 84, 203, 154,41, 8.)

  • What was the average grade? (Ans: 73).

  • What is the class GPA if A=4.0, B=3.0, C=2.0, D=1.0, F=0? (Ans: 1.70)

  • For the "Dean's List," print just students who got an "A."

  • For the "academic probation list," print just students who got a "D" or "F."

  • Who got the highest grade? Or were there more than one with the highest?

Now you try. Run some data science on these grades.

Type your code here:

See your results here: