What This Document Is
This document is a final exam from the Computing for Data Analysis (CSE 6040) course at Georgia Tech, specifically focusing on SQL and Pandas. It utilizes a dataset of Hillary Rodham Clinton's emails for practical application of these data analysis tools. The exam is designed to assess a student’s ability to query and manipulate data using both SQL and the Pandas library in Python.
Why This Document Matters
This exam is valuable for students currently enrolled in or preparing for a similar data analysis course. It provides a realistic assessment of the skills required to work with relational databases and dataframes, common tasks in data science and analytics roles. Reviewing past exams helps students identify knowledge gaps and practice applying concepts to a real-world dataset.
Common Limitations or Challenges
This document is a past exam and does not represent the entirety of the course material. It focuses specifically on SQL and Pandas, and does not cover other topics potentially included in the course. Additionally, the document notes a potential issue with the `sqlite3` module in certain Python environments (Vocareum with Python 3.6), requiring students to be aware of version compatibility.
What This Document Provides
This document includes the full text of a 2018 final exam, including:
* Four exercises centered around the Hillary Clinton email dataset.
* Setup code for loading necessary modules and connecting to the SQLite database.
* Helper functions for inspecting table data (e.g., `peek_table`, `list_tables`).
* Example outputs from running the initial setup code.
* The beginning of Exercise 0, setting the stage for the problem.
This preview *does not* include solutions to the exam problems, nor does it provide detailed explanations of the SQL or Pandas code required to solve them. It also does not include the full dataset itself, only instructions on where it was originally sourced.
