Python [EN] Archives

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 […]

Building efficient freight & trucking stock portfolios in Python

In previous posts I have demonstrated how you can query stock price data with e.g. pandas_datareader in Python. In this post I will present an algorithm with which you can construct an efficient portfolio based on any set of stocks […]

Analyzing UPS and FedEx stock returns with pandas datareader in Python

I have already demonstrated how you can retrieve e.g. GDP data from FRED using pandas_datareader in Python. I have also analyzed stock prices for Procter & Gamble using Yahoo Finance as a source and pulling the data via pandas_datareader. In […]

Linear integer programming with Google ortools in Python

In a several other posts on Google’s ortools module in Python I have already solved the linear optimization problem stated below. The problem is a continuous problem as all optimization variables are from a continuous solution space. I could think […]

Python [EN]

Implementing SELECT statements in Python for SQLite3 database

Setting up databases and data tables in SQLite via Python

Indexing Python dictionaries with tuples

Constraint programming for work scheduling with Google OR-Tools

Using Altair in Python for visualizing Tesla stock performance

Python for AutoCAD (pyautocad module)

Building efficient freight & trucking stock portfolios in Python

Analyzing UPS and FedEx stock returns with pandas datareader in Python

Linear integer programming with Google ortools in Python

Lean coding of simple linear optimization ortools models in Python

Simple linear programming with Google ortools in Python

Pandas datareader for FRED quarterly GDP data queries in Python

Pandas_datareader for Yahoo stock price queries in Python

Monte-carlo simulation of stock prices (using Python)

Meta