# Delete row(s) of a dataframe based on dates in a vector

**URL:** https://discourse.julialang.org/t/delete-row-s-of-a-dataframe-based-on-dates-in-a-vector/87688
**Category:** New to Julia
**Created:** [September 23, 2022, 7:20am UTC](https://discourse.julialang.org/t/delete-row-s-of-a-dataframe-based-on-dates-in-a-vector/87688 "2022-09-23T07:20:32Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Nash](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nash/32/14482_2.png) [@Nash](https://discourse.julialang.org/u/Nash)
#### Post date: [September 23, 2022, 7:20am UTC](https://discourse.julialang.org/t/delete-row-s-of-a-dataframe-based-on-dates-in-a-vector/87688/1 "2022-09-23T07:20:32Z")

</div>

I have a dataframe where one of the columns contain many dates. In a vector, I have a few dates. How do I remove those rows of my dataframe where rows contain dates that are found in my vector?

---

<div class="post-metadata">

### Author: ![jar1](https://avatars.discourse-cdn.com/v4/letter/j/c0e974/32.png) [@jar1](https://discourse.julialang.org/u/jar1)
#### Post date: [September 23, 2022, 7:21am UTC](https://discourse.julialang.org/t/delete-row-s-of-a-dataframe-based-on-dates-in-a-vector/87688/2 "2022-09-23T07:21:57Z")

</div>

`filter(:dates => ∉(datesvector), df)`

---

<div class="post-metadata">

### Author: ![rocco\_sprmnt21](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rocco_sprmnt21/32/20127_2.png) [@rocco\_sprmnt21](https://discourse.julialang.org/u/rocco_sprmnt21)
#### Post date: [September 23, 2022, 11:23am UTC](https://discourse.julialang.org/t/delete-row-s-of-a-dataframe-based-on-dates-in-a-vector/87688/3 "2022-09-23T11:23:49Z")

</div>

You could use the `antijoin ()` function, defining a dataframe with the vector of dates to exclude.