python实现对Excel某一列乘以某个常数,结果存放在另一个单元格中

 

 

#python实现对Excel某一列乘以某个常数,结果存放在另一个单元格中
import pandas as pd

filepath = 'D:\python\python名单.xls'
data = pd.read_excel(filepath)
data["测试"] = data["总和"] * 5;
print(data.head())

with pd.ExcelWriter('D:\python\python名单.xls') as writer:
    data.to_excel(writer, sheet_name = str(7))