filling missing indices in DataFrame

user_15367195 0
Viewed 54

I'm trying to fill out the missing indices with 0. I've tried some code from similar questions, but it didn't really do the trick fully.

I have a DataFrame:

df
2    1
5    5

When I use: df.reindex(range(df.index[0], df.index[-1] + 1), fill_value=0), I get:

df
2    1
3    0
4    0    
5    5

I expect:

df
0    0
1    0
2    1
3    0
4    0    
5    5
pandas dataframe python
3 Answers

Try reindex with np.arange:

>>> df.reindex(np.arange(df.index[-1] + 1), fill_value=0)
0    0
1    0
2    1
3    0
4    0
5    5
dtype: int64
>>>
user_87083640

You can use

df.reindex(range(df.index.max() + 1), fill_value=0)
user_36200030

After np.arange and range, the last version with pd.RangeIndex:

>>> df.reindex(pd.RangeIndex(df.index.max()+1), fill_value=0)
0    0
1    0
2    1
3    0
4    0
5    5
dtype: int64
user_152399510
Related