I have this block of code that I would like repeated 21 times. It creates a feature layer, executes summary statistics, joins a field, executes update cursor twice, for a line and polygon feature class. Lastly, it calculates a field and deletes two fields. Can somebody please explain to me the logic of the Python method/function? How does the program know which variable should be called within an ArcPy function? The block of code below has within the first function what I would like executed 21 times. However, when the SummaryStats(DistrictConfig) is executed, I do not receive my expected output. What is being done incorrectly? import arcpy import DistrictConfig import logging import logging . handlers import ConfigParser LOGGER_NAME = 'korterra_district' arcpy . env . workspace = r "C:\KorTerraTables\tables_db.gdb" arcpy . env . overwriteOutput = True from datetime import datetime startTime = datetime . now ( ) logger = logging . getLogger ( LOGGER_NAME ) distfc = DistrictConfig . distfc linefc = DistrictConfig . linefc polyfc = DistrictConfig . polyfc totalexpression = DistrictConfig . TotalExpression totalscline = DistrictConfig . TotalSCLine totalscpoly = DistrictConfig . TotalSCPoly statsfield = DistrictConfig . StatsField fields = DistrictConfig . fields totalCalc = DistrictConfig . TotalCalc unique_name = arcpy . CreateUniqueName ( "featureLyr" ) transPoly = DistrictConfig . Overdue_Expression_SC_Tran overDueLine = DistrictConfig . OverdueTableSC_TransLine overDueExpression = DistrictConfig . Overdue_Expression statusCaseFields = DistrictConfig . CaseFields TotalLong = "TOTAL_LONG" OverDueTotal = "OVERDUE" def DistrictFunction ( DistrictConfig , distfc , totalexpression , totalscline , statsfield , fields , TotalLong ) : print "Calculating Total Line Tickets per District" arcpy . MakeFeatureLayer_management ( linefc , unique_name , totalexpression ) arcpy . Statistics_analysis ( unique_name , totalscline , statsfield , "DISTRICT" ) arcpy . JoinField_management ( distfc , "NAME" , totalscline , "DISTRICT" , fields ) with arcpy . da . UpdateCursor ( distfc , [ "FREQUENCY" ] ) as cursor : for row in cursor : if row [ 0 ] == None : row [ 0 ] = 0 cursor . updateRow ( row ) #Calculate and Join Totals per District Polys arcpy . MakeFeatureLayer_management ( polyfc , unique_name , totalexpression ) arcpy . Statistics_analysis ( unique_name , totalscpoly , statsfield , "DISTRICT" ) arcpy . JoinField_management ( distfc , "NAME" , totalscpoly , "DISTRICT" , fields ) with arcpy . da . UpdateCursor ( distfc , [ "FREQUENCY_1" ] ) as cursor : for row in cursor : if row [ 0 ] == None : row [ 0 ] = 0 cursor . updateRow ( row ) arcpy . CalculateField_management ( distfc , TotalLong , totalCalc ) arcpy . DeleteField_management ( distfc , [ "FREQUENCY" , "FREQUENCY_1" ] ) def SummaryStats ( DistrictConfig ) : try : ## DistrictFunction(DistrictConfig, distfc, totalexpression, totalscline, statsfield, fields, TotalLong ) ## DistrictFunction(DistrictConfig, distfc, totalexpression, totalscpoly, statsfield, fields, TotalLong) DistrictFunction ( DistrictConfig , distfc , overDueExpression , overDueLine , statsfield , fields , OverDueTotal ) except Exception as e : logger . info ( e . message , exc_info = True ) raise e

