initiating_gis_7

gistfile1.txt

df_ineff = save_results(df)
df_complete = save_results_complete(df)
df_complete.head()

#Estimating the improvement options - input oriented
heading = list(df_ineff.iloc[:, 1:6])
inter = []
for c in df_ineff.iloc[:, 1:6].columns:
    inter.append(df_ineff[c].multiply((1- df_ineff.iloc[:,-1])))
    df_improvement = round(pd.concat(inter, axis = 1),1)
    df_improvement = df_improvement.rename(columns = dict(zip(df_improvement.columns, heading)))
df_improvement  = pd.concat([df_improvement,df_ineff[['dmu']]], axis = 1)

#Estimating the improvement options - output oriented
heading_output = list(df.iloc[:, 6:9])
inter_out = []
for c in df.iloc[:, 6:9].columns:
    inter_out.append(df[c].multiply((1- df.iloc[:,-1])/df.iloc[:,-1]).add(df[c]))
    df_improvement_outpt = round(pd.concat(inter_out, axis = 1),1)
    df_improvement_outpt = df_improvement_outpt.rename(columns = dict(zip(df_improvement_outpt.columns, heading_output)))
df_improvement_outpt  = pd.concat([df_improvement_outpt,df[['dmu']]], axis = 1)