title: I have Multiple csv files.Each csv file contains multiple tables with multiple headers.How to get the table its header contains given specific value?
body: <p>I have multiple csv files (4000) in one folder.  Each csv files have the data like below. Data length, the rows of the headers and number of headers in different lines in each csv file might be different.  There are multiple tables with the headers and these table all starts with the same column &quot;a&quot;. I want to get the table that its header contains &quot;apple&quot; and with the values.</p>
  <p>Input</p>
  <pre><code>
  a   b   c   d   e   f   g   h   i           
  1   2   3   4   5   6   7   8   9           
  a   b1  c1  d1  e1  f1  g1                  
  1   2   3   4   5   6   7                   
  a   b2  c2  d2  e2  f2  g2  h2  i2  k2  l2  
  3   5   6   7   3   4   5   6   7   7   0   
  a   b3  d3  e3  g23 t4  apple   r4  w2  r5  t6  
  1   2   3   4   5   6   7   8   9   1   1   2
  1   2   3   4   5   6   7   8   9   10  1   2
  1   2   3   4   5   6   7   8   9   11  1   2
  1   2   3   4   5   6   7   8   9   12  1   2
  1   2   3   4   5   6   7   8   9   13  1   2
  1   2   3   4   5   6   7   8   9   14  1   2
  1   2   3   4   5   6   7   8   9   15  1   2
  1   2   3   4   5   6   7   8   9   16  1   2
  1   2   3   4   5   6   7   8   9   17  1   2
  1   2   3   4   5   6   7   8   9   18  1   2
  a   b   c   d   e   f   g   h   i           
  1   2   3   4   5   6   7   8   9           
  </code></pre>
  <p>Final Output</p>
  <pre><code>a   b3  d3  e3  g23 t4  apple   r4  w2  r5  t6
  1   2   3   4   5   6   7   8   9   1   1   2
  1   2   3   4   5   6   7   8   9   10  1   2
  1   2   3   4   5   6   7   8   9   11  1   2
  1   2   3   4   5   6   7   8   9   12  1   2
  1   2   3   4   5   6   7   8   9   13  1   2
  1   2   3   4   5   6   7   8   9   14  1   2
  1   2   3   4   5   6   7   8   9   15  1   2
  1   2   3   4   5   6   7   8   9   16  1   2
  1   2   3   4   5   6   7   8   9   17  1   2
  1   2   3   4   5   6   7   8   9   18  1   2
  </code></pre>