excel sum once for each unique value in another column code example
Example: Sum values of column based on the unique values of another column
df.groupby('Column1')['Column2'].sum()
Column1 Column2
1 44
2 65
3 30
4 18