I have a table like this: * A B C A 1 2 3 B 2 3 4 C 3 4 5 And I want to sort descending both on columns and rows after the sum something like this: * C B A S C 5 4 3 12 B 4 3 2 9 A 3 2 1 6 S 12 9 6 * How can I do that the simplest? thx.

As far as i know DataFrames does not have row names. It indexes rows from 1:n. [image] Rename a row in DataFrames? Data Is it possible to rename a row in DataFrames.jl? Currently it looks like rows are numbered by default 1:n. The function rename!() only changes column n…

I assume you do not want the "*" and "S" columns and do not want the last row in the output. In this case do: julia> df = DataFrame("A" => 1:3, "B" => 2:4, "C" => 3:5) 3×3 DataFrame Row │ A B C │ Int64 Int64 Int64 ─────┼───────────────────── 1 │ 1 2 3 2 │ 2…

julia> sort(sort(m,dims=1, by=sum, rev=true),dims=2,rev=true) 3×3 Matrix{Int64}: 5 4 3 4 3 2 3 2 1 using LinearAlgebra rot180(sort(sort(m,dims=1, by=sum),dims=2))

Thank you! Something like this but I need the column label too and the sum if is possible too.

That’s not the main problem I want to know after double sorting a label or index.

julia> using DataFrames julia> M=[1 2 3 ; 2 3 4 ; 3 4 5] 3×3 Matrix{Int64}: 1 2 3 2 3 4 3 4 5 julia> r=sum(M,dims=1) 1×3 Matrix{Int64}: 6 9 12 julia> l=sum(M,dims=2) 3×1 Matrix{Int64}: 6 9 12

I need to sort after the sum and to have the labels.

All is doable, can you confirm that this is the exact way how your input data frame looks like and how your ouput should look? (then I can give you information how to transform input into output) julia> input = DataFrame("*" => ["A", "B", "C"], "A" => 1:3, "B" => 2:4, "C" => 3:5) 3×4 DataFrame Row…

Yes the my problem has a table of over 1000x1000 with labels on raws and columns and I want to have in the top left corner the values that have the highest sums of absolute values. The initial table is matrix in Julia.

Here are the steps to do (I designed them so that they should be hopefully easy to grasp - I did not want to squeeze too much into one step): julia> input = DataFrame("*" => ["A", "B", "C"], "A" => 1:3, "B" => 2:4, "C" => 3:5) 3×4 DataFrame Row │ * A B C │ String Int64 Int64…

Sorting a Table / DataFrame

General Usage

raman_kumar September 3, 2023, 3:44am 2

As far as i know DataFrames does not have row names. It indexes rows from 1:n.

Topic		Replies	Views
Sort rows in a dataframe based on a predefined order New to Julia sort , dataframes	5	1926	September 17, 2021
Sort DataFrame by the greater of multiple columns New to Julia question , sort , dataframes	5	559	January 4, 2023
Ranking of Dataframe? New to Julia dataframes	8	1118	July 22, 2021
Sorting a DataFrame based on a multi-column function General Usage question	3	148	November 5, 2024
DataFrame group by first column, and sort by last column Data dataframes	4	1959	October 16, 2018

Sorting a Table / DataFrame

Related topics