数据框列上一行与两列的乘积之和

import pandas as pd

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

# 计算第二行与第一列、第二列的乘积之和
row_index = 1
col_index = 0

# 获取上一行的值
previous_row_value = df.iloc[row_index - 1, col_index]

# 获取当前列和前两列的值
current_col_value = df.iloc[row_index, col_index]
previous_col_value = df.iloc[row_index, col_index - 1]
previous_previous_col_value = df.iloc[row_index, col_index - 2]

# 计算乘积之和
result = previous_row_value * (current_col_value + previous_col_value + previous_previous_col_value)

print(result)