# pandas groupby, split df and rename multiple sheets

I have a dataframe like as below import numpy as np import pandas as pd from numpy.random import default_rng rng = default_rng(100) cdf = pd.DataFrame({‘Id’:[1,2,3,4,5], ‘customer’: rng.choice(list(‘ACD’),size=(5)), ‘segment’: rng.choice(list(‘PQRS’),size=(5)), ‘manager’: rng.choice(list(‘QWER’),size=(5)), ‘dumma’: rng.choice((1234),size=(5)), ‘damma’: rng.choice((1234),size=(5)) }) I would like to do the below a) create an excel file output with multiple sheets (based on segment… Read More pandas groupby, split df and rename multiple sheets