How can i use pandas to parse dataframe with specific column and write to sheets in one excel file : I uesed this but it won't work
for group in z3.group:
    group=z3[z3['group']==group]
    group.to_csv('group.csv',encoding='gbk')