Adding an “Export to Excel” Option in Fiddler

Fiddler (HTTP proxy for Windows) is a valuable tool for finding out what is happening in an external environment (e.g. when a client uses IE). It’s sometimes helpful to pull it’s data into Excel – this allows you to highlight dramatic deviations. The scripting API allows you to do this – drop the following code […]

Rendering scikit Decision Trees in D3.js

Scikit-learn provides routines to export decision trees to a format called Graphviz, although typically this is used to provide an image of a chart. For some applications this is valuable, but if the product of machine learning is a the ability to generate models (rather than predictions), it would be preferable to provide interactive models. […]

Indexing the filesystem with SqlAlchemy and Postgres

In attempt to understand how SqlAlchemy works, I’ve written up a sample indexing a large folder hierarchy. This loops over each file in a structure (there are several million files here – it’s a small subset of court cases from PACER). First, connect to the postgres database- before running this you want to install Anaconda, […]

Hacking Customer Service with Python

Customer support questions come in many forms, some of which are difficult to answer: Why does this screen show different results than it did a week ago? Why does screen A show ten records when screen B shows five? And, a favorite, what don’t you know about this problem? Answering these questions in a satisfactory […]

Tuning Postgres Queries

I have an application ported from using Oracle to Postgres – tuning queries is quite different between the two. While I know many of the Postgres devs have detailed blogs, I haven’t found many practical articles on the subject, so I’m writing up what I’ve found. I appreciate any further comments or resources people may […]