here is your dataset--->The DataFrame dfcan = pd.readexcel('https://ibm.box.com/shared/static/lw190pt9zpy5bd1ptyg2aw15awomz9pu.xlsx', sheetname='Canada by Citizenship', skiprows=range(20), skipfooter=2 )

rr
But acually,python can't not work and also crashed;here i download the file and cancel the(dropdown list) set ,and i upload to my box cloud,so here you can go to download in this URL (https://app.box.com/s/zkd6hlp15nr38581ew0kifswwncaacwr), and you have to check out what cloumns have and to decide to use .drop method

and now, when you download file finished and use df=pd.readexcel( your filepath,sheetname=' Canada by Citizenship (2)', skiprows=range(20), skip_footer=2)
) BY THE WAY,your filepath is different from me, don't forgrt to check out.