Guided Project: Analyzing NYC High School Data

Over the last three lessons, you explored relationships between SAT scores and demographic factors in New York City public schools by combining multiple datasets into a single, clean pandas dataframe. 

In the last lesson, you began performing some analysis, and you'll extend that analysis in this guided project. In this guided project, you'll work the data that you have worked within this course so far and play the role of a data analyst and act on your own accord to determine which demographic factors such as race, income, gender, etc. are influential to a person's performance on the SAT.

Working on guided projects gives you hands-on experience with real-world examples, which also means they'll be more challenging than missions. However, keep in mind that now you have more tools you can use to clean and transform data than you did at the beginning of this data ckeaning project walkthrough course course

As with all guided projects, we encourage you to experiment and extend your project, taking it in unique directions to make it a more compelling addition to your portfolio! 

We also recommend creating a GitHub repository and placing this project there. It will help other people see your work, including employers. As you start to put multiple projects on GitHub, you'll have the beginnings of a strong portfolio.


  • Learn to generate scatter plots to compare colums.
  • Learn to generate maps using the basemap library.

Mission Outline

1. Introduction
2. Exploring Safety and SAT Scores
3. Exploring Race and SAT Scores
4. Exploring Gender and SAT Scores
5. Exploring AP Scores vs. SAT Scores
6. Next Steps


Course Info:


The median completion time for this course is 7.5 hours. ​View Details​​​

This course requires a basic subscription. This course includes four missions and two guided projects. It is the seventh course in the Data Analyst in Python path and the Data Scientist in Python path.


Take a Look Inside

(function(d) { d.addEventListener("DOMContentLoaded", function() { var pathname = d.location.pathname.replace(/^[/]|[/]$/g, "").replace("/", "-"); var tags = d.getElementsByTagName("iframe"); var type = pathname.startsWith("course") ? "?course=" : pathname.startsWith("path") ? "?path=" : null; if (type) { var i; for (i = 0; i < tags.length; i++) { if (tags[i].src.indexOf("signup#iframe") !== -1) { tags[i].src = tags[i].src.replace("#iframe", "") + type + pathname + "#iframe"; } } } }, false); })(document);