openmolecules.org Forum: Cheminformatics » Mean value in category function

Home » DataWarrior » Cheminformatics » Mean value in category function

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

Mean value in category function [message #1347]

Wed, 21 July 2021 20:06

chemtv
Messages: 27
Registered: February 2015
Location: Indianapolis

Junior Member

Hello,
I am using a calc'd column to obtain the mean of clogP (values) in a plate (category). In a dummy table with 25 cpds and the necessary info it works fine but I get 'NaN' for my large table of 525K cpds with clogP (float values from -2.6 to 11) and 209 PlateNo's (integers 1-209 category). There are no missing values, I use the drop-down menu to select columns and I am quoting both column identifiers in the formula below:

categoryMean("Plateno", "clogP")

Is there a size limit to the calculation?

Thanks for any help.

Greg

Report message to a moderator

[Message index]

Mean value in category function

By: chemtv on Wed, 21 July 2021 20:06

Previous Topic:	mean from 'n' in pKaInWater.dwar
Next Topic:	sp3 count

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jun 14 03:52:43 CEST 2025

Total time taken to generate the page: 0.07771 seconds