Optimise the allocation of work using PuLP, a linear programming library in Python.

Image for post
Image for post
Photo by Eric Rothermel on Unsplash


For large operations, the allocation of work can be a sizeable daily task. For this article i am going to focus on using PuLP to create a model to allocate work. It's possible to automate this process using VBA in Excel, however, this would be a ‘greedy’ approach finding the optimal route for each individual driver but not for the entire allocation so it would not be as effective.

Excel does have a solver that can solve linear and non-linear problems, but this is limited to 200 decision variables and for large operations this solution would be feasible. …

Capstone Project for Udacity’s Data Scientist Nanodegree.

Image for post
Image for post


This project is my Capstone Challenge for Udacity’s Data Scientist Nanodegree. The project is in collaboration with Starbucks where we were given simulated data that mimics customer behavior on the Starbucks rewards app. The offer could be purely informational or it could include a discount such as BOGO (buy one get one free).

From the data we received, it appears that Starbucks sent 10 different offers to its customers via a variety of different channels.

For this project, we received 3 datasets —

  1. Portfolio — dataset describing the characteristics of each offer type, including its offer type, difficulty, and duration. …

Descriptive analysis of what guests value most

Image for post
Image for post


Since 2008, guests and hosts have been using Airbnb to travel in more unique and personalized ways. I wanted to find out what Airbnb travelers really look for when booking to try and help hosts make their listings more appealing to potential guests.

In this article, I used the publically available dataset on Kaggle — which describes the listing activity of homestays in Seattle, WA.


In this post, I will try to answer the following questions:

  • Does it help to be an Airbnb Superhost?
  • What do guests think about the cleaning fee?
  • Does the type of property affect the price? …


John Abel

Recent Chemistry graduate from the University of Nottingham.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store