Python

Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd., someone asked me to explain?

CODE:

import pandas as pd
from matplotlib import pyplot as plt

df = pd.read_excel('Global Superstore.xls')

sales_data = df.groupby('Region')[['Sales']].sum()

print(sales_data.index)
plt.pie(sales_data['Sales'], labels = sales_data.index)

plt.show()

When I tried to read the excel file, I got this following error in python

"Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.". 

To Solve this problem install xlrd.

cmd: pip install xlrd

VIDEO GUIDE:

Post your comments / questions