2026-11-10
I will use the Nobel Prize API to retrieve Nobel Prize records in JSON format. I will keep the prize information in one table and separate the nested laureate information into a second table. This will make the data easier to check and allow me to join the two tables when needed.
I will answer four questions. I will compare laureate entries across categories, examine how the average number of laureates per awarded prize changed by decade, identify categories with prize records that do not list a laureate, and find laureates who appear in more than one prize record. The fourth question will join the prize and laureate tables by a prize ID. I will include the request code, cleaning decisions, readable tables, and color blind friendly charts.