retrieve raster statistics and export to an .xls

HeatherHook

I need to retrieve minimum, maximum, mean, and standard deviation statistical values from a directory of raster files and store the values in an excel spreadsheet. 

My approach as been cursors and GetRasterProperties_management. 

Any insight would be greatly appreciated. 

Anonymous User

I did something similar the other day. Instead of keeping it all inside GIS, I did a standalone script and exported from the script to a .txt file, which I then imported in Excel.

The iterating and printing part of the script looks like this:

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import arcpy, os, sys, string, glob

arcpy.env.overwriteOutput = True

shpWS = "E:\MidlGIS\I7010"

arcpy.env.workspace = shpWS

shplist = arcpy.ListFeatureClasses()  

print (len(shplist))

for fc in shplist:
 count = arcpy.GetCount_management(fc)
 ord = fc
 ord = ord[6:]
 ord = ord[:-4]
 print fc[1:5]+"____"+ ord +'____'+str(count)