WTF Excel?!
For a tool that probably underlies most of the financial systems in the world, Excel has some incredibly weird limitations and quirks. Let me share a few WTFs I encountered when working with it.
I write about Python, productivity for developers (dotfiles, CLI tools, etc.), micro-entrepreneurship (i.e. side projects that I built), and whatever else interested me at this time.
For a tool that probably underlies most of the financial systems in the world, Excel has some incredibly weird limitations and quirks. Let me share a few WTFs I encountered when working with it.
Is using dictionary comprehension faster than calling the dict() function? And what's the most efficient way to create a dictionary from two iterables?
After years of using Evernote, I finally found a worthy replacement. And not only for Evernote but for two other tools as well. Let me show you how I organize my notes, mind maps, tasks, and long-term goals in Obsidian.
Is using {} faster than dict()? If yes, then why? And when would you use one version over the other?
There are plenty of ways to measure the speed of your code. Let me show you a few that I considered for the Writing Faster Python series.
Can we speed up our code examples by simply upgrading the Python version? And if yes, by how much?
Here is a quick tip: if you add a comment to an important command, it will be easier to find it later or understand what it did.
I've got this shiny, new blog design. Let me tell you how I got here. It all started with an idea for a dark theme...
pyenv is a tool that lets you easily install new Python versions and switch between them.
I don't always do the Advent of Code challenges. But when I do, I do them in IPython. Let me show you why.
What's the fastest way to remove duplicates from a list?
What's the difference between type() and isinstance() methods, and which one is better for checking the type of an object?
Why iterating over the whole list is a bad idea, what data structure is best for membership testing, and when it makes sense to use it?
How can we compare a variable to True or False, what's the difference between "is" and "==" operators, and what are truthy values?
What's the fastest way to sort a list? When can you use sort() and when you need to use sorted() instead?