Search code examples
pythonpandasdataframeindexingreset

Pandas reset index is not taking effect

I'm not sure where I am astray but I cannot seem to reset the index on a dataframe.

When I run test.head(), I get the output below:

test.head

As you can see, the dataframe is a slice, so the index is out of bounds. What I'd like to do is to reset the index for this dataframe. So I run test.reset_index(drop=True). This outputs the following:

reset

That looks like a new index, but it's not. Running test.head again, the index is still the same. Attempting to use lambda.apply or iterrows() creates problems with the dataframe.

How can I really reset the index?

Solution

  • BrenBarn's answer works.

    The following also worked via this thread, which isn't a troubleshooting so much as an articulation of how to reset the index:

    test = test.reset_index(drop=True)