Arcpy为矢量数据添加字段与循环修改值或赋值
如题目所示,已经生成的Arcmap矢量属性表里对于赋值一些简单的操作时是可以的,但是想添加Excel表格里的一列新数据则需要使用Arcpy的游标来处理。可以提前在Arcmap里建好字段,或者直接新建字段:
#coding:utf-8
import arcpy
import numpy as np
filename = r'E:\bjdata\data'
arcpy.env.workspace = filename
# path = r"E:\bjdata\result(1000,15).xlsx"
path = r"C:\Users\mianmian\Desktop\result.csv"
wdata=np.genfromtxt(path,delimiter=",") # 打开Excel文件
x=wdata[:,13]; #第13列,所有行数据
# print(x)
shp_path = r'E:\bjdata\rightbjnet.shp'
cursor = arcpy.UpdateCursor(shp_path)
i = 1
for my_row in cursor:
my_value = my_row.getValue('result')
# print(my_value)
my_row.setValue('result', float(x[i]))
cursor.updateRow(my_row)
i += 1
print(my_value)