openmolecules.org Forum: Functionality » Updating Merged Columns

Home » DataWarrior » Functionality » Updating Merged Columns

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

Re: Updating Merged Columns [message #1126 is a reply to message #1125]

Thu, 19 November 2020 17:48

nbehrnd
Messages: 235
Registered: June 2019

Senior Member

I would suggest to continue on the path mentioned by you, i.e. starting with two columns of raw data and a third column based on calculated data offering the quick re-calculate option (yielding the update).

To illustrate, I set up a small set of molecules and randomly attributed data. To simulate data missing, I kept some of the cells empty, or used as entries the strings "0" .or. "NaN". The column to pick data from either one of the two previous columns then used the if-clause

if((vendor_1!=0), vendor_1,vendor_2)

which works reasonably well in terms of an update in the new column.

index.php?t=getfile&id=291&private=0

This however assumes the absence of a row, where both columns contain disagreeing entries ...

Attachment: example_update.png
(Size: 25.82KB, Downloaded 1006 times)
Attachment: update_from_two_columns.dwar
(Size: 1.92KB, Downloaded 543 times)

Report message to a moderator

[Message index]

		Updating Merged Columns By: ELFritzen on Thu, 19 November 2020 16:09
		Re: Updating Merged Columns By: nbehrnd on Thu, 19 November 2020 17:48
		Re: Updating Merged Columns By: ELFritzen on Thu, 19 November 2020 20:53
		Re: Updating Merged Columns By: nbehrnd on Thu, 19 November 2020 21:51
		Re: Updating Merged Columns By: ELFritzen on Fri, 20 November 2020 16:00

Previous Topic:	Copy and paste from Chemdraw to Datawarrior structure
Next Topic:	pchembl values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jan 11 08:50:30 CET 2026

Total time taken to generate the page: 1.24364 seconds