# Avoid display all data

**URL:** <https://discourse.julialang.org/t/avoid-display-all-data/136914>\
**Category:** General Usage\
**Tags:** question\
**Created:** [April 29, 2026, 1:21am UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914 "2026-04-29T01:21:58Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 29, 2026, 1:21am UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/1 "2026-04-29T01:21:58Z")

</div>

Hi all,  
I am new with Julia my background is Stata and R, I am comparing different command and results. I wonder if exist some way to avoid display all database without ask for it.  
Its complicated when I load millions of observations.  
Maybe its my configuration??  
I am using SublimeRepl with Sublime text 4

Example:  
You can see that print all the rows and columns…

```julia-auto
using Random, CategoricalArrays, DataFrames
# Generate sample data
n = 1000
Random.seed!(06515)
df = DataFrame(
    y = randn(n),
    x1 = randn(n), 
    x2 = randn(n),
    group = categorical(rand(["A", "B", "C"], n)))

```

 ![Sin título](https://global.discourse-cdn.com/julialang/original/3X/b/f/bff733f021abe5b6df564a70a1f22a51402b9e62.png)

---

<div class="post-metadata">

**Author:** ![technocrat](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/technocrat/32/220947_2.png) [@technocrat](https://discourse.julialang.org/u/technocrat)\
**Post date:** [April 29, 2026, 2:56am UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/2 "2026-04-29T02:56:44Z")

</div>

`DataFrame` adjusts display dynamically depending on the size of the display window. For example

```julia-auto
julia> using CategoricalArrays

julia> using DataFrames

julia> using Random

julia> n = 1000
1000

julia> Random.seed!(06515)
TaskLocalRNG()

julia> df = DataFrame(
           y = randn(n),
           x1 = randn(n),
           x2 = randn(n),
           group = categorical(rand(["A", "B", "C"], n)))
1000×4 DataFrame
  Row │ y x1 x2 group
      │ Float64 Float64 Float64 Cat…
──────┼────────────────────────────────────────────
    1 │ -1.702 0.630715 0.615604 A
    2 │ -0.783141 3.32108 0.398537 A
    3 │ -1.12673 0.741291 1.0854 A
    4 │ -1.8922 -0.219293 0.275528 B
    5 │ 0.251435 -0.168469 -0.384072 B
    6 │ 1.32279 0.478072 -0.727269 C
    7 │ 0.0177961 0.50748 0.511304 A
    8 │ -0.00805389 1.32029 0.665092 B
    9 │ 1.07988 0.664838 1.24314 A
   10 │ 1.28176 1.24093 0.552596 A
   11 │ -1.56424 -1.1748 1.26912 C
   12 │ -0.101351 0.154412 0.245494 C
   13 │ 0.1592 -0.291401 -0.370051 B
   14 │ 0.305936 -1.95372 -1.67376 A
   15 │ -0.455743 0.960887 0.232676 A
   16 │ 1.46745 2.84029 0.278892 A
   17 │ 0.145784 0.186623 0.11497 A
   18 │ -1.04925 -0.494621 -0.182952 B
   19 │ -1.50332 -1.70582 -0.358066 B
   20 │ -0.725616 -0.0157264 -1.29976 B
   21 │ -0.453116 0.611136 -2.54458 A
   22 │ 0.435147 -1.11523 0.838568 C
  ⋮ │ ⋮ ⋮ ⋮ ⋮
  979 │ 1.73312 0.45741 -0.394642 C
  980 │ 0.297119 0.708152 -0.593984 A
  981 │ -1.97116 -0.199694 0.572518 C
  982 │ -1.80177 -0.294087 -0.627953 C
  983 │ -1.14641 1.70589 -1.05738 C
  984 │ -0.427469 0.199414 -1.53624 A
  985 │ 0.443345 -0.446598 1.06973 C
  986 │ 0.58093 -0.542177 0.709585 C
  987 │ -0.942309 -3.04805 -1.38662 C
  988 │ -0.317554 0.914196 0.283311 B
  989 │ 0.802619 -1.84786 0.607003 A
  990 │ 0.421096 -0.951215 0.382277 B
  991 │ -0.632904 -1.4118 -0.294012 A
  992 │ -0.260684 -0.526704 0.122641 B
  993 │ -0.452213 -1.35053 -1.18115 B
  994 │ -1.58226 0.420341 0.916672 B
  995 │ -1.39596 0.339323 -1.45384 C
  996 │ 1.36291 -1.30481 0.524041 B
  997 │ 0.847221 0.0251756 0.781781 B
  998 │ 1.21163 0.68933 0.0178197 A
  999 │ -2.82673 -0.784539 0.156953 C
 1000 │ 0.82131 -1.4174 -0.391486 B
                                   956 rows omitted

julia>

```

and

```julia-auto
julia> using CategoricalArrays

julia> using DataFrames

julia> using Random

julia> n = 1000
1000

julia> Random.seed!(06515)
TaskLocalRNG()

julia> df = DataFrame(
           y = randn(n),
           x1 = randn(n),
           x2 = randn(n),
           group = categorical(rand(["A", "B", "C"], n)))
1000×4 DataFrame
  Row │ y x1 x2 group
      │ Float64 Float64 Float64 Cat…
──────┼─────────────────────────────────────────────
    1 │ -1.702 0.630715 0.615604 A
    2 │ -0.783141 3.32108 0.398537 A
    3 │ -1.12673 0.741291 1.0854 A
    4 │ -1.8922 -0.219293 0.275528 B
    5 │ 0.251435 -0.168469 -0.384072 B
    6 │ 1.32279 0.478072 -0.727269 C
    7 │ 0.0177961 0.50748 0.511304 A
    8 │ -0.00805389 1.32029 0.665092 B
    9 │ 1.07988 0.664838 1.24314 A
   10 │ 1.28176 1.24093 0.552596 A
   11 │ -1.56424 -1.1748 1.26912 C
   12 │ -0.101351 0.154412 0.245494 C
   13 │ 0.1592 -0.291401 -0.370051 B
   14 │ 0.305936 -1.95372 -1.67376 A
   15 │ -0.455743 0.960887 0.232676 A
   16 │ 1.46745 2.84029 0.278892 A
   17 │ 0.145784 0.186623 0.11497 A
   18 │ -1.04925 -0.494621 -0.182952 B
   19 │ -1.50332 -1.70582 -0.358066 B
   20 │ -0.725616 -0.0157264 -1.29976 B
   21 │ -0.453116 0.611136 -2.54458 A
   22 │ 0.435147 -1.11523 0.838568 C
   23 │ 0.501289 1.24776 0.647895 B
   24 │ 0.402811 0.801254 1.27738 C
   25 │ 0.211726 1.60119 -1.38694 B
   26 │ -1.20796 -1.26969 1.2001 B
   27 │ 0.177459 0.00575822 0.159947 C
   28 │ 0.738264 -0.495383 -1.40506 B
   29 │ -0.252979 -0.769827 0.527035 C
   30 │ 0.266908 -0.246113 -0.827958 C
   31 │ 0.0444857 0.0742844 -0.331827 C
  ⋮ │ ⋮ ⋮ ⋮ ⋮
  971 │ -1.92257 -0.65397 -1.2593 B
  972 │ -0.725117 -1.08739 -0.105488 A
  973 │ -0.467188 0.420613 -0.485866 C
  974 │ -0.791398 0.910714 -0.944314 B
  975 │ -1.43344 0.891557 0.39844 A
  976 │ -0.681357 -0.806813 2.01171 A
  977 │ -1.41441 -1.57139 -0.260637 C
  978 │ -0.420314 0.455886 -0.698848 A
  979 │ 1.73312 0.45741 -0.394642 C
  980 │ 0.297119 0.708152 -0.593984 A
  981 │ -1.97116 -0.199694 0.572518 C
  982 │ -1.80177 -0.294087 -0.627953 C
  983 │ -1.14641 1.70589 -1.05738 C
  984 │ -0.427469 0.199414 -1.53624 A
  985 │ 0.443345 -0.446598 1.06973 C
  986 │ 0.58093 -0.542177 0.709585 C
  987 │ -0.942309 -3.04805 -1.38662 C
  988 │ -0.317554 0.914196 0.283311 B
  989 │ 0.802619 -1.84786 0.607003 A
  990 │ 0.421096 -0.951215 0.382277 B
  991 │ -0.632904 -1.4118 -0.294012 A
  992 │ -0.260684 -0.526704 0.122641 B
  993 │ -0.452213 -1.35053 -1.18115 B
  994 │ -1.58226 0.420341 0.916672 B
  995 │ -1.39596 0.339323 -1.45384 C
  996 │ 1.36291 -1.30481 0.524041 B
  997 │ 0.847221 0.0251756 0.781781 B
  998 │ 1.21163 0.68933 0.0178197 A
  999 │ -2.82673 -0.784539 0.156953 C
 1000 │ 0.82131 -1.4174 -0.391486 B
                                    939 rows omitted

```

are from the same terminal REPL session with the first having a smaller display than the second. I haven’t used `Julia` within `Sublime` so I don’t know how it differs from the REPL.

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 29, 2026, 3:22am UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/3 "2026-04-29T03:22:08Z")

</div>

Thanks for you reply.  
I have your same result using Julia default Repl.  
I am trying to change some configuration of my setup but i failed…  
I use the same configuration with R and Sublime Repl for 10 year and never had this issue  
Anyway I am still work in that.  
Regards

---

<div class="post-metadata">

**Author:** ![Sevi](https://avatars.discourse-cdn.com/v4/letter/s/c67d28/32.png) [@Sevi](https://discourse.julialang.org/u/Sevi)\
**Post date:** [April 29, 2026, 9:01am UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/4 "2026-04-29T09:01:12Z")

</div>

What do you get when you run this in Sublime?

```julia
get(stdout, :limit, "no default value")

```

It looks like the `show` function for Dataframes (which is called internally within `display` which is called when the Dataframe is shown in the REPL), checks whether the output should be limited or not by checking the above property. See also here:

> <https://github.com/JuliaData/DataFrames.jl/blob/e0963d4c4239f53609dd67896680cc7ad66785cd/src/abstractdataframe/show.jl#L412>

If `stdout[:limit]` is `false` for the Sublime REPL then that would be the issue I think. If `:limit` is `true` or if there is no default value (that’s the case in my standard terminal REPL) then the issue might be one level higher at the `display` function and the type of output the Sublime REPL implements (perhaps the `io` is not `stdout`)?

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 29, 2026, 1:49pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/5 "2026-04-29T13:49:30Z")

</div>

Thanks Sevi for your reply.  
In Sublime I got:

“no default value”

I will check the information that you sent.  
I change all the settings of SublimeRepl but i get the same Issue

---

<div class="post-metadata">

**Author:** ![mikmoore](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mikmoore/32/31109_2.png) [@mikmoore](https://discourse.julialang.org/u/mikmoore)\
**Post date:** [April 29, 2026, 1:52pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/6 "2026-04-29T13:52:12Z")

</div>

If you want it to display _just a little,_ see the above responses.

If you don’t need it to print _anything at all,_ know that when you `include` a file in the REPL (or possibly “run” it from an editor REPL, depends on the editor), it will `display` the last “result” of the file, in this case your `df = ...` line. If you don’t want that printout, you can add `nothing` as the last line of your file. `nothing` prints as a blank.

If you or the editor are pasting the results to the REPL one at a time (possible but doubtful), you can add a `;` to the ends of the lines. Lines ending in `;` in the REPL do not `display` their result.

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 29, 2026, 2:32pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/7 "2026-04-29T14:32:38Z")

</div>

Finally i use nothing and work great, I have some issues with margins predictions and how display results from linear mixed model but i hope solve later  
Thanks all for your time

```julia-auto
using DataFrames, Random,MixedModels,CategoricalArrays,RegressionTables, MixedModelsDatasets, GLM

using Random, CategoricalArrays, DataFrames

# Generate sample data
n = 1000
Random.seed!(06515)

begin
    df = DataFrame(y = randn(n), 
           x1 = randn(n), 
           x2 = randn(n), 
           group = categorical(rand(["A", "B", "C"], n)))
          nothing
end

lmod = @time lmm(@formula(y ~ x1+ x2+x1 & x2+ (1|group)), df)
coeftable(lmod)

```

 ![Sin título](https://global.discourse-cdn.com/julialang/original/3X/4/f/4fa77ddf83197086e9467f3c8d31301ed2eceb57.png)

---

<div class="post-metadata">

**Author:** ![mahmah](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mahmah/32/214326_2.png) [@mahmah](https://discourse.julialang.org/u/mahmah)\
**Post date:** [April 29, 2026, 7:30pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/8 "2026-04-29T19:30:10Z")

</div>

@Rodrigo , there is a much simpler solution: a semicolon. This will suppress output in the REPL:

```julia-auto
df = DataFrame(
           y = randn(n),
           x1 = randn(n), 
           x2 = randn(n),
           group = categorical(rand(["A", "B", "C"], n)));

```

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 29, 2026, 8:52pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/9 "2026-04-29T20:52:43Z")

</div>

@mahmah Thanks, I tried but semicolon dont work for me.

The only solution that I got was that.

---

<div class="post-metadata">

**Author:** ![mahmah](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mahmah/32/214326_2.png) [@mahmah](https://discourse.julialang.org/u/mahmah)\
**Post date:** [April 30, 2026, 1:51pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/10 "2026-04-30T13:51:20Z")

</div>

Could you post a screenshot? A semicolon should supress the output of a data frame.

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 30, 2026, 2:04pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/11 "2026-04-30T14:04:42Z")

</div>

Hi @mahmah

I have to remark that I am using SublimeRepl, not the Julia default Repl.

Using semicolon display all rows and columns

 ![Sin título](https://global.discourse-cdn.com/julialang/original/3X/f/6/f6ca3ac850e5efc7c2b87b392a9b4ee731bb93ec.png)

---

<div class="post-metadata">

**Author:** ![mahmah](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mahmah/32/214326_2.png) [@mahmah](https://discourse.julialang.org/u/mahmah)\
**Post date:** [April 30, 2026, 3:00pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/12 "2026-04-30T15:00:51Z")

</div>

That’s so strange!

---

<div class="post-metadata">

**Author:** ![Rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@Rodrigo](https://discourse.julialang.org/u/Rodrigo)\
**Post date:** [April 30, 2026, 3:05pm UTC](https://discourse.julialang.org/t/avoid-display-all-data/136914/13 "2026-04-30T15:05:12Z")

</div>

@mahmah

When I use Stata integration with Julia, Semicolon work perfect.

 ![stata1](https://global.discourse-cdn.com/julialang/original/3X/8/5/85a77a8926d4081d18a13968712bb8d4c1151282.png)