CODEWITHSUNDEEP
pythonpandasindexingfill
Ahamed Moosa
Ahamed Moosa

Reputation: 1445

Filling the missing index and filling its value with 0

I have a pandas dataframe with a column value as index number 

      Sales
140   100
142   200
145   300

I want to fill the missing index and also want to fill the value of missing index with 0

      Sales
140   100
141   0
142   200
143   0
144   0
145   300

I also want to fill missing values as the missing index number like 

     Week_num
140   140
142   142
145   145

      Week_Num
140   140
141   141
142   142
143   143
144   144
145   145

I request you to help me how to code this out?

Upvotes: 23

Views: 15398

Answers (1)

BENY
BENY

Reputation: 323226

You can using reindex

df.reindex(list(range(df.index.min(),df.index.max()+1)),fill_value=0)
Out[471]: 
     Sales
140    100
141      0
142    200
143      0
144      0
145    300

Upvotes: 35

Related Questions