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 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

Post as a guest

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

You Might Also Like