The loading of the JSON data set was covered last time but here is the gist. The first step is to fire up the MySQL Shell and login to the server.
|Here a new schema is created and then a new collection|
|Then we switch to Python mode to load the data with a simple program|
What types of RestaurantsWe can quickly look at all the restaurants but it may be easier to start out looking at the types of cuisine. And it would be nice to see the numbers of each type.
The result set:
"$.cuisine": "Latin (Cuban, Dominican, Puerto Rican, South & Central American)",
85 documents in set (0.7823 sec)
The big surprise for me was the 1,011 other restaurants after seeing a rather inclusive list of cuisine styles.
|What cuisine types are available and their numbers?|
Feel like Red Beans and RiceSo lets narrow our search down and look for some Cajun food. But since we are health conscious we will want to check the health department ratings on the restaurants.
|And we can see the names of the restaurants with their latest health department grades.|
Next time we will dig deeper into our NYC restaurants