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.
Hi, I'm Sebastian
Python freelancer, consultant, and speaker.
Latest posts
Dictionary Comprehension
Is using dictionary comprehension faster than calling the dict() function? And what's the most efficient way to create a dictionary from two iterables?
How I Organize My Notes With Obsidian
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.
Most popular posts
In case you haven't read them, here are my most popular posts:
Talks
I spoke at 20+ Python conferences around the world.
Get in touch if you would like me to present at yours.
Here are some of my favorite talks.
Writing Faster Python 3
A talk about source code optimization. How some common problems can be solved with different code structures, together with benchmarks and explanations why one way is usually better (and often faster) than the other.
This is a revised version of my very first talk that I created in 2016 - adjusted for Python 3 with new code examples.
9 Jupyter Tricks For Your Next Advent of Code
Every year thousands of developers try to solve the programming puzzles of the Advent of Code challenge. For many Pythonistas, their favorite tool to do that is the Jupyter notebook. Here are some cool tricks that can help you next time.
Modern Python Developer's Toolkit workshop
This is a tutorial for PyCon 2020 that I wish someone gave to me when I first learned Python.
Python is (relatively) easy and fun to learn, but there is a gap between "knowing how to write Python code" and "knowing the tools and good practices when writing Python code". This tutorial will try to bridge this gap. It's intended for beginners who know Python, but who are not sure how to write a Python project from scratch.