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