I want to compare two group fields in attribute table, which are related to the name of villages.
The name of these villages (in both field) are the same but they have in some cases differentiation (because of misspelling).
In order to update my databases I need to find different names and edit them.
They are many names and it doesn't make sense to check them manually.
I think Python or VBA code in ArcGIS is practical.
How can this be done?
-
Is using Python or VBA code a requirement for you or just the only way you thought your question could be answered? Are you talking about doing fuzzy text comparisons?PolyGeo– PolyGeo ♦2013年11月18日 09:07:29 +00:00Commented Nov 18, 2013 at 9:07
3 Answers 3
There is no need to use code to find the mismatched village names so I am going to assume that doing that is not a requirement. I am also going to assume that you are comparing village name fields from two shapefiles.
First Join the two shapefiles based on their village name field (I have used Name and did this from the Attribute Table). Make sure that you choose to Keep all records.
enter image description here
When you hit OK you should find that any villages with the same name recorded in both shapefiles have null values in the joined field. In the graphic below I have clicked on that record to highlight it.
enter image description here
You can then do a Select By Attributes and use "name"<>"name_1" or whatever the two similar name fields are. Then you will have the different ones selected and can just click on the Show Only Selected icon and just edit those.
-
1You can then do a select by attributes and use "name"<>"name_1" or whatever the two similar name fields are. Then you have the different ones selected and can just click on the show only selected icon and just edit those.mike– mike2013年11月17日 02:29:25 +00:00Commented Nov 17, 2013 at 2:29
-
@Mike - I've updated my Answer with your excellent suggestion - thanks!2013年11月17日 03:09:14 +00:00Commented Nov 17, 2013 at 3:09
If you are talking about doing fuzzy text comparisons, check out the answers to this question on StackOverflow. Particularly, the built-in difflib module can do this.
create a test field, type short. apply this code in field calculator:
- choose "python" as a parser:
- check show block:
- write these line in pre-logic text-box:
def test(a,b): if a==b: return 1 else: return 0 - at the last text box write this line:
test(!field1!,!field2!) - Field1 and field2 should be your two field to be compared:
- Then you can find the different values on test field, rows with number 1 are same and the rows with 0 are different: