I have a long tab-delimited text file that I'd like to convert into csv
format so I can read it into a statistics package.
I've been using Excel to do the format conversion up till now, but now I
have more rows than Excel can handle, and would like to avoid going
through Excel if possible.
I've found the csv module but am confused by its documentation, as I am
with the few threads on the subject generally.
Here's what I've tried to do:
import csv
inputFileList = file('input.txt').readlines()
writer = csv.writer(file('output.csv', 'wb'))
writer.writerows(inputFileList)
del writer
When I try to open the resulting file in Excel (I've used a sample file
of 100 rows), however, it appears that I'm delimiting every character,
as each character has its own column. The rows in the original text file
are combinations of integers and character strings (some of which
include double quotes). Do I need to alter the 'dialect' or what?
Many thanks in advance for your help!
Nick
_______________________________________________
Tutor maillist - [email protected]
http://mail.python.org/mailman/listinfo/tutor
