如何基于与另一列的所有先前值相关的函数在pandas中创建新列

import pandas as pd

# 创建示例数据
data = {'A': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

# 使用shift()函数获取先前值，并计算与另一列的差值
df['B'] = df['A'] - df['A'].shift(1)

# 输出结果
print(df)

   A    B
0  1  NaN
1  2  1.0
2  3  1.0
3  4  1.0
4  5  1.0

import pandas as pd

# 创建示例数据
data = {'A': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

# 计算移动平均值
df['Moving Average'] = df['A'].rolling(window=2).mean()

# 计算累计和
df['Cumulative Sum'] = df['A'].cumsum()

# 输出结果
print(df)

   A  Moving Average  Cumulative Sum
0  1             NaN               1
1  2             1.5               3
2  3             2.5               6
3  4             3.5              10
4  5             4.5              15