Using pandas to Make a Gradebook in Python

One of the jobs that all teachers have in common is evaluating students. Whether you use exams, homework assignments, quizzes, or projects, you usually have to turn students’ scores into a letter grade at the end of the term. This often involves a bunch of calculations that you might do in a spreadsheet. Instead, you can consider using Python and pandas.

In this course, you’ll learn how to:

  • Load and merge data from multiple sources with pandas
  • Filter and group data in a pandas DataFrame
  • Calculate and plot grades in a pandas DataFrame

What’s Included:

Downloadable Resources:

Related Learning Paths:

About Cesar Aguilar

Cesar Aguilar Cesar Aguilar

Cesar is an avid Pythonista and records video tutorials for Real Python. He enjoys teaching programming to anyone who listens and seeing in others their programming "eureka" moment.

» More about Cesar

Each tutorial at Real Python is created by a team of developers so that it meets our high quality standards. The team members who worked on this tutorial are:

Participant Comments

Sahbi Ouali on April 3, 2022

Thanks for the quality of your content. Probably one of the best courses on RP. I didn’t find any difficulties coding along.

Felipe Sebben on Jan. 25, 2022

Wow, what a great class! Thank you for teaching how to use Path, it has really made my life easier! Do have any projects like this one that you’d recommend? I am interested in data analysis! Thank you once again!

« Browse All Courses