AnsweredAssumed Answered

Python for select by attribute then remove from current selection

Question asked by tarekkandakji on Aug 5, 2015
Latest reply on Aug 5, 2015 by wwmiller68

Hi all,

I have a table called"July_join". Within this table I have many attributes or columns. I want first to select every thing under "grade" column that has values of 90, then remove from this selection the courses found in "courses" column that are "math", then remove from the resulted selection schools under column "schools" that are "Austin" and "Dallas", then from the resulted selection I want to remove those with only one teacher under "Num_Teachers" were the value is 1. Then the resulted selection I want to export them to a new table. The second new table I want to create is exactly the same as previous, except for the "Num_Teachers" value were I want to remove values that are less than 4.

By the way, I tried to build a model and then export python, but this is only going to be helpful if I am dealing with one set of data for one time only. I need to build a python code that could be used for continuous data analysis.


I am using ArcGIS 10.2.2 and python 2.7.5 Shell.