# How do delete a column from a freqtable?

**URL:** <https://discourse.julialang.org/t/how-do-delete-a-column-from-a-freqtable/42744>\
**Category:** General Usage\
**Created:** [July 8, 2020, 4:28pm UTC](https://discourse.julialang.org/t/how-do-delete-a-column-from-a-freqtable/42744 "2020-07-08T16:28:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julia1](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Julia1](https://discourse.julialang.org/u/Julia1)\
**Post date:** [July 8, 2020, 4:28pm UTC](https://discourse.julialang.org/t/how-do-delete-a-column-from-a-freqtable/42744/1 "2020-07-08T16:28:07Z")

</div>

Hi how’s it going?

I’m using freqtables as a pivot table in Julia, and essentially I want to drop certain columns that I don’t need after computing the freqtable. Here’s an example of a computation straight from the docs.

```julia
julia> using FreqTables
julia> x = repeat(["a", "b", "c", "d"], outer=[100]);
julia> y = repeat(["A", "B", "C", "D"], inner=[10], outer=[10]);

julia> freqtable(x, y)
4x4 NamedArrays.NamedArray{Int64,2,Array{Int64,2},Tuple{Dict{ASCIIString,Int64},Dict{ASCIIString,Int64}}}
Dim1 \ Dim2 A B C D 
a 30 20 30 20
b 30 20 30 20
c 20 30 20 30
d 20 30 20 30

```

Now imagine for some reason, I wanted to get rid of capital D from the freqtable columns, because the counts of capital D mean nothing in my use case.

How would I do so?

Thanks

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [July 8, 2020, 4:43pm UTC](https://discourse.julialang.org/t/how-do-delete-a-column-from-a-freqtable/42744/2 "2020-07-08T16:43:04Z")

</div>

```julia
using DataFrames # exports InvertedIndices.Not
t = freqtable(x, y)
s = t[:, Not("D")]

```

---

<div class="post-metadata">

**Author:** ![Julia1](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Julia1](https://discourse.julialang.org/u/Julia1)\
**Post date:** [July 8, 2020, 5:04pm UTC](https://discourse.julialang.org/t/how-do-delete-a-column-from-a-freqtable/42744/3 "2020-07-08T17:04:21Z")

</div>

thank you!