In pandas, how can I reset index without adding a new column?

PythonPandas

Python Problem Overview

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?

Python Solutions

Solution 1 - Python

You can use the drop=True option in reset_index(). See here.

Solution 2 - Python

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
Categories
Recommended Python Solutions
Recommended Pandas Solutions

Previous Solution:

bootstrap initially collapsed element

HtmlCssTwitter BootstrapToggle

Next Solution:

Optional return in C#.Net

C#.NetNullableOptional

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionwaitingkuoView Question on Stackoverflow
Solution 1 - PythonbdiamanteView Answer on Stackoverflow
Solution 2 - Pythonder FotikView Answer on Stackoverflow