Excel Data Extraction and Visualization

Overview

This Python script is designed to extract specific data from Excel files, format the output into a desired Excel format, and visualize the results using Matplotlib.

Requirements

  • Python 3.x
  • Pandas
  • numpy
  • Matplotlib
  • Openpyxl
  • xlsxwriter

Input Excel Files

The input Excel files are assumed to be stored locally and are not uploaded as part of this project due to privacy considerations. Users are required to provide their own input Excel files during script execution.