Hey Geoffrey, I would add that your DistrictFunction function collects DistrictConfig as an input parameter but doesn't actually use it anywhere in the function. If you need the functions run 21 one times with 21 different sets of parameters, you may with to store those parameters in a table. Each row would contain all the values required by your function. Then, read that table with an arcpy data access search cursor and run your function each time. Something along the lines of: def DistrictFunction ( distfc , totalexpression , totalscline , statsfield , fields , TotalLong ) : # your logic # create variables for your parameter table and the fields in that table you will interact with paramterTable = r "[Path to Parameter Table]" fields = ( "distfc" , "totalexpression" , "totalscline" , "statsfield" , "fields" , "TotalLong" ) # read the paramter table with a search cursor and run your function with arcpy . da . SearchCursor ( table , fields ) as cursor : for row in cursor : DistrictFunction ( row [ 0 ] , row [ 1 ] , row [ 2 ] , row [ 3 ] , row [ 4 ] , row [ 5 ] ) Good luck. Micah

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Working with Python Functions/Methods and ArcPy

enterprisemaps-gwest

I have this block of code that I would like repeated 21 times. It creates a feature layer, executes summary statistics, joins a field, executes update cursor twice, for a line and polygon feature class. Lastly, it calculates a field and deletes two fields.

Can somebody please explain to me the logic of the Python method/function? How does the program know which variable should be called within an ArcPy function?

The block of code below has within the first function what I would like executed 21 times. However, when the SummaryStats(DistrictConfig) is executed, I do not receive my expected output. What is being done incorrectly?

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> DistrictConfig
<SPAN class="keyword token">import</SPAN> logging
<SPAN class="keyword token">import</SPAN> logging<SPAN class="punctuation token">.</SPAN>handlers
<SPAN class="keyword token">import</SPAN> ConfigParser
LOGGER_NAME <SPAN class="operator token">=</SPAN> <SPAN class="string token">'korterra_district'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\KorTerraTables\tables_db.gdb"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> datetime
startTime <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
logger <SPAN class="operator token">=</SPAN> logging<SPAN class="punctuation token">.</SPAN>getLogger<SPAN class="punctuation token">(</SPAN>LOGGER_NAME<SPAN class="punctuation token">)</SPAN>
distfc <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>distfc
linefc <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>linefc
polyfc <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>polyfc
totalexpression <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>TotalExpression
totalscline <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>TotalSCLine
totalscpoly <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>TotalSCPoly
statsfield <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>StatsField
fields <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>fields
totalCalc <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>TotalCalc
unique_name <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateUniqueName<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"featureLyr"</SPAN><SPAN class="punctuation token">)</SPAN>
transPoly <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>Overdue_Expression_SC_Tran
overDueLine <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>OverdueTableSC_TransLine
overDueExpression <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>Overdue_Expression
statusCaseFields <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>CaseFields
TotalLong <SPAN class="operator token">=</SPAN><SPAN class="string token">"TOTAL_LONG"</SPAN>
OverDueTotal <SPAN class="operator token">=</SPAN> <SPAN class="string token">"OVERDUE"</SPAN>



<SPAN class="keyword token">def</SPAN> <SPAN class="token function">DistrictFunction</SPAN><SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN>TotalLong<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Calculating Total Line Tickets per District"</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>linefc<SPAN class="punctuation token">,</SPAN> unique_name<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>unique_name<SPAN class="punctuation token">,</SPAN> totalscline <SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NAME"</SPAN><SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
 row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
 cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#Calculate and Join Totals per District Polys</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>polyfc<SPAN class="punctuation token">,</SPAN> unique_name<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>unique_name<SPAN class="punctuation token">,</SPAN> totalscpoly <SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NAME"</SPAN><SPAN class="punctuation token">,</SPAN> totalscpoly<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY_1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
 row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
 cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> TotalLong<SPAN class="punctuation token">,</SPAN> totalCalc<SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>DeleteField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FREQUENCY_1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">SummaryStats</SPAN><SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="comment token">## DistrictFunction(DistrictConfig, distfc, totalexpression, totalscline, statsfield, fields, TotalLong )</SPAN>
