ABOUT the data visualization with python
here is your dataset--->The DataFrame df_can = pd.read_excel('https://ibm.box.com/shared/static/lw190pt9zpy5bd1ptyg2aw15awomz9pu.xlsx', sheet_name='Canada by Citizenship', skiprows=range(20), skip_footer=2 )
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.read_excel( your filepath,sheet_name=' 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.