Breaking News: Grepper is joining You.com. Read the official announcement!

pandas sort by multiple columns

Add Answer

Testy Turtle answered on August 5, 2020 Popularity 9/10 Helpfulness 4/10

answer pandas sort by multiple columns

related sort by two columns in pandas

related pandas sort by multiple columns

related Sort an array on multiple columns

pandas sort by multiple columns

Comment

In [11]: df1 = pd.DataFrame(np.random.randint(1, 5, (10,2)), columns=['a','b'])

In [12]: df1.sort(['a', 'b'], ascending=[True, False])
Out[12]:
   a  b
2  1  4
7  1  3
1  1  2
3  1  2
4  3  2
6  4  4
0  4  3
9  4  3
5  4  1
8  4  1

Popularity 9/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: multiple-columns pandas python

Link to this answer
Share Copy Link

Contributed on Feb 26 2023

Testy Turtle

0 Answers Avg Quality 2/10

Closely Related Answers

sort by two columns in pandas

Comment

df.sort_values(['a', 'b'], ascending=[True, False])

Popularity 10/10 Helpfulness 10/10 Language python

Source: Grepper

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Aug 05 2020

Sachin

0 Answers Avg Quality 2/10

pandas sort by multiple columns

Comment

# Below are quick example
# Sort multiple columns
df2 = df.sort_values(['Fee', 'Duration'],
              ascending = [False, True])

# Sort by two columns 
df2 = df.sort_values(['Courses', 'Discount'],
              ascending = [True, True])

# Using the sorting function
df.sort_values(["Fee", "Courses"],
               axis = 0, ascending = True,
               inplace = True,
               na_position = "first")

Popularity 9/10 Helpfulness 6/10 Language python

Source: sparkbyexamples.com

Tags: multiple-columns mult

Link to this answer
Share Copy Link

Contributed on Feb 25 2023

Testy Turtle

0 Answers Avg Quality 2/10

Sort an array on multiple columns

Comment

function sort_Function() {//Sort an array on multiple columns
  
    var array = [
        [0, 'Aluminium', 'z', 'Francis'],
        [1, 'Argon', 'x', 'Ada'],
        [2, 'Brom', 'x', 'John'],
        [3, 'Cadmium', 3, 'Marie'],
        [4, 'Fluor', 'x', 'Marie'],
        [5, 'Gold', 'x', 'Ada'],
        [6, 'Kupfer', 1, 'Ines'],
        [7, 'Krypton', 'x', 'Joe'],
        [8, 'Sauerstoff', 'x', 'Marie'],
        [9, 'Zink', 2, 'Max']
    ];

    array.sort(function (a, b) {
        return a[2].toString() .localeCompare(b[2].toString()) || a[1].localeCompare(b[1]);//has to be string to compare
    });

      console.log(array);

}//end function

Popularity 9/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on Aug 13 2022

Poor Polecat

0 Answers Avg Quality 2/10

pandas sort by multiple columns

Contents

More Related Answers

pandas sort by multiple columns

Closely Related Answers

sort by two columns in pandas

pandas sort by multiple columns

Sort an array on multiple columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.