Working with Matplotlib and Pandas (Python package for graphs)

import pandas as pd
import matplotlib.pyplot as plt

file = pd.read_excel('/full/path/to/file.xlsx')

When you run this, you may get following error.

ImportError: Install xlrd >= 0.9.0 for Excel support
To proceed further, install xlrd package using

pip install xlrd or pip3 install xlrd



For mentioning the sheet number in the excel sheet import.

df =pd.read_excel('fileName.xlsx', sheet_name='Sheet4')