In this article I want to show you a few lines of Python code that can help you to save a lot of time when comparing CSV and other files with eachother.
In literally every data migration project you will need to compare the actual outcome of the migration with the expected outcome. While there is a plethora of dedicated software tools (e.g. Redgate’s SQL Compare) a DIY approach can take you quite far.
Let us assume that we have two datasets in CSV format:
Dataset 1 (“expected”):
Dataset 2 (“actual”), that has been…
After having tried every possible way of capturing my todos (Palm Pilot, Sony Clié, Psion 3, Psion 5, Trello, Filofax, Time/System, Emacs orgmode, taskwarrior, just to name a few [!]) I am currently experimenting with bullet journals. Not with the fancy-style lists you can see on Pinterest or Instagram, but with the rational list of todo items that is carried from day to day on paper.
For my “someday log” I am not yet so far that I would like to have it handwritten, as this is not going to change regularly a printed list would be nice. I have…
From Cologne, Germany, working in the financial industry as a specialist for data-related topics. Hobbies include LaTeX typesetting, electronics and programming