openmolecules.org

 
Home » DataWarrior » Functionality » Updating columns
Updating columns [message #1638] Thu, 16 June 2022 05:53 Go to next message
ChristerW is currently offline  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
Re: Updating columns [message #1646 is a reply to message #1638] Sat, 25 June 2022 12:47 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
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 Go to previous messageGo to next message
ChristerW is currently offline  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
Re: Updating columns [message #1662 is a reply to message #1651] Thu, 30 June 2022 16:26 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
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.
Re: Updating columns [message #1680 is a reply to message #1662] Sat, 16 July 2022 14:22 Go to previous messageGo to next message
sansun is currently offline  sansun
Messages: 45
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
Re: Updating columns [message #1681 is a reply to message #1680] Sun, 17 July 2022 22:30 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
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'.
Re: Updating columns [message #1683 is a reply to message #1681] Tue, 19 July 2022 05:43 Go to previous message
sansun is currently offline  sansun
Messages: 45
Registered: April 2019
Member
Yes, I found it. This feature is really helpful

Thanks a lot!

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


Current Time: Thu Mar 28 21:06:15 CET 2024

Total time taken to generate the page: 0.08538 seconds