# Most efficient way to delete row without memory consuming

**URL:** <https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157>\
**Category:** New to Julia\
**Created:** [June 10, 2020, 6:24pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157 "2020-06-10T18:24:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)\
**Post date:** [June 10, 2020, 6:24pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157/1 "2020-06-10T18:24:21Z")

</div>

Would you suggest, how to delete row without consuming memory?

I try the code but have not enough memory error.

```julia

df = df[df.cl!=1,:]

```

thank you in advance!

---

<div class="post-metadata">

**Author:** ![stillyslalom](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/stillyslalom/32/45687_2.png) [@stillyslalom](https://discourse.julialang.org/u/stillyslalom)\
**Post date:** [June 10, 2020, 10:17pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157/2 "2020-06-10T22:17:36Z")

</div>

```julia
julia> df = DataFrame(cl = rand(1:3, 10))
10×1 DataFrame
│ Row │ cl │
│ │ Int64 │
├─────┼───────┤
│ 1 │ 1 │
│ 2 │ 3 │
│ 3 │ 1 │
│ 4 │ 3 │
│ 5 │ 3 │
│ 6 │ 2 │
│ 7 │ 2 │
│ 8 │ 1 │
│ 9 │ 2 │
│ 10 │ 2 │

julia> delete!(df, df.cl .== 1)
7×1 DataFrame
│ Row │ cl │
│ │ Int64 │
├─────┼───────┤
│ 1 │ 3 │
│ 2 │ 3 │
│ 3 │ 3 │
│ 4 │ 2 │
│ 5 │ 2 │
│ 6 │ 2 │
│ 7 │ 2 │

```

---

<div class="post-metadata">

**Author:** ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)\
**Post date:** [June 10, 2020, 10:35pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157/4 "2020-06-10T22:35:23Z")

</div>

What version of Julia and DataFrame do you use?  
I have error `delete!(df1, df1.cl .== 1)`

---

<div class="post-metadata">

**Author:** ![stillyslalom](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/stillyslalom/32/45687_2.png) [@stillyslalom](https://discourse.julialang.org/u/stillyslalom)\
**Post date:** [June 10, 2020, 11:05pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157/5 "2020-06-10T23:05:12Z")

</div>

```julia
(@v1.4) pkg> st DataFrames
Status `C:\Users\Alex\.julia\environments\v1.4\Project.toml`
  [a93c6f00] DataFrames v0.21.2

```

Have you tried updating DataFrames?

---

<div class="post-metadata">

**Author:** ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)\
**Post date:** [June 10, 2020, 11:31pm UTC](https://discourse.julialang.org/t/most-efficient-way-to-delete-row-without-memory-consuming/41157/6 "2020-06-10T23:31:44Z")

</div>

> [@stillyslalom](#):
>
> `st DataFrames`

I’ve update. Now it works! Thank you