openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Updating columns

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

Updating columns [message #1638]

Thu, 16 June 2022 05:53

ChristerW
Messages: 2
Registered: June 2022

Junior Member

Hi!

Can one update internally calculated columns in DataWarrior and if so how does one do that? For example if you have a column with calculated Log P and add some new compounds, how do you update the LogP column for the new new compounds.

ChristerW

Report message to a moderator

Re: Updating columns [message #1646 is a reply to message #1638]

Sat, 25 June 2022 12:47

thomas
Messages: 706
Registered: June 2014

Senior Member

If a column was calculated with 'Add Calculated Values...', then the formula is stored in the file. In this case the column's values can be re-calculated. Calculated chemical properties are different: The procedure here would involve deleting the old column and freshly generating a new one. Of course, one can do that as a macro. Especially, if multiple columns shall be recalculated, a macro would be a convenient ways to do that: start macro recording, delete property columns manually, calculated the same columns freshly, stop macro recording, export the macro into a file. You may then move the macro file into the datawarrior/macro folder, which would create an entry in the 'Macro' menu, which allows to run the macro from any DataWarrior window any time.

[Updated on: Sat, 25 June 2022 12:50]

Report message to a moderator

Re: Updating columns [message #1651 is a reply to message #1646]

Mon, 27 June 2022 09:22

ChristerW
Messages: 2
Registered: June 2022

Junior Member

Thanks so very much for the answer Thomas and the description of the procedure for creating a macro for doing this. I must say though, that it would have been much easier to to be able to recalculate also these type of calculated columns. Now the new column ends up at the end and one has to move it manually to the place where the old column was and also change background coloring and such again for the new column. Perhaps one could do that with a macro also, but I don't see why there couldn't be a function to just recalculate the values in these columns also.

ChristerW

Report message to a moderator

Re: Updating columns [message #1662 is a reply to message #1651]

Thu, 30 June 2022 16:26

thomas
Messages: 706
Registered: June 2014

Senior Member

I just have released an development update that allows to re-calculate chemical properties of an existing column from the column header popup menu. Thanks for being persistent.

Report message to a moderator

Re: Updating columns [message #1680 is a reply to message #1662]

Sat, 16 July 2022 14:22

sansun
Messages: 49
Registered: April 2019

Member

Hi Thomas

I have the latest development update but don't see this option. Can you please explain where is this exactly located?

SS

Report message to a moderator

Re: Updating columns [message #1681 is a reply to message #1680]

Sun, 17 July 2022 22:30

thomas
Messages: 706
Registered: June 2014

Senior Member

Hi Sansun,

after calculating a new chemical property column, e.g. cLogP, then you find in the column header popup menu of that new column in the table view (right mouse click on the column name) a new menu item, e.g. 'Re-Calculate cLogP'.

Report message to a moderator

Re: Updating columns [message #1683 is a reply to message #1681]

Tue, 19 July 2022 05:43

sansun
Messages: 49
Registered: April 2019

Member

Yes, I found it. This feature is really helpful

Thanks a lot!

Report message to a moderator

Previous Topic:	Medchem rules
Next Topic:	Assign cluster name based on cluster size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 30 21:03:56 CET 2024

Total time taken to generate the page: 0.00679 seconds