Automate Excel with Python: From manual grind to one-click workflow

Re:Automate Excel with Python: From manual grind to one-clic... by janlaureys on Wednesday July 08, 2026 @04:54AM (#48829384)

Been working on a dashboard that takes in a bunch of different public data sources in different formats and pandas has truly been a godsend for this.

I've got csv, txt, xlsx in all different shapes and sizes and with just a few settings I can go through them quite easily and very fast as well.

[ Parent | on HN ]

Re:Automate Excel with Python: From manual grind to one-clic... by OGWhales on Wednesday July 08, 2026 @09:56AM (#48832035)

Depending on the size and the transformations you are doing, polars is worth checking out. Syntax is a bit different from pandas but the performance is really nice.

[ Parent | on HN ]

Re:Automate Excel with Python: From manual grind to one-clic... by janlaureys on Wednesday July 08, 2026 @10:16AM (#48832282)

My biggest bottleneck right now is upload speed but I'll keep it in mind thanks.

[ Parent | on HN ]