RAVENCLAW ~ or ~ THE HOUSE THAT GOES UNMENTIONED

By Raynard Flores, Rosemary Medina, Gian F. Villafane, Maya Wilson-Fernandez, Alex Lopez, Dylan Sedeno

Project Overview

Despite being the Hogwarts house renowned for the intellect and wit of its students and alumni, Ravenclaw is rarely referenced in the Harry Potter series, in both books and films.

The chosen Harry Potter dataset was from Kaggle, with a singular focus on the Characters CSV file.

HYPOTHESES

• Ravenclaw has fewer Purebloods than Slytherin and more than Hufflepuff.

• Ravenclaw has more female students than other Houses.

• Ravenclaw students are less likely to be affiliated with Dumbledore’s Army and Order of the Phoenix.

• There are fewer Ravenclaw characters than in any other house.

DATA ACQUISITION, ENRICHMENT & EXAMINATION

Primary Sources of data:

For the primary source of data, we utilized dedicated Harry Potter datasets from Kaggle. These datasets included data related to the first three categories, as well as datasets for characters, spells, and potions.

Supplemental Data:

We had access to a dedicated Harry Potter API for supplemental data, in case the primary source lacked sufficient information for the project.

Challenges:

• The primary challenge in working with the dataset was accessing the API data and developing code to retrieve specific information.
• Another significant challenge was the presence of numerous 'NaN' values in the data, which complicated the process of locating relevant information for our project.

SQL INSIGHTS & ANALYSIS

Inconsistencies in Labeling:

CHALLENGES

Data Cleaning:

• Dropping columns and filling ‘N/A’ values.

• Figuring out how to add columns as well as formatting data in order to filter it for our needs.

  

Issues

VISUALIZATION & KEY INSIGHTS

FINDINGS

NUMBER OF CHARACTERS:

Ravenclaw has fewer characters than Gryffindor and Slytherin but more than Hufflepuff.

LOYALTY:

In our analysis, Gryffindor emerges as the primary house associated with Dumbledore’s Army and the Order of the Phoenix. Additionally, we observe that Ravenclaw's unaffiliated presence aligns with their role in the movie.

BLOOD STATUS:

Slytherin has a significantly higher number of Pure Bloods, while other houses like Gryffindor and Ravenclaw have a more balanced distribution of blood statuses

GENDER: Ravenclaw has the most even gender balance of all the Houses.

• Ravenclaw has fewer Purebloods than Slytherin and more than Hufflepuff.
• The gender balance in Ravenclaw is even (9 female / 9 male)
• Ravenclaw students and professors are less likely to be affiliated with Dumbledore’s Army or the Order of the Phoenix.