sort database by column pandas code example
Example 1: 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)
Example 2: 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)