OPS435 Python Assignment 2 B

From CDOT Wiki
Jump to: navigation, search


"A picture is worth a thousand words.". A computer usage chart is believed to be more useful than the mere usage data as you might have been able to produce with the python script for your previous assignments. The scripting task for this assignment is to present the usage data produced by the usage_report python script in a graphical chart form.

There are two modules you can use to make such a task easy to achieve:

  1. openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files
  2. matplotlib - a Python 2D plotting library

You also need to update your usage_report for assignment 1 to support command line options to select the type of report to generate.


Your task is to write a python script which takes the usage data (daily report by user) generate by the usage_report program and present the data in Bar-Chart form. You can use either one of the above python packages to generate the chart.

In the bar chart, the user should be on the x-axis and the usage should be on the y-axis. It there are more than 10 users, just display a bar chart for the first 10 users.

Sample runs and results

  • Coming soon...