Pandas rank by multiple columns

by

The generic way to do that is to group the desired fiels in a tuple, whatever the types.

df["Rank"] = df[["SaleCount","TotalRevenue"]].apply(tuple,axis=1)\
             .rank(method='dense',ascending=False).astype(int)

df.sort_values("Rank")

   TotalRevenue        Date  SaleCount shops  Rank
1          9000  2016-12-02        100    S2     1
5          2000  2016-12-02        100    S8     2
3           750  2016-12-02         35    S5     3
2          1000  2016-12-02         30    S1     4
7           600  2016-12-02         30    S7     5
4           500  2016-12-02         20    S4     6
9           500  2016-12-02         20   S10     6
0           300  2016-12-02         10    S3     7
8            50  2016-12-02          2    S9     8
6             0  2016-12-02          0    S6     9

More Related Contents:

  1. Pandas number rows within group in increasing order
  2. Number rows within group in increasing order in a pandas dataframe
  3. How to provide a reproducible copy of your DataFrame with to_clipboard()
  4. Pandas groupby with delimiter join
  5. How to plot multiple Seaborn Jointplot in Subplot
  6. pandas: merge (join) two data frames on multiple columns
  7. Pandas Extract Number from String
  8. Calculate average of every x rows in a table and create new table
  9. Conditionally fill column values based on another columns value in pandas
  10. No module named ‘pandas._libs.tslibs.timedeltas’ in PyInstaller
  11. append dataframe to excel with pandas
  12. what are all the dtypes that pandas recognizes?
  13. matplotlib: plot multiple columns of pandas data frame on the bar chart
  14. How to translate “bytes” objects into literal strings in pandas Dataframe, Python3.x?
  15. How can I see the formulas of an excel spreadsheet in pandas / python?
  16. Python pandas: remove everything after a delimiter in a string
  17. How to remove or hide x-axis labels from a seaborn / matplotlib plot
  18. Unpack dictionary from Pandas Column
  19. Remove NaN ‘Cells’ without dropping the entire ROW (Pandas,Python3)
  20. python pandas read_csv delimiter in column data
  21. Showing all index values when using multiIndexing in Pandas
  22. How to change the plot order of the categorical x-axis
  23. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  24. append dictionary to data frame
  25. Python pandas: how to remove nan and -inf values
  26. Create a pandas DataFrame from generator?
  27. AttributeError: module ‘numpy’ has no attribute ‘__version__’
  28. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  29. bash: Python import – Command not found for pandas
  30. Confusion about pandas copy of slice of dataframe warning

Leave a Comment