# Aggregating entry-level parameters satisfied with some conditions by row

**URL:** <https://discuss.hail.is/t/aggregating-entry-level-parameters-satisfied-with-some-conditions-by-row/1927>\
**Category:** Hail Query & hailctl\
**Created:** [February 25, 2021, 7:45pm UTC](https://discuss.hail.is/t/aggregating-entry-level-parameters-satisfied-with-some-conditions-by-row/1927 "2021-02-25T19:45:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jinasong](https://avatars.discourse-cdn.com/v4/letter/j/9fc348/32.png) [@jinasong](https://discuss.hail.is/u/jinasong)\
**Post date:** [February 25, 2021, 7:45pm UTC](https://discuss.hail.is/t/aggregating-entry-level-parameters-satisfied-with-some-conditions-by-row/1927/1 "2021-02-25T19:45:29Z")

</div>

Hello,

I am doing the site-level annotation from the entry-level parameter values. I used the script for just mean aggregation as below.

> info\_expr=info\_expr.annotate(qd=hl.agg.mean(mt.gvcf\_info.QD))

In this script, I want to add the condition which only get the mean value of entry-level QD parameters with mt.GT.is\_het()==True or mt.GT.is\_hom\_var() ==True.

If possible, could you suggest some solution for this issue? Thank you.

Best,  
Jina

---

<div class="post-metadata">

**Author:** ![tpoterba](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/tpoterba/32/61_2.png) [@tpoterba](https://discuss.hail.is/u/tpoterba)\
**Post date:** [February 25, 2021, 7:47pm UTC](https://discuss.hail.is/t/aggregating-entry-level-parameters-satisfied-with-some-conditions-by-row/1927/2 "2021-02-25T19:47:32Z")

</div>

You can do this with `hl.agg.filter`:

```auto
info_expr=info_expr.annotate(
    qd=hl.agg.mean(mt.gvcf_info.QD),
    qd_het = hl.agg.filter(mt.GT.is_het(), hl.agg.mean(mt.gvcf_info.QD)),
    qd_hv = hl.agg.filter(mt.GT.is_hom_var(), hl.agg.mean(mt.gvcf_info.QD)),
)

```

---

<div class="post-metadata">

**Author:** ![jinasong](https://avatars.discourse-cdn.com/v4/letter/j/9fc348/32.png) [@jinasong](https://discuss.hail.is/u/jinasong)\
**Post date:** [February 25, 2021, 7:48pm UTC](https://discuss.hail.is/t/aggregating-entry-level-parameters-satisfied-with-some-conditions-by-row/1927/3 "2021-02-25T19:48:45Z")

</div>

Thanks, @tpoterba !!!