title: Round pandas datetime index?
body: <p>I am reading multiple spreadsheets of timeseries into a pandas dataFrame and concatenating them together with a common pandas datetime index. The datalogger that logged the timeseries is not 100% accurate which makes resampling very annoying because depending on if the time is slightly higher or lower than the interval being sampled it will create NaNs and starts to make my series look like a broken line. Here's my code </p>
  
  <pre><code>def loaddata(filepaths):
      t1 = time.clock()
      for i in range(len(filepaths)):
          xl = pd.ExcelFile(filepaths[i])
          df = xl.parse(xl.sheet_names[0], header=0, index_col=2, skiprows=[0,2,3,4], parse_dates=True)
          df = df.dropna(axis=1, how='all') 
          df = df.drop(['Decimal Year Day', 'Decimal Year Day.1', 'RECORD'], axis=1)
  
          if i == 0:
              dfs = df
          else:
              dfs = concat([dfs, df], axis=1)
      t2 = time.clock()
      print "Files loaded into dataframe in %s seconds" %(t2-t1)
  
  files = ["London Lysimeters corrected 5min.xlsx", "London Water Balance 5min.xlsx"]
  data = loaddata(files)
  </code></pre>
  
  <p>Here's an idea of the index:</p>
  
  <blockquote>
    <p>data.index</p>
    
    <p>class 'pandas.tseries.index.DatetimeIndex'>
    [2012-08-27 12:05:00.000002, ..., 2013-07-12 15:10:00.000004]
    Length: 91910, Freq: None, Timezone: None</p>
  </blockquote>
  
  <p>What would be the fastest and most general to round the index to the nearest minute?</p>