To create a list from all the values in a field you can do something like this:
import arcpy
tbl1 = r"C:\Users\kaaper\Documents\DataDrivenPages\DataDrivenPages.gdb\YourTableName1"
fld1= "your field name from table 1"
tbl2 = r"C:\Users\kaaper\Documents\DataDrivenPages\DataDrivenPages.gdb\YourTableName2"
fld1= "your field name from table 2"
lst1 = [r[0] for r in arcpy.da.SearchCursor(tbl1, (fld1))]
lst2 = [r[0] for r in arcpy.da.SearchCursor(tbl2, (fld2))]
To compare the lists you can use something like this (it would be easier to have access to the data, this example creates random text values in both lists):
def main():
import random
lst1 = [chr(i+65) for i in range(10)]
print("\nContent Table 1:\n{}".format(lst1))
lst2 = []
for a in range(100):
i = random.randrange(0, 10)
chr1 = lst1[i]
j = random.randrange(0, 26)
chr2 = chr(j+65)
txt = chr1 + chr2
lst2.append(txt)
print("\nContent Table 2:\n{}".format(lst2))
dct1 = {}
for value1 in lst1:
for value2 in lst2:
if value1.upper() in value2.upper():
if value1 in dct1:
data = dct1[value1]
data.append(value2)
data = list(set(data))
dct1[value1] = data
else:
data = [value2]
dct1[value1] = data
print("\nContent Dict 1:\n{}".format(dct1))
dct2 = {}
for value2 in lst2:
for value1 in lst1:
if value1.upper() in value2.upper():
if value2 in dct2:
data = dct2[value2]
data.append(value1)
data = list(set(data))
dct2[value2] = data
else:
data = [value1]
dct2[value2] = data
print("\nContent Dict 2:\n{}".format(dct2))
if __name__ == '__main__':
main()
This will yield:
Content Table 1:
['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J']
Content Table 2:
['CO', 'CA', 'GK', 'HT', 'HZ', 'IF', 'BJ', 'CD', 'GF', 'FS', 'FP', 'DO', 'BH', 'CW', 'CA', 'BV', 'IQ', 'DN', 'AC', 'IP', 'GY', 'EK', 'JH', 'EC', 'DN', 'CO', 'GM', 'FT', 'IV', 'AX', 'JO', 'HT', 'GK', 'JL', 'CX', 'HQ', 'EF', 'GM', 'CB', 'JB', 'DC', 'CE', 'AM', 'EA', 'CA', 'CA', 'EB', 'FI', 'HM', 'DO', 'FN', 'HI', 'AA', 'CL', 'HR', 'AS', 'HA', 'DI', 'BI', 'IJ', 'FN', 'IJ', 'GC', 'AQ', 'DF', 'HF', 'II', 'EP', 'AW', 'AP', 'FO', 'CY', 'FL', 'AS', 'BT', 'DD', 'BX', 'JH', 'JV', 'JN', 'JL', 'HR', 'IK', 'DU', 'BY', 'AP', 'FJ', 'EN', 'AT', 'IU', 'AL', 'EQ', 'DS', 'JP', 'HU', 'IN', 'IM', 'HV', 'CE', 'II']
Content Dict 1:
{'A': ['AA', 'AC', 'EA', 'CA', 'AM', 'AL', 'AQ', 'AP', 'AS', 'AT', 'AW', 'AX', 'HA'], 'C': ['AC', 'CO', 'CL', 'CB', 'CA', 'DC', 'EC', 'CD', 'CY', 'CX', 'GC', 'CE', 'CW'], 'B': ['CB', 'BH', 'BI', 'BJ', 'EB', 'BT', 'BV', 'BX', 'BY', 'JB'], 'E': ['EN', 'EK', 'EF', 'EA', 'CE', 'EB', 'EC', 'EQ', 'EP'], 'D': ['DN', 'DO', 'DI', 'DF', 'DD', 'DC', 'CD', 'DU', 'DS'], 'G': ['GC', 'GF', 'GM', 'GK', 'GY'], 'F': ['FP', 'FS', 'FT', 'DF', 'HF', 'EF', 'GF', 'FI', 'FJ', 'FO', 'FL', 'FN', 'IF'], 'I': ['DI', 'IQ', 'IP', 'IU', 'BI', 'IV', 'II', 'IK', 'IJ', 'HI', 'IN', 'IM', 'FI', 'IF'], 'H': ['HZ', 'HR', 'HV', 'HQ', 'BH', 'HT', 'HU', 'HI', 'JH', 'HM', 'HA', 'HF'], 'J': ['JO', 'JV', 'JP', 'BJ', 'JL', 'JN', 'IJ', 'JH', 'FJ', 'JB']}
Content Dict 2:
{'HZ': ['H'], 'FP': ['F'], 'FS': ['F'], 'FT': ['F'], 'DO': ['D'], 'HR': ['H'], 'EA': ['A', 'E'], 'AA': ['A'], 'HQ': ['H'], 'BH': ['H', 'B'], 'DC': ['C', 'D'], 'HT': ['H'], 'HU': ['H'], 'JL': ['J'], 'BV': ['B'], 'JO': ['J'], 'JH': ['H', 'J'], 'FL': ['F'], 'HM': ['H'], 'JV': ['J'], 'FI': ['I', 'F'], 'FJ': ['J', 'F'], 'HA': ['A', 'H'], 'HF': ['H', 'F'], 'BY': ['B'], 'JB': ['J', 'B'], 'FO': ['F'], 'HV': ['H'], 'DU': ['D'], 'GK': ['G'], 'DI': ['I', 'D'], 'IJ': ['I', 'J'], 'DS': ['D'], 'JP': ['J'], 'DF': ['D', 'F'], 'FN': ['F'], 'CB': ['C', 'B'], 'IK': ['I'], 'DD': ['D'], 'BX': ['B'], 'EC': ['C', 'E'], 'AC': ['A', 'C'], 'EN': ['E'], 'CO': ['C'], 'EK': ['E'], 'CL': ['C'], 'IQ': ['I'], 'IP': ['I'], 'CA': ['A', 'C'], 'EF': ['E', 'F'], 'AM': ['A'], 'AL': ['A'], 'GY': ['G'], 'CD': ['C', 'D'], 'AQ': ['A'], 'GF': ['G', 'F'], 'AS': ['A'], 'CX': ['C'], 'CE': ['C', 'E'], 'BJ': ['J', 'B'], 'AW': ['A'], 'IN': ['I'], 'AX': ['A'], 'GM': ['G'], 'IV': ['I'], 'CW': ['C'], 'EP': ['E'], 'EB': ['B', 'E'], 'IF': ['I', 'F'], 'II': ['I'], 'DN': ['D'], 'BT': ['B'], 'EQ': ['E'], 'AP': ['A'], 'CY': ['C'], 'HI': ['I', 'H'], 'JN': ['J'], 'IU': ['I'], 'IM': ['I'], 'GC': ['C', 'G'], 'BI': ['I', 'B'], 'AT': ['A']}
