Python Pandas用以上单元格的单元格值递增地填充NaN

Question

我有一个数据帧如下。。。在

           Word  Count  Team Sex    Code
0       develop      9   1     M  P45.01
1     Effective      7   NaN   M     NaN
2  professional      8   NaN   M     NaN
3      approach      5   NaN   M     NaN
4        raster     34   NaN   M     NaN
5           Sad     55   NaN   M     NaN
6         water      2   NaN   M     NaN
7          soil      7   NaN   M     NaN
8       farming      9   NaN   M     NaN
9          deep     12   NaN   M     NaN

我想用1, 2, 3, 4, 5, ....递增地填充“Team”列中的NaN，并且对“Code”列也是这样：P45.01, P46.01, P47.01, P48.01, ...。请参阅下面的最终数据框。。。在

注意：Team是数字，而代码是字符串列类型

^{pr2}$

Answer 1

我意识到您也可以执行以下操作之一，因为您在此处更新了dataframe：

设置

import re

def count(n):
    x = 0
    while x < n:
        yield x
        x += 1

def populate(s, step):
    chars = re.split('(\d*)', s)
    number = int(chars[1]) + step
    chars[1] = str(number)
    return ''.join(chars)

number_generator = count(10)
number_generator2 = count(10)

主

^{pr2}$

我们需要注意的一点是，生成器正在动态生成数字，并且只能使用一次；但它确实起作用。在