JIYIK CN >

Pandas is a well-known Python library for data science and machine learning. This library provides many functions for data analysis, prediction, and manipulation.

There are many operations we can perform on the datasets provided. Most of the time, we perform analysis on Excel files (also known as xls files) or CSV files (single spreadsheets) that contain the datasets.

We can load a single worksheet or multiple Excel worksheets from this file.

Reading Multiple Excel Worksheets from a Workbook Using Pandas in Python

To use Pandas, we should first install it using the following command.

#Python 3.x
pip install pandas

Also, we will read an Excel file here (with the extension xls). For this, we also have to install xlrdthe module using the following command.

#Python 3.x
pip install xlrd

Sometimes we have a large dataset consisting of multiple spreadsheets in the same workbook. But we are only interested in some specific spreadsheets of that file.

To do this, we have to open the specific spreadsheet from the workbook. We can do this task easily in Python using Pandas.

read_Excel()Open the spreadsheet from the Pandas workbook using

First, we will pd.ExcelFile('path_to_file.xls')read the entire Excel file using . Here, pdreferring to Pandas, we will pass the path of the Excel file as a parameter to ExcelFile()the method call.

In the following code, we import the Pandas package. Then we read an Excel file dataset.xlscontaining two spreadsheets irisand customer_churn.

We are working with Jupytera notebook, so we have uploaded this dataset to our home directory. xlsThe object spreadsheet is now accessible.

If we only want to read iristhe spreadsheet, we will call read_excel()the method again. In the first parameter, we will pass xlsand in the second parameter, we will write the name of the specific spreadsheet that we want to read from that xls file.

We then df.head()displayed the first five rows of the spreadsheet using . We can read_excel()load multiple spreadsheets from a workbook in the same way by specifying the name of the spreadsheet in .

# Python 3.x
import pandas as pd

xls = pd.ExcelFile("dataset.xls")
df = pd.read_excel(xls, "iris")
df.head()
print(df)

Output:

parse()Open a spreadsheet from a workbook using the

Another way to read a single spreadsheet from a workbook is to load the xls file and then xlscall parse()the method with the object. As parse()a parameter of the method, we will specify the index number of the spreadsheet.

The integers refer to the spreadsheets in that xls file. 0represents the first spreadsheet, 1represents the second, and so on, just like an array index.

Here, we load iristhe spreadsheet, which is the second spreadsheet of our workbook, so we pass 1as the index. The output of this code is the same as above.

# Python 3.x
import pandas as pd

xls = pd.ExcelFile("dataset.xls")
df = xls.parse(1)
df.head()
print(df)

Output: