Remove Row Index dataframe pandas

Question

Given a df

in[0]df1
out[0]
        DATE    REVENUE    COST    POSITION
FACTOR
0    2017/01/01    1000    900    10
1    2017/01/01    900     700    9
2    2017/01/01    1100    800    7

I have an additional row FACTOR. After trying reset_index() and other ways, I cannot remove the FACTOR multi (row) index. Is there a way to do so?

I know it's common to drop columns and reset index but not this way though.

Answer 1

I hope this works :)

df.reset_index(inplace=True) # Resets the index, makes factor a column
df.drop("Factor",axis=1,inplace=True) # drop factor from axis 1 and make changes permanent by inplace=True

Answer 2

Try using:

df1.reset_index(drop=True)

This resets the index to the default integer index and removes the original one. If you want to assign this change to original dataframe it is easier to use:

df1.reset_index(drop=True, inplace=True)

As it will edit the df1 dataframe without making a copy of it.