import pandas as pd

# Load your data (adjust filename)
df = pd.read_csv("new_targets.csv")

# Group by year_id and sub_category_name, sum the targets
agg_df = df.groupby(['year_id', 'sub_category_name'], as_index=False).agg({
    'set_target': 'sum',
    'achieved_target': 'sum'
})

# Save to new CSV
agg_df.to_csv("overall_targets.csv", index=False)

print("✅ Done! Saved as aggregated_targets_by_year_and_subcategory.csv")