openmolecules.org

 
Home » DataWarrior » Cheminformatics » cumlativeSumInCategory
cumlativeSumInCategory [message #1294] Wed, 19 May 2021 15:56 Go to previous message
chemtv is currently offline  chemtv
Messages: 24
Registered: February 2015
Location: Indianapolis
Junior Member
I am trying to use a calculated column to sum the values per a text category but I keep getting "NaN" as the result. Can you tell what the problem is?
Attached is an example table...

The formula that gives NAN is:
cumulativeSumInCategory(plateID,"penalties")

I am expecting a new column that has the sum 14 for the first 3 entries and 7 for the second 3 entries, (same number for each of 3 rows).

BTW, I have no success with frequencyInCategory either. Can the frequency count unique text strings (eg. SMILES) as well as numbers?

Thanks,
Greg
  • Attachment: Example.dwar
    (Size: 1.19KB, Downloaded 215 times)

[Updated on: Wed, 19 May 2021 15:58]

Report message to a moderator

 
Read Message
Read Message
Read Message
Previous Topic: Count # scaffolds by plate ID
Next Topic: mean from 'n' in pKaInWater.dwar
Goto Forum:
  


Current Time: Thu Mar 28 16:44:33 CET 2024

Total time taken to generate the page: 0.08335 seconds