In Pandas, How Can I Reset Index Without Adding a New Column?
In [37]: Df = Pd. Dataframe([[1, 2, 3, 4], [2, 3, 4, 5], [3, 4, 5, 6]]) in [38]: Df2 = Pd. Concat([Df, Df]) in [39]: Df2. Reset_Index() Out[39]: Index 0 1 2 3...
In [37]: df = pd.DataFrame([[1, 2, 3, 4], [2, 3, 4, 5], [3, 4, 5, 6]])
In [38]: df2 = pd.concat([df, df])
In [39]: df2.reset_index()
Out[39]:
index 0 1 2 3
0 0 1 2 3 4
1 1 2 3 4 5
2 2 3 4 5 6
3 0 1 2 3 4
4 1 2 3 4 5
5 2 3 4 5 6
My problem is that how can I reset_index without adding a new column index?
2 Answers
You can use the drop=True option in reset_index(). See here.
You can also drop the column.
df2.reset_index().drop(["index"], axis=1)
0 1 2 3
0 1 2 3 4
1 2 3 4 5
2 3 4 5 6
3 1 2 3 4
4 2 3 4 5
5 3 4 5 6
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
