Wednesday, June 29, 2011

Python project

http://docs.python.org/library/csv.html

I'm itching to try and write a quick and dirty program for zipping through an Excel spreadsheet I keep for work stuff and giving me some basis stats. Nothing fancy - it's just a list of support cases where every row is a new case and the first colum is the date I entered it in MM/DD/YYYY format. I was trying to find a module that read in .xlsx files but then discovered that there is a built in CVS reading module. Score. Now I gotta figure out how to extract all the dates and then (for example) count how many entries were made per month (per month that exists - I started this spreadsheet in January of this year).

No comments:

Post a Comment