The Wolfram Language Mathematica program contained in notebook "JoinAcross-Counties-Adjacent Counties-Cities.nb" takes a list of Florida counties (and their respective adjacent counties) and performs a JoinAcross with another list of Florida counties (and their corresponding cities). The input files of the program are two Excel worbooks called "01-Counties-Adjacent Counties.xlsx" and "02-Florida Counties & Cities.xlsx". The output file of the program is an Excel workbook called "FL-Counties-AdjacentCounties-Cities.xlsx". Make sure that you save: "JoinAcross-Counties-Adjacent Counties-Cities.nb" and the two input files into a working directory of your choosing before evaluating the program. When you open "JoinAcross-Counties-Adjacent Counties-Cities.nb"; make sure to press the "Enable Dynamics" blue button (located at the right-upper corner of the nootebook) before evaluating the program. The program illustrates how to use "SemanticImport" and "Dataset" to "JoinAcross" tables and how to export the desired final table to your working directory. Query Language commands are used to answer the following questions: (1.) What Florida cities are located in multiple counties? and (2.) What counties lack cities located in them?
Attachments:
