Pandas read_html how to drop Index?

Question

I'm struggling on removing the index column from the dataframe.

Usually when I read a csv file, I can set the index = False or index_col = 0, and that removes the index column. But I can't do that when reading html for some reason. Any ideas? I've also tried reset_index(drop=True). I don't want to set any of the columns to an index.

path = 'https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M' 

canada = pd.read_html(path)    

cn_table=canada[0]

anky · Accepted Answer · 2019-01-20 04:58:49Z

2

IIUC , you want the 1st row as headers, Use header=0:

canada = pd.read_html(r'https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M',header =0, flavor = 'bs4')

Or:

canada = pd.read_html(r'https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M',header =0)

cn_table=canada[0]
>>cn_table

    Postcode    Borough          Neighbourhood
0   M1A         Not assigned     Not assigned
1   M2A         Not assigned     Not assigned
2   M3A         North York       Parkwoods
3   M4A         North York       Victoria Village
4   M5A         Downtown Toronto Harbourfront
5   M5A         Downtown Toronto Regent Park

... ... ... ...
288 M9Z         Not assigned     Not assigned

To save the dataframe to csv without index use:

cn_table.to_csv('path+filename.csv',index=False)

edited Jan 20, 2019 at 4:58

answered Jan 20, 2019 at 4:03

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

user10939484 Over a year ago

The output still contains an index column.

anky Over a year ago

@user10939484 can you share your expected output plz?

anky Over a year ago

@user10939484 did you mean print(cn_table.to_string(index=False)) ??

user10939484 Over a year ago

No, I'd like to permanently modify the dataframe to output only the 3 columns without the index to the left. Same as your output without the index.

user10939484 Over a year ago

Thanks, I was not aware of that. Not bothering me. The assignment I'm working on has a finished dataframe image that does not have an index so it's been annoying me, making me think I was just missing something obvious.

|

Collectives™ on Stack Overflow

Pandas read_html how to drop Index?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related