benjamin.kaplan at case.edu
Wed Jul 6 00:09:09 CEST 2011
On Jul 5, 2011 2:28 PM, "miguel olivares varela" <klica_sk8 at hotmail.com>
> i got a csv file that i need to modify and create a new one, i have no
problem to read mi 'test.cvs' which is the source file but when i try to
create a new one with the modifications i only got the first row in my
'out.csv' file. I think there is somethng wrong in my loop because i can't
put into the rest.
> [here my code:]
> import sys
> import csv
> import os
> import glob
> import time
> dir_cdr = "/tmp"
> #loop to find files csv in a directory and read thoses files
> for cdr_files_in in glob.glob(os.path.join(dir_cdr, '*.csv') ):
> file_source = open(cdr_files_in, 'r')
> reader = csv.reader(file_source, delimiter=';',
> for data in reader:
> if data:
> firstname = data
> lastname = data
> date_source = data
> phone = data
> #Date to epoch
timestamp=int(time.mktime(time.strptime(date_cdr, "%Y%m%d %H%M%S")))
> fout = open("out.csv", "w")
> print >>fout, lastname, firstname,
Do you understand what these next two lines are doing? They are closing the
file and then exiting the program. I'm pretty sure that's not what you want
to do here.
> except csv.Error, e:
> print e
> sys.exit('file %s, line %d: %s' % (file_source,
> Smith John 1296208720 33611111111
> Could you help me?
> Best Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list