Join us and get access to thousands of tutorials and a community of expert Pythonistas.

Unlock This Lesson

This lesson is for members only. Join us and get access to thousands of tutorials and a community of expert Pythonistas.

Unlock This Lesson

Hint: You can adjust the default video playback speed in your account settings.
Hint: You can set your subtitle preferences in your account settings.
Sorry! Looks like there’s an issue with video playback 🙁 This might be due to a temporary outage or because of a configuration issue with your browser. Please refer to our video player troubleshooting guide for assistance.

Using pandas to Make a Gradebook (Summary)

Cesar Aguilar
Using pandas to Make a Gradebook in Python Cesar Aguilar 01:03
Recommended Tutorial Course Slides (.pdf) Sample Code (.zip) Ask a Question

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

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.