title: How to grep a column and add it in dictionary key as value
body: <p>I have been working in excel and i am trying to fetch a dictionary with keys and values .This is my table: </p>
  
  <pre><code>int1           int2         int3    int4         int5
  
  core_6  2       22           32     core_8      23.34.34.45
  
  72.20.20.20     11           33     core_7      core_work
  
  255.255.255.0   12           12     core_12     44      
  </code></pre>
  
  <p>I am trying to make as:</p>
  
  <pre><code>{'int1' : 'core_6' '72.20.20.20' ,'255.255.255.0' 'int2': and so on}.
  </code></pre>
  
  <p>The issue i am facing with my code is:</p>
  
  <pre><code>import xlrd
  
  workbook = xlrd.open_workbook('input.xlsx')
  workbook = xlrd.open_workbook('input.xlsx', on_demand = True)
  worksheet = workbook.sheet_by_name("GlobalInfo")
  
  my_dict = {}
  for i in range(2):
      row = worksheet.row_values(i)
      my_dict[row[1]] = row[1::]
  
  d =dict((k, v) for k,v in my_dict.items() if k is not None and k != '')
  
  for x in d:
      print(d[x])
  
  my_di = {k: '' for k in d[x]} 
  print(my_di)  ////take all the int1 as keys
  worksheet.cell_value(0, 1) 
  num_rows = worksheet.nrows - 1
  curr_row = 1
  kk = []
  
  while curr_row &lt; num_rows:
          curr_row += 1
          row = worksheet.row(curr_row)
          kk.append(row[1].value)
  
  print(kk)     ///this will print value of 1st row
  </code></pre>
  
  <p>But i am not able to add values to the keys i have made.</p>
  
  <p>Also i am not able to get values of other rows.</p>