Pandas Excel: Import excel data into a Pandas dataframe and display the last ten rows

Last update on September 11 2025 12:28:52 (UTC/GMT +8 hours)

8. Display Last Ten Rows of Excel Data

Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a Pandas dataframe and display the last ten rows. Go to Excel data

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_excel('E:\coalpublic2013.xlsx')
df.tail(n=10)

Sample Output:

    Year  MSHA ID         Mine_Name  Production  Labor_Hours
40  2013   103372   Cane Creek Mine       66258        32401
41  2013   103376        Town Creek      299167       176499
42  2013   103389  Carbon Hill Mine       76241        84966
43  2013   103410  Coal Valley Mine      407841       158591
44  2013   103423  Dutton Hill Mine       37275         9162
45  2013  1519322           Ghm #25       25054         3108
46  2013   103321    Poplar Springs      189370        76366
47  2013   103358         Old Union      284563       161805
48  2013  5000030          Usibelli     1631584       286079
49  2013   201195      Kayenta Mine     7602722      1015333

Excel Data:

coalpublic2013.xlsx:

For more Practice: Solve these Related Problems:

Write a Pandas program to import coalpublic2013.xlsx and then display the last ten rows of the DataFrame.
Write a Pandas program to read an Excel file and use tail() to show the final ten records.
Write a Pandas program to load the Excel data and verify the last ten entries by comparing with the DataFrame shape.
Write a Pandas program to import coalpublic2013.xlsx and output the last ten rows in a custom formatted table.

Go to:

PREV : Add Summation to a Row.
NEXT : Subtotal of Labor Hours by MSHA ID.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.