Filling the missing index and filling its value with 0

Question

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

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

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

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

score 22 · Accepted Answer · answered Jun 05 '18 at 01:54

22

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

answered Jun 05 '18 at 01:54

BENY

296,997
19
147
204

Thanks Wen for your fast response. Let me try it on my use case and mark the green tick :) – Ahamed Moosa Jun 05 '18 at 02:03
1

I prefer `df.reindex(range(df.index[0], df.index[-1] + 1), fill_value=0)` if the index is sorted. By the way I think this is a dupe. – cs95 Jun 05 '18 at 02:06
Hi @coldspeed , this solution is also correct :) Yeah since this is dupe , I have assigned it to the new variable – Ahamed Moosa Jun 05 '18 at 02:19
Hi , What if I want to add the index value in the Sales column instead of 0? is there any way? – Ahamed Moosa Jun 05 '18 at 05:33
@AhamedMoosa do it with `df['Sales']=df.index.values` – BENY Jun 05 '18 at 13:23

Filling the missing index and filling its value with 0

1 Answers1

Linked