topic Re: convert row values to field values in Python Questions

convert row values to field values

ElaineKuo — Tue, 12 Jun 2012 20:45:06 GMT

Hello

I have a table describing annual temperature of seasonal distributions of five birds.
Now the fields of the table are as followed:
Rowid, bird_code (classified as summer and winter), min, max, mean

Now I want to convert the row values of summer (in bird_code) into a new field, with the row of min, max, and mean.
Please kindly advise any python code to perform this task.

Thank you

Re: convert row values to field values

NobbirAhmed — Wed, 13 Jun 2012 06:32:29 GMT

Use Calculate Field tool (under Data Management > Fields). The screenshot below shows an example. Here, in the expression I'm passing four field values to a function. The function is implemented in code block.

I don't know what you want to do with the three values (min, max, mean). Here, I have just converted them to string and concatanated before returning (if the bird code is summer).

[ATTACH=CONFIG]15164[/ATTACH]

Re: convert row values to field values

MikeMacRae — Wed, 13 Jun 2012 14:40:14 GMT

You can try the Transpose Fields tool:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000v4000000

Re: convert row values to field values

ElaineKuo — Wed, 13 Jun 2012 21:08:09 GMT

Thanks for the response.
sorry I forgot to mention I am using ArcGIS 9.3

Are code block or transpose field still available iin 9.3?

Re: convert row values to field values

NobbirAhmed — Wed, 13 Jun 2012 21:11:34 GMT

Calculate Field is available on 9.3 and the code should work on 9.3 as well. Are you getting any error? Here is the doc for that version of ArcGIS:

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Calculate_Field_(Data_Management)

Re: convert row values to field values

ElaineKuo — Sun, 12 Dec 2021 07:26:44 GMT

sorry for the late response.

The above link is broken.
Also, please kindly advise how to write the expression in the following code.
Thank you.

##Script Name: Make a line from points
##Description: Connect the line by points using XToools Pro
##Created By: Elaine Kuo
##Date: 03/05/2012


#Import standard library modules
import arcgisscripting
import os

#Create the Geoprocessor object
gp = arcgisscripting.create(9.3)

#Set the input workspace
#GP.workspace = sys.argv[1]
#Set the workspace.
gp.Workspace= "H:/temp/test"

#Set the output workspace
#outWorkspace = sys.argv[2]
#Set the workspace. List all of the feature classes in the dataset
outWorkspace= "H:/temp"



#Get a list of the featureclasses in the input folder
fcs = gp.ListFeatureClasses()

# Loop through every item in the list that was just generated
for fc in fcs:

    # Break out the name, no path or extension, using the describe object.
    desc = gp.describe(fc)
    featureName = desc.name

    #Validate the new feature class name for the output workspace.
    gp.Toolbox = "Data Management"

    # Add a field to this shapefile
    gp.addfield (fc, "min", "double", 6,3)
    

    # Loop through every item in the list that was just generated 
    

    gp.toolbox = "Data Management"


    expression = "!min!"
        
    gp.CalculateField_management(fc, "min", expression, "PYTHON")
      
    #Validate the new feature class name for the output workspace.
    OutFeatureClass = outWorkspace + os.sep + gp.ValidateTableName(fc,outWorkspace)

gp.AddMessage(gp.GetMessages())
print gp.GetMessages()