Hi all!
I have a programming problem that I can't get my head around and hope that you'll be able to help me. Right now my dataset looks like:
but I would like to remove all row duplicates and compress the data set so that missing values are placed towards the end:
Is there a smart way to do this?
Thank you for taking your time!
Best regards, Viktor
I have a programming problem that I can't get my head around and hope that you'll be able to help me. Right now my dataset looks like:
ID | CODE1 | CODE2 | CODE3 | CODE4 | CODE5 | CODE6 |
1 | X001 | X001 | X003 | |||
2 | X001 | X002 | X001 | |||
3 | X004 | X001 | X004 | |||
4 | T004 | X005 | T004 | |||
5 | R001 | T004 | R001 | T004 | T004 | R002 |
ID | CODE1 | CODE2 | CODE3 | CODE4 | CODE5 | CODE6 |
1 | X001 | X003 | ||||
2 | X001 | X002 | ||||
3 | X004 | X001 | ||||
4 | T004 | X005 | ||||
5 | R001 | T004 | R002 |
Thank you for taking your time!
Best regards, Viktor
Comment