Load password protected Excel files into Pandas DataFrame
When trying to read an Excel file into a Pandas DataFrame gives you the following error, the issue might be that you are dealing with a password protected Ex...
Recent Posts
Bokeh plots with Flask and AJAX
Tutorial on creating Bokeh plots with an AJAX data source, served from an existing Flask app.
The basics of Logarithms – with examples
Logarithms are widely used in computer science (e.g. for algorithm analyses, floating point number limitations, scaling data, feature transformations). Not c...
Using vi commands in your bash shell
Entering a long shell command and then moving the cursor around to correct parts of it always felt a bit clunky to me. I remembered some of the <ctrl>/...
Count elementwise matches for two NumPy arrays
Let’s say we have two integer NumPy arrays and want to count the number of elementwise matches.
Basic understanding of IPv4 addresses
In a recent project I needed to anonymize IP addresses in tracking data. While masking a few bits from an IP address is not so interesting, it’s a good excus...
A few updates
After having neglected my blog over the last few months, I want to start posting more frequently again (New Year’s resolutions and all that).
VPN: Temporarily solve same subnet conflicts
I recently had the problem of needing to establish a connection to a server behind a VPN that was in the same subnet as the network I was connecting from. Ev...
Running Flask on macOS with mod_wsgi/wsgi-express
Tutorial on setting up your Flask application to run on macOS with WSGI
SQL: Get the count of related records
Micro tutorial: SQL select the count of related records and sort by it.