o ;Di @sdddlmZmZmZddlmZddlmZmZddZ e e_ eddZ ddZ e e_ d d d Z d S) )absolute_importprint_functiondivision) namedtuple)valuesTablecCs^tt||}zt|}}Wn tyYdSw|D]}||kr$|}||kr*|}q||fS)a` Find minimum and maximum values under the given field. E.g.:: >>> import petl as etl >>> table = [['foo', 'bar'], ['a', 1], ['b', 2], ['b', 3]] >>> minv, maxv = etl.limits(table, 'bar') >>> minv 1 >>> maxv 3 The `field` argument can be a field name or index (starting from zero). )NN)iterrnext StopIteration)tablefieldvalsminvmaxvvrM/var/www/Datamplify/venv/lib/python3.10/site-packages/petl/util/statistics.pylimits s rstats)counterrorssumminmaxmean pvariancepstdevc Csd}d}d}d}d}d}d}t||D]>} zt| } Wnttfy*|d7}Yqw|d7}|dus7| |kr9| }|dusA| |krC| }|| 7}t| |||d\}}q|d} t|||||||| S)aJ Calculate basic descriptive statistics on a given field. E.g.:: >>> import petl as etl >>> table = [['foo', 'bar', 'baz'], ... ['A', 1, 2], ... ['B', '2', '3.4'], ... [u'B', u'3', u'7.8', True], ... ['D', 'xyz', 9.0], ... ['E', None]] >>> etl.stats(table, 'bar') stats(count=3, errors=2, sum=6.0, min=1.0, max=3.0, mean=2.0, pvariance=0.6666666666666666, pstdev=0.816496580927726) The `field` argument can be a field name or index (starting from zero). Nr)rvarianceg?)rfloat ValueError TypeError onlinestats_stats) r r _min_max_sum_mean_var_count_errorsr_stdrrrr/s,  cCsD|}|}|d|||}|d||||||}||fS)Nrr)xinrrmeanprv varianceprvrrrr"\s  r"N)rr) __future__rrr collectionsrpetl.util.baserrrr#rr"rrrrs  *