Cell shift in Excel using python

Question

I wrote the following python script that reads the contents of "prom output.csv" file, and after some processing it writes the output to the file "sorted output."

import collections
import csv
import sys

with open("prom output.csv","r") as f:
    cr = csv.reader(f,delimiter=",")
    d=collections.defaultdict(lambda : list())
    header=next(cr)   
    for r in cr:
        d[r[0]].append(r[1])  


with open("sorted output.csv","w") as f:
    cr = csv.writer(f,sys.stdout, lineterminator='\n')
    cr.writerow(header)  
    od = collections.OrderedDict(sorted(d.items()))
    for k,v in od.items(): 
        cr.writerow([k,";".join(v)])

The output "sorted output.csv" looks like:

My input file: "prom output.csv" looks like:

I want to slightly modify the current output so that it will have the following form:

Any ideas?

Scott Hunter · Accepted Answer · 2016-09-12 17:19:36Z

3

Don't use join for your row content; just combine the header w/ the data into a single list:

cr.writerow([k]+v)

answered Sep 12, 2016 at 17:19

Scott Hunter

50k12 gold badges65 silver badges107 bronze badges

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

Collectives™ on Stack Overflow

Cell shift in Excel using python

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