将一些列设为虚拟并移动值为pandas

import pandas as pd

# 创建示例DataFrame
data = {
    '销售金额': [100, 200, 300, 400],
    '税率': [0.1, 0.1, 0.1, 0.1]
}
df = pd.DataFrame(data)

# 添加虚拟列计算税额
df['税额'] = df['销售金额'] * df['税率']

print(df)

   销售金额  税率    税额
0     100  0.1   10.0
1     200  0.1   20.0
2     300  0.1   30.0
3     400  0.1   40.0

def calculate_tax(sales_amount, tax_rate):
    return sales_amount * tax_rate

df['税额'] = calculate_tax(df['销售金额'], df['税率'])

def complex_calculation(row):
    # 假设这里有一些复杂的计算逻辑
    return row['销售金额'] * row['税率'] + 5

df['复杂计算结果'] = df.apply(complex_calculation, axis=1)