In this recipe, we will use the New York Restaurant Inspections Excel file and use the legacy Jet driver to shape the file so we can have both the inspection date and grade date in the same column. This will allow us to visualize how many restaurants were inspected and graded for a specific date:
To follow this recipe, download the file from the New York City Open Data website using the following URL:
Once you have downloaded the data, save the file as DOHMH_New_York_City_Restaurant_Inspection_Results.xls
(Microsoft Excel 97-2003 Worksheet). Note that the records may have been updated between the time of writing and the time of your download.