Midterm 2 Practice Problems Release Notes

Note: this is a quick demo created to show you what Pandas or SQL-only exercises look like
Topic: Star Wars
Key skills: SQL, Pandas

PMT2-SP25

More solutions from TA testing - placeholder, releasing by 10/15

11 exercises; 22 available points; 14 points required for 100%; Time limit 4 hours
Topic: Data Deidentification. This exam mimics the process of exploring and extracting data from a university database for third-party research.
Key skills: SQL, Basic Python, pandas, and NumPy

PMT2-FA24

More solutions from TA testing - placeholder, releasing by 10/15

10 exercises; 17 available points; 12 points required for 100%; Time limit 4 hours
Topic: Netflix and Bills. In this notebook you will evaluate whether there is a relationship between the programming that is distributed by Netflix and the financial performance of the firm.
Key skills: General Python', Tabular Data, Pandas, SQL and SQLite, NumPy

PMT2-SP24

7 exercises; 13 available points; 7 points required for 100%; Time limit 4 hours
Topic: NYC Roadmap - Traffic fatality density. In this notebook you will look through some NYC traffic data to build a KDE model.
Key skills: SQL, Pandas, Numpy

PMT2-FA23

9 exercises; 21 available points; 13 points required for 100%; Time limit 4 hours
Topic: "Punt, Kick, or Go for it?". In this notebook you will look through some NFL play results and create a risk/reward model.
Key skills: Pandas, Numpy

PMT2-SP23

-- The TA Walkthrough solution presentation for this exam was split between 2 TAs, so the solution pages below represent the exercises that each TA presented. Students will need both for a complete solution.

11 exercises; 21 available points; 12 points required for 100%; Time limit 4 hours
Topic: "Better Reads". In this notebook you will look through user-generated book reviews to uncover "communities of users".
Key skills: SQL, Pandas, Numpy

PMT2-FA22

-- The TA Walkthrough solution presentation for this exam was split between 2 TAs, so the solution pages below represent the exercises that each TA presented. Students will need both for a complete solution.

9 exercises; 19 available points; 12 points required for 100%; Time limit 4 hours
Topic: Capturing Data Changes for Slowly Changing Dimensions. In this notebook you will implement a common data engineering paridigm to maintain a historical record of some mock-up business data.
Key skills: Manipulating tabular data with Pandas and SQL, Strings
Note: Most exercises in this notebook are solvable with Pandas or SQLite. However, the solutions using SQLite need to be "massaged" to pass all of the test cells. Pandas is strongly recommended.

PMT2-SP22

-- The TA Walkthrough solution presentation for this exam was split between 2 TAs, so the solution pages below represent the exercises that each TA presented. Students will need both for a complete solution.

9 exercises; 17 available points; 12 points required for 100% (lowered from 14); Time limit 4 hours
Topic: Actor network analysis. In this notebook you will explore a dataset of film credits and create/analyze a relationship network of actors starring in the films.
Key skills: Pandas, native Python data structures, and incorporating new tools given appropriate documentation.

PMT2-FA21

-- The TA Walkthrough solution presentation for this exam was split between 2 TAs, so the solution pages below represent the exercises that each TA presented. Students will need both for a complete solution.