Midterm 2 Practice Problems Release Notes
PMT2 = "Practice Midterm 2 problems"
Success
While we're releasing all of the solutions with the notebooks, we recommend you don't use those until you finish the whole practice exam, or if you get stumped on an exercise for an extended period of time. Learning how to resolve and hunt down those issues on your own is the skill you need to build in order to prepare for the exam.
Note
You're free to discuss these practice exams openly and share your code with classmates. Connecting with others on Piazza may help you think through alternative approaches to problems.
NOTE NEW EXAM FORMAT -- SQL and Pandas requirement
Prior to the Fall 2024 semester, most problems were written to be able to be solved with either Pandas or SQL, with varying levels of difficulty. Starting with the Fall 2024 MT2, each exercise specifies that you use either Pandas, or SQL.
This requirement means students need to prepare for both in order to answer all of the exercises.
Practice Exam Solutions
Solutions, walkthrough videos, additional TA solutions
PMT2-FA25
- 11 exercises; 21 available points; 13 points required for 100%; Time limit 4 hours
- Topic: Airbnb selection. This exam mimics the process of cleaning, filtering, and analyzing data about Airbnb listings to plan a vacation.
- Key skills: SQL, Pandas, NumPy
PMT2-SP25
More solutions from TA testing
- 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
- 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
Warning
The exams below were made before we specified whether certain exercises could be solved with Pandas or SQL. They are still good practice, but keep in mind you'll have to practice both Pandas and SQL.
PMT2-SP24
- 7 exercises; 13 available points; 7 points required for 100%; Time limit 4 hours
- Note: The original point cap for this exam was 11 points. A curve was later applied to lower it to 7.
- 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
- Note: The original point cap for this exam was 11 points. A curve was later applied to lower it to 7.
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