openmolecules.org

 
Home » DataWarrior » Cheminformatics » Removing "NaN points" from graphs or formula to avoid "NaN" results
Removing "NaN points" from graphs or formula to avoid "NaN" results [message #1734] Mon, 12 September 2022 13:48 Go to previous message
Charlene is currently offline  Charlene
Messages: 2
Registered: September 2022
Junior Member
Dear team,
First of all, thanks a lot for this useful forum, I already found answers to my questions in the previous topics!
However I was not able to find an answer to this issue that I encountered:
- I added calculated values with some formula from different columns. However, in these columns, some rows do not have values and are empty, therefore the calculation gave "NaN"
- The problem is that when I draw a 2D graph, the "NaN" values are also reported on the graph as "0" all on the bottom which is not useful.

My questions are:
- is there a function like there is on excel which allows to get an empty box if the result of the calculation is 0?
- and/or is it possible to remove all the "NaN" points from the graphs?

Many thanks in advance for your return,
Kind regards,
Charlène
 
Read Message
Read Message
Read Message
Previous Topic: Metrics to use for UMAP analysis with SkelSpheres descriptor
Next Topic: Molecular Descriptors Tools (Free for non-commercial use)
Goto Forum:
  


Current Time: Sat Oct 12 06:31:28 CEST 2024

Total time taken to generate the page: 0.03389 seconds