I have 336 excel files and each excel file has 25 columns. I have to extract the rows from column 17 which do not have “efflux pump” (for example: extract the other rows with full entries which do not have efflux pump) and print the output as the same name of input files.
Kindly help regarding this. Thank you.
Below is example data from 1 file:
I have to extract
pmr phosphoethanolamine transferase and its corresponding data and excludes entries which have
efflux pump from column 17 (
Q in the excel sheet).