Question

using python programming language, find the following

Table 2 Parts Current Inventory Part 1 20 Part2 3 0 Part 3 100 Part 4 50 Part 5 90 Table 1 Suppliers Defective Rate (%) Supplierl 5 Supplier2 Supplier3 10 Supplier

Answer 1

#import the libraries
import matplotlib.pyplot as plt
import numpy as np

from openpyxl import load_workbook

#load workbook
wb = load_workbook('Table1.xlsx')
#first sheet name extracted
sheet = wb.sheetnames[0];
ws = wb[sheet];
suppliers=[];
#get suppliers name ... exclude attributes name
for i in ws['A'][1:]: # ws['A'] is column A and [1:] excludes first value
    suppliers.append(i.value);
  
  
dRate=[];
#get defective rate
for i in ws['B'][1:]: # column 2 with attribute value exluded
    dRate.append(i.value);

index = np.arange(len(suppliers)) # create an array of [1,.....len(suppliers)]

plt.bar(index, dRate) #craete the bar

plt.xlabel(ws['A1'].value, fontsize=5) # label s axis
plt.ylabel(ws['B1'].value, fontsize=5) # label y axis
plt.xticks(index, suppliers, fontsize=5, rotation=30) # xticks on the x axis
plt.title('Defective Rate(%) for each supplier') # title
plt.show()

#--------------------------------------------------------------------------

wb2 = load_workbook('Table2.xlsx')
sheet = wb2.sheetnames[0];
ws2 = wb2[sheet];

parts =[];
for i in ws2['1'][1:]: # get row 1 with 1st column excluded
    parts.append(i.value);
  
inventories = [];
for i in ws2['2'][1:]: # get row 2 with 1st column excluded
    inventories.append(i.value);
explode = np.zeros(len(parts));     # make a row vector with all zero of size equal to total parts
explode[1]=0.2;                     # explode value for part2 set to 0.2 instead of 0
fig1, ax1 = plt.subplots()

#pie chart plotted with given explode value and labels as parts with startangle of 90
ax1.pie(inventories, explode=explode, labels=parts, autopct='%1.1f%%',
        shadow=True, startangle=90)
ax1.axis('equal') # Equal aspect ratio ensures that pie is drawn as a circle.

plt.show()

=========================================================

import matplotlib.pyplot as plt import numpy as np from openpyxl import load_workbook #load workbook wb = load_workbook('Table1.xlsx') #first sheet name extracted sheet = wb. sheetnames[0]; WS = wb[ sheet]; suppliers=[]; #get suppliers name ... exclude attributes name for i in ws['A'][1:]: # ws['A') is column A and [1:] excludes first value suppliers.append(i.value); dRate=[]; #get defective rate for i in ws['B'][1:]: # column 2 with attribute value exluded dRate.append(i.value); index = np.arange(len(suppliers)) # create an array of (1, ..... Zen(suppliers plt.bar(index, dRate) #craete the bar plt.xlabel(ws['A1'].value, fontsize=5) # label s axis plt.ylabel(ws['B1'].value, fontsize=5) # label y axis plt.xticks(index, suppliers, fontsize=5, rotation=30) # xticks on the x axis plt.title('Defective Rate(%) for each supplier') # title plt.show()

wb2 = load_workbook ('Table2.xlsx') sheet = wb2.sheetnames[0]; WS2 = wb2[sheet]; parts =[]); for i in ws2['1'][1:]: # get row 1 with 1st column excluded parts.append(i.value); inventories = []; for i in ws2['2'][1:]: # get row 2 with 1st column excluded inventories.append(i.value); explode = np.zeros(len(parts)); # make a row vector with all zero of size equal t explode[1]=0.2; # explode value for part2 set to 0.2 instead of 6 figi, ax1 = plt.subplots() #pie chart plotted with given explode value and Labels as parts with startangle of 90 ax1.pie(inventories, explode=explode, labels=parts, autopct='%1.1f%%', shadow=True, startangle=90) ax1.axis('equal') # Equal aspect ratio ensures that pie is drawn as a circle. plt.show()

The output bar chart and pie chart are :--

Defective Rate(%) for each supplier Part 1 Part2 10.3% 6.9% Part5 31.0% 34.5% 17.2% Part3 Part4

Thanks

import matplotlib.pyplot as plt import numpy as np from openpyxl import load_workbook #load workbook wb = load_workbook('Table1.xlsx') #first sheet name extracted sheet = wb. sheetnames[0]; WS = wb[ sheet]; suppliers=[]; #get suppliers name ... exclude attributes name for i in ws['A'][1:]: # ws['A') is column A and [1:] excludes first value suppliers.append(i.value); dRate=[]; #get defective rate for i in ws['B'][1:]: # column 2 with attribute value exluded dRate.append(i.value); index = np.arange(len(suppliers)) # create an array of (1, ..... Zen(suppliers plt.bar(index, dRate) #craete the bar plt.xlabel(ws['A1'].value, fontsize=5) # label s axis plt.ylabel(ws['B1'].value, fontsize=5) # label y axis plt.xticks(index, suppliers, fontsize=5, rotation=30) # xticks on the x axis plt.title('Defective Rate(%) for each supplier') # title plt.show()

wb2 = load_workbook ('Table2.xlsx') sheet = wb2.sheetnames[0]; WS2 = wb2[sheet]; parts =[]); for i in ws2['1'][1:]: # get row 1 with 1st column excluded parts.append(i.value); inventories = []; for i in ws2['2'][1:]: # get row 2 with 1st column excluded inventories.append(i.value); explode = np.zeros(len(parts)); # make a row vector with all zero of size equal t explode[1]=0.2; # explode value for part2 set to 0.2 instead of 6 figi, ax1 = plt.subplots() #pie chart plotted with given explode value and Labels as parts with startangle of 90 ax1.pie(inventories, explode=explode, labels=parts, autopct='%1.1f%%', shadow=True, startangle=90) ax1.axis('equal') # Equal aspect ratio ensures that pie is drawn as a circle. plt.show()

Defective Rate(%) for each supplier Part 1 Part2 10.3% 6.9% Part5 31.0% 34.5% 17.2% Part3 Part4