Title: Ranking Rows Of Pandas Dataframes Slug: pandas_dataframe_ranking_rows Summary: Ranking Rows Of pandas Dataframes Date: 2016-05-01 12:00 Category: Python Tags: Data Wrangling Authors: Chris Albon
In [3]:
# import modules
import pandas as pd
In [4]:
# Create dataframe
data = {'name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'],
'year': [2012, 2012, 2013, 2014, 2014],
'reports': [4, 24, 31, 2, 3],
'coverage': [25, 94, 57, 62, 70]}
df = pd.DataFrame(data, index = ['Cochice', 'Pima', 'Santa Cruz', 'Maricopa', 'Yuma'])
df
Out[4]:
In [12]:
# Create a new column that is the rank of the value of coverage in ascending order
df['coverageRanked'] = df['coverage'].rank(ascending=1)
df
Out[12]: