sum columns based a unique 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
df.groupby('Column1')['Column2'].sum()
Column1 Column2
1 44
2 65
3 30
4 18