Automating Insights Generation with Python and OpenAI

Strong Correlation Between CO2 Emissions and GDP

The regression results show that the CO2 emissions (kt) are significantly affected by GDP per capita (current US$) and Population, total (p<0.05). The F-statistic is 637.7 and the R-squared is 0.921, indicating a strong correlation between the two variables.

The above title and text were made using a python script that I made. That script retrieves data, conduct statistical analysis on it, summarises the results automatically, and then publishes the summary using the WordPress API. The goal was to use technology to automatically generate insights from data.

Read More

Single Basket Espresso Made Easy: A 3D Printed Solution


As a coffee lover, you often found yourself craving the rich, bold flavour of espresso. However, brewing a single shot of espresso could be a real challenge – the small size of the basket makes it difficult to get the right amount of coffee in without making a mess, and using a regular tamper is nearly impossible. I saw some single dosing funnels online, but I did not know if they would fit and be worth the price.

That’s why I decided to take matters into my own hands and design a special dosing funnel and tamper specifically for the IMS competition single basket*.

Using 3D drawing program Fusion 360 I designed a dosing funnel and tamper that would make it easy to precisely dose and tamp small amounts of coffee.

Read More

ChatGPT is amazing: The Cat’s Pawn

hipstercat

ChatGPT is a artificial intelligence chatbot created by OpenAI. This clever bot was launched in November 2022. People are amazed at how detailed and articulate ChatGPT’s responses are, even though some people say it’s not always 100% accurate. But who cares about facts when you’re having fun chatting with ChatGPT? (This intro is partly written by ChatGPT).

I asked ChatGPT to write a story about a cat that wanted to become a barista.
Read More

Vixen – Nikon DIY Telescope adapter

My girlfriend recently got a present from a friend who is also a wonderful dressmaker. It’s a beautiful Vixen Japanese telescope. Using this vintage telescope and watching the sky is truly a magical experience. It reminds us that we are very small and that we are all part of this giant cosmos.

It’s kind of mind blowing when you think about it. Things we are made of were once made in stars.

This is not meant to be a philosophical post, so let’s get back to the telescope. After looking through the telescope I thought it would be great to make some pictures of the moon. I have no experience whatsoever with telescopes but I though a simple way to do this, would be by using my smartphone. After a few tries this seemed to be a rather difficult task. First, it’s difficult to aim the telescope in the right direction, secondly it is very hard to manoeuvre the phone and get the view focused on the camera sensor. You need to precisely get the focus right, that’s almost impossible in case you have ordinary human hands.

Read More

Colino Coffee Grading Kit


Last week Marko Luther send me the Colino coffee grading kit. The Tonino team consisting of Marko Luther and Paul Holleis developed a system with a full array of sieves for Arabica, Robusta and even peaberry green coffee beans under the name Colino.
Read More

3D printed Compak hopper adapter for Mahlkonig K30 grinder


I recently bought a second hand Mahlkonig K30 Vario grinder. This grinder did not work at all but I got it for only 150 euro. After a thorough inspection I found that one of the essential wires for starting the grinding was loose. Just a little bit of soldering was enough to make this grinder work again. This made me happy but the grinder was still not usable because it lacked a hopper. I searched on the Internet for a replacement but these replacements seemed to be quite expensive. Luckily a friend of mine, Frans Goddijn, still had beautiful spare Compak – Londinium hopper stored in this attic. Frans was generous as ever and gave me the hopper for free. There was however still one problem to be solved.
Read More

TC4 board by Viliam


A few months ago we wanted to order some extra TC4 boards for our roaster. This board is an arduino shield that can handle 4 thermocouples and takes care of precise temperature measurement. During the order process we had a problem. We could not order them anymore from the mlpg-website. All the “order buttons” seemed to be disappeared and mailing them gave no response. But somehow the universe came with a solution. A few weeks ago we got in contact with Viliam from Slovakia.
Read More

Fluid Bed Roaster, new edition 2


Last weekend we tested the Fluid Bed Roaster again. There were several improvements made to the machine. Tije has improved the thermal insulation and housing. Also he improved the internal airflow, this prevents beans from unintentionally ending into the chaff collector. Also some software changes were made. To prevent burn through of the heating coils, the fan now has to get a minimal of 60 percent power. Otherwise the heating element will get no power. To improve roasting performance it would be helpful to use different PID-settings during a roast. Tije tried to implement this, unfortunately this didn’t work. Frans Goddijn contacted Marko Luther, the maker of the more then excellent Artisan roast software. Marko is again very helpful and tries to fix this. Many thanks again for his outstanding help.
Read More

Tiny Fluid Bed Roaster, new edition


Last week we tested the next version of The Fluid Bed Roaster prototype. Tije designed and constructed this new roaster. In the picture above, you can see him charging green coffee beans on the prototype. The roaster has a build in cooling, chaff collector, LCD screen and it uses a more powerful and less noisy blower. Also the roaster has a higher capacity (batch size) than the previous model. I worked on the Arduino TC4 control board and electronics. In this first test we encountered a technical problem. I got a much cheaper relay to drive the blower of the roaster. This relay blew immediately after powering up the device. We will switch back soon to Crydom 2425-10 relay that has proven to work solid in the previous prototype. For speed control we reverted back to manual Variac operation of the blower. The PID settings to control heater intensity also needed some work and Tije has already worked on a heat isolation of the roast chamber. The purpose of this insulation is to make the roaster more energy efficient and make it easier for the roaster to reach a desired finish temperature. Read More

Lasered Coffee Grading Kit


I recently got some Indonesian Mandeling coffee. This green coffee looks like a mess, some are large, lots are small, many are broken and a large number of them have defects. More than 12% of this coffee should not land in your cup of joe. But after proper sorting, this bean can really shine. The problem however is that this sorting is a tedious proces. It takes more than an hour to sort 750 grams of this coffee. Frans Goddijn uses a his own fan and a pan technique for sorting the beans. This is presumably a good and effective method. But because I was looking for my first Laser Cutting project I thought of something else. Read More

Just another Espresso dosing funnel

Here is another espresso funnel that I made. The bottom of the funnel is slightly curved, this creates a tight fit with an espresso basket. Want to try it? Just download the model from Sketchfab. The models doesn’t need to be scaled when printed in PLA. For the best results you need to print it upside down.

P120 Creator review: 3D printing for all

Two months ago I bought my first 3D printer, the PrimaCreator P120. This printer retails for less than 300 euro’s in the Netherlands. This small 3D printer has great looks and fits easily on your desktop. The printer is sold under different names under the world. You can also find it as the Malyan M200 and Monoprice Mini Select. I decided to buy the PrimaCreator P120 because that version was locally available and I wanted a fast shipping and a nearby shop in case of problems.

Read More