# Average of Dataset Column

**URL:** <https://forum.inductiveautomation.com/t/average-of-dataset-column/21216>\
**Category:** Ignition\
**Created:** [December 4, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/average-of-dataset-column/21216 "2018-12-04T19:31:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [December 4, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/average-of-dataset-column/21216/1 "2018-12-04T19:31:44Z")

</div>

> [@Get min/max/average values from dataset](http://forum.inductiveautomation.com/t/get-min-max-average-values-from-dataset/20988):
>
> I have a script which uses system.tag.queryTagHistory to retrieve log data in 15 minute intervals for the previous 24 hours. I run it three times, and get a minimum dataset, a maximum dataset, and an average dataset. Now, I want to find the lowest value in the minimum dataset, the highest value in the maximum dataset, and the average value of all values in the average dataset. In expression language, I can do this easily, but I don’t believe it’s possible to use expression language in a script. …

Continuing with this topic of conversation.. Could someone help me modify my code to filter out certain values when running an average of a column? For example, I would like to exclude any values that are zero. I'm unsure on where to put the clause in this code.

```auto
for item in headers:
	avg = system.math.mean(map(float,dataIn.getColumnAsList(dataIn.getColumnIndex(item))))
	dataOut.append(avg)
newDS = system.dataset.toDataSet(headers, [dataOut])

```

---

<div class="post-metadata">

**Author:** ![Stevenson.Yuan](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@Stevenson.Yuan](https://forum.inductiveautomation.com/u/Stevenson.Yuan)\
**Post date:** [December 4, 2018, 7:50pm UTC](https://forum.inductiveautomation.com/t/average-of-dataset-column/21216/2 "2018-12-04T19:50:19Z")

</div>

avg = [val for val in map(float,dataIn.getColumnAsList(dataIn.getColumnIndex(item))) if val\>0]