Remove last n rows of a Pandas DataFrame
Let’s see the various methods to Remove last n rows of a Pandas Dataframe.
First, let’s make a dataframe:
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
Python3
# Import Required Librariesimport pandas as pd# Create a dictionary for the dataframedict = { 'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti', 'Abhishek Jain'], 'Age': [22, 20, 45, 21, 22], 'Marks': [90, 84, -33, -87, 82]}# Converting Dictionary to# Pandas Dataframedf = pd.DataFrame(dict)# Print Dataframeprint(df) |
Output:
Method 1: Using Dataframe.drop() .
We can remove the last n rows using the drop() method. drop() method gets an inplace argument which takes a boolean value. If inplace attribute is set to True then the dataframe gets updated with the new value of dataframe (dataframe with last n rows removed).
Example:
Python3
# Import Required Librariesimport pandas as pd# Create a dictionary for the dataframedict = { 'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti', 'Abhishek Jain'], 'Age': [22, 20, 45, 21, 22], 'Marks': [90, 84, -33, -87, 82]}# Converting Dictionary to# Pandas Dataframedf = pd.DataFrame(dict)# Number of rows to dropn = 3# Dropping last n rows using dropdf.drop(df.tail(n).index, inplace = True)# Printing dataframeprint(df) |
Output:
Method 2: Using Dataframe.iloc[ ].
This method is used when the index label of a data frame is something other than numeric series of 0, 1, 2, 3….n or in case the user doesn’t know the index label.
Example:
Python3
# Import Required Librariesimport pandas as pd# Create a dictionary for the dataframedict = { 'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti', 'Abhishek Jain'], 'Age': [22, 20, 45, 21, 22], 'Marks': [90, 84, -33, -87, 82]}# Converting Dictionary to# Pandas Dataframedf = pd.DataFrame(dict)# Number of rows to dropn = 3# Removing last n rowsdf_dropped_last_n = df.iloc[:-n]# Printing dataframeprint(df_dropped_last_n) |
Output:
Method 3: Using Dataframe.head().
This method is used to return top n (5 by default) rows of a data frame or series.
Example:
Python3
# Import Required Librariesimport pandas as pd# Create a dictionary for the dataframedict = { 'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti', 'Abhishek Jain'], 'Age': [22, 20, 45, 21, 22], 'Marks': [90, 84, -33, -87, 82]}# Converting Dictionary to# Pandas Dataframedf = pd.DataFrame(dict)# Number of rows to dropn = 3# Using head() to# drop last n rowsdf1 = df.head(-n)# Printing dataframeprint(df1) |
Output:
Method 4: Using Dataframe slicing [ ].
Example:
Python3
# Import Required Librariesimport pandas as pd# Create a dictionary for the dataframedict = { 'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti', 'Abhishek Jain'], 'Age': [22, 20, 45, 21, 22], 'Marks': [90, 84, -33, -87, 82]}# Converting Dictionary to# Pandas Dataframedf = pd.DataFrame(dict)# Number of rows to dropn = 3# Slicing last n rowsdf1 = df[:-n]# Printing dataframeprint(df1) |
Output:
