I have some data in a CSV file. One of the interested variable is test done (1=done, 2=not done). There is a variable of county name in which I would like to join with a county shapefile.
I only know how to join them using the county file as the base using ArcGIS, but the interested variable cannot be summarized correctly (as I would like each county to get a percent of 'done' from the interested variable).
How do I join it so I use the CSV as a base, such that I can get a percentage of 'done' later on?