I have to read two csv file, combine the row and write the result in a third csv file. first csv file have five row with user name in the first colunm.( 25 colunm in total) second csv file have five row with user name in the first colunm and user id in second colunm.(only 2 colunm)
the third csv file will contain username+useridand all remaining 24 column of first file.
data = open(os.path.join("c:\\transales","AccountID+ContactID-source1.csv"),"rb").read().replace(";",",").replace("\0","")
data2 = open(os.path.join("c:\\transales","AccountID+ContactID-source2.csv"),"rb").read().replace(";",",").replace("\0","")
i = 0
j = 0
Info_Client_source1=StringIO.StringIO(data)
Info_Client_source2=StringIO.StringIO(data2)
for line in csv.reader(Info_Client_source1):
name= line[1]
i=i+1
print "i= ",i
for line2 in csv.reader(Info_Client_source2):
print "j = :",j
j=j+1
if line[1] == line2[2]:
continue
the result:
i= 1
j = : 0
j = : 1
j = : 2
j = : 3
j = : 4
j = : 5
j = : 6
i= 2
i= 3
i= 4
i= 5
i= 6
i= 7
why after i=2 the seconf for loop do nothing ?? I expect to have i=2, j=0 to 6, i=3 j=0 ro 6 ,...