对于 Python 计算,必须在字段名称两边添加惊叹号 (!fieldname!)。
语法格式
CalculateField(in_table, field, expression, {expression_type}, {code_block})
直接将A字段的值赋值给B字段,示例代码如下
import arcpy
arcpy.env.workspace = "E:/工作/20210408/01-数据/2085上海市-208W/2085上海市_split_1/5.shp"
#打开工作空间
arcpy.CalculateField_management("2","name",'Field1', "PYTHON_9.3")
#第一个为表名称,
#第二个为字段名称
#第三个为表达式(此处代表将'Field1'的值赋值给name)
#第四个为选择的地理信息处理器为PYTHON_9.3
arcpy.CalculateField_management("2","type",'!Field2!', "PYTHON_9.3")
arcpy.CalculateField_management("2","tel",'!Field3!', "PYTHON_9.3")
arcpy.CalculateField_management("2","gpsx",'!Field15!', "PYTHON_9.3")
arcpy.CalculateField_management("2","gpsy",'!Field16!', "PYTHON_9.3")
arcpy.CalculateField_management("2","pname",'!Field6!', "PYTHON_9.3")
arcpy.CalculateField_management("2","city",'!Field7!', "PYTHON_9.3")
arcpy.CalculateField_management("2","district",'!Field8!', "PYTHON_9.3")
arcpy.CalculateField_management("2","citycode",'!Field9!', "PYTHON_9.3")
arcpy.CalculateField_management("2","adcode",'!Field10!', "PYTHON_9.3")
arcpy.CalculateField_management("2","typecode",'!Field11!', "PYTHON_9.3")
arcpy.CalculateField_management("2","address",'!Field12!', "PYTHON_9.3")
arcpy.CalculateField_management("2","locationx",'!Field4!', "PYTHON_9.3")
arcpy.CalculateField_management("2","locationy",'!Field5!', "PYTHON_9.3")
arcpy.CalculateField_management("2","bdx",'!Field13!', "PYTHON_9.3")
arcpy.CalculateField_management("2","bdy",'!Field14!', "PYTHON_9.3")