Python代碼import numpy as npimport pandas as pdimport matplotlib.pyplot as pltfrom pandas_datareader import data as wbstock='3988.HK'df = wb.DataReader(stock,data_source='yahoo',start='2018-07-01')rsi_period = 14chg = df['Close'].diff(1)gain = chg.mask(chg<0,0)df['Gain'] = gainloss = chg.mask(chg>0,0)df['Loss'] = lossavg_gain = gain.ewm(com = rsi_period-1,min_periods=rsi_period).mean()avg_loss = loss.ewm(com = rsi_period-1,min_periods=rsi_period).mean()df['Avg Gain'] = avg_gaindf['Avg Loss'] = avg_lossrs = abs(avg_gain/avg_loss)rsi = 100-(100/(1+rs))df['RSI'] = rsidf.reset_index(inplace=True)df在這種情況下,我想創建一個新列“14 個交易日內的最大收盤價”。“14 個交易日內的最大收盤價”=接下來 14 天內的最大“收盤價”。例如,在第 0 行,數據范圍應該是從第 1 行到第 15 行,“14 個交易日內的最大收盤價”= 3.86
Pandas:對 Pandas DataFrame 中的當前和后續單元格求和
慕尼黑5688855
2021-09-11 15:28:35