title: Filter the rows in CSV file based on column values of two CSV files using Python
body: <p>I have two CSV files:</p>
  
  <p>Each of them has three columns: time, X and Y. 
  I want to retain the rows of both files which has same time(intersection of column 0) and delete the rows with different time. </p>
  
  <p>For example:  </p>
  
  <p><strong>a.csv</strong></p>
  
  <pre><code>time                      x          y
  
  2018/01/01/01:00:45:03    3          4
  
  2018/01/01/01:00:45:05    4.5        5
  
  2018/01/01/01:00:45:06    5         5.5
  
  2018/01/01/01:00:45:08    5.5       6.5
  </code></pre>
  
  <p><strong>b.csv</strong></p>
  
  <pre><code>time                     x   y
  
  2018/01/01/01:00:45:01  3.5 4.5
  
  2018/01/01/01:00:45:05  5.5 5.5
  
  2018/01/01/01:00:45:06  8   6.5
  
  2018/01/01/01:00:45:09  10  9
  </code></pre>
  
  <p>**expected output **c.csv****</p>
  
  <pre><code>time                    x   y
  
  2018/01/01/01:00:45:05  5.5 5.5
  
  2018/01/01/01:00:45:06  8   6.5
  </code></pre>
  
  <p>Thanks in advance!</p>