#coding:utf-8
import arcpy
from arcpy import env
import csv
import codecs
import sys
defaultencoding = 'utf-8'
if sys.getdefaultencoding() != defaultencoding:
reload(sys)
sys.setdefaultencoding(defaultencoding)
csvPath20=r"I:\Doublelogistics\testdata\test_write.csv" #路径要全英文
f=open(csvPath20,"wb")
f.write(codecs.BOM_UTF8)
csv_writer=csv.writer(f)
env.workspace = r"I:\DATA\新建文件夹"
for file1 in arcpy.ListFiles("*OS.dbf"):
with arcpy.da.SearchCursor(file1,["OID","VALUE","COUNT","AREA","MEAN"]) as cursor: #根据数据字段修改引号内容
csv_writer.writerow([file1])
for row in cursor:
data=[row[0],row[1],row[2],row[4]]
csv_writer.writerow(data)
#根据字段位置修以上改方括号数字
print ("finished")
09-24