Use Python to write on specific columns in csv file
Question: I have data in a file and I need to write it to CSV file in specific column.
The data in file is like this:

    
    
    002100
    002077
    002147
    

My code is this:

    
    
    import csv
    
    f = open ("file.txt","r")
    with open("watout.csv", "w") as output:
        for line in f :
           c.writerows(line)
    

It is always writes on the first column. How could I resolve this? Thanks.


Answer: This is how I solved the problem

    
    
    f1 = open ("inFile","r") # open input file for reading
    
    with open('out.csv', 'wb') as f: # output csv file
        writer = csv.writer(f)
        with open('in.csv','r') as csvfile: # input csv file
            reader = csv.reader(csvfile, delimiter=',')
            for row in reader:  
                row[7] = f1.readline() # edit the 8th column 
                writer.writerow(row)
    f1.close()   
    

