Category Archives: Python

Prototyping PL/Python functions

I’ve seen a variable called numerical intensity crop up in a couple of papers recently (one example is Lundholm, Rogo, and Zhang (2014)). I spent a little time coming up with a Python program to extract numbers from text. Once … Continue reading

Posted in PostgreSQL, Python | Tagged , , , , | Leave a comment

Using JSON to pass dictionaries from Python to PostgreSQL and back

To my (very untrained) eyes, JSON looks like Python dictionaries. I’d wondered if one could use JSON to pass around Python dictionaries. Turns out that it works quite well. Task Get the top N words from passages of text (conference … Continue reading

Posted in PostgreSQL, Python | Tagged , , , , | 1 Comment

Installing Python

I use MacPorts to install my basic python set-up as follows: Then it’s just a matter of typing:

Posted in Mac, Python | Tagged | Leave a comment