Dit is het geworden. Bedankt!!!!! Hij veranderd nu 1,97,385 etc naar A01 en 2,98 etc naar B01 etcetera.
for csv in bestand:
file_in=file(csv,'r') #input bestand
file_out=file('tijdelijk.csv','w') #output bestand
for line in file_in:
line=line.split(';')
if n == 0:
line[0] = 'BRON'
else:
for i in range (0,13):
if line[0] == '"'+str(1+96*i)+'"':
line[0] = 'A01'
elif line[0] == '"'+str(2+96*i)+'"':
line[0] = 'B01'
elif line[0] == '"'+str(3+96*i)+'"':
line[0] = 'C01'
elif line[0] == '"'+str(4+96*i)+'"':
line[0] = 'D01'
elif line[0] == '"'+str(5+96*i)+'"':
line[0] = 'E01'
elif line[0] == '"'+str(6+96*i)+'"':
line[0] = 'F01'
elif line[0] == '"'+str(7+96*i)+'"':
line[0] = 'G01'
elif line[0] == '"'+str(8+96*i)+'"':
line[0] = 'H01'
elif line[0] == '"'+str(9+96*i)+'"':
line[0] = 'A02'
elif line[0] == '"'+str(10+96*i)+'"':
line[0] = 'B02'
elif line[0] == '"'+str(11+96*i)+'"':
line[0] = 'C02'
elif line[0] == '"'+str(12+96*i)+'"':
line[0] = 'D02'
elif line[0] == '"'+str(13+96*i)+'"':
line[0] = 'E02'
elif line[0] == '"'+str(14+96*i)+'"':
line[0] = 'F02'
elif line[0] == '"'+str(15+96*i)+'"':
line[0] = 'G02'
elif line[0] == '"'+str(16+96*i)+'"':
line[0] = 'H02'
elif line[0] == '"'+str(17+96*i)+'"':
line[0] = 'A03'
elif line[0] == '"'+str(18+96*i)+'"':
line[0] = 'B03'
elif line[0] == '"'+str(19+96*i)+'"':
line[0] = 'C03'
elif line[0] == '"'+str(20+96*i)+'"':
line[0] = 'D03'
elif line[0] == '"'+str(21+96*i)+'"':
line[0] = 'E03'
elif line[0] == '"'+str(22+96*i)+'"':
line[0] = 'F03'
elif line[0] == '"'+str(23+96*i)+'"':
line[0] = 'G03'
elif line[0] == '"'+str(24+96*i)+'"':
line[0] = 'H03'
elif line[0] == '"'+str(25+96*i)+'"':
line[0] = 'A04'
elif line[0] == '"'+str(26+96*i)+'"':
line[0] = 'B04'
elif line[0] == '"'+str(27+96*i)+'"':
line[0] = 'C04'
elif line[0] == '"'+str(28+96*i)+'"':
line[0] = 'D04'
elif line[0] == '"'+str(29+96*i)+'"':
line[0] = 'E04'
elif line[0] == '"'+str(30+96*i)+'"':
line[0] = 'F04'
elif line[0] == '"'+str(31+96*i)+'"':
line[0] = 'G04'
elif line[0] == '"'+str(32+96*i)+'"':
line[0] = 'H04'
elif line[0] == '"'+str(33+96*i)+'"':
line[0] = 'A05'
elif line[0] == '"'+str(34+96*i)+'"':
line[0] = 'B05'
elif line[0] == '"'+str(35+96*i)+'"':
line[0] = 'C05'
elif line[0] == '"'+str(36+96*i)+'"':
line[0] = 'D05'
elif line[0] == '"'+str(37+96*i)+'"':
line[0] = 'E05'
elif line[0] == '"'+str(38+96*i)+'"':
line[0] = 'F05'
elif line[0] == '"'+str(39+96*i)+'"':
line[0] = 'G05'
elif line[0] == '"'+str(40+96*i)+'"':
line[0] = 'H05'
elif line[0] == '"'+str(41+96*i)+'"':
line[0] = 'A06'
elif line[0] == '"'+str(42+96*i)+'"':
line[0] = 'B06'
elif line[0] == '"'+str(43+96*i)+'"':
line[0] = 'C06'
elif line[0] == '"'+str(44+96*i)+'"':
line[0] = 'D06'
elif line[0] == '"'+str(45+96*i)+'"':
line[0] = 'E06'
elif line[0] == '"'+str(46+96*i)+'"':
line[0] = 'F06'
elif line[0] == '"'+str(47+96*i)+'"':
line[0] = 'G06'
elif line[0] == '"'+str(48+96*i)+'"':
line[0] = 'H06'
elif line[0] == '"'+str(49+96*i)+'"':
line[0] = 'A07'
elif line[0] == '"'+str(50+96*i)+'"':
line[0] = 'B07'
elif line[0] == '"'+str(51+96*i)+'"':
line[0] = 'C07'
elif line[0] == '"'+str(52+96*i)+'"':
line[0] = 'D07'
elif line[0] == '"'+str(53+96*i)+'"':
line[0] = 'E07'
elif line[0] == '"'+str(54+96*i)+'"':
line[0] = 'F07'
elif line[0] == '"'+str(55+96*i)+'"':
line[0] = 'G07'
elif line[0] == '"'+str(56+96*i)+'"':
line[0] = 'H07'
elif line[0] == '"'+str(57+96*i)+'"':
line[0] = 'A08'
elif line[0] == '"'+str(58+96*i)+'"':
line[0] = 'B08'
elif line[0] == '"'+str(59+96*i)+'"':
line[0] = 'C08'
elif line[0] == '"'+str(60+96*i)+'"':
line[0] = 'D08'
elif line[0] == '"'+str(61+96*i)+'"':
line[0] = 'E08'
elif line[0] == '"'+str(62+96*i)+'"':
line[0] = 'F08'
elif line[0] == '"'+str(63+96*i)+'"':
line[0] = 'G08'
elif line[0] == '"'+str(64+96*i)+'"':
line[0] = 'H08'
elif line[0] == '"'+str(65+96*i)+'"':
line[0] = 'A09'
elif line[0] == '"'+str(66+96*i)+'"':
line[0] = 'B09'
elif line[0] == '"'+str(67+96*i)+'"':
line[0] = 'C09'
elif line[0] == '"'+str(68+96*i)+'"':
line[0] = 'D09'
elif line[0] == '"'+str(69+96*i)+'"':
line[0] = 'E09'
elif line[0] == '"'+str(70+96*i)+'"':
line[0] = 'F09'
elif line[0] == '"'+str(71+96*i)+'"':
line[0] = 'G09'
elif line[0] == '"'+str(72+96*i)+'"':
line[0] = 'H09'
elif line[0] == '"'+str(73+96*i)+'"':
line[0] = 'A10'
elif line[0] == '"'+str(74+96*i)+'"':
line[0] = 'B10'
elif line[0] == '"'+str(75+96*i)+'"':
line[0] = 'C10'
elif line[0] == '"'+str(76+96*i)+'"':
line[0] = 'D10'
elif line[0] == '"'+str(77+96*i)+'"':
line[0] = 'E10'
elif line[0] == '"'+str(78+96*i)+'"':
line[0] = 'F10'
elif line[0] == '"'+str(79+96*i)+'"':
line[0] = 'G10'
elif line[0] == '"'+str(80+96*i)+'"':
line[0] = 'H10'
elif line[0] == '"'+str(81+96*i)+'"':
line[0] = 'A11'
elif line[0] == '"'+str(82+96*i)+'"':
line[0] = 'B11'
elif line[0] == '"'+str(83+96*i)+'"':
line[0] = 'C11'
elif line[0] == '"'+str(84+96*i)+'"':
line[0] = 'D11'
elif line[0] == '"'+str(85+96*i)+'"':
line[0] = 'E11'
elif line[0] == '"'+str(86+96*i)+'"':
line[0] = 'F11'
elif line[0] == '"'+str(87+96*i)+'"':
line[0] = 'G11'
elif line[0] == '"'+str(88+96*i)+'"':
line[0] = 'H11'
elif line[0] == '"'+str(89+96*i)+'"':
line[0] = 'A12'
elif line[0] == '"'+str(90+96*i)+'"':
line[0] = 'B12'
elif line[0] == '"'+str(91+96*i)+'"':
line[0] = 'C12'
elif line[0] == '"'+str(92+96*i)+'"':
line[0] = 'D12'
elif line[0] == '"'+str(93+96*i)+'"':
line[0] = 'E12'
elif line[0] == '"'+str(94+96*i)+'"':
line[0] = 'F12'
elif line[0] == '"'+str(95+96*i)+'"':
line[0] = 'G12'
elif line[0] == '"'+str(96+96*i)+'"':
line[0] = 'H12'
line=';'.join(line) #weer aan elkaar zetten met ; als delimiter
file_out.write(line) #schrijven naar het output bestand
n = n+1
file_out.close()
file_in.close()
shutil.copy('tijdelijk.csv',csv)
os.remove('tijdelijk.csv')