python 线损率计算

# encoding=utf-8
import numpy as np
import pandas as pd

#   线损率属性构造

# 参数初始化
#  供入供出电量数据
inputfile = 'data/electricity_data.xls'
outputfile = 'data/electricity_data_out.xls'
#  读入数据
data = pd.read_excel(inputfile)
data[u'线损率'] = (data[u'供入电量'] - data[u'供出电量']) / data[u'供入电量']
#  保存结果
data.to_excel(outputfile, index=False)