I am new to Python and want to create a script inside the ArcMap Python window. My current workspace is a series of rivers portrayed in the state of Ohio. I have a list of fish and the rivers (from my series of rivers) they are found in. Ideally, I would like the user to be able to enter the name of a fish and have the script highlight or select the rivers in the map.
For example, if I were a fisherman who was not from this area and wanted to catch a certain fish (such as a smallmouth bass) I could type the fish into the script as a raw input and have the map highlight the rivers where this fish could be caught.
I have an excel sheet with column titles as fish (i.e. largemouth bass, smallmouth bass, etc) and each row is a river name that they can be found in
How might I go about doing this?
Largemouth Bass (Col 1. Title) Smallmouth Bass (Col 2. Title) Ashtabula River Ashtabula River Chagrin River Chagrin River Cuyahoga River Conneaut Creek Grand River Grand River Huron River Huron River Rocky River Rocky River Sandusky River Vermillion River Vermillion River