This is an overview of most common numerical optimization problems. Some definitions are accompanied with usage example from OpenOpt framework, and, maybe, with some more info; some others have no OpenOpt-connected solvers yet. If your needs are beyond the solvers currently present in OpenOpt, you could take into account that some commercial solvers (e.g. mosek, CPLEX, GuRoBi) have their own Python API.
You can view the set of OpenOpt problems along with lists of solvers and usage samples in a little bit classified representation: