title: Comparing two excel files by using Python
body: <p>I have data in two excel files like below</p>
  
  <h1>Sample DS Created:</h1>
  
  <pre><code>df1 =  {'Transaction_Name':['SC-001_Homepage', 'SC-002_Homepage', 'SC-001_Signinlink'], 'Count': [1, 1, 2]}
  df1 = pd.DataFrame(df1, columns=df1.keys())
  
  df2 =  {'Transaction_Name':['SC-001_Homepage', 'SC-002_Homepage', 'SC-001_Signinlink'], 'Count': [2, 1, 2]}
  df2 = pd.DataFrame(df2, columns=df2.keys())
  </code></pre>
  
  <p>please help me to get difference of both excels as below..</p>
  
  <pre><code>Transaction_name    Count_df1        Count_df2
  SC-001_Homepage          1              2
  SC-001_Homepage          1              1
  SC-001_Homepage          2              2
  </code></pre>
  
  <p>First line of the output count is not matching. Will i be able to highlight in different color? Sample code is as below</p>
  
  <pre><code>#COmparing both excels
  df1 = pd.read_csv(r"WLMOUTPUT.csv", dtype=object)
  df2 = pd.read_csv(r"results.csv", dtype=object)
  
  print('\n', df1)
  print('\n',df2)
  
  df1['Compare'] = df1['Transaction_Name'] + df1['Count'].astype(str)
  df2['Compare'] = df2['Transaction_Name'] + df2['Count'].astype(str)
  
  print('\n', df1.loc[~df1['Compare'].isin(df2['Compare'])])
  </code></pre>
  
  <p>Thanks in advance</p>