October 29th, 2004 | by Derek | published in Python
Format database field names in Excel: “Often I get data to import in MS Excel files, and the column headers are not very useful for column names. They contain spaces, punctuation, and special characters that make a simple import difficult.
This script opens the file in Excel, and applies some simple formatting rules to the first [...]
October 8th, 2004 | by Derek | published in Python, XML
The latest version of my Python script that scrapes the FEC’s press release page and creates an RSS feed fixes two previous errors, one big and one small.
October 2nd, 2004 | by Derek | published in Python, XML
I’ve updated my Python script that creates an RSS feed by scraping the FEC’s page of news releases, due to a redesign of the FEC site.
September 15th, 2004 | by Derek | published in Car Tools, Python
Wow, this looks useful: “XML to DDL is a set of Python programs to convert an XML representation of a database into a set of DDL (Data Definition Language) statements.” Supports PostgreSQL, MySQL and Firebird.
July 13th, 2004 | by Derek | published in Python, XML
Just a small change to my script that makes an RSS feed from the Federal Election Commission’s releases: instead of grabbing just the press releases, it grabs the first 10 items from the entire “What’s New” section of the homepage.