For the ones interested: these are all the ways the organization "Raad Van State" and its legal id where spelled in the EU Tender data, for a very limited subset of data (50ish procedures).
ted.europa.eu/en/
Screenshot that shows 6 objects called a variation of "Raad van State" having an id that is a variation of "0931.814.266".
Haters gonna hate but I love wild data. It just doesn't hit the same after all the little human footprints are scrubbed clean #databs
Hit my goal early this year 🌟
(and made a chart of course #databs)
Ending a busy weekend with solving days 5, 6 and 7 in one sitting. Only 5 days left of unconventional SQL fun 😊
When you picked the right programming language for day 5 😄
Day 4 was definitely a lot harder then the first three, but happy to report I eventually figured out how to do it with SQL 😊
#AdventOfCode #databs adventofcode.com/2025/day/4
Day 3... Strap in for some recursive SQL
🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋
adventofcode.com/2025/day/3
Should I use SQL for Advent of Code? ...probably not
But can I solve all puzzles using SQL? ...again, probably not
But will I try anyway? ... definitely yes 🦆
#databs
github.com/LienBosmans/...
To all data peeps that want to work on very cool data & all (semiconductor) industry peeps that want to move into a full-time data role, this is your chance!
www.imec-int.com/en/work-at-i...
To all data peeps that want to work on very cool data & all (semiconductor) industry peeps that want to move into a full-time data role, this is your chance!
www.imec-int.com/en/work-at-i...
If you're not making yourself the hero of the internal documentation you're writing, what's even the point? #databs
You are faced with two data sources. One mostly tells the truth, the other sometimes lies. They never answer your questions at the same time. A small mob of stake-holders is demanding a fresh and perfectly trustworthy report of events. In short, you are utterly and completely fucked. Luckily, ...
Screenshot of eProcurementOntology documentation (link at end). The text "TODO: add defintion" is highlighted. https://docs.ted.europa.eu/EPO/latest/_attachments/html_reports/ePO/EARoot/EA1/EA2/EA102.htm
hehe, spotted a "TODO" in the documentation... Can't even blame them, I do it all the time 😂
Those pesky datasets never are 🥲
I'm currently in the muddy part of getting to know a new dataset... and a new API... and a new query language... wish me luck #databs! At least the documentation seems pretty complete 😊
Damn... If you know data people that want to move to Europe, they'd be very welcome... imec is a cool organization and pretty international.
www.imec-int.com/en/work-at-i...
www.imec-int.com/en/work-at-i...
www.imec-int.com/en/work-at-i...
New PyStack't documentation site is live!
lienbosmans.github.io/pystackt/
#pystackt #opensource #OCED #processmining
Not yet, I'm sure they are out there! But I'm guessing they are busy doing more useful things than giving these kind of demos 😄
Drawing of a wombat with clean, simple lines. The gray wombat is sitting and stacking three rounded cubes in front of it. The cubes are brown. To the left of the wombat, in light brown, the letters of PyStack't are stacked a bit jumbly in three rows: p y - s t a - c k 't.
What's awesome about building open source is that you don't have to worry about sales prospects. For example, using your favourite animal stacking poo cubes as the logo for a data preparation tool, is a totally valid option.
#databs
Drake No/Yes Meme. No: Improving PyStack't. Yes: Creating a cute logo. The logo in question shows a black-and-white drawing of a wombat with clean, simple lines. The wombat is sitting and stacking three rounded cubes in front of it. To the left of the wombat, in light grey, the letters of PyStack't are stacked a bit jumbly in three rows: py - sta - ck't.
How's your side project going? #databs #opensource
Mister Crabs (from Spongebob) lying in a pile of money. Caption reads "Software vendors after showing demo of AI going brrrrr to C-suite."
Mostly DuckDB & some Polars at home, SQL, Excel, Databricks and PowerBI at work.
Vendor demos be like "give us money because AI goes brrrrr"
Ooooh, I made a tool that can extract a dataset from the activity data (issues/pull requests) of a GirHub repo. I'll try it with the tidytuesday repo next week to see what comes out 😄
👑 Improve the docs. (I'm known as a queen of typos after all)
🐍 Fix my code. (Apparently, it's not "pythonic" enough... or so I'm told)
🎁 Contribute a data exporter to your favorite OCED format, or a data extractor for an open data source you're excited to dive into.
📣 Shamelessly promote your compatible & open-source tool, method, use-case, ... by dropping a link in our docs.
