Our great sponsors
-
RegExr
RegExr is a HTML/JS based tool for creating, testing, and learning about Regular Expressions.
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
If you are going to use RE's, use something like https://regexr.com/ to double check that they're doing what you want. I was suspicious of your 'cols = re.findall(r'\d+ .....', i)' line, and indeed it does miss some columns. You should rethink your column detection, and either not use REs or learn how to use capture groups and \w. There would then be no reason to use yet another RE in your column iterator to extract the numbers which you've already detected.