Re-index Pandas Dataframe - python

Question

I have a data frame and I droped some part of it. now my new data frame has not all the rows if we consider data frame as a table.

I want to change

1

2

3

11 . . .

to

0

1

2

3

4 . . .

Thanks.

@IMCoins this will make another column to to the data frame. is there any way to remove the previous index?they are still there — CFD
– CFD, Commented Feb 18, 2019 at 19:28

IMCoins · Accepted Answer · 2019-02-18 19:32:29Z

3

Use reset_index() with the optional parameter drop=True

import pandas as pd

df = pd.DataFrame({
        'A0' : list(range(10)),
        'A1' : list(range(10)),
        'A2' : list(range(10)),
        '3A' : list(range(10)),
        'A4' : list(range(10)),
        'A5' : list(range(10))
    })
print(df.head())
#    A0  A1  A2  3A  A4  A5
# 0   0   0   0   0   0   0
# 1   1   1   1   1   1   1
# 2   2   2   2   2   2   2
# 3   3   3   3   3   3   3
# 4   4   4   4   4   4   4

df = df.iloc[2:4]
print(df)
#    A0  A1  A2  3A  A4  A5
# 2   2   2   2   2   2   2
# 3   3   3   3   3   3   3

df = df.reset_index(drop=True)
print(df)
#    A0  A1  A2  3A  A4  A5
# 0   2   2   2   2   2   2
# 1   3   3   3   3   3   3

answered Feb 18, 2019 at 19:32

IMCoins

3,3161 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Re-index Pandas Dataframe - python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related