I want to only read the sheet names that start with a number before ". Final Ranked List" for example most sheets are named "4. Final Ranked List" but some are named "3. Final Ranked List". There are some sheets named "Copy of 4. Final Ranked List" for example that I do not want to include.
I've tried adding RegEx in the string, but pandas attempts to read it as the sheet name, not as a modifier.
df = pd.read_excel(file, sheet_name='4. Final Ranked List')
I'm hoping the script will read in all sheets that have a number & '. Final Ranked List' but excluding those that begin with 'Copy of'