How to group by multiple columns with string and value

Hi All,

i have just started learning Python and i have started automating my first Excel.
I have a 5 columns where i need to group them together and split them into multiple worksheets.
Where i am unable to group them as 4 columns are string and one which is value column.

could some one guide me how to do it?
Below code works for selecting the required columns and split them into multiple worksheets.

import pandas as pd
import numpy as np
import openpyxl
from openpyxl import load_workbook
df= pd.read_excel(‘EE sample.xlsx’)
df[[‘EngagementID’,‘Focus Status/Quadrant’,‘EngagementName’,‘UDN’,‘AccountName’,‘TERFYTD_PR’]]
df[‘Focus Status/Quadrant’].unique()

df1=(df.loc[(df[‘Focus Status/Quadrant’]==“ACCELERATE”) | (df[‘Focus Status/Quadrant’]==“BUILD”) |(df[‘Focus Status/Quadrant’]==“INNOVATE”) | (df[‘Focus Status/Quadrant’]==“PROTECT”)])
for focus in df1[‘Focus Status/Quadrant’].unique():
print(focus)
writer=pd.ExcelWriter(‘Largest Eng_Focus Account.xlsx’,engine=‘xlsxwriter’)
for focus in df1[‘Focus Status/Quadrant’].unique():
newdf=df1[df1[‘Focus Status/Quadrant’]==focus]

newdf.to_excel(writer,sheet_name=focus, index=False)

writer.save()