openmolecules.org Forum: Cheminformatics » Use of calculated column functions

Home » DataWarrior » Cheminformatics » Use of calculated column functions

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

Use of calculated column functions [message #814]

Wed, 11 March 2020 11:09

sansun
Messages: 50
Registered: April 2019

Member

I have a file with the bioactivity column for several molecules.

I want to create a new column so that molecules with IC50 less than value 'x' are annotated as '1' while those with more than 'y' value labelled as '0'.

I understand that it can be done bey 'Calculated column' but I am not able to figure out the exact formula.
Any help is appreciated.

Report message to a moderator

[Message index]

		Use of calculated column functions By: sansun on Wed, 11 March 2020 11:09
		Re: Use of calculated column functions By: nbehrnd on Wed, 11 March 2020 22:25
		Re: Use of calculated column functions By: sansun on Thu, 12 March 2020 11:43
		Re: Use of calculated column functions By: nbehrnd on Thu, 12 March 2020 22:03
		Re: Use of calculated column functions By: thomas on Wed, 18 March 2020 19:19
		Re: Use of calculated column functions By: sansun on Sun, 10 May 2020 06:00

Previous Topic:	SureChEMBL
Next Topic:	Suggested addition: mirror access to Tautobase.dwar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 22 08:44:02 CET 2026

Total time taken to generate the page: 1.56844 seconds