Linnart Felkl M.Sc., Author at SCM data

Spatial proximity based clustering of customers

Providing a coding example for how to conduct spatial proximity customer clustering, applicable e.g. when searching for multiple centers of gravity (i.e. when wanting to locate multiple warehouses). The logic and approach is the same as in any kind of distance based […]

Implementing SELECT statements in Python for SQLite3 database

In a previous post on SQLite 3 and Python I added two related tables to a SQLite 3 database, usign Pyhton. The tables are called universitiesTBxx and studentsTBxx. Both tables are stored in a database called “newDatabase.db”. Students are enlisted […]

Adding entries into related SQLite 3 database tables in Python

In a previous post I already demonstarted how one can connect to a SQLite 3 database in Python and how one can create tables in the connected database. I also demonstrate how one can write data into a table created […]

Setting up databases and data tables in SQLite via Python

In this post I will demonstrate how you can create SQL databases powered by SQLite as a database engine in Python. I will be using the sqlite3 engine. The SQLite driver is installed by default through the Python installation itself. […]

Indexing Python dictionaries with tuples

In Python it is possible to index dictionaries with tuples. I made use of this technique in one of my previous posts, covering constraint programming with Google OR-tools in Python. I demonstrate the technique in the coding example below: # […]

Constraint programming for work scheduling with Google OR-Tools

In previous posts I have already introduced Google OR tools for linear programming. In this post I want to demonstrate the capabilities of Google OR tools for constraint programming. More specifically, I will solve a job scheduling problem using constraint […]

Using Altair in Python for visualizing Tesla stock performance

I previous posts I have already introduced seaborn and matplotlib.pyplot for visualization in Python. In this post I want to introduce the altair module. This is an alternative module supporting visualization in Python. The altair module can be installed with […]

Python for AutoCAD (pyautocad module)

In this post I want to introduce a module available in Python for automatizing the creation of drawings in AutoCAD. The module is called pyautocad. It is supported by pip install for easy installation. The pyautocad module will also allow […]

AutoCAD layer walk tool

In this post I will demonstrate the layer walk tool in AutoCAD. In other posts I have introduced basic AutoCAD commands such as AutoCAD LINE, AutoCAD PLINE etc. I have also demonstrated how one can use pyautocad for scripting AutoCAD […]

AutoCAD MLINE command

In this post I will demonstrate the AutoCAD MLINE command for drawing multilines in AutoCAD. I start by entering the MLINE command into AutoCAD. AutoCAD will prompt me for a start point. After having selected the start point AutoCAD will […]

AutoCAD XLINE command

In this post I will demonstrate the AutoCAD XLINE command. In other posts I already demonstrated simple AutoCAD commands such as e.g. AutoCAD LINE, AutoCAD MLINE, AutoCAD CIRCLE, AutoCAD OFFSET and many more. You can create construction lines of infinite […]

AutoCAD RAY command

In this post I will demonstrate rays in AutoCAD, using the AutoCAD RAY command. In other posts I already demonstrated other simple AutoCAD commands, such as e.g. the AutoCAD PLINE command. Rays or ray lines are linear objects that have […]

AutoCAD INTERSECT, SUBTRACT and UNION commands

In this post I will demonstrate three AutoCAD commands related to AutoCAD regions: INTERSECT, SUBTRACT and UNION. In a previous post I introduced the AutoCAD region command. I have also already introduced other basic AutoCAD commands, such as e.g. AutoCAD […]

AutoCAD REGION command

The AutoCAD REGION command allows you to convert objects into regions. I provide a basic introduction in this post. I have already introduced other basic AutoCAD commands in other post (e.g. AutoCAD PLINE, AutoCAD SPLINE etc.). Below I trigger the […]

AutoCAD SPLINE command

In this post I want to introduce the SPLINE command in AutoCAD. In other posts I have already introduced other important objects and commands in AutoCAD, such as e.g. AutoCAD XLINE, AutoCAD PLINE, AutoCAD POLYGON etc. A spline is curved […]

Older Posts

Linnart Felkl M.Sc.

Meta