Skip to content Skip to sidebar Skip to footer

How Can I Fill In A Missing Values In Range With Pandas?

I have a dataset with a number of values like below. >>> a.head() value freq 3 9 1 2 11 1 0 12 4 1 15 2 I need to fill in the values

Solution 1:

You didn't say what should happen to your Index, so I'm assuming it's unimportant.

In [12]: df.index = df['value']

In [15]: df.reindex(np.arange(df.value.min(), df.value.max() + 1)).fillna(0)
Out[15]:
       value  freq
value
9          9     1
10         0     0
11        11     1
12        12     4
13         0     0
14         0     0
15        15     2

Post a Comment for "How Can I Fill In A Missing Values In Range With Pandas?"