I need to insert null values for missing index in python pandas

Question

I have a dataset

x  text
1  one
2  two
4  four
5  five
7  seven

now I want output as

x  text
1  one
2  two
3  null
4  four
5  five
6  null
7  seven

jezrael · Accepted Answer · 2018-10-02 09:16:25Z

4

Use reindex:

#if x is column
#df = df.set_index('x').reindex(np.arange(df.index.min(), df.index.max() + 1))
#if x is index
df = df.reindex(np.arange(df.index.min(), df.index.max() + 1))
print (df)
    text
x       
1    one
2    two
3    NaN
4   four
5   five
6    NaN
7  seven

edited Oct 2, 2018 at 9:16

answered Oct 2, 2018 at 8:14

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Rahul Varma Over a year ago

i have tried but i am getting this error ->AttributeError: 'Series' object has no attribute 'set_index'

jezrael Over a year ago

@RahulVarma - use second answer - df = df.reindex(np.arange(df.index.min(), df.index.max() + 1))

jezrael Over a year ago

@RahulVarma - what is print(df.index) ?

Collectives™ on Stack Overflow

I need to insert null values for missing index in python pandas

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related