如标题所述,我想根据“Cut”中的值将“Vorgabe”和“Temp”中的值更改为 nan。
这是一个具有预期结果的示例。我认为这是理解我的问题的最佳方式。
OptOpTemp OpTemp Grad Vorgabe Temp Cut
0 22.5 24 0.0 22.5 24 0.0
1 22.5 24 0.0 22.5 24 0.0
2 23.5 24 1.0 23.5 24 1.0
3 23.5 24 0.0 23.5 24 0.0
4 23.5 24 0.0 23.5 24 0.0
5 23.5 24 0.0 23.5 24 0.0
6 23.5 24 0.0 23.5 24 0.0
7 23.5 24 0.0 23.5 24 0.0
8 23.5 24 0.0 23.5 24 0.0
9 26.0 24 2.5 26.0 24 3.0
10 26.0 24 0.0 26.0 24 0.0
11 26.0 24 0.0 26.0 24 0.0
12 26.0 24 0.0 26.0 24 0.0
13 26.0 24 0.0 26.0 24 0.0
我想把它改成这样:
OptOpTemp OpTemp Grad Vorgabe Temp Cut
0 22.5 24 0.0 22.5 24 0.0
1 22.5 24 0.0 nan nan 0.0 <- one row above
2 23.5 24 1.0 nan nan 1.0
3 23.5 24 0.0 nan nan 0.0 <- one row among
4 23.5 24 0.0 23.5 24 0.0
5 23.5 24 0.0 23.5 24 0.0
6 23.5 24 0.0 nan nan 0.0 <- three rows above
7 23.5 24 0.0 nan nan 0.0
8 23.5 24 0.0 nan nan 0.0
9 26.0 24 2.5 nan nan 3.0
10 26.0 24 0.0 nan nan 0.0
11 26.0 24 0.0 nan nan 0.0
12 26.0 24 0.0 nan nan 0.0 <- three rows among
13 26.0 24 0.0 26.0 24 0.0
上方和中间的行数基于“Cut”中的值。
我想为“Cut”中的每个整数值创建它。因此,如果出现 2,则应在上方切割两行,在中间切割两行。因此我认为需要一个循环,但我不知道如何获得正确的结果......
请您参考如下方法:
一种方法是创建一个索引数组并由它们掩码:
# define in-scope cuts
cuts = df.loc[df['Cut'] != 0, 'Cut'].astype(int)
# calculate array of indices
idx = np.hstack([np.arange(i - val, i + val + 1) for i, val in cuts.items()])
# mask series according to indices
df.loc[idx, ['Vorgabe', 'Temp']] = np.nan
# alternative: use if index ranges may fall out of dataframe index
# df.loc[df.index.isin(idx), ['Vorgabe', 'Temp']] = np.nan
print(df)
# OptOpTemp OpTemp Grad Vorgabe Temp Cut
# 0 22.5 24 0.0 22.5 24.0 0.0
# 1 22.5 24 0.0 NaN NaN 0.0
# 2 23.5 24 1.0 NaN NaN 1.0
# 3 23.5 24 0.0 NaN NaN 0.0
# 4 23.5 24 0.0 23.5 24.0 0.0
# 5 23.5 24 0.0 23.5 24.0 0.0
# 6 23.5 24 0.0 NaN NaN 0.0
# 7 23.5 24 0.0 NaN NaN 0.0
# 8 23.5 24 0.0 NaN NaN 0.0
# 9 26.0 24 2.5 NaN NaN 3.0
# 10 26.0 24 0.0 NaN NaN 0.0
# 11 26.0 24 0.0 NaN NaN 0.0
# 12 26.0 24 0.0 NaN NaN 0.0
# 13 26.0 24 0.0 26.0 24.0 0.0
