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
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base