title: Count number of records in a specific time interval in Python
body: <p>I am reading from a csv file which contains the following data:</p>
  
  <pre><code>Create Date,           Original Filesize,  Number of Encodings
  2016-01-27 16:27:10,   855583191,          1
  2016-01-27 16:28:11,   854336,             1
  2016-01-27 16:28:25,   854336,             1
  2016-01-27 16:30:12,   9691559,            1
  </code></pre>
  
  <p>I want to count the number of records generated every two minutes in the table.</p>
  
  <p>E.g. if we start from <code>2016-01-27 16:27:00</code>
  then from <code>2016-01-27 16:27:01</code> to <code>2016-01-27 16:29:00</code>, we have <code>2</code> records. 
  from <code>2016-01-27 16:29:01</code> to <code>2016-01-27 16:31:00</code>, we have <code>1</code> record and so on.</p>
  
  <p>I am trying to use <a href="http://pandas.pydata.org/" rel="nofollow noreferrer">pandas</a> as I want to do some data analysis on it later. Is there an easy way to do this with/without pandas?</p>
  
  <p>Also, I use <code>mysql</code> to export this data in the first place. If it is easier using <code>sql</code>, that is also ok.</p>