This is not a generic solution. It assumes that the format of the file remains constant and that the only changes are that rows are added to the bottom and the provional status might disappear.
Having said that, if the header was of variable length, you could use a different technique: read only 7 columns from each line, ignore bad lines, and then delete any unwanted lines within the Pandas dataframe (they are not numeric so could be indentified).

--

--

--

Technology, data science and programming

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alan Jones

Alan Jones

Technology, data science and programming

More from Medium

A Deep Look into Lyra’s Performance

The relationship between Model compression and Model explainability

Performing Analysis of Meteorological Data

Final Project for MySkill’s Data Science Bootcamp — Part 3 (Google Data Studio)