Learning Python with Inventory Assessment

I’ve used python before but only for small things. String formatting, Comma Separated Values processing, and basic things like that.

We have an in-house homemade robotics inventory system where we need to go through the improvement of efficiency. (We want to limit the movements of one of the robots in the system.)

I wanted to be able to take a look at a heatmap of all the inventory system in order to take a look at how spread out the system was.

I started to look at python for libraries pertaining to heatmap’s and data collection.

The idea behind the venture was that we have a series of Tray’s with X Number of Parts in said Trays, with the potential that parts were spread across multiple trays.

A basic representation for this would be { TRAY: 1, PART: ASDF => n}

What this says is that Tray 1 has n number of part ASDF.

Here’s a sample of a query

SELECT TRAY, PART, COUNT(*) as MANY_PARTS FROM STORAGE group by TRAY, PART

Leave a Reply