<SPAN class="comment token">## DistrictFunction(DistrictConfig, distfc, totalexpression, totalscpoly, statsfield, fields, TotalLong)</SPAN>
 DistrictFunction<SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> overDueExpression<SPAN class="punctuation token">,</SPAN> overDueLine<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> OverDueTotal<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
 logger<SPAN class="punctuation token">.</SPAN>info<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>message<SPAN class="punctuation token">,</SPAN> exc_info<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">raise</SPAN> e








<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

enterprisemaps-gwest

I was able to sort this out; I mistakingly had used a variable

incorrectly. Here is my corrected code.

Define the funtion

def DistrictFunction(distfc, totalexpression, totalscline, statsfield,

fields,TotalLong):

print "DistrictFunction called"

print "distfc: " + distfc

print "totalexpression: " + totalexpression

print "totalscline: " + totalscline

print statsfield

print fields

print TotalLong

unique_name = arcpy.CreateUniqueName("featureLyr")

arcpy.MakeFeatureLayer_management(linefc, unique_name, totalexpression)

arcpy.Statistics_analysis(unique_name, totalscline , statsfield,

"DISTRICT")

arcpy.JoinField_management(distfc, "NAME", totalscline, "DISTRICT",

fields)

with arcpy.da.UpdateCursor(distfc, ["FREQUENCY"]) as cursor:

for row in cursor:

if row[0] == None:

row[0] = 0

cursor.updateRow(row)

#Calculate and Join Totals per District Polys

arcpy.MakeFeatureLayer_management(polyfc, unique_name, totalexpression)

arcpy.Statistics_analysis(unique_name, totalscpoly , statsfield,

"DISTRICT")

arcpy.JoinField_management(distfc, "NAME", totalscpoly, "DISTRICT",

fields)

with arcpy.da.UpdateCursor(distfc, ["FREQUENCY_1"]) as cursor:

for row in cursor:

if row[0] == None:

row[0] = 0

cursor.updateRow(row)

arcpy.CalculateField_management(distfc, TotalLong, totalCalc)

arcpy.DeleteField_management(distfc, ["FREQUENCY", "FREQUENCY_1"])

def SummaryStats():

try:

DistrictFunction(distfc, totalexpression, totalscline, statsfield,

fields, TotalLong)

DistrictFunction(distfc, totalexpression, totalscpoly, statsfield,

fields, TotalLong)

DistrictFunction(distfc, overDueExpression, overDueLine,

statsfield, fields, OverDueTotal)

DistrictFunction(distfc, overDueExpression, OverDuePoly,

statsfield, fields, OverDueTotal)

DistrictFunction(distfc, inProgressExpression, inProgressLine,

statsfield, fields, inProgresstotal)

DistrictFunction(distfc, inProgressExpression, inProgressPoly,

statsfield, fields, inProgresstotal)

DistrictFunction(distfc, unKnownExpression, unKnownLine,

statsfield, fields, unKnownTotal)

DistrictFunction(distfc, unKnownExpression, unKnownPoly,

statsfield, fields, unKnownTotal)

DistrictFunction(distfc, upComingExpression, upComingLine,

statsfield, fields, upComingTotal)

DistrictFunction(distfc, upComingExpression, upComingPoly,

statsfield, fields, upComingTotal)

except Exception as e:

logger.info(e.message, exc_info=True)

raise e

SummaryStats()

MicahBabinski

Hey Geoffrey,

I would add that your DistrictFunction function collects DistrictConfig as an input parameter but doesn't actually use it anywhere in the function.

If you need the functions run 21 one times with 21 different sets of parameters, you may with to store those parameters in a table. Each row would contain all the values required by your function. Then, read that table with an arcpy data access search cursor and run your function each time.

Something along the lines of:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">DistrictFunction</SPAN><SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> TotalLong<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># your logic</SPAN>

<SPAN class="comment token"># create variables for your parameter table and the fields in that table you will interact with</SPAN>
paramterTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"[Path to Parameter Table]"</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"distfc"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"totalexpression"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"totalscline"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"statsfield"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"fields"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TotalLong"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># read the paramter table with a search cursor and run your function</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DistrictFunction<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Good luck.

