Remove Row Index dataframe pandas
pandas, python
Solution
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
Problem
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.