利用Python进行计算并将计算结果写入Excel表
import pandas as pd
df = pd.read_excel('E:/后100个.xlsx',sheet_name='Sheet1')
x1 = df['平均行驶速度(km/h)']
x2 = df['平均旅行时间(min)']
x3 = df['平均延迟时间(min)']
x4 = df['是否为早晚高峰']
fx = -0.006*x1-0.059*x2+0.136*x3+0.482*x4+1.890
print(fx)
list1 = fx.values
result = open('result.xls', 'w', encoding='gbk')
for i in range(0, len(list1)):
result.write(str(list1[i]))
result.write('\n')
result.close()
欢迎加群:620139909