# How to get FreqTables to show all entries, not truncate?

**URL:** https://discourse.julialang.org/t/how-to-get-freqtables-to-show-all-entries-not-truncate/73322
**Category:** New to Julia
**Tags:** dataframes
**Created:** [December 19, 2021, 5:22am UTC](https://discourse.julialang.org/t/how-to-get-freqtables-to-show-all-entries-not-truncate/73322 "2021-12-19T05:22:01Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![samerb](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/samerb/32/9242_2.png) [@samerb](https://discourse.julialang.org/u/samerb)
#### Post date: [December 19, 2021, 5:22am UTC](https://discourse.julialang.org/t/how-to-get-freqtables-to-show-all-entries-not-truncate/73322/1 "2021-12-19T05:22:01Z")

</div>

```julia
N = 200
df_test = DataFrame(a = rand(1:30, N), b=rand(1:30, N))
freqtable(df_test, :a, :b)

```

This will truncate the middle values. I want to see the whole table. How can I?

```julia
30×30 Named Array{Int64,2}
a ╲ b │ 1 2 3 4 5 … 26 27 28 29 30
──────┼──────────────────────────────────────────
1 │ 0 0 0 0 0 … 0 0 1 0 0
2 │ 0 0 0 0 0 0 0 1 0 0
3 │ 0 0 0 0 0 0 0 0 0 1
4 │ 0 0 1 0 0 0 1 0 1 0
5 │ 0 0 0 0 0 0 0 0 0 0
6 │ 0 0 0 0 0 0 0 0 0 1
7 │ 2 0 1 0 1 0 1 0 0 0
8 │ 0 0 0 0 0 0 0 0 0 0
9 │ 1 0 0 1 0 1 1 0 0 0
10 │ 1 1 0 0 0 0 0 0 0 0
11 │ 0 0 1 0 1 0 0 1 0 1
⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋱ ⋮ ⋮ ⋮ ⋮ ⋮
20 │ 0 0 1 0 0 0 0 0 0 0
21 │ 1 0 0 2 0 1 2 0 0 0
22 │ 1 0 1 0 0 0 0 0 0 0
23 │ 0 1 0 0 0 0 0 0 0 0
24 │ 0 0 0 0 0 2 0 0 2 0
25 │ 0 0 0 0 0 0 0 1 0 0
26 │ 1 0 0 0 0 0 1 0 0 0
27 │ 0 0 1 1 0 0 0 0 0 1
28 │ 0 0 0 0 1 0 0 1 0 0
29 │ 0 0 0 0 1 0 0 0 0 0
30 │ 0 0 0 1 0 … 0 0 0 0 1

```

---

<div class="post-metadata">

### Author: ![oheil](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/oheil/32/220745_2.png) [@oheil](https://discourse.julialang.org/u/oheil)
#### Post date: [December 19, 2021, 10:26am UTC](https://discourse.julialang.org/t/how-to-get-freqtables-to-show-all-entries-not-truncate/73322/2 "2021-12-19T10:26:27Z")

</div>

You can do:

```julia
julia> show(freqtable(df_test, :a, :b))

```

But I like

```julia
julia> using TerminalPager

julia> pager(freqtable(df_test, :a, :b))

```
