Reading data from Excel files

In this section, we will learn how to work with Excel data using pandas and use pandas' read_excel method for reading data from Excel files. We will read and explore a real Excel dataset and explore some of the advanced options available for parsing Excel data.

pandas internally uses the Excel rd Python library to extract data from Excel files. We can install it by executing conda install xlrd.

Firstly, make sure the command-line program is running in admin mode ahead of installation, as shown in the following screenshot:

The following screenshot shows the Excel dataset that we will be reading and exploring with ...

Get Mastering Exploratory Analysis with pandas now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.