Hi Joe Borgione , to explain a little more of what is happening with the dictionary in the process, see the snippet below:
table = [[1, "A"], [2, "A"], [2, "A, B"], [3, "A"], [3, "A, E"], [3, "A, E, G"]]
dct = {}
cnt = 0
for row in table:
cnt += 1
apn = row[0]
soil_type = row[1]
dct[apn] = soil_type
print("cnt:{}\tapn:{}\tsoil_type:{}\tdct:{}".format(cnt, apn, soil_type, dct))
This will print the dictionary for each row that is being read:
cnt:1 apn:1 soil_type:A dct:{1: 'A'}
cnt:2 apn:2 soil_type:A dct:{1: 'A', 2: 'A'}
cnt:3 apn:2 soil_type:A, B dct:{1: 'A', 2: 'A, B'}
cnt:4 apn:3 soil_type:A dct:{1: 'A', 2: 'A, B', 3: 'A'}
cnt:5 apn:3 soil_type:A, E dct:{1: 'A', 2: 'A, B', 3: 'A, E'}
cnt:6 apn:3 soil_type:A, E, G dct:{1: 'A', 2: 'A, B', 3: 'A, E, G'}
So, when it finds the same apn key, the value that was stored in the dictionary for that apn key will be replaced by the last value (soil type).
