Thank you for your help!
Once I read your comments I tried both corrections in my code, but none of
them we're sucessful.
Tim's idea kept the quotes at the moment I open the csv in Excel, quotues
appeared at the beggining and the end of the row for Excel.
Joel's idea wrote just tha variable name 'filepath' and ''filename'.
The corrections I made were:
import os, csv, time, socket
from osgeo import ogr,gdal,osr
from dbf import *
gdal.AllRegister()
file_list = []
folders = None
for root, folders, files in os.walk( "C:\\" ):
file_list.extend(os.path.join(root,fi) for fi in files if
fi.endswith(".shp"))
ofile = open('csv1.csv', "wb")
writer = csv.writer(open('csv2.csv', "wb"))
ruta = 'Ruta'
archivo = 'archivo'
prj = '.prj'
campos = [ruta,archivo,prj]
writer.writerow(campos)
for row, filepath in enumerate(file_list, start=1):
(ruta, filename) = os.path.split(filepath)
n = os.path.splitext(filepath)
p = n[0]+'.prj'
filepath = ''+filepath+''
filename = ''+filename+''
if os.path.exists(p):
prj_text = open(p, 'r').read()
prjtext = ''+prj_text+''
aRow= [ filepath, filename, 1, ]
writer.writerow(aRow)
else:
no_prj = 'Sin prj, no se puede determinar la proyeccion'
aRow1= [ filepath, filename,0]
writer.writerow(aRow1)
print "El archivo esta listo"
2011/3/11 Tim Golden <m...@timgolden.me.uk>
> On 11/03/2011 8:59 PM, Susana Iraiis Delgado Rodriguez wrote:
>
>> Hello list!!
>>
>> I'm trying to write a CSV file to work it with Excel. My python script is
>> working, the issue is: when I import the file from excel the data comes
>> with
>> quotes at the beginnig and ending of the row. I don't want to have these
>> quotes. What is wrong with my code?
>>
>
> Essentially, the work is being done twice.
> The .writerow method expects a list which it will
> convert into a quoted, comma-separated string. You're
> giving it a list whose one element is a quoted, comma-separated
> string.
>
> Just pass it a list instead:
>
> writer.writerow (['Ruta', 'Archivo', '.prj'])
> ...
> writer.writerow ([filepath, filename, 1])
>
> (BTW, my naive knowledge of Spanish suggests that you're confusing
> the two identical-sounding English words: "root" -> "raiz" and
> "route" -> "ruta").
>
> TJG
>
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
