Monthly Archives: November 2008

Python, Subversion, and revision diffs

One of my hobbies is working as an amateur translator for scripts (of the textual kind) and assorted short stories. Since I move around to different machines often, it just makes sense to put everything on subversion. Of course, when … Continue reading

Posted in Uncategorized | Leave a comment

Types of Data

There are four types of data, or levels of measurement, that show up in databases.  Everything that goes into the database or shows up on a survey corresponds to one of these levels, from address fields to income.  It is … Continue reading

Posted in Uncategorized | Leave a comment

Arrays in Python

One of the first hurdles with doing data process in python is the format of the data. Our data naturally exists in rows and matrixes, but Python generally only allows us to work with one variable at a time. We … Continue reading

Posted in Uncategorized | Leave a comment

Pulling data from Excel using Python, COM

Previously, I had a quick overview of extracting data from Excel files using the python xlrd module. While that’s the recommended way of extracting data that you need from Excel data files you receive, it’s not the way to make … Continue reading

Posted in Uncategorized | Leave a comment

Working with named Excel ranges with Python/VBA code

Named ranges are useful things, especially for writing formulas that need to refer to the same block of cells constantly. You can easily set them by hand just by selecting the range you’re interested in, and then clicking the box … Continue reading

Posted in Uncategorized | Leave a comment

Closing Excel using Python

Closing Excel from Python using COM seems pretty simple, but there’s a few little caveats to remember. Subscribe to the comments on this post

Posted in Uncategorized | Leave a comment

R1C1, the unused Excel cell reference system

Everyone knows about the “A1 style” notation for referring to cells in Excel. It’s what the labels on the edges of the worksheet are after all, and it’s the most natural thing to work with if you’re using the standard … Continue reading

Posted in Uncategorized | Leave a comment