Home » DataWarrior » Cheminformatics » Mean value in category function
Mean value in category function [message #1347] Wed, 21 July 2021 20:06
chemtv is currently offline  chemtv
Messages: 18
Registered: February 2015
Location: Indianapolis
Junior Member
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.

Previous Topic: mean from 'n' in pKaInWater.dwar
Next Topic: Importing compounds with assay data from Pubchem into Datawarrior
Goto Forum:

Current Time: Mon Oct 18 04:33:40 CEST 2021

Total time taken to generate the page: 0.01748 seconds