代码
import pandas as pd
def shop(file_name = "test.xlsx",sep=["条件1","条件2"],to_file="路径"):
data = pd.read_excel(file_name)
pro_data = data.groupby(sep)
for [i, j], n in pro_data:
new_file_name = str(to_file + "_" + i + "_" + j + ".xlsx")
n.to_excel(new_file_name)