Python (pandas) - Working With Numeric Data But Adding Non Numeric Data Back

I have a CSV file that looks like this: Build,Avg,Min,Max BuildA,56.190,39.123,60.1039 BuildX,57.11,40.102,60.200 BuildZER,55.1134,35.129404123,60.20121 I want to get the average,

Solution 1:

IIUC:

df_out = pd.concat([df.set_index('Build'),df.set_index('Build').agg(['max','min','mean'])]).rename(index={'max':'Max','min':'Min','mean':'Average'}).reset_index()

Output:

      index      Avg        Min       Max
0    BuildA  56.1900  39.123000  60.10390
1    BuildX  57.1100  40.102000  60.20000
2  BuildZER  55.1134  35.129404  60.20121
3       Max  57.1100  40.102000  60.20121
4       Min  55.1134  35.129404  60.10390
5   Average  56.1378  38.118135  60.16837