Empty column name in first column, how do I set the name?

Question

I have this dataframe

For some reason when I did this all_data = all_data.set_index(['Location+Type']) the name 'Location+Type' is now gone. How do I now set the first column of the dataframe to have the name 'Location+Type'?

If it doesn't show the index name after calling set_index, there's a bug somewhere or something is wrong. — cs95
– cs95, Commented Dec 13, 2019 at 19:02

Celius Stingher · Accepted Answer · 2019-12-13 18:33:26Z

1

By using set_index(['Location+Type']) you no longer have the column Location+Type instead, it is now the index of your dataframe therefore when printing, you are not seeing the name. If you wish to recover Location+Type as a column, then you need to use:

all_data = all_data.reset_index()

This will create a new index, while returning the original index (Location+Type) to a column. As the documentation states:

When we reset the index, the old index is added as a column, and a new sequential index is used:

answered Dec 13, 2019 at 18:33

Celius Stingher

18.4k6 gold badges26 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Empty column name in first column, how do I set the name?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related