Skip to content
Related Articles

Related Articles

Python | Pandas Dataframe/Series.tail() method
  • Last Updated : 01 Oct, 2018

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas tail() method is used to return bottom n (5 by default) rows of a data frame or series.

Syntax: Dataframe.tail(n=5)

n: integer value, number of rows to be returned

Return type: Dataframe with bottom n rows

To download the data set used in following example, click here.
In the following examples, the data frame used contains data of some NBA players. The image of data frame before any operations is attached below.

Example #1:
In this example, bottom 5 rows of data frame are returned and stored in a new variable. No parameter is passed to .tail() method since by default it is 5.

# importing pandas module
import pandas as pd
# making data frame
# calling tail() method 
# storing in new variable
data_bottom = data.tail()
# display

As shown in the output image, it can be seen that the index of returned rows is ranging from 453 to 457. Hence, last 5 rows were returned.

Example #2: Calling on Series with n parameter()

In this example, the .tail() method is called on series with custom input of n parameter to return bottom 12 rows of the series.

# importing pandas module
import pandas as pd
# making data frame
# number of rows to return
n = 12
# creating series
series = data["Salary"]
# returning top n rows
bottom = series.tail(n = n)
# display

As shown in the output image, top 12 rows ranging from 446 to 457th index position of the Salary column were returned.

 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

My Personal Notes arrow_drop_up
Recommended Articles
Page :