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)
Parameters:
n: integer value, number of rows to be returnedReturn 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 moduleimport pandas as pd # making data frame # calling tail() method # storing in new variabledata_bottom = data.tail() # displaydata_bottom |
Output:
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 moduleimport pandas as pd # making data frame # number of rows to returnn = 12 # creating seriesseries = data["Salary"] # returning top n rowsbottom = series.tail(n = n) # displaybottom |
Output:
As shown in the output image, top 12 rows ranging from 446 to 457th index position of the Salary column were returned.
