I just found out that I can save space\ speed up reads of CSV files.
Using the answer of my previous question http://stackoverflow.com/questions/3710263/how-do-i-create-a-csv-file-from-database-in-python
And 'wb' for opens
w = csv.writer(open(Fn,'wb'),dialect='excel')
How can I open all files in a directory and saves all files with the same name as starting name and use 'wb' to reformat all files. I guess convert all CSV's to binary CSV's.
You can't "overwrite a file on the fly". You have two options:
if the files are small enough (smaller than the amount of available RAM by
a comfortable margin), just loop over them (os.listdir makes that loop
easy, or os.walk if you want to catch the whole tree of subdirectories,
not just one directory), and for each, read it in memory first, then
overwrite the on-disk copy.
otherwise, loop over them, and each time write to a new file (e.g. by
appending .new to the name), then move the new file over the old. This
is safer (no risk of running out of memory, no risk of damaging a file if
the computer crashes) but more complicated.
So, what is your situation: small-enough files (and backups for safeguard against computer and disk crashes), in which case I can if you wish show the simple code; or huge multi-GB files -- in which case it will have to be the complex code? Let us know!
=== WARNING ===
Please explain your fundamental premise "I just found out that I can save space\ speed up reads of CVS [sic -- you mean CSV] files" evidenced by "the" answer (which answer??) to your previous question plus 'wb' on writes -- it is NOT immediately obvious (a) that there is a grain of truth in that at all (b) that a perilous venture like re-writing all your files should be contemplated.