Re: Count # scaffolds by plate ID [message #1281 is a reply to message #1280] |
Wed, 05 May 2021 06:23 |
amorrison
Messages: 38 Registered: March 2016
|
Member |
|
|
Hi Greg,
Would either of these achieve what you are aiming to do.
a) Generate Murcko scaffolds then calculate 'Frequency of same value in same category' - frequencyInCategory(category-column, value-column). Where the category-column is the plateID and the value-column is the Murcko.
b) Generate Murcko scaffolds then merge rows on both Murcko and PlateID. This would give you the list of compoundIDs with the same Murcko in one cell which you could then do a valueCount to get the number of compounds.
Best,
Angus
|
|
|