topic Re: Incorporate one variable into another in ArcPy Script in Python Questions

Incorporate one variable into another in ArcPy Script

MeredithGreen — Fri, 12 Jun 2015 12:44:09 GMT

I am trying to take a bunch of text files and export them to a workspace geodatabase and then take the new tables and do a summary stats calculation and export that out as a new table that is whatever the loss table is plus summ at the end. Script is below. What exactly is the best way to do this with a variable? Any help would be greatly appreciated.

for file in arcpy.ListFiles("*.txt"):

loss_table = os.path.join(output_workspace, str(file[:-4]))

summary = os.path.join(output_workspace, str(loss_table + "summ"))

arcpy.TableToGeodatabase_conversion(file, output_workspace)

arcpy.Statistics_analysis(loss_table, summary, stats, "CensusBlock")

Re: Incorporate one variable into another in ArcPy Script

SepheFox — Fri, 12 Jun 2015 12:53:03 GMT

Hi Meredith, Right now, you're joining your output workspace path to the summary path twice. Try just removing the output workspace from summary. I'm assuming, of course, that you have your other variables, such as output_workspace and stats, defined in a different part of the script.

Re: Incorporate one variable into another in ArcPy Script

MeredithGreen — Fri, 12 Jun 2015 13:18:05 GMT

It worked! Output workspace and stats are defined elsewhere. So the new script is shown as this instead:

for file in arcpy.ListFiles("*.txt"):

loss_table = os.path.join(output_workspace, str(file[:-4]))

summary = (str(loss_table + "summ"))

arcpy.TableToGeodatabase_conversion(file, output_workspace)

arcpy.Statistics_analysis(loss_table, summary, stats, "CensusBlock")

Thanks so much for the tip!

Re: Incorporate one variable into another in ArcPy Script

SepheFox — Fri, 12 Jun 2015 13:20:31 GMT

You are very welcome. I'm just happy I could actually solve a python problem--a fairly rare event!

Re: Incorporate one variable into another in ArcPy Script

curtvprice — Sat, 11 Dec 2021 20:23:58 GMT

Meredith, here are few suggested improvements:

1. Use os.path.splitext() to get the filename without the extension (safer)

2. Use .format() instead of appending strings (easier to read and debug)

3. Use CopyRows instead of TableToGeodatabase (this gives you more control over what the output is named)

for file in arcpy.ListFiles("*.txt"):
    loss_table = os.path.join(output_workspace, os.path.splitext(file)[0])
    summary = "{}summ".format(loss_table)
    arcpy.CopyRows_management(file, loss_table)
    arcpy.Statistics_analysis(loss_table, summary, stats, "CensusBlock")