Python
Python With Excel and Text Strings

Print the First 5 Rows From an Excel File in Python

Complete & Continue Next Lesson Learn More

Print an Excel File with Python

Add one more line to the code to see Python print the first five lines of the Excel file you’ve just read in. This line prints the dataframe’s first five rows with the built-in function “.head(5)”. Change 5 to 10 to see the first 10 rows as well to see how it works.

Code:

import pandas as pd

df = pd.read_excel('Enter Your Excel Filename Here.xlsx')

print(df.head(5))

  • Add a short summary or a list of helpful resources here.