# Row wise median (or sum or mean) with missings

**URL:** <https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514>\
**Category:** New to Julia\
**Created:** [June 21, 2019, 6:09am UTC](https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514 "2019-06-21T06:09:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![abeburnett](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/abeburnett/32/8974_2.png) [@abeburnett](https://discourse.julialang.org/u/abeburnett)\
**Post date:** [June 21, 2019, 6:09am UTC](https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514/1 "2019-06-21T06:09:23Z")

</div>

Hi there,

I’ve been beating my head on this for a bit, and I’m coming up empty. Based on another answer I found here (and after realizing there’s no R equivalent of the apply functions or dplyr rowwise functions), I tried something like this:

f(a, b, c, d, e, f) = Statistics.median(a, b, c, d, e, f)

And then tried to execute it like:  
f.(reddit\_df[:subdomain\_all\_freq\_comment\_count], reddit\_df[:subdomain\_all\_freq\_comment\_query\_count], reddit\_df[:subdomain\_all\_freq\_submission\_count], reddit\_df[:subdomain\_all\_freq\_submission\_query\_count], reddit\_df[:subdomain\_all\_freq\_active\_user\_count], reddit\_df[:subdomain\_all\_freq\_subscriber\_count])

Which yields “ERROR: MethodError: no method matching median(::Float64, ::Float64, ::Float64, ::Float64, ::Missing, ::Missing)”

I assume it’s due to the presence of the missings. But when I try to add a skipmissings in there, pretty much anywhere, it doesn’t work either. Any tips here on how to do row-wise operations over a dataframe?

Thank you!

---

<div class="post-metadata">

**Author:** ![abeburnett](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/abeburnett/32/8974_2.png) [@abeburnett](https://discourse.julialang.org/u/abeburnett)\
**Post date:** [June 21, 2019, 6:18am UTC](https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514/2 "2019-06-21T06:18:58Z")

</div>

Ah, for any who wander across this. I figured it out (finally!).

f(a, b, c, d, e, f) = Statistics.median(skipmissing([a, b, c, d, e, f]))

f.(reddit\_df[:subdomain\_all\_freq\_comment\_count], reddit\_df[:subdomain\_all\_freq\_comment\_query\_count], reddit\_df[:subdomain\_all\_freq\_submission\_count], reddit\_df[:subdomain\_all\_freq\_submission\_query\_count], reddit\_df[:subdomain\_all\_freq\_active\_user\_count], reddit\_df[:subdomain\_all\_freq\_subscriber\_count])

---

<div class="post-metadata">

**Author:** ![Tamas\_Papp](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tamas_papp/32/25949_2.png) [@Tamas\_Papp](https://discourse.julialang.org/u/Tamas_Papp)\
**Post date:** [June 21, 2019, 10:09am UTC](https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514/3 "2019-06-21T10:09:13Z")

</div>

Please [quote your code](https://discourse.julialang.org/t/psa-how-to-quote-code-with-backticks/7530) (you can still edit your posts).

---

<div class="post-metadata">

**Author:** ![Nosferican](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nosferican/32/9275_2.png) [@Nosferican](https://discourse.julialang.org/u/Nosferican)\
**Post date:** [June 21, 2019, 10:31am UTC](https://discourse.julialang.org/t/row-wise-median-or-sum-or-mean-with-missings/25514/4 "2019-06-21T10:31:51Z")

</div>

```julia
using DataFrames, Statistics

data = DataFrame(a = 1:5,
                 b = 2:6) |>
       allowmissing!
data.a[3] = missing
data.b[5] = missing
sum.(skipmissing.(eachrow(data)))
mean.(skipmissing.(eachrow(data)))
median.(skipmissing.(eachrow(data)))

```