Rex Bytes @BytesRex

Related deeper investigation: on the ProArt X870E-Creator WiFi, the Intel I226-V 2.5G port appears fully configured for WoL under Linux but still won’t wake from shutdown. The Aquantia/Marvell 10G port becomes the reliable workaround once the atlantic PME shutdown bug is fixed. rexbytes.com/2026/05/08/wol…

@NetworkChuck Did you notice Wake-on-LAN not working when running Linux on your ASUS ProArt X670E-Creator WiFi build? I found a Linux atlantic driver shutdown bug affecting the onboard Aquantia/Marvell 10G NIC: it clears PCI PME on poweroff, so WoL never fires. Fix + patch details: rexbytes.com/2026/05/06/fix…

Search terms for anyone debugging the same thing: ASUS ProArt X870E-Creator WiFi ProArt X670E-Creator WiFi Intel I226-V Linux Wake-on-LAN igc driver Wake-on: g /sys/class/net/.../device/power/wakeup Intel I226 NVM Aquantia AQC113CS

Published a detailed investigation into Wake-on-LAN failure on the ASUS ProArt X870E-Creator WiFi under Linux. Short version: the onboard Intel I226-V can be fully configured for WoL in Linux and BIOS, receive valid magic packets on the LAN, and still not wake. The onboard Aquantia/Marvell 10G port works. The post includes the full diagnostic chain: ethtool, sysfs wakeup, BIOS APM settings, packet capture, NVM version check, and the practical workaround. rexbytes.com/2026/05/08/wol…

The safest way to standardize psycopg connection behavior across Python services. pgmonkey.net

👇30 seconds from messy spreadsheet to clean SQLite:

pandas ffill() on tiered Excel data will silently put Tokyo in Europe. I kept rebuilding the same hierarchical fill-down logic across projects, so I packaged it. xlfilldown: one command, clean data, constant memory, audit hashes. pip install xlfilldown rexbytes.com/2026/02/11/xlf…

Watch this 15-second video and tell me you haven’t received this exact Excel from sales/finance: → merged cells everywhere → pandas explodes on read → soul leaves body Then watch xlfilldown turn it into clean rows ready for SQLite or a new xl file. One command. No crying. I built this because I was tired of losing. 🧵↓ #Python #pandas #DataEngineering #ExcelHell

If you’ve ever rage-searched “pandas read_excel merged cells” at 3 a.m.… this is for you. Star/save/bookmark so future-you doesn’t suffer again: github.com/rexbytes/xlfil… ⭐ Drop your worst Excel horror stories below — best one gets a reply from me with virtual therapy. #DataCleaning #Python #pandas

Why this exists: Every month someone emails you a “beautiful” hierarchical report that’s actually a data crime scene. You’ve tried: • header=[0,1,2] + multi-index hell • manual Ctrl+Down+Enter on 400 blank cells • quitting xlfilldown is the “Select blanks → =Up → Ctrl+Enter” you do 40 times… but automated, repeatable, and scriptable. Blog with war stories & benchmarks: rexbytes.com/2025/10/13/the…

xlfilldown: the missing link between "beautiful" hierarchical Excel reports and data pipelines. Forward-fill merged headers → clean tables → dump straight to SQLite/parquet. Constant memory, repeatable ETL. Details: rexbytes.com/2025/10/13/the… #Python #pandas #DataCleaning

If you’ve ever wondered why Excel sheets end up this way — I dug into the hidden logic of “managerial hierarchies” and how they break data flows. 👉 rexbytes.com/2025/10/13/the…

Ever opened an Excel sheet and felt like it’s hiding a secret hierarchy only the manager understands? 😩 I built a small tool that flattens that chaos into clean, SQL-ready data. It’s called xlfilldown — one command, no scripts. #Python #Excel #ETL #DataEngineering

Every company has that one Excel file that silently runs the business. It’s messy. It’s hierarchical. It’s critical. pip install xlfilldown makes it usable again. #ETL #DataEngineering #Python #Excel rexbytes.com/2025/10/13/the…

Merging cells in Excel feels powerful… until your data engineer starts twitching. xlfilldown saving analysts, one blank cell at a time. rexbytes.com/2025/10/13/the… #Excel #Analytics #Python