title: Correlating between two sheets of excel using Python
body: <p>I am trying to take data from sheeet2 if sheet1 value matches with sheet2.</p>
  
  <p>For example:</p>
  
  <p>sheet1:</p>
  
  <pre><code>name    school
  Rahul   DPS
  Seema   KV
  </code></pre>
  
  <p>sheet2: </p>
  
  <pre><code>school_name profile       color       subject
  DPS           1      orange,blue        math
  DPS           2      red,purple        english
  KV            1        yellow          science
  </code></pre>
  
  <p>if in sheet1 school matching with sheet2 school_name than take its all data ie. profile, color, subject.</p>
  
  <p>For eg. sheet1 DPS matching with sheet2 DPS than output be like:</p>
  
  <pre><code>name= Rahul
  school:{DPS:[{'profile':1,'color':orange,blue,'subject':math},{'profile':2,'color':red,purple,'subject':english}]}
  </code></pre>