1. Home
  2. Python

Sort df by column

Code examples

26
0

sort a dataframe by a column valuepython 

>>> df.sort_values(by=['col1'])
    col1 col2 col3
0   A    2    0
1   A    1    1
2   B    9    9
5   C    4    3
4   D    7    2
3   NaN  8    4
12
0

sort dataframe by column 

df.sort_values(by='col1', ascending=False)
10
0

sorting by column in pandas 

#Python, Pandas
#Sorting dataframe df on the values of a column col1
#Temporary
df.sort_values(by=["col1"]) 

#Permanent
df.sort_values(by=["col1"], inplace = True)
3
0

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'
2
0

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)
2
0

sort by dataframe 

DataFrame.sort_values(self, by, axis=0, ascending=True,
                      inplace=False, kind='quicksort',
                      na_position='last',
                      ignore_index=False)

# Example
df.sort_values(by=['ColToSortBy'])

Similar pages

Similar pages with examples

sort df by column
sort by dataframe
sort column pandas
sort dataframe by column
pandas sort dataframe by column
sort a dataframe by a column valuepython
sorting by column in pandas
sort values pandas
dataframe sort by column
python sort dataframe by one column
order pandas dataframe by column values
sort a dataframe
pandas order dataframe by column of other dataframe
pandas reorder columns

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

pandas dataframe replace inf
displaying full columns in pandas
dataframe sort by column
how to get dictionary values in python
how to get value in dictionary python
dict python get value
how to get the values in a dictionary python
python get value in dictionary
dictionary.get in python
python get values of dict
how to get the key and value from dict in py
getting value from a dictionary in python
get value key python
how to get the value from dictionary in python
return a value from dictionary
get key using value from dictionary python