how to sum column data on the basis of one unique column in pandas 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