I want to create a ESRI tool using python scrips to:
1) Unzip a txt file that is inside a zipped file.
2) I would like to save the txt as a csv removing the first and last rows (would like to make these part of the name or metadata) the first row is the date created and the last row is file info. The column headder is the second row.
3) There are 2 columns I would like to delete
4)Then I need to change the column headings to remove the spaces and match the fields names as I would like to geocode them.
5) I need to concatenate several fields to create a single address field for the geocode. My address locator that I created uses a single address field with Zip.
6) Geocode the csv with my created Address Locator to my master address point file.
Is this possible?