openmolecules.org Forum: Functionality » Suggest: select within cluster by property

Home » DataWarrior » Functionality » Suggest: select within cluster by property

Show: Today's Messages :: Polls :: Message Navigator

Re: Suggest: select within cluster by property [message #921 is a reply to message #920]

Sat, 30 May 2020 17:19

thomas
Messages: 730
Registered: June 2014

Senior Member

Assuming you have cluster numbers in a column called 'Cluster No' and molecular weights in a column called 'Molweight', then you could use "Data->Add Calculated Values...", configure the dialog as follows:
index.php?t=getfile&id=202&private=0

This creates a new column with a '1' value for all cluster members that have the lowest molecular weight within their own cluster. All other rows have a '0' in that column. Note that the Molweight column should not be set to use logarithmic behaviour. I need to fix an issue there.

Thomas

Attachment: smallestInCategory.png
(Size: 30.57KB, Downloaded 708 times)

[Updated on: Sat, 30 May 2020 17:22]

Report message to a moderator

[Message index]

		Suggest: select within cluster by property By: DrCJM on Fri, 29 May 2020 04:06
		Re: Suggest: select within cluster by property By: thomas on Sat, 30 May 2020 17:19
		Re: Suggest: select within cluster by property By: DrCJM on Mon, 01 June 2020 03:35
		Re: Suggest: select within cluster by property By: thomas on Fri, 05 June 2020 16:34

Previous Topic:	Feature Request: Expand Column Headers
Next Topic:	Feature request: Creating Row List

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue May 13 18:28:58 CEST 2025

Total time taken to generate the page: 0.03635 seconds