Add several rows header in an existing csv file

Question

I have a group of csv files, and I need to add to all of them a specific header compounded by 6 different rows:

header = ['Plantillas.mot', 'version=1', 'nRows='+str(len(data1)), 'nColumns=7', 'inDegrees=yes', 'endheader']

I am trying everything, my last try:

header = ['Plantillas.mot', 'version=1', 'nRows='+str(len(data1)), 'nColumns=7', 'inDegrees=yes', 'endheader']
import csv
ordered_filenames = header
with open('mycsv.csv') as csvfile, open(rute+'/loadsol/result1.mot',"w",newline='') as result:
    rdr = csv.DictReader(csvfile, fieldnames=ordered_filenames)
    wtr = csv.DictWriter(result, ordered_filenames)
    wtr.writeheader()
    for line in rdr:
        wtr.writerow(line)

But that gives me all the header in the same row, and I need the header to appear like this:

Plantillas.mot
version=1
nRows=821
nColumns=7
inDegrees=yes
endheader

Thank you very much for your help!

gosuto · Accepted Answer · 2020-04-02 10:57:09Z

1

You could add a newline character to each header name and write that string:

header = ['Plantillas.mot', 'version=1', 'nRows='+str(len(data1)), 'nColumns=7', 'inDegrees=yes', 'endheader']
header = '\n'.join(header)

answered Apr 2, 2020 at 10:57

gosuto

5,8316 gold badges42 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

Add several rows header in an existing csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related