Motivation Out of curiosity I bought a ESP32 board to tinker with, but for almost half a year hadn’t got an idea what to do with it… But then! Project Idea The idea: Every time I get mail into my physical snail mail mailbox, the mailbox shall send a message via Telegram to my smartphone:…
Everything we did in the last articles of the series SQL-Tutorial was a dry run because we just used SQLFiddle. So let’s start with a real database like SQLite. SQLite is a file based DBRMS and can be used for e.g. web sites. The official docs say: “SQLite works great as the database engine for…
After laying the foundation in Introduction to matplotlib and Introduction to matplotlib – Part 2 I want to show you another important chart Bar Charts A bar chart is useful to show total values over time e.g. the revenue of a company. years = (2017, 2018, 2019) revenue = (5000, 7000, 9000) plt.bar(years, revenue, width=0.35)…
# import and instantiate model from sklearn.linear_model import LinearRegression model = LinearRegression() #prepare test data features_train = df_train.loc[:, ‘feature_name’] target_train = df_train.loc[:, ‘target_name’] #fit (train) model and print coefficient and intercept model.fit(features_train , target_train ) print(model.coef_) print(model.intercept_) # calculate model quality from sklearn.metrics import mean_squared_error from sklearn.metrics import r2_score target_prediction = model.predict(features_train) print(mean_squared_error(target_train , target_prediction))…
At PyConDE Berlin 2019 Florian Bruhin gave a really nice session about testing with pytest, which I try to recap here. Writing Tests If You want to work with pytest you can install it via: pip install pytest When you know basic python unittest fixtures, good news ahead: pytest is compatible and will run your…
Sessions 110 Sldies from Sascha Pallenberg Working out loud Creativity Techniques “Quantity beats Quality” 6-3-5 Methode 6 People – 3 ideas each – 5 times pass around Worldcafe Lessons Learned in Apprenticeship Impressions
Climate change, you know the drill. Believing in the 1% improvement thing / atomic habits I would start small but consistent. And also believing in the Management 3.0 experimenting culture I would run experiments. Some ideas: Household Switch to green electricity Buy more used / second hand stuff Especially books and furnitures https://www.afbshop.de/ https://www.gwv-shop.de/ https://www.medimops.de/…
This article is part of my SQL-Tutorial Motivation Sometimes you need to retrieve data from a database without knowing the exact string to look up so wildcards for the rescue Underscore Se_en represents a pattern with a wildcard character. The _ means you can substitute any individual character here without breaking the pattern. It matches…
This is part 3 of the 5 part series 15 Steps for successful Bootstrapping USP, USP, USP USP means “unique selling proposition”, which makes it even better than the German word USP. It’s all about “selling”, so selling. That means your unique selling point must also make the customer buy something. What sets you apart…
My Tale of Woe When I graduated from university and had my first job as a software engineer at Harman Becker Automotive Systems GmbH I should do the parental leave cover for a colleague. He showed me his project, gave me some info e.g. contact person and went off to Canada. Literally on the second…