Micah

JamesCrandall

I should have specified 21 times with different parameters each time

You want the impossible unless you can explain the specifics of each parameter. I suspect your DistrictConfig contains everything but we are not going to be able to help without knowing what's in it.

distfc <SPAN class="operator token">=</SPAN> DistrictConfig<SPAN class="punctuation token">.</SPAN>distfc<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I'm not exactly sure what this even is because you are importing it from another python class.

KristenE

Are you missing some code in the above block? Is there a line later in the code where you call SummaryStats? In order to execute the code you would have to call SummaryStats like so:

SummaryStats<SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I'm not sure I understand why you have 2 functions. It looks like the second one just calls the first one. And your comments are different ways you would like to run it? I would just have one function and call it 3 times (or 21 times).

<SPAN class="comment token"># Define the funtion</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">DistrictFunction</SPAN><SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN>TotalLong<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Calculating Total Line Tickets per District"</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>linefc<SPAN class="punctuation token">,</SPAN> unique_name<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>unique_name<SPAN class="punctuation token">,</SPAN> totalscline <SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NAME"</SPAN><SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Calculate and Join Totals per District Polys</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>polyfc<SPAN class="punctuation token">,</SPAN> unique_name<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>unique_name<SPAN class="punctuation token">,</SPAN> totalscpoly <SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NAME"</SPAN><SPAN class="punctuation token">,</SPAN> totalscpoly<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY_1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> TotalLong<SPAN class="punctuation token">,</SPAN> totalCalc<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>DeleteField_management<SPAN class="punctuation token">(</SPAN>distfc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FREQUENCY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FREQUENCY_1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Call the function 3 times</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; DistrictFunction<SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> TotalLong<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; DistrictFunction<SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscpoly<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> TotalLong<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; DistrictFunction<SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> overDueExpression<SPAN class="punctuation token">,</SPAN> overDueLine<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> OverDueTotal<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; logger<SPAN class="punctuation token">.</SPAN>info<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>message<SPAN class="punctuation token">,</SPAN> exc_info<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">raise</SPAN> e‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

enterprisemaps-gwest

James,

I should have specified 21 times with different parameters each time.

JamesCrandall

The block of code below has within the first function what I would like executed 21 times

Then you would just iterate over 21 times:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">DistrictFunction</SPAN><SPAN class="punctuation token">(</SPAN>DistrictConfig<SPAN class="punctuation token">,</SPAN> distfc<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">,</SPAN> totalscline<SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN>TotalLong<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">21</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Calculating Total Line Tickets per District"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>linefc<SPAN class="punctuation token">,</SPAN> unique_name<SPAN class="punctuation token">,</SPAN> totalexpression<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>unique_name<SPAN class="punctuation token">,</SPAN> totalscline <SPAN class="punctuation token">,</SPAN> statsfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DISTRICT"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">.</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

enterprisemaps-gwest

So Kristen,

When you say that I am not executing the functions, how should my code be

modified so that I can execute the 3rd call of DistrictFunction in my

SummaryStats function?

KristenE

Functions use variables to define parameters (stuff inside the parenthesis that can change each time you call the function). In the above code you are defining your functions, but you are not executing them.

<SPAN class="comment token"># Define function</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">do_something</SPAN><SPAN class="punctuation token">(</SPAN>variable1<SPAN class="punctuation token">,</SPAN> variable2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># do something with variable1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># do something with variable2</SPAN>

<SPAN class="comment token"># Call the function</SPAN>
do_something<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN> y<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Call the function again using different values</SPAN>
do_something<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The first time I called the function ‘x’ was plugged in for variable1 and ‘y’ was plugged in for variable2. The second time I called the function ‘a’ was plugged in for variable1 and ‘b’ was plugged in for variable2.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.