DataFrame.tail() to get last five rows of data from the DataFrame

DataFrame.tail(n=5)

Returns the last n rows of the DataFrame.
n : int, defalut is 5, number of rows to return.

import pandas as pd 
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,60,30],
         'ENGLISH':[80,70,40,50,60,30]}
df = pd.DataFrame(data=my_dict) # dataframe 
print(df.tail()) # default, last 5 records

Output ( by default we get last 5 rows )

   NAME  ID  MATH  ENGLISH
1  Raju   2    40       70
2  Alex   3    70       40
3   Ron   4    70       50
4  King   5    60       60
5  Jack   6    30       30

Let us change the last line only by asking 2 records

print(df.tail(2))

Output

   NAME  ID  MATH  ENGLISH
4  King   5    60       60
5  Jack   6    30       30

Negative value

print(df.tail(-1)) # All records after first records

Reading from csv file to create DataFrame and displaying last n records.

import pandas as pd 
df= pd.read_csv('D:\\my_data\\student.csv') # DataFrame from csv file data
print(df.tail(2)) #  last 2 records

By using shape() you can get a tuple showing rows and columns. Create DataFrame from Excel file by using read_excel()

import pandas as pd 
df = pd.read_excel('D:\student.xlsx',index_col='id')
print(df.shape)

Output

(35, 4)

You can check the code and output at Exercise 1

str.contains.sum()

Using tail() output as string

Using to_string() we can convert the object to string and then add.
We used str() to convert tuple element as integer to string before adding.

str1="Rows:" + str(df.shape[0])+ ",Columns:"+str(df.shape[1])
str1=str1+ "\n"+df.head(2).to_string()

Download Sample student DataFrame or CSV or Excel file

Pandas head() read_csv() read_excel() to_excel()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here