Published in Towards Data Science·Dec 12, 2022Member-onlyBuild a Docker Image for Jupyter Notebooks and run on Cloud’s VertexAIRun any Python script automatically in Google Cloud Platform with Docker, Bash, Scheduler, Pub/Sub, and Function — 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…Vertex AI12 min readVertex AI12 min read
Published in Towards Data Science·Oct 21, 2022Member-onlyProject management the right wayKeep track of your tasks with this ready-to-use Excel/Python Gantt template — 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…Excel Vba Course9 min readExcel Vba Course9 min read
Published in Towards Data Science·Oct 12, 2022Member-onlyTraveling salesman problemFind the shortest route using a genetic algorithm — 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. …Python7 min readPython7 min read
Published in Towards Data Science·May 30, 2022Member-onlyEvery drop countsUse smart irrigation in a water-scarce world — 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…Openweathermap6 min readOpenweathermap6 min read
Published in Towards Data Science·May 25, 2022Member-onlyHigh scalable fast search with HaystackPut your FAQ search on steroids with Elasticsearch and GPU — 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 time gives good control over answers …Haystack5 min readHaystack5 min read
Published in Towards Data Science·May 25, 2022Member-onlyCreating autocomplete search formsTkinter vs Excel VBA — 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.Tkinter5 min readTkinter5 min read
Published in Towards Data Science·May 5, 2022Member-onlySudoku smashing solutionExhaustive Sudoku solving bot tutorial: Image and optical character recognition plus text to speech — In a previous article we created a bot called Isaac (inteligible solution for administrative and analytical communication). In this post we will teach Isaac how to play Sudoku. Isaac will receive eyes to see, hands to write and a mouth to speak. …Image Recognition6 min readImage Recognition6 min read
Published in Towards Data Science·Mar 24, 2022Member-onlyDepreciation anomaly detectionApplied statistical process control on financial write-downs — Depreciation refers to an accounting method used to allocate the cost of a tangible or physical asset over its useful life. In this post the value of an asset used is amounted monthly per profit and cost center. Accounting for depreciation can greatly affect one’s profits. That’s why it is…Statistical Process4 min readStatistical Process4 min read
Published in Towards Data Science·Mar 21, 2022Member-onlySAP Querying Intelligent RobotExtracting SAP’s tables automatically with SQUIR — Are you frequently running SE16N transaction to extract tables out of SAP? If you want to automate this, here you’ll find the solution. Squir (SAP querying intelligent robot) is a standalone application. The programme is made of Python, an Excel template for parameter selection, and screenshots which the bot needs…Pyinstaller4 min readPyinstaller4 min read
Published in Towards Data Science·Mar 8, 2022Member-onlyPush your sales with statistical process controlAre quality control charts an underestimated concept of sales analysis? — One sub field of statistics is statistical process control (SPC). SPC is hardly ever mentioned in any books about data science. Top of that SPC is scarcely used with sales data. I believe that SPC is misprized in this analytical conception. Actually SPC can be a much supportive supplement for…Python12 min readPython12 min read
