[Tutor] converting xls to csv

Nick Burgess burgess.nick at gmail.com
Sat Jun 6 22:07:31 CEST 2009


f seems to be a string containing the file names, so csv.reader isnt
actually opening them..  maybe i will play with os.walk..?

files = glob.glob("*.csv")

for f in files:
    print f
    csv.reader(open (f), delimiter=' ', quotechar='|')
    for row in f:
        for cell in row:
            if pattern.search(cell):
                print ', '.join(row)


XLS.xls.org1.csv
XLS.xls.org2.csv
XLS.xls.org3.csv

On Sat, Jun 6, 2009 at 3:33 PM, Emile van Sebille<emile at fenx.com> wrote:
> On 6/6/2009 12:19 PM Nick Burgess said...
>>
>> Thank you. The data is pretty much random throughout the csv's so I
>> think I it would have to iterate over the entire rows .  I need to
>> search all .csv files in the current directory.   I can get glob to
>> return a list of files.  How could I get csv.reader to open all the
>> files in the list?
>
> Open the files from within your loop.
>
>> My loop logic must be bad..  I am using
>> ActivePython 2.6.1.1.  Any clues would be appreciated.
>>
>>
>>
>> pattern = re.compile(r'10\.191\.239\.0')
>> files = glob.glob("*.csv")
>>
>> csv.reader(open (files), delimiter=' ', quotechar='|')
>> for f in files:
>
> do the open here
>
>>    for row in f:
>>        for cell in row:
>>            if pattern.search(cell):
>>                print ', '.join(row)
>>
>
>
> Emile
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>


More information about the Tutor mailing list