title: To compare 2 excel files using python
body: <p>I have a excel file with following fields </p>
  
  <blockquote>
    <p>Software_name , Version  and Count.</p>
  </blockquote>
  
  <p>This file is a inventory of all softwares installed in the network of an organization which was generated using LANdesk.</p>
  
  <p>I have another excel file which is an purchase inventory of these softwares which is generated manually.</p>
  
  <p>I need to compare these sheets and create a report stating whether the organization is compliant or not.</p>
  
  <p>Hence how do i compare these two files.</p>
  
  <p>there are instances like Microsoft Office is mentioned as just office and 'server' is spelt as 'svr'</p>
  
  <p>How do go about with it?</p>