You now know how to build a gradebook script with pandas so you can stop using spreadsheet software. This will help you avoid errors and calculate your final grades more quickly in the future.

In this course, you learned:

How to load, clean, and merge data into pandas DataFrames
How to calculate with DataFrames and Series
How to map values from one set to another
How to plot summary statistics using pandas and Matplotlib

In addition, you saw how to group data and save files to upload to your student administration system. Now you’re ready to create your pandas gradebook for next term!

Here are some resources for more information about topics covered in this lesson:

Download

Sample Code (.zip)

54.9 KB

Download

Course Slides (.pdf)

1.5 MB

Congratulations, you made it to the end of the course! What’s your #1 takeaway or favorite thing you learned? How are you going to put your newfound skills to use? Leave a comment in the discussion section and let us know.

00:00 So, what did you learn in this course? Well, now you know how to use pandas to create a gradebook and get all your grading done at the end of the semester. But if you think about it, you actually learned a lot more. You learned how to load, clean, and merge data into pandas DataFrames, do some calculations on the DataFrames and Series, map values from one set to another, and plot some summary statistics using pandas and Matplotlib.

00:25 What now? Well, whether you were getting a refresher on pandas or maybe this was your very first exposure to pandas, you now have the basics to dive more deeply into the pandas module and the data science ecosystem in Python.

00:41 Check out the many courses that we’re continuously uploading on realpython.com on pandas and the different modules that you can work with if you’re doing any type of data science or numerical computations.

00:54 Don’t stop learning, and good luck in your Python journey! Until next time, I’m Cesar Aguilar from realpython.com.

aniketbarphe on Sept. 26, 2021

Thank You!

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.

Become a Member to join the conversation.

Using pandas to Make a Gradebook (Summary)