<code> ugds = set()
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
ugds.update(df["Pooln Gestão"].unique())
for UGD in ugds:
new_file_name = f'{base_name}_{UGD}.xlsx'
with pd.ExcelWriter(new_file_name) as writer:
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
df_filtrado = df[df["Pooln Gestão"] == UGD]
df_filtrado.to_excel(writer, sheet_name=sheet_name, index=False)
</code>
<code> ugds = set()
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
ugds.update(df["Pooln Gestão"].unique())
for UGD in ugds:
new_file_name = f'{base_name}_{UGD}.xlsx'
with pd.ExcelWriter(new_file_name) as writer:
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
df_filtrado = df[df["Pooln Gestão"] == UGD]
df_filtrado.to_excel(writer, sheet_name=sheet_name, index=False)
</code>
ugds = set()
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
ugds.update(df["Pooln Gestão"].unique())
for UGD in ugds:
new_file_name = f'{base_name}_{UGD}.xlsx'
with pd.ExcelWriter(new_file_name) as writer:
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
df_filtrado = df[df["Pooln Gestão"] == UGD]
df_filtrado.to_excel(writer, sheet_name=sheet_name, index=False)
I need to skip the first row because what i am searching for is on the second row, but I need to include the first row on the new files.
New contributor
Rio is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1