Use pd.Series.rank with method='dense'
df['Rank'] = df.Year.rank(method='dense').astype(int)
df
More Related Contents:
- SQL / Pandas equivalent
- Pandas read_sql with parameters
- How to create a large pandas dataframe from an sql query without running out of memory?
- Pandas left outer join multiple dataframes on multiple columns
- Get data from pandas into a SQL server with PYODBC
- Python Pandas write to sql with NaN values
- Pandas query function not working with spaces in column names
- python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
- Pandas analogue to SQL MINUS / EXCEPT operator, using multiple columns
- Pandas GroupBy.apply method duplicates first group
- Could pandas use column as index?
- NLTK-based text processing with pandas
- Pandas: Bar-Plot with two bars and two y-axis
- Extracting specific selected columns to new DataFrame as a copy
- Assign pandas dataframe column dtypes
- Python – Delete duplicates in a dataframe based on two columns combinations?
- Pandas error when using if-else to create new column: The truth value of a Series is ambiguous
- How do I make the width of the title box span the entire plot?
- Renaming columns in a Pandas dataframe with duplicate column names?
- Is this Python code vulnerable to SQL injection? (SQLite3)
- How to determine whether a column/variable is numeric or not in Pandas/NumPy?
- Python Pandas: Convert “.value_counts” output to dataframe
- Given a pandas Series that represents frequencies of a value, how can I turn those frequencies into percentages?
- LabelEncoder: TypeError: ‘>’ not supported between instances of ‘float’ and ‘str’
- What are the pros and cons between get_dummies (Pandas) and OneHotEncoder (Scikit-learn)?
- Run an OLS regression with Pandas Data Frame
- Relative Strength Index in python pandas
- how to specify the datetime format in read_csv
- Drop row in pandas dataframe if any value in the row equals zero
- Get total values_count from a dataframe with Python Pandas