grouping_excel_sheets.py

import pandas as pd

# Read the Excel file
df = pd.read_excel('/content/datadict_khaodao.xlsx')

# Group the DataFrame by column 'A'
grouped = df.groupby('table_nm')

# Create a new Excel writer object
with pd.ExcelWriter('/content/output_file.xlsx') as writer:
    # Iterate over each group
    for group_name, group_data in grouped:
        # Write each group to a separate sheet
        group_data.to_excel(writer, sheet_name=str(group_name), index=False)

print("Data has been successfully grouped and saved to 'output_file.xlsx'")