The name of the excel files can change with time, but there would be one specific keyword that will always be in the name of the excel.
For test purposes, let the keyword be
For the excel which have fixed name like
Fruits_Pineapple.xlsx the code works:
import pandas as pd pd.read_excel(r'c:\mypath\Fruits_Pineapple.xlsx')
But I can have excel file like
Vegetables etc. I want to know how can I read the excel with