Extract values from Excel and PDF/ Data Engineering
I have numerous Excel and PDF files on Google Drive containing T12 reports, all structured differently. The columns are named variably by different accountants. My task is to extract specific total values from these files, but the variables are located in various places and have different name variations, such as “Cost of reconstruction,” “Cost of renovation,” “Total renovation,” etc.