The output of showall looks nasty in a HTML capable display like Jupyter or Weave, so instead you can use the LINES environment variable to increase the displayed row count.

using DataFrames

df = DataFrame(A = rand(Int, 100), B = rand(Int, 100))

withenv("LINES" => 20) do
    display(df)
end

There is also a COLUMNS var, see the displaysize function help.

AFAICT to disable the limit altogether you need to change the display context which gets a bit messy and is just generally inadvisable, but here it is anyway

io = IOBuffer()
ioctx = IOContext(io, :limit => false)
show(ioctx, MIME("text/html"), df)
HTML(String(take!(io)))
Answer from Richard Palethorpe on Stack Overflow
🌐
Machine Learning Plus
machinelearningplus.com β€Ί blog β€Ί dataframes in julia
DataFrames in Julia - machinelearningplus
March 8, 2022 - By default, Julia doesn’t print ... if you want to see all the rows and columns, it’s possible using show() function with allrows & allcols arguments....
🌐
Juliadata
dataframes.juliadata.org β€Ί stable β€Ί man β€Ί working_with_dataframes
Working with DataFrames Β· DataFrames.jl
Printing options can be adjusted by calling the show function manually: show(df, allrows=true) prints all rows even if they do not fit on screen and show(df, allcols=true) does the same for columns. The first and last functions can be used to look at the first and last rows of a data frame ...
🌐
Juliadata
dataframes.juliadata.org β€Ί stable β€Ί man β€Ί getting_started
Getting Started Β· DataFrames.jl
You can override this behavior by changing the values of the ENV["DATAFRAMES_COLUMNS"] and ENV["DATAFRAMES_ROWS"] variables to hold the maximum number of columns and rows of the output. All columns or rows will be printed if those numbers are equal or lower than 0. Alternatively, you may want to set the maximum number of data frame rows to print to 100 and the maximum number of columns to print to 1000 for every Julia session using some Jupyter kernel file (numbers 100 and 1000 are only examples and can be adjusted).
🌐
JuliaHub
docs.juliahub.com β€Ί DataFrames β€Ί AR9oZ β€Ί 0.21.6 β€Ί man β€Ί getting_started
Getting Started Β· DataFrames.jl
Printing options can be adjusted by calling the show function manually: show(df, allrows=true) prints all rows even if they do not fit on screen and show(df, allcols=true) does the same for columns. The first and last functions can be used to look at the first and last rows of a data frame ...
🌐
GitHub
github.com β€Ί JuliaLang β€Ί julia β€Ί issues β€Ί 29223
Provide a simple way to print all entries in a collection Β· Issue #29223 Β· JuliaLang/julia
September 17, 2018 - For example, if one wants to get all the column names in a table/data frame. show(x) prints a vector in full, but the entries are not aligned, making it quite painful to read on most terminals: julia> show(string.("col", 1:50)) ["col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", " col11", "col12", "col13", "col14", "col15", "col16", "col17", "col18", "col19", "co l20", "col21", "col22", "col23", "col24", "col25", "col26", "col27", "col28", "col2 9", "col30", "col31", "col32", "col33", "col34", "col35", "col36", "col37", "col38" , "col39", "col40", "col41", "col42", "col43", "col44", "col45", "col46", "col47", "col48", "col49", "col50"]
Author Β  nalimilan
🌐
GitHub
github.com β€Ί JuliaData β€Ί DataFrames.jl β€Ί issues β€Ί 886
Select number of rows to be displayed in a DataFrame Β· Issue #886 Β· JuliaData/DataFrames.jl
September 17, 2018 - I asked about this on julia-users but I haven't received a response. To put it simply, is there an equivalent to pandas.set_option('display.max_rows', 500) in order to control the number of displayed rows in a DataFrame? Currently, we have a summary that shows the first and last rows and that's okay, but sometimes you want to see more rows, particularly when the DataFrame is not very large.
Author Β  ghost
Find elsewhere
🌐
Julia Programming Language
discourse.julialang.org β€Ί general usage
Configure DataFrame show - General Usage - Julia Programming Language
December 10, 2020 - I need a way to configure the show method of DataFrames.jl. I have in the past hacked the show method for the DataFrames type using internal DataFrames API. But of course this breaks when an update comes along. What I would like is to globally do the following: specify the number of rows printed ...
🌐
Julia Programming Language
discourse.julialang.org β€Ί general usage
DataFrames: display in a Jupyter notebook - General Usage - Julia Programming Language
May 20, 2019 - I’d like to display all 9 columns of a DataFrame in Jupyter notebook, but the system decides to omit the 2 rightmost columns because it thinks there is a lack of space. I know I can show all columns with the show(datafr…
🌐
GitHub
github.com β€Ί JuliaData β€Ί DataFrames.jl β€Ί blob β€Ί main β€Ί docs β€Ί src β€Ί man β€Ί basics.md
DataFrames.jl/docs/src/man/basics.md at main Β· JuliaData/DataFrames.jl
As you can see the data frame is wider and taller than the display width, so it got cropped and its 4 rightmost columns and middle 985 rows were not printed. Later in the tutorial we will discuss how to force Julia to show the whole data frame if we wanted so. Also observe that DataFrames.jl displays the data type of the column below its name.
Author Β  JuliaData
🌐
GeeksforGeeks
geeksforgeeks.org β€Ί julia β€Ί working-with-dataframes-in-julia
Working with DataFrames in Julia - GeeksforGeeks
July 15, 2025 - We will be using the data frame ... few rows you can use the first(DataFrame, rows) or last(DataFrame, rows) functions respectively where 'rows' represent the number of rows you want to access....
🌐
Educative
educative.io β€Ί answers β€Ί how-to-get-the-number-of-rows-in-a-dataframe-in-julia
How to get the number of rows in a DataFrame in Julia
There are two ways to obtain the ... in Julia. ... The nrow() function obtains the total number of rows present. ... Line 1: Imports DataFrames for use. Lines 2–5: Creates a DataFrame with five rows.
🌐
GitHub
github.com β€Ί fonsp β€Ί Pluto.jl β€Ί issues β€Ί 292
Display DataFrame with more than 18 rows/columns Β· Issue #292 Β· JuliaPluto/Pluto.jl
August 14, 2020 - using DataFrames ENV["COLUMNS"]=1000 ENV["LINES"] = 50 # method that works in REPL / IJulia, but seems to have no effect in Pluto # https://juliadata.github.io/DataFrames.jl/stable/man/getting_started/#Installation df = hcat([DataFrame(a=1:30, b=2:31) for _ in 1:10]..., makeunique=true) # only 18 rows and 18 columns are displayed (the df size is 30x20) show(df, allrows=true, allcols=true) # prints on the server side, but not in the notebook Β·
Author Β  lungben
🌐
Google Groups
groups.google.com β€Ί d β€Ί topic β€Ί julia-users β€Ί mlbkeNcschg
how to print out part of a row in DataFrame?
June 9, 2014 - Can I get a printout of the values just as I print out a row of an array? julia> println(df[jj, 1:20]) 1x20 DataFrame |-------|------|--------|---------| | Col # | Name | Eltype | Missing | | 1 | x1 | Int64 | 0 | | 2 | x2 | Int64 | 0 | | 3 | x3 | Int64 | 0 | | 4 | x4 | Int64 | 0 | | 5 | x5 | Int64 | 0 | | 6 | x6 | Int64 | 0 | | 7 | x7 | Int64 | 0 | | 8 | x8 | Int64 | 0 | | 9 | x9 | Int64 | 0 | | 10 | x10 | Int64 | 0 | | 11 | x11 | Int64 | 0 | | 12 | x12 | Int64 | 0 | | 13 | x13 | Int64 | 0 | | 14 | x14 | Int64 | 0 | | 15 | x15 | Int64 | 0 | | 16 | x16 | Int64 | 0 | | 17 | x17 | Int64 | 0 | | 18 | x18 | Int64 | 0 | | 19 | x19 | Int64 | 0 | | 20 | x20 | Int64 | 0 |
Top answer
1 of 1
8

Selecting a single row from a data frame returns a DataFrameRow, which is a view of the row in the original data frame. So any changes you make to the DataFrameRow will be reflected in the original data frame:

julia> using DataFrames

julia> df = DataFrame(a=1:3, b=4:6)
3Γ—2 DataFrame
β”‚ Row β”‚ a     β”‚ b     β”‚
β”‚     β”‚ Int64 β”‚ Int64 β”‚
β”œβ”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1   β”‚ 1     β”‚ 4     β”‚
β”‚ 2   β”‚ 2     β”‚ 5     β”‚
β”‚ 3   β”‚ 3     β”‚ 6     β”‚

julia> dfr = df[2, :]
DataFrameRow
β”‚ Row β”‚ a     β”‚ b     β”‚
β”‚     β”‚ Int64 β”‚ Int64 β”‚
β”œβ”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 2   β”‚ 2     β”‚ 5     β”‚

julia> dfr.b = 100
100

julia> df
3Γ—2 DataFrame
β”‚ Row β”‚ a     β”‚ b     β”‚
β”‚     β”‚ Int64 β”‚ Int64 β”‚
β”œβ”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1   β”‚ 1     β”‚ 4     β”‚
β”‚ 2   β”‚ 2     β”‚ 100   β”‚
β”‚ 3   β”‚ 3     β”‚ 6     β”‚

Of course, if you just want to change the values of a few entries in a row, you can do that directly without having to first create a DataFrameRow:

julia> df = DataFrame(a=1:3, b=4:6)
3Γ—2 DataFrame
β”‚ Row β”‚ a     β”‚ b     β”‚
β”‚     β”‚ Int64 β”‚ Int64 β”‚
β”œβ”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1   β”‚ 1     β”‚ 4     β”‚
β”‚ 2   β”‚ 2     β”‚ 5     β”‚
β”‚ 3   β”‚ 3     β”‚ 6     β”‚

julia> df[2, :] = [101, 102]
2-element Array{Int64,1}:
 101
 102

julia> df
3Γ—2 DataFrame
β”‚ Row β”‚ a     β”‚ b     β”‚
β”‚     β”‚ Int64 β”‚ Int64 β”‚
β”œβ”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1   β”‚ 1     β”‚ 4     β”‚
β”‚ 2   β”‚ 101   β”‚ 102   β”‚
β”‚ 3   β”‚ 3     β”‚ 6     β”‚