【Arcpy】-【属性表运算】添加或删除列

1. 读取

# encoding: utf-8
import arcpy

shapefile_path = r"E:\Family.shp"

2. 添加列

#要添加的列名
fields = ['Vol', 'Tsu', 'Flo']

existing_fields = [field.name for field in arcpy.ListFields(shapefile_path)]
for field in fields:
    # 检查列字段是否已存在
    if field not in existing_fields:
        # 若字段不存在，添加字段
        arcpy.AddField_management(in_table=shapefile_path,
                                  field_name=field,
                                  field_type="FLOAT",
                                  field_precision="",
                                  field_scale="",
                                  field_length="",
                                  field_alias="",
                                  field_is_nullable="NULLABLE",
                                  field_is_required="NON_REQUIRED",
                                  field_domain="")#添加列的相关属性

3. 删除列

# 要删除的列名
fields_to_delete = ['Vol', 'Tsu', 'Flo']

#删除字段
arcpy.DeleteField_management(shapefile_path, fields_to_delete)