Python How do I get multiple results in the same excel sheet

Question

I now use the groupby() function to get the averages of the first 6 columns in a data collection that has 10 columns, as well as the minimum and maximum values for the remaining 4 columns. The problem is that I keep receiving problems saying that the "list" object has no property "to excel" when I try to input the results into a new excel sheet.

avg = df.groupby('column1')[['column2' , 'column3', 'column4' ,'column5',  'column6',  'column7' ]].mean()

c8= (df.assign(c8=df['column8'].abs())
       .groupby(['column1'])['column8'].agg([('min' , 'min'), ('max', 'max')])
       .add_prefix('c8'))

c9= (df.assign(c9=df['column9'].abs())
       .groupby(['column1'])['column9'].agg([('min' , 'min'), ('max', 'max')])
       .add_prefix('c9'))

c10= (df.assign(c10=df['column'].abs())
       .groupby(['column1'])['column10'].agg([('min' , 'min'), ('max', 'max')])
       .add_prefix('c10'))


df = [avg , c8, c9, c10]

#print(df)

wb = pd.ExcelWriter('C:filepath.xlsx' , engine='xlsxwriter')
df.to_excel(wb,sheet_name='Results')
wb.save()
         

Whenever I run any of the functions by themselves, they all work fine, the issue is when I put them together.

What I am expecting is an excel sheet filled with the corresponding data presented like this:

column1 column2 column3 column4 column5 column6 column7 c8min c8max c9min c9max c10min c10max 

Answer 1

Try this:

fmin = lambda x: abs(x).min()
fmax = lambda x: abs(x).max()

out = (
        df.groupby("column1", as_index=False)
          .agg(column2=("column2", "mean"), column3=("column3", "mean"),
               column4=("column4", "mean"), column5=("column5", "mean"),
               column6=("column6", "mean"), column7=("column7", "mean"), # avg
               c8min=("column8", fmin), c8max=("column8", fmax), # c8
               c9min=("column9", fmin), c9max=("column9", fmax), # c9
               c10min=("column10", fmin), c10max=("column10", fmax)) # c10
)


out.to_excel("C:/filepath.xlsx", sheet_name="Results", index=False)