New Blog Post

Books about Artificial Intelligence & Data Science

Foundation Annotated Turing Statistics For Dummies The Practically Cheating Statistics Handbook Artificial Intelligence: A Modern Appoach Prediction & Data Science The Signal and the Noise: The Art and Science of Prediction The Elements of Statistical Learning: Data Mining, Inference, and Prediction Philosophical Hello World: How to be Human in the Age of the Machine The…

Getting the file extension from a file path in Python

Determine the file extension os.path.splitext() is used to split the path name into a pair root and ext. e.g. C:\Users\memyselfandi\projects\file_extension_test\data.csv is split into C:\Users\memyselfandi\projects\file_extension_test\data and .csv Here is a working snippet for identifying CSV and XLS: import os if os.path.isfile(input_file): file_extension = os.path.splitext(input_file)[1].lower() if file_extension == “.csv”: logger.info(“It’s a CSV”) # do something with CSV…

SQL-Tutorial

I really like SQL. But sometimes I struggle to undestand some of the concepts. So I write about it. Meanwhile there are a bunch of articles, so time for a overview page: SQL-Basics: Create, Read, Update & Delete SQL-Basics: Relations SQL-Functions – SQL-Basics 3 SQLite3: Python and SQL Subqueries: Update column with values from another…

My book writing workflow

In this article I want to give you a short overview of my book writing process which I use in my current project “Level Up!” Content Overview For planning purposes I use Google Docs. Everything is tracked in a spreadsheet. I use task based planning.

Developer Toolbelt – private edition

Inspired by the Blog Post https://gingter.org/2016/12/15/my-developers-toolbelt-2016 I want to share what my tool set looks like in 2022: PyCharm as main IDE for Python and markdown pandoc for converting markdown to PDF Android Studio Github (now with private repo support) Guitar Pro Version 7.5 (Thomann Affiliate Link) Logic Pro X Spotify for getting into “the…

Bullet Journal

Nothing changed my life so drastically in the last couple of years like the Bullet Journal Method. Fumbling with to-do lists, habit tracking apps, a Kanban board in the kitchen, a google docs spreadsheet for goals and a mood journal I grew tired of not having one single source of truth regarding my life planning.…

How to connect to your ESP32 on macos

To find out as what USB device the ESP32 is connected, open Terminal and enter: ls /dev/tty* | grep usb in my case I got /dev/tty.usbserial-14120 Now we can connect via screen: screen /dev/tty.usbserial-14120 115200 When you reset the board you should see something like this configsip: 0, SPIWP:0xee clk_drv:0x00,q_drv:0x00,d_drv:0x00,cs0_drv:0x00,hd_drv:0x00,wp_drv:0x00 mode:DIO, clock div:2 load:0x3fff0030,len:5656 load:0x40078000,len:12696…