Dataframe table data in Julia can easily be cropped right with the column_width keyword of PrettyTables.jl. For some of my columns I need data cropped left or center. I used to do this in R with the str_trunc function from the stringr package. I could not find this functionality in Julia, did I over…

See here below a modification of the formatting function following your template. I added your ASCII example and also my previous unicode example with a mixed types dataframe. ▶ revised code

What happens if you use column_width together with alignment?

Thanks for quick reply. Alignment either :l or :r doesn’t change the right truncation.

Please check the following proposal (*edited): using DataFrames # function by @StefanKarpinski (https://discourse.julialang.org/t/truncate-string/27978/14) slice(s, n, m) = s[max(1, nextind(s, 0, n)):min(end, nextind(s, 0, m))] lstr(s) = slice(s, 1, colwidth) rstr(s) = slice(s, max(1, length(s) -…

Thanks a lot; almost there, I think Your suggestion df = DataFrame(strings = ["0123456789", join('a':'z'), "short"]) #= 3×1 DataFrame Row │ strings │ String ─────┼──────────────────────────── 1 │ 0123456789 2 │ abcdefghijklmnopqrstuvwxyz 3 │ short =# colwidth = 10 pretty_table(df, …

Note that in my edited post, I got rid of formatters because I could not find an option in PrettyTables.jl to apply them only to text columns when the dataframe is of mixed types. The code in the edited post looks for dataframe columns of type String and applies the formatting only to those. It use…

Thanks again. Two down, one to go, I think (the last one, cstr). Example#1 # I changed "..." to "…" in your str functions df = DataFrame(strings = ["0123456789", join('a':'z'), "short"]) #= 3×1 DataFrame Row │ strings │ String ─────┼──────────────────────────── 1 │ 0123456789 2 │ abcde…

Just ran your last revised code. Everything fine now, only the last sees the “short” string mysteriously duplicated: show(transform(df, textcols .=> ByRow(cstr); renamecols=false), alignment=:l, columns_width=colswidths) #= 3×1 DataFrame Row │ strings │ String ─────┼───────────…

[image] rafael.guerra: slice(s, n, m) = s[max(1, nextind(s, 0, n)):min(end, nextind(s, 0, m))] This should be replaced by a graphemes based slice, which is more appropriate (some codepoints combine to a single… grapheme). Rewriting the above is simple thanks to Unicode package: using Unicode…

Fixed in the revised code in post above .

Thanks, @rafael.guerra . For what it is worth, below an example how I now use this solution in my workflow. function tbk_trunc(trunc::Function, df::AbstractDataFrame, field::String, colwidth::Int64) transform(df, field .=> ByRow(trunc); renamecols=false) end @pipe first(tbk_triple(), 5) |> tbk_…

Cropping dataframe table data left or center

General Usage

rafael.guerra February 19, 2024, 2:26pm 14

Just in case, are you aware of the TerminalPager Julia package?

1 Like

Topic		Replies	Views
How to change the column width of a DataFrame General Usage question , dataframes	8	1805	April 26, 2021
DataFrames show() ignores column width, prints everything Data jupyter , dataframes	3	930	January 14, 2021
Print DataFrame the same way pandas print New to Julia question , dataframes , prettytables	7	596	June 25, 2022
PrettyTables; DataFrames: Combination Visualization dataframes , prettytables	3	920	November 30, 2019
Configure DataFrame show General Usage dataframes	5	2756	December 11, 2020

Cropping dataframe table data left or center

Related topics