# Replace missing values with zeros and nonmissing values with one in Dataframe

**URL:** <https://discourse.julialang.org/t/replace-missing-values-with-zeros-and-nonmissing-values-with-one-in-dataframe/53686>\
**Category:** New to Julia\
**Created:** [January 20, 2021, 8:59pm UTC](https://discourse.julialang.org/t/replace-missing-values-with-zeros-and-nonmissing-values-with-one-in-dataframe/53686 "2021-01-20T20:59:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![max\_schwarzer](https://avatars.discourse-cdn.com/v4/letter/m/278dde/32.png) [@max\_schwarzer](https://discourse.julialang.org/u/max_schwarzer)\
**Post date:** [January 20, 2021, 8:59pm UTC](https://discourse.julialang.org/t/replace-missing-values-with-zeros-and-nonmissing-values-with-one-in-dataframe/53686/1 "2021-01-20T20:59:11Z")

</div>

Hello,

I would like to recode a dataframe containing positive numbers and missings such that every positive number is replaced with one and every missing is replaced with zero.

I found some similar solutions but was unable to adjust them to Dataframes.

```julia
# Input 
df = DataFrame(A = [1, missing,3, 4], B = [5,6,missing,7])

# Desired Output 
nonmissing = DataFrame(B = [1, 0, 1, 1], C = [1,1,0,1])

```

---

<div class="post-metadata">

**Author:** ![tbeason](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tbeason/32/15898_2.png) [@tbeason](https://discourse.julialang.org/u/tbeason)\
**Post date:** [January 20, 2021, 9:05pm UTC](https://discourse.julialang.org/t/replace-missing-values-with-zeros-and-nonmissing-values-with-one-in-dataframe/53686/2 "2021-01-20T21:05:43Z")

</div>

```julia
nonmissing = .!ismissing.(df)

```