topic Re: Statistics_analysis fails in Python Questions

Statistics_analysis fails

ChristopherJursa — Fri, 11 Mar 2011 12:49:42 GMT

Hello

I am trying to execute Statistics_analysis from a python script. However, it fails when I run it. I exported this from a ModelBuilder from where it runs fine.

import arcpy

# Local variables:
myShpFile = "C:\\temp\\stats\\forms\\outputDir\\0arbuckle\\intersect_1.shp"
stats_dbf = "C:\\temp\\stats\\waters\\stats.dbf"

# Process: Summary Statistics
arcpy.Statistics_analysis(myShpFile, stats_dbf, "field1 MIN;field1 MEAN;field1 MAX;field1 RANGE;field1 STD;field2 MIN;field2 MEAN;field2 MAX;field2 STD;field2 RANGE")

However, the execute python script gives me the following error.

Traceback (most recent call last):
File "stats.py", line 19, in <module>

File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\analysis.py", line
910, in Statistics
raise e
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000840: The value is not a String.
ERROR 000840: The value is not a String.
Failed to execute (Statistics).

What is wrong with my script?

Re: Statistics_analysis fails

ChrisMathers — Fri, 11 Mar 2011 16:37:43 GMT

Try running the tool outside of a model or script. Go to the results window and right click on the results and select "copy as python snippit." Paste this into IDLE or whatever and compare. Exports from model builder sometimes wonk out like this.

Re: Statistics_analysis fails

ChristopherJursa — Fri, 11 Mar 2011 17:03:47 GMT

Try running the tool outside of a model or script. Go to the results window and right click on the results and select "copy as python snippit." Paste this into IDLE or whatever and compare. Exports from model builder sometimes wonk out like this.

What results window are you referring?

Re: Statistics_analysis fails

ChrisMathers — Fri, 11 Mar 2011 18:34:02 GMT

In Map or Catalog, on the geoprocessing menu there is a results option. Clicking it will open up a new pane that has previously run tools in it.

Re: Statistics_analysis fails

ChristopherJursa — Mon, 14 Mar 2011 12:24:08 GMT

To use this I apparently have to create a front end interface.

When I copy as Python snippet it only gives me the python interface call like arcpy.("", "").

It does not give me the python statistical invocation.

Re: Statistics_analysis fails

ChrisMathers — Mon, 14 Mar 2011 12:58:47 GMT

I dont know why it isnt giving you the syntax when you do the snippit copy thing. Thats how many of us get complex syntax without having to type it all out by hand. I think one thing may be the way that model builder formatted your tool. It may have given you the syntax for 9.3.x instead of 10.x. Now the fields and stat type are strings in nested lists.
Try:
arcpy.Statistics_analysis(myShpFile, stats_dbf, [["field1","MIN"],["field1","MEAN"],["field1","MAX"],["field1","RANGE"],["field1","STD"],["field2","MIN"],["field2","MEAN"],["field2","MAX"],["field2","STD"],["field2","RANGE"]])

Re: Statistics_analysis fails

ChristopherJursa — Mon, 14 Mar 2011 13:00:45 GMT

I dont know why it isnt giving you the syntax when you do the snippit copy thing. Thats how many of us get complex syntax without having to type it all out by hand. I think one thing may be the way that model builder formatted your tool. It may have given you the syntax for 9.3.x instead of 10.x. Now the fields and stat type are strings in nested lists.
Try:
arcpy.Statistics_analysis(myShpFile, stats_dbf, [["field1","MIN"],["field1","MEAN"],["field1","MAX"],["field1","RANGE"],["field1","STD"],["field2","MIN"],["field2","MEAN"],["field2","MAX"],["field2","STD"],["field2","RANGE"]])

You must have posted this right when I got the answer myself. The help system had this syntax and it worked. Thanks!

To do the code snippet procedure you mentioned, do I need to have an interaface on the tool or could I just build a mode without an interface?

Re: Statistics_analysis fails

ChrisMathers — Mon, 14 Mar 2011 13:18:38 GMT

The code snippit would be for the stat tool specifically. Run Summary Statistics only and then copy its syntax.