Entering edit mode
2.4 years ago
Paula
▴
60
Hi!
I have a table with different categories and the respective coverage values:
taxonomy coverage
A 1815.928793
ADK 5.488047
ADL 5.047244
AJ 71.070325
AL 119.333441
Now, I want to group all the entries that contain one or more of the letters "A,B,J,K,L" in a new category called "W", and add the coverages. I would use Python. The result should look like this:
taxonomy coverage
ADK 5.488047
ADL 5.047244
W 2006.332559
Thanks a lot!
Hello Paula ! It is usually a good practice to provide your attempt to solve the problem :). What have you tried?
Is D the only taxonomy that needs to be excluded from W or are there other letters that need to be excluded?