CMPG$111-$ Pandas and Matplotlib

SU$8\_1$ Filtering and Selecting

Write a Python program to filter and select data from the given CSV file using Pandas.

Read the provided CSV file into a Pandas DataFrame.

$8\mathrm{.}1\mathrm{.}1.$ Filter rows where the course is "Databases" and print the resulting DataFrame.

$8\mathrm{.}1\mathrm{.}2.$ Filter rows to identify students who are at$-$risk of failing, meaning any one of their grades are below $40\%.$ Print the resulting DataFrame.

$8\mathrm{.}1\mathrm{.}3.$ Filter rows to identify students with a distinction in "Programming", meaning that they achieved $75\%$ or greater. Print the resulting DataFrame.

Submit your Python script $(*.$py$)$ named: SU$8\_1.$py

SU$8\_2$ Grouping and Aggregating

Write a Python program to group data by course and calculate aggregate statistics.

Read the provided CSV file into a Pandas Dataframe.

Group the data by the "Course" column and calculate the average grades for each course. Print the resulting aggregated DataFrame.

Submit your Python script $(*.$py$)$ named: SU$8\_2.$py