Pandas Project: Make a Gradebook With Pandas

Using pandas to Make a Gradebook in Python

Cesar Aguilar
Cesar Aguilar 13 Lessons 1h 37m advanced data-science projects
Start Now Rate and Review

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:

Start Now

Using pandas to Make a Gradebook in Python

13 Lessons 1h 37m

  1. 1. Using pandas to Make a Gradebook (Overview)04:45
  2. 2. Exploring the Data06:24
  3. 3. Setting Up Your Gradebook Environment07:06
  4. 4. Loading the Exam and Homework Data08:34
  5. 5. Loading the Quiz Files08:44
  6. 6. Merging the Grade DataFrames08:44
  7. 7. Calculating Grades With pandas DataFrames05:06
  8. 8. Calculating the Homework Scores13:17
  9. 9. Calculating the Quiz and Exam Scores11:42
  10. 10. Grouping the Data to Calculate Final Scores07:41
  11. 11. Writing the Data to CSV Files07:19
  12. 12. Plotting and Analyzing the Data06:44
  13. 13. Using pandas to Make a Gradebook (Summary)01:03
Start Now

About 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:

Christopher

Sadie

Tappan

Bryan

Geir Arne

David

Joanna

Aldren

Jacob

Related Courses:

Combining Data in Pandas With merge(), .join(), and concat()

Combining Data in pandas With concat() and merge()

Participant Comments

Avatar image for Sahbi Ouali

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.

Avatar image for Felipe Sebben

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