title: Making a vector out of excel columns using python
body: <p>everyone...
  I just started on python a couple of days ago because I require to handle some excel data in order to automatically update the data of certain cells from one file into another.</p>
  <p>However, I'm kind of stuck since I have barely programmed before, and it's my first time using python as well, but my job required me to find a solution and I'm trying to make it work even though it's not my field of expertise.</p>
  <p>I used the &quot;xlrd library&quot;, imported my file and managed to print the columns I'm needing... However, I can't find a way to put those columns into a matrix in order to handle the data like this:</p>
  <p>Matrix =[DataColumnA     DataColumnG  DataColumnH] in the size [nrows x 3]</p>
  <p>As for now, I have 3 different outputs for the 3 different columns I need, but I'm trying to join them together into one big matrix.</p>
  <p>So far my code looks like this:</p>
  <pre><code>import xlrd
  
  workbook = xlrd.open_workbook(&quot;190219_serviciosWRAmanualV5.xls&quot;);
  worksheet = workbook.sheet_by_name(&quot;ServiciosDWDM&quot;);
  
  workbook2 = xlrd.open_workbook(&quot;Potencia2.xlsx&quot;);
  worksheet2 = workbook2.sheet_by_name(&quot;Hoja1&quot;);
  
  filas = worksheet.nrows
  filas2 = worksheet2.nrows
  columnas = worksheet.ncols
  
  
  for row in range (2, filas):
      Equipo_A = worksheet.cell(row,12).value
      Client_A = worksheet.cell(row,13).value
      Line_A = worksheet.cell(row, 14).value
      print (Equipo_A, Line_A, Client_A)
  </code></pre>
  <p>So I have only gotten, as mentioned above, the data in the columns which is what I'm printing which you can see.</p>
  <p>What I'm trying to do, or the main thing I need to do is to read the cell of the first row in Column A and look for it in the other excel file... if the names match, I would have to validate that for the same row (in file 1) the data in both the ColumnG and ColumnH is the same as the data in the second file.
  If they match I would have to update Column J in the first file with the data from the second file.</p>
  <p>My other approach is to retrieve the value of the cell in ColumnA and look for it in the column A of the second file, then I would make an if conditional to see if ColumnsG and H are equal to Column C of 2nd file and so on...
  The thing here is, I have no idea how to pin point the position of the cell and extract the data to make the conditional for this second approach.</p>
  <p>I'm not sure if by making that matrix my approach is okay or if the second way is better, so any suggestion would be absolutely appreciated.</p>
  <p>Thank you in advance!</p>