Andrew Cooke | Contents | Latest | RSS | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Choochoo Training Diary

Last 100 entries

Surprise Paradox; [Books] Good Author List; [Computing] Efficient queries with grouping in Postgres; [Computing] Automatic Wake (Linux); [Computing] AWS CDK Aspects in Go; [Bike] Adidas Gravel Shoes; [Computing, Horror] Biological Chips; [Books] Weird Lit Recs; [Covid] Extended SIR Models; [Art] York-based Printmaker; [Physics] Quantum Transitions are not Instantaneous; [Computing] AI and Drum Machines; [Computing] Probabilities, Stopping Times, Martingales; bpftrace Intro Article; [Computing] Starlab Systems - Linux Laptops; [Computing] Extended Berkeley Packet Filter; [Green] Mainspring Linear Generator; Better Approach; Rummikub Solver; Chilean Poetry; Felicitations - Empowerment Grant; [Bike] Fixing Spyre Brakes (That Need Constant Adjustment); [Computing, Music] Raspberry Pi Media (Audio) Streamer; [Computing] Amazing Hack To Embed DSL In Python; [Bike] Ruta Del Condor (El Alfalfal); [Bike] Estimating Power On Climbs; [Computing] Applying Azure B2C Authentication To Function Apps; [Bike] Gearing On The Back Of An Envelope; [Computing] Okular and Postscript in OpenSuse; There's a fix!; [Computing] Fail2Ban on OpenSuse Leap 15.3 (NFTables); [Cycling, Computing] Power Calculation and Brakes; [Hardware, Computing] Amazing Pockit Computer; Bullying; How I Am - 3 Years Post Accident, 8+ Years With MS; [USA Politics] In America's Uncivil War Republicans Are The Aggressors; [Programming] Selenium and Python; Better Walking Data; [Bike] How Fast Before Walking More Efficient Than Cycling?; [COVID] Coronavirus And Cycling; [Programming] Docker on OpenSuse; Cadence v Speed; [Bike] Gearing For Real Cyclists; [Programming] React plotting - visx; [Programming] React Leaflet; AliExpress Independent Sellers; Applebaum - Twilight of Democracy; [Politics] Back + US Elections; [Programming,Exercise] Simple Timer Script; [News] 2019: The year revolt went global; [Politics] The world's most-surveilled cities; [Bike] Hope Freehub; [Restaurant] Mama Chau's (Chinese, Providencia); [Politics] Brexit Podcast; [Diary] Pneumonia; [Politics] Britain's Reichstag Fire moment; install cairo; [Programming] GCC Sanitizer Flags; [GPU, Programming] Per-Thread Program Counters; My Bike Accident - Looking Back One Year; [Python] Geographic heights are incredibly easy!; [Cooking] Cookie Recipe; Efficient, Simple, Directed Maximisation of Noisy Function; And for argparse; Bash Completion in Python; [Computing] Configuring Github Jekyll Locally; [Maths, Link] The Napkin Project; You can Masquerade in Firewalld; [Bike] Servicing Budget (Spring) Forks; [Crypto] CIA Internet Comms Failure; [Python] Cute Rate Limiting API; [Causality] Judea Pearl Lecture; [Security, Computing] Chinese Hardware Hack Of Supermicro Boards; SQLAlchemy Joined Table Inheritance and Delete Cascade; [Translation] The Club; [Computing] Super Potato Bruh; [Computing] Extending Jupyter; Further HRM Details; [Computing, Bike] Activities in ch2; [Books, Link] Modern Japanese Lit; What ended up there; [Link, Book] Logic Book; Update - Garmin Express / Connect; Garmin Forerunner 35 v 230; [Link, Politics, Internet] Government Trolls; [Link, Politics] Why identity politics benefits the right more than the left; SSH Forwarding; A Specification For Repeating Events; A Fight for the Soul of Science; [Science, Book, Link] Lost In Math; OpenSuse Leap 15 Network Fixes; Update; [Book] Galileo's Middle Finger; [Bike] Chinese Carbon Rims; [Bike] Servicing Shimano XT Front Hub HB-M8010; [Bike] Aliexpress Cycling Tops; [Computing] Change to ssh handling of multiple identities?; [Bike] Endura Hummvee Lite II; [Computing] Marble Based Logic; [Link, Politics] Sanity Check For Nuclear Launch; [Link, Science] Entropy and Life

© 2006-2017 Andrew Cooke (site) / post authors (content).

Mixed Integer Programming in Python

From: andrew cooke <andrew@...>

Date: Mon, 29 Aug 2011 17:22:25 -0300

The weather in NY has left me with a free afternoon at work, so I have been
looking at mixed integer programming (this is not completely self-indulgent -
it's related to compressive sensing, which we might use).

My motivating example was this question on Stack Overflow -
http://stackoverflow.com/questions/7076349/is-there-a-good-way-to-do-this-type-of-mining

These notes describe largely separate (because I didn't get very far) aspects:
describing that particular problem and Python libraries.


Python Libraries

It seems that mixed integer and linear programming are not, in general, well
supported by open source projects.  See, for example, the comparison of
running times for commercial and open source solutions here:
http://scip.zib.de/

Support in Python reflects that.  My initial candidate was pulp-or
http://code.google.com/p/pulp-or/ but many links there are dead (with ominous
notes about a "transition").  So then I turned to Coopr
https://software.sandia.gov/trac/coopr which, from the text there, may be what
pulp-or is combining with.  However, the documentation was both minimal and
aimed at experts - I really need something more introductory.

At this point I started looking for an implementation in any language, and
identified SCIP http://scip.zib.de/ (as mentioned earlier) as one of the most
active and efficient.  And - a rare positive moment within this work - it has
a Python 3.2 library that looks very nice
http://code.google.com/p/python-zibopt/ although the installation instructions
suggest things are still rather alpha
http://code.google.com/p/python-zibopt/wiki/Installation


Framing the Problem

At first I assumed that the clustering problem described above would be easy
to solve.  But all my initial approaches contained variable numbers of
variables.  This can be avoided, to some extent, by using control variables,
which are binary flags that indicate whether some other variable is used or
not, but the next problem was how to express various constraints as linear
expressions.

I still don't have a perfect solution, but here are some notes to remind me of
how far I have got:

 - By default, every point is in the vertical group for that column.
 - We want to minimise the number of vertical groups, while also minimising
   "gaps" in horizontal groups.
 - Each point has a vertical (1) / horizontal (0) control variable.  The sum
   of these is one contribution to the final weight.
 - Each point has an additional variable which is the horizontal group
   number.  Originally these start at 0 (left) and increment across the row.
 - The sum of the rightmost group number on each row is also minimised.
   This reduces the number of groups.
 - There is a constraint that each successive group number from left to
   right must be the same as the neighbour to the left, or one more.
 - Finally, there is a complex weight that depends on the number of 
   horizontal "gaps" between two points when they have the same group 
   number.  I think this can be generated programmatically, but it's a bit
   complex (especially since it must be ignored when groups are vertical).
   This weight should also be minimised.

Writing that down, it doesn't seem very impressive, but it was a lot of
work... :o(

Andrew

Non-Comemrcial

From: andrew cooke <andrew@...>

Date: Mon, 29 Aug 2011 19:01:52 -0300

The SCIP and related code is non-commercial only.

Andrew

lp_solve

From: andrew cooke <andrew@...>

Date: Mon, 29 Aug 2011 19:40:46 -0300

OK, so it seems like the best-supported (but not fastest or ost advanced)
package is lp_solve, and it also has some kind of python interface.

http://lpsolve.sourceforge.net/

Andrew

Comment on this post