What is the best way to pick the optimized configuration from this dataset?
I have not executed the below code but I would do something like this,
df.loc[(df['Lighting Levela (Max)'] == max(df['Lighting Levela (Max)']) &amp;
       (df['Energy Consumption (Min)'] == min(df['Energy Consumption (Max)']) &amp;
       (df['Visual Comfort (Max)'] == max(df['Visual Comfort (Max)']) &amp;
       (df['Thermal Comfort (Max)'] == max(df['Thermal Comfort (Max)']) &amp;
       (df['CO2 levels (Min)'] == min(df['CO2 levels (Max)']), :)