Python program to read a excel file and create appropriate graphs and tables out of it
- First excel file that contains the master data 'Nov_2019_v1.xls'
- There is a second excel file that contains connected data 'Resources.csv'
- Output - Using this 2 excel files we have to create a Report with tables and graphs with excel output - 'Results_HDReport.xlsx'
Go through 3 excel files to understand what we are trying to achieve.
Libraries used are
- Pandas
- xlsxwriter
- Numpy
Python version used is 3.7. Devlopment IDE is using Jupyter Notebook