I've hacked together a small utility program that I assume can be written much better. The program reads in output from a statistical program and spits out the relevant data needed. The purpose of the program is to reach into the original data file (which is a text file), pull out the relevant informaiton, and spit out a file that can be opened in Excel in order to create tables for some reports we need.
To accomplish this, I enter in commas by brute force so that the output is a csv file that excel can open. This program works fine, but, as I am still learning python, I am interested in ways to write better code. If anyone has any suggestions, they are most appreciated. Below is the program in its current form. Harold filename = raw_input("Please enter the WinSteps ISF file: ") new_file = raw_input("Enter the name of the csv file to output: ") # create a new file defined by the user f = open(new_file, 'w') f.write("Num, Measure, SE, Measure, SE, Measure, SE, Measure, SE \n") params = open(filename, 'r') for line in params: x = line if x[15] == '1': print >> f, x[4:6], ',' ,x[39:47], ',' ,x[49:55], ',,,' elif x[15] == '2': print >> f, x[4:6], ',' ,x[39:47], ',' ,x[49:55], ',' ,x[90:97], ',' ,x[99:105], ',,' elif x[15] == '3': print >> f, x[4:6], ',' ,x[39:47], ',' ,x[49:55], ',' ,x[90:97], ',' ,x[99:105], ',' ,x[140:147], ',' ,x[149:155], ',' elif x[15] == '4': print >> f, x[4:6], ',' ,x[39:47], ',' ,x[49:55], ',' ,x[90:97], ',' ,x[99:105], ',' ,x[140:147], ',' ,x[149:155], ',',x[190:197], ',' ,x[199:205] f.close()
-- http://mail.python.org/mailman/listinfo/python-list