An interesting question came about a few days ago. While I have been discussing ESRI’s geoprocessor and how one can use it effectively, I failed to define what geoprocessing is,, either within the ESRI realm or the general GIS realm. In short, geoprocessing is an operation performed on geographic (spatial) data. In other words, it is when one uses data to perform some operations and receiving results. An example would be geocoding. The user provides spatial data (an address), which we geoprocess to identify the output (latitude and longitude). In the ArcGIS world, there are a few methods for geoprocessing: running commands from the ArcToolbox, the Model Builder, the command line and Python scripting (the one I focus on mostly in this blog).
Continue reading »
Mar 16
Jun 17
Writing Excel files using Python is quite easy, using the xlwt package. Similar to xlrd mentioned in an earlier post, xlwt allows one to write Excel files from scratch using Python. Continue reading »
Jun 15
It is often the case that the freely available data online are in Excel format. If one has Excel, then one has the ability to do some sort of basic manipulation of the files. But if Excel is not available, or your analysis software does not read Excel files, there is another way: use Python to manipulate Excel files. Continue reading »
