I've run into a bit of an issue. I recently pulled data from the CDC website concerning Suicide rates by county. However, the csv file does not have locational data. Luckily, my project is about the correlation between suicide rate and % of abandoned homes in the nation (by county).
The abandoned homes shapefile does have locational data and I wanted to do a table join based on county name or county code; however, for both instances, the data within the field is just a little different.
For instance, Autauga County, AL versus Autauga County, Alabama. As you can see, the names almost align. The default method of joining the fields based on county names brings up a lot of "Null" values.