Summary
I recorded this video to walk students through the final portion of our Pandas assignment so they can finish it before the Sunday night deadline. I start by reloading the notebook and showing how to filter the 2018 dataset to extract the four Final Four teams—Kansas, Loyola Chicago, Michigan (second place), and Villanova (champion)—using OR logic because the data model does not support combined AND conditions. Next, I demonstrate how to compute each team’s win‑rate by creating a new column (wins divided by games) and then filter for Big Ten schools with a win‑rate of 0.70 or higher, displaying the results and refining the output to include only team, year, and win‑rate. After that, I extract the champion of each season from the postseason data, limit the columns to team and year, and sort the list in ascending order to reveal recent trends such as Connecticut’s back‑to‑back titles. I conclude by reminding everyone to copy the final code snippets into their spreadsheet, submit the assignment by Sunday night, and wish them a happy Halloween and a successful weekend.