Pandas use rank method to find the ranking of elements in a DataFrame
Example of using rank():
import pandas as pd df = pd.DataFrame([[10, 20, 30, 40], [7, 14, 21, 28], [5, 5, 0, 0]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3']) print("\n--------- DataFrame Values--------\n") print(df) print("\n--------- DataFrame Values by Rank--------\n") print(df.rank())
C:\pandas>python example.py --------- DataFrame Values-------- Apple Orange Banana Pear Basket1 10 20 30 40 Basket2 7 14 21 28 Basket3 5 5 0 0 --------- DataFrame Values by Rank-------- Apple Orange Banana Pear Basket1 3.0 3.0 3.0 3.0 Basket2 2.0 2.0 2.0 2.0 Basket3 1.0 1.0 1.0 1.0 C:\pandas>
2018-10-25T08:41:58+05:30
2018-10-25T08:41:58+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution