Python - Write to csv from a particular column number

Question

I have a csv file Temp.csv that I am copying over to another csv file Final.csv using the following piece of code.

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'Final.csv')
tempfile = os.path.join(dirname, 'Temp.csv')
with open(csvfilename, 'wb') as output_file:
    writer = csv.writer(output_file, delimiter=',')
    writer.writerow(["Title","This"])
    writer.writerow([])
    with open(tempfile, 'r') as data_file:
        for line in data_file:
            line = line.replace('\n', '')
            row = line.split(",")            
            writer.writerow(row)

The last 5 lines of the code are going to write to the Final.csv file from column A. I want them to write to final.csv from column D. Also I have multiple columns in the Temp.csv file. What is the best solution for this? Using python 2.7.10.

Did you solve your problem?

Sardorbek Imomaliev
– Sardorbek Imomaliev

2016-10-17 14:41:25 +00:00
Commented Oct 17, 2016 at 14:41 — Sardorbek Imomaliev
– Sardorbek Imomaliev, Commented Oct 17, 2016 at 14:41
No. You did! Thank you!

amazingCodingExperience
– amazingCodingExperience

2016-10-18 08:12:19 +00:00
Commented Oct 18, 2016 at 8:12 — amazingCodingExperience
– amazingCodingExperience, Commented Oct 18, 2016 at 8:12

Sardorbek Imomaliev · Accepted Answer · 2016-10-17 10:31:48Z

1

EDIT Answering comment. You just need to prepend 3 empty strings to your row

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'Final.csv')
tempfile = os.path.join(dirname, 'Temp.csv')
with open(csvfilename, 'wb') as output_file:
    writer = csv.writer(output_file, delimiter=',')
    writer.writerow(["Title","This"])
    writer.writerow([])
    with open(tempfile, 'r') as data_file:
        for line in data_file:
            line = line.replace('\n', '')
            row = line.split(",")
            # there are better ways to do this but this is the most straight forward
            new_row = ['', '', '']
            new_row.extend(row)            
            writer.writerow(new_row)

edited Oct 17, 2016 at 10:31

answered Oct 17, 2016 at 9:39

Sardorbek Imomaliev

15.5k3 gold badges55 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

amazingCodingExperience Over a year ago

This is gonna write temp file to Final file from column 4 i.e. the first three columns of the temp file aren't written and not write to the final file from column 4. I want that in the final file the first 3 columns are blank and the entire temp file writes from the fourth column.

amazingCodingExperience Over a year ago

Can you please suggest something for that?

Sardorbek Imomaliev Over a year ago

@amazingCodingExperience Sorry can't understand your english. Give some examples please, this may help.

amazingCodingExperience Over a year ago

e.g. my temp file contains 4 fields in the first four columns Field1, Field2, Field3, Field4. When I write the temp file to the final file, it should leave the first three columns (A,B,C) blank and write Field1 in column D, Field2 in E, Field3 in F and Field4 in G. Hope this helps!

Sardorbek Imomaliev Over a year ago

@amazingCodingExperience see changed answer

Harsha Biyani · Accepted Answer · 2016-10-17 09:31:42Z

0

You can try :

with open(tempfile, 'r') as data_file:
   for line in data_file:
       line = line.replace('\n', '')
       row = line.split(",")         
       csvfilename.writerow([row[0]+","+row[3]])

answered Oct 17, 2016 at 9:31

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges

Collectives™ on Stack Overflow

Python - Write to csv from a particular column number

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related