Hope you are well.
Context: I have an excel file with 10 columns. Which include one of the column as open text with description.
Objective - Extract information from the open text column based on the user input keyword and extract the relevant information.
if i have a dataset with 4 column
- column - city
- column - age
- column - location
- column - description - which contains the open text.
Requirement - User input the keyword “maintenance” then the bot has to search through the excel file say the "description " column and give user the rows where the “maintenance” word is appearing along with the other columns.
Please let me know how to achieve this,