Basic Excel read

We are using pandas' read_excel method to read this data. In its simplest format, we are just passing the filename of the Excel dataset we want to the read_excel method. pandas converts the data from the Excel file into a pandas DataFrame . The pandas internally uses the Excel rd library for this. Here, pandas has read the data and created a tabular data object in the memory, which we can access, explore, and manipulate in our code, as shown in the following code:

df = pd.read_excel('IMDB.xlsx')df.head()

The output for the previous code block is as follows:

pandas has a lot of advanced options, which we can use to control ...

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.