What This Document Is
This document contains sample solutions for the second midterm exam in Computing for Data Analysis (CSE 6040) at Georgia Tech. It focuses on applying Pandas and SQL skills to a real-world dataset related to soccer statistics. The provided excerpt includes the problem statement for a soccer analysis task and the initial code setup for loading the data.
Why This Document Matters
This resource is valuable for students enrolled in CSE 6040 who are reviewing their work on the second midterm. It allows learners to check their approach to problem-solving and understand the expected format and level of detail for solutions. It’s most useful *after* attempting the midterm independently.
Common Limitations or Challenges
This is a *sample* solution, meaning it represents one possible correct approach. Other valid solutions may exist. It does not provide a comprehensive explanation of the underlying concepts or alternative methods. It also doesn’t cover all problems from the midterm – only the initial “Soccer Guru” problem is shown.
What This Document Provides
The document includes:
* The full problem statement for Exercise 0 and Exercise 1 of the midterm.
* Code to load the soccer results dataset into a Pandas DataFrame.
* Assertions to verify the data loading process.
* A partially completed SQL query for Exercise 1, intended to find the top 10 teams with the highest average away scores.
* A preview of the loaded soccer results data.
This preview *does not* include the complete SQL query solution, nor does it contain solutions for any other problems on the midterm. It also does not offer explanations of the SQL code or Pandas operations.
