To read an excel file and do operations on it, we could use pandas library.
main.py603 chars17 lines
In the above code, we read an excel file using pandas and then create a list of software strings to look for. We then loop through the target column 'software in fs' and check if each value is present in our software_list. If it is, we store the data in our desired column. Once we have our updated dataframe, we can write it back to an excel file.
gistlibby LogSnag