In the first exercise, we will use MongoDB, one of the leading document-oriented databases, to analyze Nobel Laureates from 1902-present. MongoDB provides a simple and intuitive interface to work with JSON files. As discussed earlier, JSON is a flexible format that allows representing data using a structured approach.
Analyzing Nobel Laureates data with MongoDB
JSON format
Consider the following table:
Firstname |
Lastname |
Information |
John |
15 |
Subject: History, Grade B |
Jack |
18 |
Subject: Physics, Grade A |
Jill |
17 |
Subject: Physics, Grade A+ |
The Information field contains a column containing multiple values categorized under Subject and Grade. Such columns that contain multiple data are also...