Please Program in python and leave comments to help explain here is the google drive with the Test.xlsm file: https://drive.google.com/drive/folders/16utzb5_h7yMCN8_13E_JqasfcpykZOYr?usp=sharing The...


Please Program in python and leave comments to help explain


here is the google drive with the Test.xlsm file: https://drive.google.com/drive/folders/16utzb5_h7yMCN8_13E_JqasfcpykZOYr?usp=sharing


The objective is to create a code in Python that can extract the columns highlighted in blue and output them to a .txt file.  The code should be able to generate the text file with the columns that are highlighted in blue and store them on a seperate folder. Below shows how the Test.xlsm file looks like as well as how the text file should look like when the code extracts and outputs it.


*Correct-L.txt - Notepad<br>File<br>Edit<br>Format View Help<br>Band Group Number Time<br>1000<br>2000<br>3000<br>4452<br>5698<br>6521.00<br>7854.00<br>8000.00<br>9000.00<br>10000.00<br>11000.00<br>12000.00<br>13000.00<br>14000.00<br>15000.00<br>16000.00<br>17000.00<br>18000.00<br>19000.00<br>20000.00<br>21000.00<br>22000.00<br>23000.00<br>24000.00<br>25000.00<br>26000.00<br>27000.00<br>28000.00<br>29000.00<br>30000.00<br>31000.00<br>32000.00<br>33000.00<br>-380.00<br>Band Group Number Time<br>- 175.56<br>- 102.5<br>

Extracted text: *Correct-L.txt - Notepad File Edit Format View Help Band Group Number Time 1000 2000 3000 4452 5698 6521.00 7854.00 8000.00 9000.00 10000.00 11000.00 12000.00 13000.00 14000.00 15000.00 16000.00 17000.00 18000.00 19000.00 20000.00 21000.00 22000.00 23000.00 24000.00 25000.00 26000.00 27000.00 28000.00 29000.00 30000.00 31000.00 32000.00 33000.00 -380.00 Band Group Number Time - 175.56 - 102.5
*Correct-L.txt - Notepad<br>File<br>Edit Format View<br>Band Group Number T<br>- 175.56<br>- 102.5<br>- 188.63<br>- 258.36<br>-214.21<br>246.00<br>258.78<br>271.56<br>284.34<br>297.12<br>309.90<br>322.68<br>335.46<br>348.24<br>361.02<br>373.80<br>386.58<br>399.36<br>412.14<br>424.92<br>437.70<br>450.48<br>463.26<br>476.04<br>488.82<br>501.60<br>514.38<br>527.16<br>539.94<br>552.72<br>565.50<br>578.28<br>591.06<br>603.84<br>616.6233333<br>629.4033333<br>642.1833333<br>

Extracted text: *Correct-L.txt - Notepad File Edit Format View Band Group Number T - 175.56 - 102.5 - 188.63 - 258.36 -214.21 246.00 258.78 271.56 284.34 297.12 309.90 322.68 335.46 348.24 361.02 373.80 386.58 399.36 412.14 424.92 437.70 450.48 463.26 476.04 488.82 501.60 514.38 527.16 539.94 552.72 565.50 578.28 591.06 603.84 616.6233333 629.4033333 642.1833333

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here