topic Re: Python script to field calculate one field based on another field's value in Python Questions

Python script to field calculate one field based on another field's value

SusanO_Connell — Thu, 05 Feb 2015 14:17:08 GMT

I would like to find a python script to field calculate one field based on another field's value. For example, "Field B" will have a code '23' if "Field A" is equal to CST, or if it is equal to AFF, it will be '11'. Also need to know what to use as a wildcard if CST or AFF is followed by more descriptions.

Re: Python script to field calculate one field based on another field's value

MahtabAlam1 — Thu, 05 Feb 2015 15:12:19 GMT

It will require a code block which is nothing but a python function. Please refer Calculate Field Examples

So all you need is something like

def cal( valA):

if(valA.startswith('CST') or valA.startswith('AFF')):

return 11

else:

return

and call it as

cal(!Field_A!)

Hope that helps.

Re: Python script to field calculate one field based on another field's value

SusanO_Connell — Thu, 05 Feb 2015 15:43:25 GMT

Thank you very much!

Susan O’Connell

Geographic Information Systems

GIS Specialist

Re: Python script to field calculate one field based on another field's value

XanderBakker — Thu, 05 Feb 2015 17:39:32 GMT

Hi Susan O'Connell‌,

If your the solution provided by Mahtab Alam‌ solved your problem (and I think it did), could you please mark his answer as the correct one.

Thank you,

Xander

GeoNet Moderator

Re: Python script to field calculate one field based on another field's value

XanderBakker — Thu, 05 Feb 2015 17:48:23 GMT

Hi Susan O'Connell,

I think you ment to mark the answer by Mahtab Alam as helpful, right? Since you marked your own response as helpful.