# Deleting coordinates from sparse array

**URL:** <https://forum.tiledb.com/t/deleting-coordinates-from-sparse-array/548>\
**Category:** Uncategorized\
**Created:** [March 14, 2023, 8:11pm UTC](https://forum.tiledb.com/t/deleting-coordinates-from-sparse-array/548 "2023-03-14T20:11:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdylan2](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/mdylan2/32/250_2.png) [@mdylan2](https://forum.tiledb.com/u/mdylan2)\
**Post date:** [March 14, 2023, 8:11pm UTC](https://forum.tiledb.com/t/deleting-coordinates-from-sparse-array/548/1 "2023-03-14T20:11:41Z")

</div>

Hey, is there any way to delete coordinates from a sparse array?

I noticed there is a “delete” mode on the docs - is that for the entire array or can I specify a sub-array?

Asking because I get junk values when I run:

```auto
with tiledb.open(uri,'r') as f:
     f.df[:]

```

---

<div class="post-metadata">

**Author:** ![ihnorton](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/ihnorton/32/23_2.png) [@ihnorton](https://forum.tiledb.com/u/ihnorton)\
**Post date:** [March 15, 2023, 7:23pm UTC](https://forum.tiledb.com/t/deleting-coordinates-from-sparse-array/548/2 "2023-03-15T19:23:41Z")

</div>

Hi @mdylan2,

Deletes work on dimension or attribute values that match a query condition. Here’s an example:

```auto
import tiledb, numpy as np
import tempfile
from numpy.testing import assert_array_equal

path = tempfile.mkdtemp("example_sparse_coord_delete")
print(path)

dom = tiledb.Domain(tiledb.Dim(name="x", domain=(1, 10), tile=1, dtype=np.uint32))
attrs = [tiledb.Attr("ints", dtype=np.uint32)]
schema = tiledb.ArraySchema(domain=dom, attrs=attrs, sparse=True)
tiledb.Array.create(path, schema)

data = np.random.randint(1, 10, 10)

qc = "x < 5"

with tiledb.open(path, "w") as A:
    A[np.arange(1, 11)] = data

with tiledb.open(path, "d") as A:
    A.query(cond=qc).submit()

with tiledb.open(path, "r") as A:
    print(A[:])

```

You could similarly use `"ints < 5"`, or other conditions on the attribute value instead.

Hope this helps,  
Isaiah

---

<div class="post-metadata">

**Author:** ![mdylan2](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/mdylan2/32/250_2.png) [@mdylan2](https://forum.tiledb.com/u/mdylan2)\
**Post date:** [March 21, 2023, 5:52pm UTC](https://forum.tiledb.com/t/deleting-coordinates-from-sparse-array/548/3 "2023-03-21T17:52:28Z")

</div>

thank you! @ihnorton
