bad_provs_fix.py

import re

# Enter the entire list of province numbers that need to be corrected here.
bad_provines = [ 39, 42, 44, 49, 52, 58, 3461, 3464, 3478, 3487, 3489, 3505, 3529, 3893, 3957, 4523, 4580, 6241, 6286, 6390, 6486, 6490, 6503, 6516, 6527, 6620, 6760, 8124, 9440, 9455, 9474, 9504, 9735, 9753, 10262, 10269, 10415, 11245, 11403, 11418, 11429, 11579, 11706, 12584, 13800, 13806, 13861, 13915, 13960, 14021, 14093, 14107, 14276, 14277, 14278, 14279, 14280, 14281, 14282, 14283, 14300, 14301, 14302, 14303, 14304, 14316, 14317, 14318, 14319, 14334, 14344, 14345, 14346, 14347, 14353, 14354, 14356, 14358, 14360, 14366, 14367, 14368, 14370, 14371, 14372, 14374, 14376, 14378, 14379, 14380, 14381, 14382, 14383, 14384, 14385, 14386, 14388, 14389, 14390, 14391, 14392, 14393, 14396, 14397, 14398, 14399, 14400, 14402, 14403, 14405, 14406, 14407, 14408, 14409, 14411, 14412, 14415, 14416, 14417, 14418, 14419, 14421, 14423, 14424, 14425, 14428, 14429, 14430, 14431, 14432, 14434, 14435, 14437, 14438, 14443, 14444, 14445, 14446, 14447, 14448, 14449, 14450, 14451, 14452, 14453, 14454, 14455, 14457, 14458, 14460, 14462, 14463, 14466, 14470, 14473, 14477, 14479, 14489, 14493, 14496, 14499, 14500, 14505, 14524, 14541, 14561, 14571, 14577, 14597, 14598, 14607, 14609, 14610, 14614, 14624, 14629, 14632, 14651, 14653, 14680, 14683, 14694, 14704, 14718, 14719, 14721, 14731, 14736, 14753, 14756, 14757, 14763, 14765, 14768, 14773, 14775, 14778, 14779, 14782, 14790, 14795, 14799, 14802, 14803, 14804, 14815, 14818, 14823, 14824, 14839, 14846, 14863, 14864, 14868, 14879, 14890, 14904, 14905, 14907, 14908, 14909, 14910, 14911, 14943, 14944, 14948, 14954, 14959, 14960, 14961, 14962, 14963, 14965, 14967, 14968, 14971, 14973, 14974, 14978, 14979, 14981, 14986, 14987, 14988, 14991, 14992, 15006, 15007, 15008, 15009, 15017, 15018, 15019, 15033, 15037, 15038, 15039, 15040, 15041, 15042, 15048, 15049, 15050, 15051, 15052, 15053, 15054];

f_import = open('definition.csv', "r")
f_export = open("_fix_definition.csv", "w+") #Corrected version of provinces

for line in f_import:
    result = re.split(r';', line)
    if(bad_provines.count(int(result[0])) > 0):
        if(True == result[5].lower()):
            result[5] = "false";
        else:
            result[5] = "true";
        f_export.write(str(result[0]) + ";" + str(result[1]) + ";" + str(result[2]) + ";" + str(result[3]) + ";" + str(result[4]) + ";" + str(result[5]) + ";" + str(result[6]) + ";" + str(result[7]))
    else:
        f_export.write(line);