說我的專欄是這樣的:
trade_signal
buy
buy
buy
buy
sell
sell
sell
sell
buy
buy
buy
sell
sell
buy
sell
buy
我想洗掉列中的重復元素并用 NAN 或 0 替換它們,這樣最終會得到類似的結果:
trade_signal
buy
nan
nan
nan
sell
nan
nan
nan
buy
nan
nan
sell
nan
buy
sell
buy
我完全不確定我可以用來執行此操作的邏輯,我想我會向前填充,直到下一次用 NAN 值改變信號?
uj5u.com熱心網友回復:
嘗試使用移位掩碼:
df['trade_signal'] = df['trade_signal'].mask(df['trade_signal'].eq(
df['trade_signal'].shift())
)
trade_signal
0 buy
1 NaN
2 NaN
3 NaN
4 sell
5 NaN
6 NaN
7 NaN
8 buy
9 NaN
10 NaN
11 sell
12 NaN
13 buy
14 sell
15 buy
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/446251.html
