In this post, I review Automating Excel with Python by Michael Driscoll. From the introduction chapter of this book:

The purpose of this book is to help you learn how to use Python to work with Excel. You will be using a package called OpenPyXL to create, read, and edit Excel documents with Python. While the focus of this book will be on OpenPyXL, you will also learn about other Python packages that you can use to interact with Excel using the Python programming language.

TL;DR: Started and ended the year well, with a depressing period in the middle. Published three programming ebooks, several blog posts, started a newsletter, improved Twitter readership, read 80+ novels, and so on. Had a good year in terms of ebook sales 😇

I posted a coding challenge in the fifth issue of learnbyexample weekly. I discuss the problem and Python/Perl solutions in this blog post.

(2023-03-20) Update: This TUI app covers many more exercises compared to the GUI app discussed below.

Still confused about Python regular expressions? Grow your confidence with Understanding Python re(gex)? ebook (FREE this month!) and an interactive GUI app.

Inspired by Advent of Code, I'll also be posting 3 challenges per day on twitter for 25 days.

Hello!

Here's some exciting programming deals for my own ebooks as well sales details from other creators.

I posted a coding challenge in the second issue of learnbyexample weekly. I discuss the problem and Python/Perl solutions in this blog post.

Hello!

I'm excited to announce learnbyexample weekly newsletter, scheduled to be delivered every Friday.

This free newsletter will help you discover awesome programming resources. I'll primarily focus on resources related to Python, Linux, CLI tools, Regular Expressions and Vim. Sometimes, I'll also include other programming resources.

Hello!

You never know where a conversation between indie authors will lead to. A tweet about Leanpub Python book sales brought up giveaways that we indie authors tend to do. Long story short, the four of us ended up deciding to create The Indie Python Extravaganza bundle.

And guess what?! You can use this pytober coupon link to get the bundle for FREE (the offer is valid till 31-Oct-2021).

Hello!

I just published my ebook titled "Practice Python Projects". This book presents five beginner to intermediate level projects inspired by real world use cases:

• Enhance your CLI experience with a custom Python calculator
• Analyzing poll data from a Reddit comment thread
• Finding typos in plain text and Markdown files
• Creating a GUI for evaluating multiple choice questions
• Square Tic Tac Toe — creating a GUI game with AI

I'm building a tool called rcut that allows you to use cut like syntax with features like regexp based delimiters. The solution uses awk inside a bash script.

Latest feature creep is fixed string field splitting. I thought it would be a simple enough solution to add.

I was wrong.