如何使用python而不是Excel宏自定义csv文件

import csv
import pandas as pd

with open('input.csv', 'r') as file:
    reader = csv.reader(file)
    data = list(reader)

data = pd.read_csv('input.csv')

# 添加新的列
data['Total'] = data['Column1'] + data['Column2']

# 删除列
data = data.drop(['Column3'], axis=1)

# 修改数据
data.loc[data['Column4'] > 10, 'Column4'] = 0

with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(data)

data.to_csv('output.csv', index=False)