The most easy way is to use the clipboard. Just copy your table in Excel to the clipboard, and then call the read_clipboard method from pandas:
df1 = pd.read_clipboard()
Pandas can read Excel files directly too, with read_excel
df1 = pd.read_excel('tmp.xlsx',index_col=0, header=0)
Taking care with header and indexes, and other options as described here.
