I'm trying to find a solution to rearrange my data frame. Currently I have more than a half duplicate raws for a single object and I would like to combine them into one. The fraction of my dataset you can find below:
#NAME Sample1 Sample2 Sample3 sample4 Sample5 AAC(6')-Ib7 5 0 0 0 0 AAC(6')-Ib7 0 3 0 0 25 AAC(6')-Ib7 0 0 0 0 0 AAC(6')-Ib7 0 0 0 10 0 AAC(6')-Ib7 0 0 0 0 0
And I would like to have the output:
#NAME Sample1 Sample2 Sample3 sample4 Sample5 AAC(6')-Ib7 5 3 0 10 25
Can you give me any tips how I can rearrange it? Because my original dataset has more than 7000 raws, but most are in dublicate (should have around 800 single raws), do I have to do it for each value separately?
Will be appreciated for your help! Thank you.