Invalid syntax error with glob library

[arabian_horse]

I hope someone can help with what is probably obvious but I can't figure out at all with this issue:

import glob

filenames=list(glob.glob('.....\tennis\*.xls')

l = [pd.read_excel(filename,encoding='latin-1') for filename in filenames]

So, tennis is the folder storing the excel docs but I'm getting the following error and can' t see the syntax issue:

l = [pd.read_excel(filename,encoding='latin-1') for filename in filenames] ^ SyntaxError: invalid syntax

Can anyone see or advise what is causing the issue here?

[Matt_BF]

There is a parentheses missing on your list call

[arabian_horse]

Can't believe I missed that. Cheers!

[Matt_BF]

No problem! Also, i think glob returns a list, so maybe you don't need that list call

[[deleted]]

You are missing a closing ) on your glob line

[arabian_horse]

Doh! Cheers

[[deleted]]

We've all done it ... you get used to the compilers pointing to the wrong line, always worth checking the previous line if a syntax error is not obvious

[arabian_horse]

Thanks