Skip to main content
 首页 » 编程设计

python之Pandas Dataframe 列的滚动梯度

2025年01月19日7wayfarer

如何使用另一列的渐变在 pandas 数据框中创建一列?

我希望梯度在滚动窗口上运行,因此一次仅评估 4 个数据点。

我假设它是这样的:

df['Gradient'] = np.gradient(df['Yvalues'].rolling(center=False,window=4)) 

但是这给出了错误:

    raise ValueError('Length of values does not match length of ' 'index') 
ValueError: Length of values does not match length of index 

有什么想法吗?

谢谢!!

请您参考如下方法:

我想我找到了解决方案。虽然它可能不是最有效的..

class lines(object): 
    def __init__(self): 
        pass 
 
    def date_index_to_integer_axis(self, dateindex): 
        d = [d.date() for d in dateindex] 
        days = [(d[x] - d[x-1]).days for x in range(0,len(d))] 
        axis = np.cumsum(days) 
        axis = [x - days[0] for x in axis] 
        return axis 
 
    def roll(self, Xvalues, Yvalues, w):  # Rollings Generator Function # https://stackoverflow.com/questions/231767/what-does-the-yield-keyword-do-in-python 
        for i in range(len(Xvalues) + 1 - w): 
            yield Xvalues[i:i + w], Yvalues[i:i + w] 
 
    def gradient(self,Xvalues,Yvalues): 
        #Uses least squares method. 
        #Returns the gradient of two array vectors (https://docs.scipy.org/doc/numpy-1.13.0/reference/generated/numpy.linalg.lstsq.html) 
        A = np.vstack([Xvalues, np.ones(len(Xvalues))]).T 
        m, c = np.linalg.lstsq(A, Yvalues)[0] 
        return m,c 
 
    def gradient_column(self, data, window): 
        """ Takes in a single COLUMN EXTRACT from a DATAFRAME (with  associated "DATE" index) """ 
        vars = variables() 
 
        #get "X" values 
        Xvalues = self.date_index_to_integer_axis(data.index) 
        Xvalues = np.asarray(Xvalues,dtype=np.float) 
        #get "Y" values 
        Yvalues = np.asarray([val for val in data],dtype=np.float) 
        Yvalues = np.asarray(Yvalues,dtype=np.float) 
 
        #calculate rolling window "Gradient" ("m" in Y = mx + c) 
        Gradient_Col = [self.gradient(sx,sy)[0] for sx,sy in self.roll(Xvalues,Yvalues, int(window))] 
        Gradient_Col = np.asarray(Gradient_Col,dtype=np.float) 
 
        nan_array = np.empty([int(window)-1]) 
        nan_array[:] = np.nan 
        #fill blanks at the start of the "Gradient_Col" so it is the same length as the original Dataframe (its shorter due to WINDOW) 
        Gradient_Col = np.insert(Gradient_Col, 0, nan_array) 
 
        return Gradient_Col 
 
 
df['Gradient'] = lines.gradient_column(df['Operating Revenue'],window=4)