Being not very familiar with python, and after carrying out unfruitful long research on internet, I submit to you my problem, hoping favorable reply.
I have a DBF table with geochemical data and I would like writing a script to be integrated in a wider model built with ModelBuilder, and that automatically delete some specific rows, specifically (please see attached example) the rows 1, 2, 4, 5 and 6, while the row 3 (Analyte symbol) is maintained. This is first.
Secondly, I would like to automatically fill in some empty cells in some coloumns (e.g., A, B, C) with the character 0 (zero). Could you please show me the way?
In fact, by deleting rows 1, 2, 4, 5 and 6, I want the row 3 to become the first row (headline) of the table (i.e., Au, Pt, pd, SiO2...). The latter contains 150 rows of data below the 6 first rows, that begins with #59101 in the provided example.
Thus, I do not want to keep just the row 3, but really deleting the rows 1, 2, 4, 5 and 6, so that the row 3 becomes the headline of 150 rows of data (as shown in the herein attached example).