Answers for "how to sort the column in pandas"

23

sort dataframe by column

df.sort_values(by='col1', ascending=False)
Posted by: Guest on April-30-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
3

sort df by column

df.rename(columns={1:'month'},inplace=True)
df['month'] = pd.Categorical(df['month'],categories=['December','November','October','September','August','July','June','May','April','March','February','January'],ordered=True)
df = df.sort_values('month',ascending=False)
Posted by: Guest on May-29-2020
-1

python dataframe sort by column name

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

Code answers related to "how to sort the column in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language