I realize this is very similar to this question. However, I have a CSV file that always comes in the same format that I need to write out with columns in a different order to move it down the data processing pipeline. If my csv file contains headers and data like this:
Date,Individual,Plate,Sample,test,QC
03312011,Indiv098,P342,A1,deep,passed
03312011,Indiv113,P352,C3,deep,passed
How would I write out a csv file with the same columns as the original input csv but in the following order:
test,QC,Plate,Sample
deep,passed,P342,A1
deep,passed,P352,C3
My initial thought was to do something like this:
f = open('test.csv')
lines = f.readlines()
for l in lines:
h = l.split(",")
a, b, c, d, e, f = h
for line in h:
print e, f, c, d,
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…