openmolecules.org Forum: Cheminformatics » Removing "NaN points" from graphs or formula to avoid "NaN" results

Home » DataWarrior » Cheminformatics » Removing "NaN points" from graphs or formula to avoid "NaN" results

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

Re: Removing "NaN points" from graphs or formula to avoid "NaN" results [message #1737 is a reply to message #1734]

Tue, 13 September 2022 21:42

thomas
Messages: 741
Registered: June 2014

Senior Member

Dear Charlène,

the answer to your second question is easy: the default for graphical views is to show empty values ('NaN' means 'Not a Number' and treated as an empty value). You can change the setting by pressing the 'wrench' button of the view, the switch to the 'Row Hiding' panel and uncheck 'Show empty values'

I don't quite understand the first question. '0' is a number and a valid numerical result. If a calculation cannot be done. because an input value is not numerical or because of another error, you get NaN or Infinity. If you intentd to convert a '0' result into an empty cell, you could use the if( Wink

function.

Report message to a moderator

[Message index]

		Removing "NaN points" from graphs or formula to avoid "NaN" results By: Charlene on Mon, 12 September 2022 13:48
		Re: Removing "NaN points" from graphs or formula to avoid "NaN" results By: thomas on Tue, 13 September 2022 21:42
		Re: Removing "NaN points" from graphs or formula to avoid "NaN" results By: Charlene on Wed, 14 September 2022 08:29

Previous Topic:	Metrics to use for UMAP analysis with SkelSpheres descriptor
Next Topic:	Molecular Descriptors Tools (Free for non-commercial use)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jan 19 10:03:53 CET 2026

Total time taken to generate the page: 1.60702 seconds