No header

We can also tell read_excel to ignore the header and treat all rows as records. This is handy whenever Excel has no header row. To achieve this, we set header to None, as shown in the following code:

df = pd.read_excel('IMDB.xlsx', sheetname=1, header=None)df.head()

The output is as follows:

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.