Python Read Excel File using Pandas Example

By Hardik Savani September 3, 2022 Category : Python

Hello Dev,

In this tutorial, you will learn python read excel file using pandas. We will use python read excel file xlsx using pandas. you will learn how to read data from excel file in python using pandas. This article goes in detailed on how to extract data from excel using python pandas.

In this example, we will read excel file using python pandas library. we will use read_excel() function to read excel file date using python pandas. so let's see a simple example.

You can use these examples with python3 (Python 3) version.

I simply created data.xlsx file with content as like below, we will use same file for both example:


Example 1: using pandas

# import pandas library as pd
import pandas as pd
# get by default 1st sheet of demo excel file
data = pd.read_excel('demo.xlsx')


   ID             Name              Email
0   1    Hardik Savani
1   2  Vimal Kashiyani
2   3   Harshad Pathak

I hope it can help you...

Tags :