I have the following txt file that has 4 fields that are tab separated: the first is the id and the other three show the results per test.
152 TEST1 valid TEST3 good TEST2 bad
158 TEST2 bad TEST1 bad TEST4 valid
Based on the above txt I need to create an xls file having as headers ID, TEST1, TEST2, TEST3, TEST4 and the values valid, bad, etc under the corresponding column:
ID TEST1 TEST2 TEST3 TEST4
152 valid bad good
158 bad bad valid
I tried to work that out with xlwt but couldn't. Actually, I started used the following code but I couldn't even split the line for further processing:
wbk = xlwt.Workbook()
sheet = wbk.add_sheet('sheet 1')
row = 0
f = open('C:/test.txt','r')
for line in f:
# separate fields by tab
L = line.rstrip().split('\t')
#actually some code is needed here to create the columns and put the values under the appropriate column
# Write the data, using the style defined above.
row += 1
Thanks in advance for any help!