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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy