Sort a pandas dataframe series by month name

by

You can use categorical data to enable proper sorting with pd.Categorical:

months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", 
          "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]
df['months'] = pd.Categorical(df['months'], categories=months, ordered=True)
df.sort_values(...)  # same as you have now; can use inplace=True

When you specify the categories, pandas remembers the order of specification as the default sort order.

Docs: Pandas categories > sorting & order.

More Related Contents:

  1. Add missing dates to pandas dataframe
  2. how to sort pandas dataframe from one column
  3. Can pandas automatically read dates from a CSV file?
  4. Why does my Pandas DataFrame not display new order using `sort_values`?
  5. python/pandas: convert month int to month name
  6. Find the unique values in a column and then sort them
  7. Python – Delete duplicates in a dataframe based on two columns combinations?
  8. Convert month int to month name in Pandas
  9. Pandas DataFrame sort by categorical column but by specific class ordering
  10. Extracting dates that are in different formats using regex and sorting them – pandas
  11. Sorting by absolute value without changing the data
  12. How to sort pandas data frame using values from several columns?
  13. Multi Index Sorting in Pandas
  14. How to change the order of DataFrame columns?
  15. Pandas: sum DataFrame rows for given columns
  16. Pandas DataFrame: replace all values in a column, based on condition
  17. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  18. How to check if any value is NaN in a Pandas DataFrame
  19. Find the end of the month of a Pandas DataFrame Series
  20. How to remove square bracket from pandas dataframe
  21. Python Pandas update a dataframe value from another dataframe
  22. How can I replicate rows in Pandas?
  23. python dataframe pandas drop column using int
  24. How to create a DataFrame of random integers with Pandas?
  25. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  26. append dictionary to data frame
  27. Remove ends of string entries in pandas DataFrame column
  28. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  29. Convert dates to pd.to_datetime where month could be either a number or month name
  30. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it

Leave a Comment