Hi there!
I am trying to add the total points earned from a student. However, student ID column contains duplicate ID numbers. What I want to do is to create another column showing the student ID and the total points earned.
Thank you
StudId TOTAL POINTS
1619419 0.3
1619419 1
1619419 0.3
1619419 0.3
1784021 0.3
1784021 0.3
1784021 0.3
1775820 0.2
1775820 0.2
1775820 1
1775820 1
1775820 1
1775820 1
1792483 0.3
1792483 1
1740471 0.3
1740471 0.3
1740471 0.3
1740471 0.3
I am trying to add the total points earned from a student. However, student ID column contains duplicate ID numbers. What I want to do is to create another column showing the student ID and the total points earned.
Thank you
StudId TOTAL POINTS
1619419 0.3
1619419 1
1619419 0.3
1619419 0.3
1784021 0.3
1784021 0.3
1784021 0.3
1775820 0.2
1775820 0.2
1775820 1
1775820 1
1775820 1
1775820 1
1792483 0.3
1792483 1
1740471 0.3
1740471 0.3
1740471 0.3
1740471 0.3