CODE:
import pandas as pdfrom matplotlib import pyplot as pltdf = 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
Recent Article
- Fix-Gradient effect turning to gray in after effects
- How to blur an image in python?
- ModuleNotFoundError: No module named 'whois' in Python GoviralHost Without Terminal
- How to Convert Image to Pencil Sketch in Python?
- AttributeError: module 'urllib' has no attribute 'request' - Python
- How to Extract audio from video files using python?
- PermissionError: [Errno 13] Permission denied: 'shampoo_sales.csv' - Python
- [WinError 145] The directory is not empty: 'FolderPath' - Python
Related Article