import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
# prepare the data - create lists
salesman = ['Ahmad', 'Omar', 'Ali', 'Ziad', 'Salwa', 'Lila']
mobile_sales = [2540, 1370, 1320, 2000, 2100, 2150]
tv_sales = [2200, 1900, 2150, 1850, 1770, 2000]
salesman
['Ahmad', 'Omar', 'Ali', 'Ziad', 'Salwa', 'Lila']
mobile_sales
[2540, 1370, 1320, 2000, 2100, 2150]
tv_sales
[2200, 1900, 2150, 1850, 1770, 2000]
# create empty dataframe
df = pd.DataFrame()
# add lists into dataframe
df['Name'] = salesman
df['Mobile_Sales'] = mobile_sales
df['TV_Sales'] = tv_sales
# set dataframe index
df.set_index("Name", drop=True, inplace=True)
df
| Mobile_Sales | TV_Sales | |
|---|---|---|
| Name | ||
| Ahmad | 2540 | 2200 |
| Omar | 1370 | 1900 |
| Ali | 1320 | 2150 |
| Ziad | 2000 | 1850 |
| Salwa | 2100 | 1770 |
| Lila | 2150 | 2000 |
# A. Create a bar plot of the sales volume.
df.plot.bar( figsize=(20, 10), rot=0).legend(bbox_to_anchor=(1.1, 1))
plt.xlabel('Salesmen')
plt.ylabel('Sales')
plt.title('Sales Volume for two salesmen in \nJanuary and April 2017')
plt.show()
# create pie chart for Mobile Sales
colors = ['b', 'g', 'r', 'c', 'm', 'y']
explode = (0.2, 0, 0, 0, 0, 0)
plt.pie(mobile_sales, labels=salesman, counterclock=False, autopct='%.1f%%', colors=colors, explode=explode, shadow=True)
plt.title('Mobile Sales')
plt.show()
# create pie chart for TV Sales
explode = (0.2, 0, 0.2, 0, 0, 0)
plt.pie(tv_sales, labels=salesman, counterclock=False, autopct='%.1f%%', explode=explode, shadow=True)
plt.title('TV Sales')
plt.show()
# C. Create a box plot of item sales.
df.plot.box()
<AxesSubplot:>
# D. Create an area plot of item sales.
df.plot.area(figsize=(6, 4)).legend(bbox_to_anchor=(1.3, 1))
<matplotlib.legend.Legend at 0x214fecbf4c0>
# E. Create a stacked bar plot of item sales.
df.plot.bar(stacked=True, figsize=(20, 10)).legend(bbox_to_anchor=(1.1, 1))
<matplotlib.legend.Legend at 0x21491ddc0d0>