<jupyter_start><jupyter_text>Explore the class datasetThe goal is to learn pandas functions by exploring the toy dataset `class_data.tsv`.  Each section of the notebook has a task to complete.  The pandas [API reference](https://pandas.pydata.org/pandas-docs/stable/reference/index.html) describes relevant functions.  Load the dataLoad the file `class_data.tsv` in the `../data` subdirectory as a pandas data frame.  It is a tab-separated text file.  See the `read_csv` pandas command and python `os` module for working with file names.  Use the pandas `head` command to inspect the columns.<jupyter_code>import os
import pandas as pd

# The pandas API changes in different versions
print(pd.__version__)<jupyter_output>0.24.2<jupyter_text>Count the number of students in the class  Display summary statisticsSee pandas `describe`  Sort the data frame by the project grade  Display only the students who are Biology majors  Display the students who are Biology or CS majors  Display the students who are Sophomore CS majors  Display only the homework grades for the Junior students  Compute the maximum, minimum, and mean project grade  Add a new grade column to the data frameThe column Grade is the sum of the homework, exam, and project grades.  See pandas `apply` and define a new function to compute the grade or use a lambda function.  Compute the mean grade for each type of majorUse the new column created above  Plot a histogram of all gradesSee `%pylab inline` or `%matplotlib inline`.  Include a title.<jupyter_code>%matplotlib inline
from matplotlib import pyplot as plt<jupyter_output><empty_output>
StarcoderdataJupyterStructuredCleanDedup