Jesko

Run any Python script automatically in Google Cloud Platform with Docker, Bash, Scheduler, Pub/Sub, and FunctionShip your apps with dockerized containers (image by Swanson Chan)Have you successfully programmed a Python application locally and now want to bring it to the cloud? This is an easy to follow and exhaustive step by step tutorial on how to turn a Python script into a Docker image and push it to the Google Cloud Registry. In Google Cloud Platform, this Docker image can be called automatically in VertexAI via…

Keep track of your tasks with this ready-to-use Excel/Python Gantt templateTeamwork is everything (Photo by Randy Fath)Background:Project management tools are a dime a dozen. But sometimes simple solutions are enough, especially if they combine Excel VBA with Python, so you don’t have to use a sledgehammer to crack a nut (or spend a fortune). One of the main components of a project management tool is tracking project milestones in terms of their assigned capacities and fulfillment. In addition, the input and evaluation…

Find the shortest route using a genetic algorithmHow to find the shortest route between different places ? (image by author)The so called traveling salesman problem is a very well known challenge. The task is to find the shortest overall route between many destinations: saleswoman visits several stores in succession and returns to the starting point in the overall shortest distance at the end. We are going to implement a genetic algorithm to solve this problem with Python.Background:Imagine a sales person for a golden…

Use smart irrigation in a water-scarce worldBeautiful is better than ugly (Zen of Python, Photo by Linus Mimietz)Nowadays, it is becoming increasingly important to use the vital resource of water sparingly. Inspired by the book “Let there be water” by Seth Siegel and the increased periods of drought in Germany, I set out to find a more sustainable solution for my garden irrigation. Since I am a friend of Python programming, my solution could not consist of a simple rain gauge, but instead had to include a smart socket, an…

Put your FAQ search on steroids with Elasticsearch and GPUPlay it safe with embedded word search with Haystack (Photo by Rutpratheep Nilpechr)In a previous post we created a simple “string match search” to find German/English translations. In a figurative sense, we can also call this translation table a kind of FAQ. FAQ search is said to have the following positive characteristics:very fast at inference timegives good control over answersWhile there is also a downer:generalizability: only questions can be answered that…

Tkinter vs Excel VBASearch easier with autocomplete (Photo by Markus Winkler)User-friendly search masks are almost indispensable in today’s flood of data. In this article we will see how to develop a responsive search for translation purposes using Tkinter and compare it with VBA.Responsive search form (image by author)Background:Our table consists of two columns. The first column contains English terms and the second column the corresponding German translations.An excerpt of the German-English financial terms (image by…