First Python Project

I did a little programming today which clarified for me the role of colons in Python. Today’s project combined stuff on using the CSV module in Python and stuff from a workshop I went to recently. I had Python take a not-very-long spreadsheet of new faculty members and departments, check it against a list of departments I’m responsible for, and tell me how many new faculty I have to worry about this year. I even figured out how to upload the results to Github if you want to follow along: and related files. Tomorrow I’ll see if I can modify it to give me a list of names and departments, too.

Ultimately I’d like to get Python to analyze two spreadsheets, one with the titles indexed by a scholarly publisher like MLA Bibliography, one with my library’s journal coverage dates–and to create a human-readable report I can share with faculty and students. I’m currently doing this with some ugly, ugly Excel spreadsheets that even I can’t read easily.

I am taking advantage of my almost complete ignorance to force myself to do this one step at a time. Today was frustrating until I started correcting my punctuation.

Published by


Boston area academic librarian and instructional designer. News junkie. Fan of marine mammals, October.