python - 如何使用 df 中的列对 Excel 工作表进行分组？

Question

 x = {'depth':[1,1,2,2,2,3,3,3,3],"Component":["A","B","C","D","E","F","G","H","I"]}
 x = pd.DataFrame(x)
 writer = pd.ExcelWriter("example.xlsx", engine='xlsxwriter')
 df.to_excel(writer, sheet_name="sheet1", startrow=1, index=False)
 writer.save()

我正在尝试在 excel 中按深度对数据进行分组，因此当单击级别 1 时，它只会显示级别 1，单击级别 2 时会显示级别 1 和级别 2。关于如何做到这一点的任何想法？

标签： pythonexcelpandas