Python Waffle from Excel

I have an Excel spreadsheet I use to work through some machines.

#!/usr/bin/env python3
import pandas as pd 
import matplotlib.pyplot as plt 
import sys
from pywaffle import Waffle  
df = pd.read_excel('TMP_P.xlsx' )
df = df.rename(columns={"Centos Version": "Version"})
calculated = df['Version' ].value_counts()
fig = plt.figure( FigureClass = Waffle, rows = 8, values = list(calculated.values), 
            labels = ["{0} ({1})".format(k,v) for k,v in calculated.items()],
figsize=(10, 5), legend={'loc': 'upper left', 'bbox_to_anchor': (1.1, 1) } )
plt.savefig('waffle-operatingsystems.png')
plt.show()

Leave a Reply

Your email address will not be published. Required fields are marked *