I suggest you ...

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 )

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.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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    ming-yu li shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base