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?"