c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
Python

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

| | python

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: