Question

How to read an excel file (name User defined) from a path using python

script that only reads an  excel file present inside a path.

pd.read_excel(filename.xlsx) is usefull to read a file with stable name . heree file names changes and i dont want to run the code every time by changing file name .

Answer 1

Hi @There,

As the path is fixed, use the Python OS module to find all the files inside the path.

Filter all excel file (probably there will be one on very first time) and read that.

You probably delete the excel file after reading otherwise next time this may create confusion.

Also, you need to pass that filename to

pd.read_excel()