Answers for "sorting a dataframe by a column"

23

sort dataframe by column

df.sort_values(by='col1', ascending=False)
Posted by: Guest on April-30-2020
12

sorting by column in pandas

# Python, Pandas
# Sorting dataframe df on the values of a column col1

# Return sorted array without modifying the original one
df.sort_values(by=["col1"]) 

# Sort the original array permanently
df.sort_values(by=["col1"], inplace = True)
Posted by: Guest on April-08-2020
5

how to sort in pandas

// Single sort 
>>> df.sort_values(by=['col1'],ascending=False)
// ascending => [False(reverse order) & True(default)]
// Multiple Sort
>>> df.sort_values(by=['col1','col2'],ascending=[True,False])
// with apply() 
>>> df[['col1','col2']].apply(sorted,axis=1)
// axis = [1 & 0], 1 = 'columns', 0 = 'index'
Posted by: Guest on July-06-2020
-1

dataframe sort by column

sorted = df.sort_values('column-to-sort-on', ascending=False)
#or
df.sort_values('name', inplace=True)
Posted by: Guest on May-13-2020
-1

python dataframe sort by column name

>>> result = df.sort(['A', 'B'], ascending=[1, 0])
Posted by: Guest on November-19-2020
0

python df pandas sort by column

>>> df.sort_values("city08")
    city08  cylinders fuelType  ...  mpgData            trany  year
99       9          8  Premium  ...        N  Automatic 4-spd  1993
1        9         12  Regular  ...        N     Manual 5-spd  1985
80       9          8  Regular  ...        N  Automatic 3-spd  1985
47       9          8  Regular  ...        N  Automatic 3-spd  1985
3       10          8  Regular  ...        N  Automatic 3-spd  1985
..     ...        ...      ...  ...      ...              ...   ...
9       23          4  Regular  ...        Y  Automatic 4-spd  1993
8       23          4  Regular  ...        Y     Manual 5-spd  1993
7       23          4  Regular  ...        Y  Automatic 3-spd  1993
76      23          4  Regular  ...        Y     Manual 5-spd  1993
2       23          4  Regular  ...        Y     Manual 5-spd  1985
[100 rows x 10 columns]
Posted by: Guest on September-27-2021

Code answers related to "sorting a dataframe by a column"

Python Answers by Framework

Browse Popular Code Answers by Language