{"id":9224,"date":"2023-03-11T07:50:05","date_gmt":"2023-03-11T07:50:05","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=9224"},"modified":"2023-03-11T07:50:05","modified_gmt":"2023-03-11T07:50:05","slug":"get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/","title":{"rendered":"Top, Bottom and Range of Excel Rows by Pandas [head & tail, iloc methods]"},"content":{"rendered":"

Getting top and bottom rows of Excel using Pandas<\/strong><\/h3>\n

Once you have a data frame by using the read_excel<\/em> method of Pandas, you may access\/manipulate Excel data in Python programs.<\/p>\n

In certain scenarios, you may want only to get a number of top rows from the Excel sheet.<\/p>\n

Similarly, accessing a specified number of rows from the bottom of the sheet.<\/p>\n

Let us show you examples of getting top and bottom rows by Pandas head<\/strong> and tail<\/strong> methods.<\/p>\n

The last example also shows how to get a range<\/a> in between e.g. 5 to 8 rows.<\/p>\n

Our sample sheet:<\/strong><\/p>\n

\"Pandas-Excel-top-tail\"<\/p>\n

An example of displaying the top five rows by head method<\/strong><\/h3>\n

Step 1:<\/strong><\/p>\n

First, create a data frame by using read_excel method<\/a> of Pandas:<\/p>\n

import pandas as pd_top<\/p>\n

dt_top = pd_top.read_excel('test_Excel.xlsx', sheet_name=\"Product Information\")<\/p><\/blockquote>\n

(We assumed you have Pandas package installed, otherwise above code gives an error).<\/p>\n

Step 2:<\/strong><\/p>\n

To display the top five rows from the data frame, write this line of code:<\/p>\n

print(dt_top.head(5))<\/p><\/blockquote>\n

That\u2019s it!<\/p>\n

Combine the above code and output<\/strong><\/p>\n

import pandas as pd_top\r\n\r\n#Loading a sheet \"Product Information\"\r\n\r\ndt_top = pd_top.read_excel('test_Excel.xlsx', sheet_name=\"Product Information\")\r\n\r\n#Display top five rows by head method\r\n\r\nprint(dt_top.head(5))<\/pre>\n
Output:<\/strong><\/p>\n
\"Pandas-Excel-top-5\"<\/p>\n
Display the last three rows from the Excel sheet<\/strong><\/h3>\n
For getting only the last specified number of rows from the last, you may use the tail<\/strong> method of the data frame.<\/p>\n
The example below displays the last three rows from the bottom of our sample sheet \u201cProduct Information\u201d.<\/p>\n
The code and output:<\/strong><\/p>\n
import pandas as pd_bottom\r\n\r\n#Loading a sheet \"Product Information\"\r\n\r\ndt_bottom = pd_bottom.read_excel('test_Excel.xlsx', sheet_name=\"Product Information\")\r\n\r\n#Display last three rows by tail method\r\n\r\nprint(dt_bottom.tail(3))<\/pre>\n
Output:<\/strong><\/p>\n
\"Pands-Excel-tail-3\"<\/p>\n
Learn more about the tail method here<\/a>.<\/p>\n
How about accessing rows in between<\/strong><\/h3>\n
So, we want to access neither the top nor bottom but rows in between certain numbers. For example, return data only from row number 5 to 8 rows from Excel sheet.<\/p>\n
The answer is using the iloc<\/strong> method of the data frame.<\/p>\n
This is how you may specify the rows range in iloc method:<\/p>\n
iloc[4:7]<\/p><\/blockquote>\n
The example below displays data from row number 5 to 8:<\/p>\n
import pandas as pd_mid\r\n\r\n#Loading a sheet \"Product Information\"\r\n\r\ndt_mid = pd_mid.read_excel('test_Excel.xlsx', sheet_name=\"Product Information\")\r\n\r\n#Display rows 3 to 8 by iloc\r\n\r\nprint(dt_mid.iloc[3:8])<\/pre>\n
 <\/p>\n
Output:<\/strong><\/p>\n
\"Pandas-Excel-iloc\"<\/p>\n","protected":false},"excerpt":{"rendered":"
Once you have a data frame by using the read_excel method of Pandas, you may access\/manipulate Excel data in Python programs.<\/p>\n","protected":false},"author":1,"featured_media":9226,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[145],"tags":[],"yoast_head":"\nHow to Get Top, Bottom and Range of Excel Rows by Pandas [head & tail, iloc methods]<\/title>\n<meta name=\"description\" content=\"Once you have a data frame by using the read_excel method of Pandas, you may access\/manipulate Excel data in Python programs.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Get Top, Bottom and Range of Excel Rows by Pandas [head & tail, iloc methods]\" \/>\n<meta property=\"og:description\" content=\"Once you have a data frame by using the read_excel method of Pandas, you may access\/manipulate Excel data in Python programs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-11T07:50:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/03\/86_3-Pands-Excel-tail-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"424\" \/>\n\t<meta property=\"og:image:height\" content=\"109\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/03\/86_3-Pands-Excel-tail-3.png\",\"width\":424,\"height\":109,\"caption\":\"Pands-Excel-tail-3\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/\",\"name\":\"How to Get Top, Bottom and Range of Excel Rows by Pandas [head & tail, iloc methods]\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/#primaryimage\"},\"datePublished\":\"2023-03-11T07:50:05+00:00\",\"dateModified\":\"2023-03-11T07:50:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"Once you have a data frame by using the read_excel method of Pandas, you may access\/manipulate Excel data in Python programs.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/get-top-bottom-and-range-of-excel-rows-by-pandas-head-tail-iloc\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9224"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=9224"}],"version-history":[{"count":4,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9224\/revisions"}],"predecessor-version":[{"id":9238,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9224\/revisions\/9238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/9226"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=9224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=9224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=9224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}