I have the following code:
import pandas as pd
df = pd.DataFrame(
{'Index' : ['1', '2', '5','7', '8', '9', '10'],
'Vals' : [1, 2, 3, 4, np.nan, np.nan, 5]})
这给了我:
Index Vals
0 1 1.0
1 2 2.0
2 5 3.0
3 7 4.0
4 8 NaN
5 9 NaN
6 10 5.0
但是我想要的是像这样的东西:
Index Vals
0 1 1.000000
1 2 2.000000
2 3 NaN
3 4 NaN
4 5 3.000000
5 6 NaN
6 7 4.000000
7 8 NaN
8 9 NaN
9 10 5.000000
我尝试通过创建一个连续索引的新数据框来实现这一点。然后,我想分配已经拥有的值,但是如何做呢?到目前为止,我唯一拥有的就是:
clean_data = pd.DataFrame({'Index' : range(1,11)})
给我带来了:
Index
0 1
1 2
2 3
3 4
4 5
5 6
6 7
7 8
8 9
9 10