Software

TL;DR — Key Takeaways 1,000,000-row stress test, real Excel limitsFlattened a full-size workbook (1,000,000 rows × 5 cols) on a laptop without a single memory spike. Performance Excel → Excel:…

xlfilldown streams an Excel sheet into SQLite or a new Excel sheet, forward-filling selected columns by header name (or letters), optionally keeping original Excel row numbers and computing a stable…

Concluding post in the python concurrency series covering the asyncio module.

Run your tasks faster by taking advantage of python concurrency.

Using Git Submodules with your python packages helps stop you from re-inventing the wheel. Make one wheel, and use it in every project. Let me show you how.

You might need to store data at the package level, take a look at the following package structure. I am going to show you how to create, read and write…

There may be occasions where you want to store application data and configuration files outside of the reach of your users, and store it directly in the package files themselves.

I've put together a python package to automate the iptables firewall commands we've covered. It's available NOW on pypi.org

The python package 'argparse' is a highly versatile and customizable command line parser. I'm going to show you a handful of examples that should cover most of your use cases,…

You need to know how to package your python projects properly. Here I show you how to package, and submit your package to your very own pypi.org repository. I create…