Reading the Docklight CO2 instrument text file with all of the original characters

Hamblin Pond 30 min (collected from 2013-06-18 20:28:08 to 2013-06-21 14:58:14) and continuous (collected from 2013-06-21 15:22:00 to 2013-06-26 02:00:00)


In [115]:
import pandas as pd
import urllib

In [116]:
#retrieve data from dropbox by rightclicking on the file in dropbox from a web browser, and selecting share link
#then rightclick the download botton and select copy link address. Paste address below.
#with desired final destination after the comma

urllib.urlretrieve('https://dl.dropboxusercontent.com/s/8i18ngoc2f5s6bn/ICO2sensordata_2_clipped_asc.txt?token_hash=AAFXu3BONr7r8xkcKSCmOuL_3IQFrhSi3CTuLRa-bBC3kw&dl=1',
                   '/usgs/data2/notebook/data/ICO2_clip_2_asc.txt')


Out[116]:
('/usgs/data2/notebook/data/ICO2_clip_2_asc.txt',
 <httplib.HTTPMessage instance at 0x16c83638>)

In [166]:
# reads columns with fixed width and chops out un-needed characters.
col_specs=[(0,10), (11,19), (23,31), (32,38), (58,62)]

df = pd.read_fwf('/usgs/data2/notebook/data/ICO2_clip_2_asc.txt',colspecs=col_specs, skiprows=2,parse_dates =[[0,1]], index_col=0, 
    names=['date','time','CO2','Temp','Pressure'],header=None,nrows=197421)

In [167]:
df1 = df['2013-06-18 20:28:08':'2013-06-21 14:58:14']

In [168]:
df2 = df['2013-06-21 15:22:00':'2013-06-26 02:00:00']

In [181]:
df1['Temp'].head(40)


Out[181]:
date_time
2013-06-18 20:28:09    31.10
2013-06-18 20:28:11    31.11
2013-06-18 20:28:13    31.11
2013-06-18 20:58:09    30.82
2013-06-18 20:58:11    30.82
2013-06-18 20:58:13    30.82
2013-06-18 21:28:09    30.59
2013-06-18 21:28:11    30.59
2013-06-18 21:28:13    30.59
2013-06-18 21:58:09    30.18
2013-06-18 21:58:11    30.18
2013-06-18 21:58:13    30.18
2013-06-18 22:28:09    30.06
2013-06-18 22:28:11    30.06
2013-06-18 22:28:13    30.06
2013-06-18 22:58:09    29.95
2013-06-18 22:58:11    29.95
2013-06-18 22:58:13    29.95
2013-06-18 23:28:09    29.83
2013-06-18 23:28:11    29.83
2013-06-18 23:28:13    29.83
2013-06-18 23:58:09    29.66
2013-06-18 23:58:11    29.66
2013-06-18 23:58:13    29.66
2013-06-19 00:28:09    29.37
2013-06-19 00:28:11    29.37
2013-06-19 00:28:13    29.37
2013-06-19 00:58:09    29.25
2013-06-19 00:58:11    29.25
2013-06-19 00:58:13    29.25
2013-06-19 01:28:09    29.19
2013-06-19 01:28:11    29.19
2013-06-19 01:28:13    29.19
2013-06-19 01:58:09    28.84
2013-06-19 01:58:11    28.84
2013-06-19 01:58:13    28.84
2013-06-19 02:28:09    28.67
2013-06-19 02:28:11    28.67
2013-06-19 02:28:13    28.67
2013-06-19 02:58:09    28.38
Name: Temp, dtype: object

In [171]:
df1['Temp'].plot(figsize=(15,6))


---------------------------------------------------------------------------
Exception                                 Traceback (most recent call last)
<ipython-input-171-e76fdf2c6399> in <module>()
----> 1 df1['Temp'].plot(figsize=(15,6))

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in plot_series(series, label, kind, use_index, rot, xticks, yticks, xlim, ylim, ax, style, grid, legend, logx, logy, secondary_y, **kwds)
   1656                      secondary_y=secondary_y, **kwds)
   1657 
-> 1658     plot_obj.generate()
   1659     plot_obj.draw()
   1660 

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in generate(self)
    798         self._compute_plot_data()
    799         self._setup_subplots()
--> 800         self._make_plot()
    801         self._post_plot_logic()
    802         self._adorn_subplots()

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in _make_plot(self)
   1195                         msg = msg + ('\nConsider setting raise_on_error=False'
   1196                                      'to suppress')
-> 1197                         raise Exception(msg)
   1198 
   1199             self._make_legend(lines, labels)

Exception: Unable to plot data ['31.10' '31.11' '31.11' '30.82' '30.82' '30.82' '30.59' '30.59' '30.59'
 '30.18' '30.18' '30.18' '30.06' '30.06' '30.06' '29.95' '29.95' '29.95'
 '29.83' '29.83' '29.83' '29.66' '29.66' '29.66' '29.37' '29.37' '29.37'
 '29.25' '29.25' '29.25' '29.19' '29.19' '29.19' '28.84' '28.84' '28.84'
 '28.67' '28.67' '28.67' '28.38' '28.38' '28.38' '27.97' '27.97' '27.98'
 '27.39' '27.39' '27.39' '27.28' '27.28' '27.28' '27.34' '27.34' '27.36'
 '27.25' '27.25' '27.27' '26.98' '26.98' '26.98' '26.58' '26.58' '26.58'
 '26.29' '26.29' '26.29' '27.74' '27.74' '27.74' '28.03' '28.03' '28.03'
 '27.86' '27.86' '27.86' '27.62' '27.62' '27.63' '27.57' '27.57' '27.57'
 '27.22' '27.22' '27.22' '27.45' '27.45' '27.45' '27.34' '27.34' '27.33'
 '26.98' '26.98' '26.98' '26.98' '26.98' '26.99' '27.11' '27.13' '27.13'
 '26.98' '26.98' '26.98' '26.97' '26.98' '26.98' '27.10' '27.10' '27.10'
 '27.28' '27.28' '27.28' '27.62' '27.62' '27.62' '27.97' '27.97' '27.97'
 '28.26' '28.26' '28.27' '28.61' '28.61' '28.61' '29.08' '29.08' '29.08'
 '29.66' '29.66' '29.66' '30.30' '30.30' '30.30' '30.75' '30.75' '30.76'
 '29.66' '29.66' '29.66' '29.60' '29.60' '29.60' '29.66' '29.66' '29.66'
 '29.51' '29.53' '29.54' '29.48' '29.48' '29.48' '29.42' '29.43' '29.43'
 '29.37' '29.37' '29.37' '29.19' '29.19' '29.19' '29.13' '29.13' '29.13'
 '29.13' '29.13' '29.13' '29.01' '29.01' '29.02' '28.84' '28.84' '28.84'
 '28.73' '28.73' '28.74' '28.67' '28.67' '28.67' '28.55' '28.55' '28.55'
 '28.15' '28.15' '28.15' '27.78' '27.79' '27.80' '27.57' '27.57' '27.57'
 '27.33' '27.33' '27.33' '26.87' '26.87' '26.87' '26.29' '26.29' '26.29'
 '26.00' '26.01' '26.01' '26.00' '26.00' '26.00' '25.42' '25.42' '25.42'
 '24.49' '24.49' '24.49' '23.88' '23.89' '23.90' '23.09' '23.09' '23.09'
 '23.03' '23.04' '23.04' '26.06' '26.06' '26.06' '26.97' '26.97' '26.98'
 '27.28' '27.28' '27.28' '25.59' '25.59' '25.59' '25.07' '25.07' '25.07'
 '26.06' '26.06' '26.06' '26.94' '26.94' '26.94' '27.07' '27.08' '27.10'
 '26.85' '26.86' '26.87' '26.87' '26.87' '26.87' '27.28' '27.28' '27.28'
 '27.51' '27.51' '27.51' '27.74' '27.74' '27.74' '27.97' '27.97' '28.00'
 '28.20' '28.20' '28.20' '28.48' '28.49' '28.49' '28.85' '28.86' '28.88'
 '29.36' '29.36' '29.37' '29.77' '29.77' '29.77' '30.12' '30.12' '30.12'
 '30.53' '30.53' '30.53' '31.05' '31.05' '31.05' '31.22' '31.22' '31.22'
 '31.16' '31.17' '31.17' '31.46' '31.47' '31.48' '31.17' '31.17' '31.17'
 '30.88' '30.88' '30.88' '30.64' '30.64' '30.64' '30.29' '30.29' '30.28'
 '30.00' '30.00' '30.00' '29.59' '29.59' '29.59' '29.42' '29.42' '29.42'
 '29.37' '29.38' '29.39' '29.31' '29.31' '29.31' '29.25' '29.25' '29.25'
 '29.08' '29.08' '29.08' '28.84' '28.84' '28.84' '28.32' '28.32' '28.32'
 '27.68' '27.68' '27.68' '27.16' '27.16' '27.16' '26.52' '26.52' '26.52'
 '26.06' '26.06' '26.06' '26.00' '26.00' '26.00' '25.82' '25.82' '25.82'
 '25.36' '25.36' '25.36' '24.49' '24.49' '24.49' '23.73' '23.73' '23.73'
 '23.21' '23.21' '23.21' '22.42' '22.44' '22.42' '21.58' '21.58' '21.58'
 '21.12' '21.12' '21.12' '20.94' '20.94' '20.94' '24.01' '24.02' '24.01'
 '25.65' '25.65' '25.66' '25.30' '25.32' '25.33' '25.71' '25.71' '25.71'
 '25.98' '25.99' '25.98' '26.13' '26.14' '26.16' '26.17' '26.17' '26.17'
 '26.29' '26.29' '26.29' '26.52' '26.52' '26.52'] vs index [datetime.datetime(2013, 6, 18, 20, 28, 9)
 datetime.datetime(2013, 6, 18, 20, 28, 11)
 datetime.datetime(2013, 6, 18, 20, 28, 13)
 datetime.datetime(2013, 6, 18, 20, 58, 9)
 datetime.datetime(2013, 6, 18, 20, 58, 11)
 datetime.datetime(2013, 6, 18, 20, 58, 13)
 datetime.datetime(2013, 6, 18, 21, 28, 9)
 datetime.datetime(2013, 6, 18, 21, 28, 11)
 datetime.datetime(2013, 6, 18, 21, 28, 13)
 datetime.datetime(2013, 6, 18, 21, 58, 9)
 datetime.datetime(2013, 6, 18, 21, 58, 11)
 datetime.datetime(2013, 6, 18, 21, 58, 13)
 datetime.datetime(2013, 6, 18, 22, 28, 9)
 datetime.datetime(2013, 6, 18, 22, 28, 11)
 datetime.datetime(2013, 6, 18, 22, 28, 13)
 datetime.datetime(2013, 6, 18, 22, 58, 9)
 datetime.datetime(2013, 6, 18, 22, 58, 11)
 datetime.datetime(2013, 6, 18, 22, 58, 13)
 datetime.datetime(2013, 6, 18, 23, 28, 9)
 datetime.datetime(2013, 6, 18, 23, 28, 11)
 datetime.datetime(2013, 6, 18, 23, 28, 13)
 datetime.datetime(2013, 6, 18, 23, 58, 9)
 datetime.datetime(2013, 6, 18, 23, 58, 11)
 datetime.datetime(2013, 6, 18, 23, 58, 13)
 datetime.datetime(2013, 6, 19, 0, 28, 9)
 datetime.datetime(2013, 6, 19, 0, 28, 11)
 datetime.datetime(2013, 6, 19, 0, 28, 13)
 datetime.datetime(2013, 6, 19, 0, 58, 9)
 datetime.datetime(2013, 6, 19, 0, 58, 11)
 datetime.datetime(2013, 6, 19, 0, 58, 13)
 datetime.datetime(2013, 6, 19, 1, 28, 9)
 datetime.datetime(2013, 6, 19, 1, 28, 11)
 datetime.datetime(2013, 6, 19, 1, 28, 13)
 datetime.datetime(2013, 6, 19, 1, 58, 9)
 datetime.datetime(2013, 6, 19, 1, 58, 11)
 datetime.datetime(2013, 6, 19, 1, 58, 13)
 datetime.datetime(2013, 6, 19, 2, 28, 9)
 datetime.datetime(2013, 6, 19, 2, 28, 11)
 datetime.datetime(2013, 6, 19, 2, 28, 13)
 datetime.datetime(2013, 6, 19, 2, 58, 9)
 datetime.datetime(2013, 6, 19, 2, 58, 11)
 datetime.datetime(2013, 6, 19, 2, 58, 13)
 datetime.datetime(2013, 6, 19, 3, 28, 9)
 datetime.datetime(2013, 6, 19, 3, 28, 11)
 datetime.datetime(2013, 6, 19, 3, 28, 13)
 datetime.datetime(2013, 6, 19, 3, 58, 9)
 datetime.datetime(2013, 6, 19, 3, 58, 11)
 datetime.datetime(2013, 6, 19, 3, 58, 13)
 datetime.datetime(2013, 6, 19, 4, 28, 9)
 datetime.datetime(2013, 6, 19, 4, 28, 11)
 datetime.datetime(2013, 6, 19, 4, 28, 13)
 datetime.datetime(2013, 6, 19, 4, 58, 9)
 datetime.datetime(2013, 6, 19, 4, 58, 11)
 datetime.datetime(2013, 6, 19, 4, 58, 13)
 datetime.datetime(2013, 6, 19, 5, 28, 9)
 datetime.datetime(2013, 6, 19, 5, 28, 11)
 datetime.datetime(2013, 6, 19, 5, 28, 13)
 datetime.datetime(2013, 6, 19, 5, 58, 9)
 datetime.datetime(2013, 6, 19, 5, 58, 11)
 datetime.datetime(2013, 6, 19, 5, 58, 13)
 datetime.datetime(2013, 6, 19, 6, 28, 9)
 datetime.datetime(2013, 6, 19, 6, 28, 11)
 datetime.datetime(2013, 6, 19, 6, 28, 13)
 datetime.datetime(2013, 6, 19, 6, 58, 9)
 datetime.datetime(2013, 6, 19, 6, 58, 11)
 datetime.datetime(2013, 6, 19, 6, 58, 13)
 datetime.datetime(2013, 6, 19, 7, 28, 9)
 datetime.datetime(2013, 6, 19, 7, 28, 11)
 datetime.datetime(2013, 6, 19, 7, 28, 13)
 datetime.datetime(2013, 6, 19, 7, 58, 9)
 datetime.datetime(2013, 6, 19, 7, 58, 11)
 datetime.datetime(2013, 6, 19, 7, 58, 13)
 datetime.datetime(2013, 6, 19, 8, 28, 9)
 datetime.datetime(2013, 6, 19, 8, 28, 11)
 datetime.datetime(2013, 6, 19, 8, 28, 13)
 datetime.datetime(2013, 6, 19, 8, 58, 9)
 datetime.datetime(2013, 6, 19, 8, 58, 11)
 datetime.datetime(2013, 6, 19, 8, 58, 13)
 datetime.datetime(2013, 6, 19, 9, 28, 9)
 datetime.datetime(2013, 6, 19, 9, 28, 11)
 datetime.datetime(2013, 6, 19, 9, 28, 13)
 datetime.datetime(2013, 6, 19, 9, 58, 9)
 datetime.datetime(2013, 6, 19, 9, 58, 11)
 datetime.datetime(2013, 6, 19, 9, 58, 13)
 datetime.datetime(2013, 6, 19, 10, 28, 9)
 datetime.datetime(2013, 6, 19, 10, 28, 11)
 datetime.datetime(2013, 6, 19, 10, 28, 13)
 datetime.datetime(2013, 6, 19, 10, 58, 9)
 datetime.datetime(2013, 6, 19, 10, 58, 11)
 datetime.datetime(2013, 6, 19, 10, 58, 13)
 datetime.datetime(2013, 6, 19, 11, 28, 9)
 datetime.datetime(2013, 6, 19, 11, 28, 11)
 datetime.datetime(2013, 6, 19, 11, 28, 13)
 datetime.datetime(2013, 6, 19, 11, 58, 9)
 datetime.datetime(2013, 6, 19, 11, 58, 11)
 datetime.datetime(2013, 6, 19, 11, 58, 13)
 datetime.datetime(2013, 6, 19, 12, 28, 9)
 datetime.datetime(2013, 6, 19, 12, 28, 11)
 datetime.datetime(2013, 6, 19, 12, 28, 13)
 datetime.datetime(2013, 6, 19, 12, 58, 9)
 datetime.datetime(2013, 6, 19, 12, 58, 11)
 datetime.datetime(2013, 6, 19, 12, 58, 13)
 datetime.datetime(2013, 6, 19, 13, 28, 9)
 datetime.datetime(2013, 6, 19, 13, 28, 11)
 datetime.datetime(2013, 6, 19, 13, 28, 13)
 datetime.datetime(2013, 6, 19, 13, 58, 9)
 datetime.datetime(2013, 6, 19, 13, 58, 11)
 datetime.datetime(2013, 6, 19, 13, 58, 13)
 datetime.datetime(2013, 6, 19, 14, 28, 9)
 datetime.datetime(2013, 6, 19, 14, 28, 11)
 datetime.datetime(2013, 6, 19, 14, 28, 13)
 datetime.datetime(2013, 6, 19, 14, 58, 9)
 datetime.datetime(2013, 6, 19, 14, 58, 11)
 datetime.datetime(2013, 6, 19, 14, 58, 13)
 datetime.datetime(2013, 6, 19, 15, 28, 9)
 datetime.datetime(2013, 6, 19, 15, 28, 11)
 datetime.datetime(2013, 6, 19, 15, 28, 13)
 datetime.datetime(2013, 6, 19, 15, 58, 9)
 datetime.datetime(2013, 6, 19, 15, 58, 11)
 datetime.datetime(2013, 6, 19, 15, 58, 13)
 datetime.datetime(2013, 6, 19, 16, 28, 9)
 datetime.datetime(2013, 6, 19, 16, 28, 11)
 datetime.datetime(2013, 6, 19, 16, 28, 13)
 datetime.datetime(2013, 6, 19, 16, 58, 9)
 datetime.datetime(2013, 6, 19, 16, 58, 11)
 datetime.datetime(2013, 6, 19, 16, 58, 13)
 datetime.datetime(2013, 6, 19, 17, 28, 9)
 datetime.datetime(2013, 6, 19, 17, 28, 11)
 datetime.datetime(2013, 6, 19, 17, 28, 13)
 datetime.datetime(2013, 6, 19, 17, 58, 9)
 datetime.datetime(2013, 6, 19, 17, 58, 11)
 datetime.datetime(2013, 6, 19, 17, 58, 13)
 datetime.datetime(2013, 6, 19, 18, 28, 9)
 datetime.datetime(2013, 6, 19, 18, 28, 11)
 datetime.datetime(2013, 6, 19, 18, 28, 13)
 datetime.datetime(2013, 6, 19, 18, 58, 9)
 datetime.datetime(2013, 6, 19, 18, 58, 11)
 datetime.datetime(2013, 6, 19, 18, 58, 13)
 datetime.datetime(2013, 6, 19, 19, 28, 9)
 datetime.datetime(2013, 6, 19, 19, 28, 11)
 datetime.datetime(2013, 6, 19, 19, 28, 13)
 datetime.datetime(2013, 6, 19, 19, 58, 9)
 datetime.datetime(2013, 6, 19, 19, 58, 11)
 datetime.datetime(2013, 6, 19, 19, 58, 13)
 datetime.datetime(2013, 6, 19, 20, 28, 9)
 datetime.datetime(2013, 6, 19, 20, 28, 11)
 datetime.datetime(2013, 6, 19, 20, 28, 13)
 datetime.datetime(2013, 6, 19, 20, 58, 9)
 datetime.datetime(2013, 6, 19, 20, 58, 11)
 datetime.datetime(2013, 6, 19, 20, 58, 13)
 datetime.datetime(2013, 6, 19, 21, 28, 9)
 datetime.datetime(2013, 6, 19, 21, 28, 11)
 datetime.datetime(2013, 6, 19, 21, 28, 13)
 datetime.datetime(2013, 6, 19, 21, 58, 9)
 datetime.datetime(2013, 6, 19, 21, 58, 11)
 datetime.datetime(2013, 6, 19, 21, 58, 13)
 datetime.datetime(2013, 6, 19, 22, 28, 9)
 datetime.datetime(2013, 6, 19, 22, 28, 11)
 datetime.datetime(2013, 6, 19, 22, 28, 13)
 datetime.datetime(2013, 6, 19, 22, 58, 9)
 datetime.datetime(2013, 6, 19, 22, 58, 11)
 datetime.datetime(2013, 6, 19, 22, 58, 13)
 datetime.datetime(2013, 6, 19, 23, 28, 9)
 datetime.datetime(2013, 6, 19, 23, 28, 11)
 datetime.datetime(2013, 6, 19, 23, 28, 13)
 datetime.datetime(2013, 6, 19, 23, 58, 9)
 datetime.datetime(2013, 6, 19, 23, 58, 11)
 datetime.datetime(2013, 6, 19, 23, 58, 13)
 datetime.datetime(2013, 6, 20, 0, 28, 9)
 datetime.datetime(2013, 6, 20, 0, 28, 11)
 datetime.datetime(2013, 6, 20, 0, 28, 13)
 datetime.datetime(2013, 6, 20, 0, 58, 9)
 datetime.datetime(2013, 6, 20, 0, 58, 11)
 datetime.datetime(2013, 6, 20, 0, 58, 13)
 datetime.datetime(2013, 6, 20, 1, 28, 9)
 datetime.datetime(2013, 6, 20, 1, 28, 11)
 datetime.datetime(2013, 6, 20, 1, 28, 13)
 datetime.datetime(2013, 6, 20, 1, 58, 9)
 datetime.datetime(2013, 6, 20, 1, 58, 11)
 datetime.datetime(2013, 6, 20, 1, 58, 13)
 datetime.datetime(2013, 6, 20, 2, 28, 9)
 datetime.datetime(2013, 6, 20, 2, 28, 11)
 datetime.datetime(2013, 6, 20, 2, 28, 13)
 datetime.datetime(2013, 6, 20, 2, 58, 9)
 datetime.datetime(2013, 6, 20, 2, 58, 11)
 datetime.datetime(2013, 6, 20, 2, 58, 13)
 datetime.datetime(2013, 6, 20, 3, 28, 9)
 datetime.datetime(2013, 6, 20, 3, 28, 11)
 datetime.datetime(2013, 6, 20, 3, 28, 13)
 datetime.datetime(2013, 6, 20, 3, 58, 9)
 datetime.datetime(2013, 6, 20, 3, 58, 11)
 datetime.datetime(2013, 6, 20, 3, 58, 13)
 datetime.datetime(2013, 6, 20, 4, 28, 9)
 datetime.datetime(2013, 6, 20, 4, 28, 11)
 datetime.datetime(2013, 6, 20, 4, 28, 13)
 datetime.datetime(2013, 6, 20, 4, 58, 9)
 datetime.datetime(2013, 6, 20, 4, 58, 11)
 datetime.datetime(2013, 6, 20, 4, 58, 13)
 datetime.datetime(2013, 6, 20, 5, 28, 9)
 datetime.datetime(2013, 6, 20, 5, 28, 11)
 datetime.datetime(2013, 6, 20, 5, 28, 13)
 datetime.datetime(2013, 6, 20, 5, 58, 9)
 datetime.datetime(2013, 6, 20, 5, 58, 11)
 datetime.datetime(2013, 6, 20, 5, 58, 13)
 datetime.datetime(2013, 6, 20, 6, 28, 9)
 datetime.datetime(2013, 6, 20, 6, 28, 11)
 datetime.datetime(2013, 6, 20, 6, 28, 13)
 datetime.datetime(2013, 6, 20, 6, 58, 9)
 datetime.datetime(2013, 6, 20, 6, 58, 11)
 datetime.datetime(2013, 6, 20, 6, 58, 13)
 datetime.datetime(2013, 6, 20, 7, 28, 9)
 datetime.datetime(2013, 6, 20, 7, 28, 11)
 datetime.datetime(2013, 6, 20, 7, 28, 13)
 datetime.datetime(2013, 6, 20, 7, 58, 9)
 datetime.datetime(2013, 6, 20, 7, 58, 11)
 datetime.datetime(2013, 6, 20, 7, 58, 13)
 datetime.datetime(2013, 6, 20, 8, 28, 9)
 datetime.datetime(2013, 6, 20, 8, 28, 11)
 datetime.datetime(2013, 6, 20, 8, 28, 13)
 datetime.datetime(2013, 6, 20, 8, 58, 9)
 datetime.datetime(2013, 6, 20, 8, 58, 11)
 datetime.datetime(2013, 6, 20, 8, 58, 13)
 datetime.datetime(2013, 6, 20, 9, 28, 9)
 datetime.datetime(2013, 6, 20, 9, 28, 11)
 datetime.datetime(2013, 6, 20, 9, 28, 13)
 datetime.datetime(2013, 6, 20, 9, 58, 9)
 datetime.datetime(2013, 6, 20, 9, 58, 11)
 datetime.datetime(2013, 6, 20, 9, 58, 13)
 datetime.datetime(2013, 6, 20, 10, 28, 9)
 datetime.datetime(2013, 6, 20, 10, 28, 11)
 datetime.datetime(2013, 6, 20, 10, 28, 13)
 datetime.datetime(2013, 6, 20, 10, 58, 9)
 datetime.datetime(2013, 6, 20, 10, 58, 11)
 datetime.datetime(2013, 6, 20, 10, 58, 13)
 datetime.datetime(2013, 6, 20, 11, 28, 9)
 datetime.datetime(2013, 6, 20, 11, 28, 11)
 datetime.datetime(2013, 6, 20, 11, 28, 13)
 datetime.datetime(2013, 6, 20, 11, 58, 9)
 datetime.datetime(2013, 6, 20, 11, 58, 11)
 datetime.datetime(2013, 6, 20, 11, 58, 13)
 datetime.datetime(2013, 6, 20, 12, 28, 9)
 datetime.datetime(2013, 6, 20, 12, 28, 11)
 datetime.datetime(2013, 6, 20, 12, 28, 13)
 datetime.datetime(2013, 6, 20, 12, 58, 9)
 datetime.datetime(2013, 6, 20, 12, 58, 11)
 datetime.datetime(2013, 6, 20, 12, 58, 13)
 datetime.datetime(2013, 6, 20, 13, 28, 9)
 datetime.datetime(2013, 6, 20, 13, 28, 11)
 datetime.datetime(2013, 6, 20, 13, 28, 13)
 datetime.datetime(2013, 6, 20, 13, 58, 9)
 datetime.datetime(2013, 6, 20, 13, 58, 11)
 datetime.datetime(2013, 6, 20, 13, 58, 13)
 datetime.datetime(2013, 6, 20, 14, 28, 9)
 datetime.datetime(2013, 6, 20, 14, 28, 11)
 datetime.datetime(2013, 6, 20, 14, 28, 13)
 datetime.datetime(2013, 6, 20, 14, 58, 9)
 datetime.datetime(2013, 6, 20, 14, 58, 11)
 datetime.datetime(2013, 6, 20, 14, 58, 13)
 datetime.datetime(2013, 6, 20, 15, 28, 9)
 datetime.datetime(2013, 6, 20, 15, 28, 11)
 datetime.datetime(2013, 6, 20, 15, 28, 13)
 datetime.datetime(2013, 6, 20, 15, 58, 9)
 datetime.datetime(2013, 6, 20, 15, 58, 11)
 datetime.datetime(2013, 6, 20, 15, 58, 13)
 datetime.datetime(2013, 6, 20, 16, 28, 9)
 datetime.datetime(2013, 6, 20, 16, 28, 11)
 datetime.datetime(2013, 6, 20, 16, 28, 13)
 datetime.datetime(2013, 6, 20, 16, 58, 9)
 datetime.datetime(2013, 6, 20, 16, 58, 11)
 datetime.datetime(2013, 6, 20, 16, 58, 13)
 datetime.datetime(2013, 6, 20, 17, 28, 9)
 datetime.datetime(2013, 6, 20, 17, 28, 11)
 datetime.datetime(2013, 6, 20, 17, 28, 13)
 datetime.datetime(2013, 6, 20, 17, 58, 9)
 datetime.datetime(2013, 6, 20, 17, 58, 11)
 datetime.datetime(2013, 6, 20, 17, 58, 13)
 datetime.datetime(2013, 6, 20, 18, 28, 9)
 datetime.datetime(2013, 6, 20, 18, 28, 11)
 datetime.datetime(2013, 6, 20, 18, 28, 13)
 datetime.datetime(2013, 6, 20, 18, 58, 9)
 datetime.datetime(2013, 6, 20, 18, 58, 11)
 datetime.datetime(2013, 6, 20, 18, 58, 13)
 datetime.datetime(2013, 6, 20, 19, 28, 9)
 datetime.datetime(2013, 6, 20, 19, 28, 11)
 datetime.datetime(2013, 6, 20, 19, 28, 13)
 datetime.datetime(2013, 6, 20, 19, 58, 9)
 datetime.datetime(2013, 6, 20, 19, 58, 11)
 datetime.datetime(2013, 6, 20, 19, 58, 13)
 datetime.datetime(2013, 6, 20, 20, 28, 9)
 datetime.datetime(2013, 6, 20, 20, 28, 11)
 datetime.datetime(2013, 6, 20, 20, 28, 13)
 datetime.datetime(2013, 6, 20, 20, 58, 9)
 datetime.datetime(2013, 6, 20, 20, 58, 11)
 datetime.datetime(2013, 6, 20, 20, 58, 13)
 datetime.datetime(2013, 6, 20, 21, 28, 9)
 datetime.datetime(2013, 6, 20, 21, 28, 11)
 datetime.datetime(2013, 6, 20, 21, 28, 13)
 datetime.datetime(2013, 6, 20, 21, 58, 9)
 datetime.datetime(2013, 6, 20, 21, 58, 11)
 datetime.datetime(2013, 6, 20, 21, 58, 13)
 datetime.datetime(2013, 6, 20, 22, 28, 9)
 datetime.datetime(2013, 6, 20, 22, 28, 11)
 datetime.datetime(2013, 6, 20, 22, 28, 13)
 datetime.datetime(2013, 6, 20, 22, 58, 9)
 datetime.datetime(2013, 6, 20, 22, 58, 11)
 datetime.datetime(2013, 6, 20, 22, 58, 13)
 datetime.datetime(2013, 6, 20, 23, 28, 9)
 datetime.datetime(2013, 6, 20, 23, 28, 11)
 datetime.datetime(2013, 6, 20, 23, 28, 13)
 datetime.datetime(2013, 6, 20, 23, 58, 9)
 datetime.datetime(2013, 6, 20, 23, 58, 11)
 datetime.datetime(2013, 6, 20, 23, 58, 13)
 datetime.datetime(2013, 6, 21, 0, 28, 9)
 datetime.datetime(2013, 6, 21, 0, 28, 11)
 datetime.datetime(2013, 6, 21, 0, 28, 13)
 datetime.datetime(2013, 6, 21, 0, 58, 9)
 datetime.datetime(2013, 6, 21, 0, 58, 11)
 datetime.datetime(2013, 6, 21, 0, 58, 13)
 datetime.datetime(2013, 6, 21, 1, 28, 9)
 datetime.datetime(2013, 6, 21, 1, 28, 11)
 datetime.datetime(2013, 6, 21, 1, 28, 13)
 datetime.datetime(2013, 6, 21, 1, 58, 9)
 datetime.datetime(2013, 6, 21, 1, 58, 11)
 datetime.datetime(2013, 6, 21, 1, 58, 13)
 datetime.datetime(2013, 6, 21, 2, 28, 9)
 datetime.datetime(2013, 6, 21, 2, 28, 11)
 datetime.datetime(2013, 6, 21, 2, 28, 13)
 datetime.datetime(2013, 6, 21, 2, 58, 9)
 datetime.datetime(2013, 6, 21, 2, 58, 11)
 datetime.datetime(2013, 6, 21, 2, 58, 13)
 datetime.datetime(2013, 6, 21, 3, 28, 9)
 datetime.datetime(2013, 6, 21, 3, 28, 11)
 datetime.datetime(2013, 6, 21, 3, 28, 13)
 datetime.datetime(2013, 6, 21, 3, 58, 9)
 datetime.datetime(2013, 6, 21, 3, 58, 11)
 datetime.datetime(2013, 6, 21, 3, 58, 13)
 datetime.datetime(2013, 6, 21, 4, 28, 9)
 datetime.datetime(2013, 6, 21, 4, 28, 11)
 datetime.datetime(2013, 6, 21, 4, 28, 13)
 datetime.datetime(2013, 6, 21, 4, 58, 9)
 datetime.datetime(2013, 6, 21, 4, 58, 11)
 datetime.datetime(2013, 6, 21, 4, 58, 13)
 datetime.datetime(2013, 6, 21, 5, 28, 9)
 datetime.datetime(2013, 6, 21, 5, 28, 11)
 datetime.datetime(2013, 6, 21, 5, 28, 13)
 datetime.datetime(2013, 6, 21, 5, 58, 9)
 datetime.datetime(2013, 6, 21, 5, 58, 11)
 datetime.datetime(2013, 6, 21, 5, 58, 13)
 datetime.datetime(2013, 6, 21, 6, 28, 9)
 datetime.datetime(2013, 6, 21, 6, 28, 11)
 datetime.datetime(2013, 6, 21, 6, 28, 13)
 datetime.datetime(2013, 6, 21, 6, 58, 9)
 datetime.datetime(2013, 6, 21, 6, 58, 11)
 datetime.datetime(2013, 6, 21, 6, 58, 13)
 datetime.datetime(2013, 6, 21, 7, 28, 9)
 datetime.datetime(2013, 6, 21, 7, 28, 11)
 datetime.datetime(2013, 6, 21, 7, 28, 13)
 datetime.datetime(2013, 6, 21, 7, 58, 9)
 datetime.datetime(2013, 6, 21, 7, 58, 11)
 datetime.datetime(2013, 6, 21, 7, 58, 13)
 datetime.datetime(2013, 6, 21, 8, 28, 9)
 datetime.datetime(2013, 6, 21, 8, 28, 11)
 datetime.datetime(2013, 6, 21, 8, 28, 13)
 datetime.datetime(2013, 6, 21, 8, 58, 9)
 datetime.datetime(2013, 6, 21, 8, 58, 11)
 datetime.datetime(2013, 6, 21, 8, 58, 13)
 datetime.datetime(2013, 6, 21, 9, 28, 9)
 datetime.datetime(2013, 6, 21, 9, 28, 11)
 datetime.datetime(2013, 6, 21, 9, 28, 13)
 datetime.datetime(2013, 6, 21, 9, 58, 9)
 datetime.datetime(2013, 6, 21, 9, 58, 11)
 datetime.datetime(2013, 6, 21, 9, 58, 13)
 datetime.datetime(2013, 6, 21, 10, 28, 9)
 datetime.datetime(2013, 6, 21, 10, 28, 11)
 datetime.datetime(2013, 6, 21, 10, 28, 13)
 datetime.datetime(2013, 6, 21, 10, 58, 9)
 datetime.datetime(2013, 6, 21, 10, 58, 11)
 datetime.datetime(2013, 6, 21, 10, 58, 13)
 datetime.datetime(2013, 6, 21, 11, 28, 9)
 datetime.datetime(2013, 6, 21, 11, 28, 11)
 datetime.datetime(2013, 6, 21, 11, 28, 13)
 datetime.datetime(2013, 6, 21, 11, 58, 9)
 datetime.datetime(2013, 6, 21, 11, 58, 11)
 datetime.datetime(2013, 6, 21, 11, 58, 13)
 datetime.datetime(2013, 6, 21, 12, 28, 9)
 datetime.datetime(2013, 6, 21, 12, 28, 11)
 datetime.datetime(2013, 6, 21, 12, 28, 13)
 datetime.datetime(2013, 6, 21, 12, 58, 9)
 datetime.datetime(2013, 6, 21, 12, 58, 11)
 datetime.datetime(2013, 6, 21, 12, 58, 13)
 datetime.datetime(2013, 6, 21, 13, 28, 9)
 datetime.datetime(2013, 6, 21, 13, 28, 11)
 datetime.datetime(2013, 6, 21, 13, 28, 13)
 datetime.datetime(2013, 6, 21, 13, 58, 9)
 datetime.datetime(2013, 6, 21, 13, 58, 11)
 datetime.datetime(2013, 6, 21, 13, 58, 13)
 datetime.datetime(2013, 6, 21, 14, 28, 9)
 datetime.datetime(2013, 6, 21, 14, 28, 11)
 datetime.datetime(2013, 6, 21, 14, 28, 13)
 datetime.datetime(2013, 6, 21, 14, 58, 9)
 datetime.datetime(2013, 6, 21, 14, 58, 11)
 datetime.datetime(2013, 6, 21, 14, 58, 13)],
error was: 'numpy.ndarray' object has no attribute 'find'
Consider setting raise_on_error=Falseto suppress

In [164]:
df1[['CO2','Temperature']].plot(figsize=(15,4),secondary_y = 'Temperature');


---------------------------------------------------------------------------
Exception                                 Traceback (most recent call last)
<ipython-input-164-5b63ba2dd837> in <module>()
----> 1 df1[['CO2','Temperature']].plot(figsize=(15,4),secondary_y = 'Temperature');

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in plot_frame(frame, x, y, subplots, sharex, sharey, use_index, figsize, grid, legend, rot, ax, style, title, xlim, ylim, logx, logy, xticks, yticks, kind, sort_columns, fontsize, secondary_y, **kwds)
   1564                      logy=logy, sort_columns=sort_columns,
   1565                      secondary_y=secondary_y, **kwds)
-> 1566     plot_obj.generate()
   1567     plot_obj.draw()
   1568     if subplots:

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in generate(self)
    798         self._compute_plot_data()
    799         self._setup_subplots()
--> 800         self._make_plot()
    801         self._post_plot_logic()
    802         self._adorn_subplots()

/home/local/python27_epd/lib/python2.7/site-packages/pandas/tools/plotting.py in _make_plot(self)
   1195                         msg = msg + ('\nConsider setting raise_on_error=False'
   1196                                      'to suppress')
-> 1197                         raise Exception(msg)
   1198 
   1199             self._make_legend(lines, labels)

Exception: Unable to plot data ['31.10' '31.11' '31.11' '30.82' '30.82' '30.82' '30.59' '30.59' '30.59'
 '30.18' '30.18' '30.18' '30.06' '30.06' '30.06' '29.95' '29.95' '29.95'
 '29.83' '29.83' '29.83' '29.66' '29.66' '29.66' '29.37' '29.37' '29.37'
 '29.25' '29.25' '29.25' '29.19' '29.19' '29.19' '28.84' '28.84' '28.84'
 '28.67' '28.67' '28.67' '28.38' '28.38' '28.38' '27.97' '27.97' '27.98'
 '27.39' '27.39' '27.39' '27.28' '27.28' '27.28' '27.34' '27.34' '27.36'
 '27.25' '27.25' '27.27' '26.98' '26.98' '26.98' '26.58' '26.58' '26.58'
 '26.29' '26.29' '26.29' '27.74' '27.74' '27.74' '28.03' '28.03' '28.03'
 '27.86' '27.86' '27.86' '27.62' '27.62' '27.63' '27.57' '27.57' '27.57'
 '27.22' '27.22' '27.22' '27.45' '27.45' '27.45' '27.34' '27.34' '27.33'
 '26.98' '26.98' '26.98' '26.98' '26.98' '26.99' '27.11' '27.13' '27.13'
 '26.98' '26.98' '26.98' '26.97' '26.98' '26.98' '27.10' '27.10' '27.10'
 '27.28' '27.28' '27.28' '27.62' '27.62' '27.62' '27.97' '27.97' '27.97'
 '28.26' '28.26' '28.27' '28.61' '28.61' '28.61' '29.08' '29.08' '29.08'
 '29.66' '29.66' '29.66' '30.30' '30.30' '30.30' '30.75' '30.75' '30.76'
 '29.66' '29.66' '29.66' '29.60' '29.60' '29.60' '29.66' '29.66' '29.66'
 '29.51' '29.53' '29.54' '29.48' '29.48' '29.48' '29.42' '29.43' '29.43'
 '29.37' '29.37' '29.37' '29.19' '29.19' '29.19' '29.13' '29.13' '29.13'
 '29.13' '29.13' '29.13' '29.01' '29.01' '29.02' '28.84' '28.84' '28.84'
 '28.73' '28.73' '28.74' '28.67' '28.67' '28.67' '28.55' '28.55' '28.55'
 '28.15' '28.15' '28.15' '27.78' '27.79' '27.80' '27.57' '27.57' '27.57'
 '27.33' '27.33' '27.33' '26.87' '26.87' '26.87' '26.29' '26.29' '26.29'
 '26.00' '26.01' '26.01' '26.00' '26.00' '26.00' '25.42' '25.42' '25.42'
 '24.49' '24.49' '24.49' '23.88' '23.89' '23.90' '23.09' '23.09' '23.09'
 '23.03' '23.04' '23.04' '26.06' '26.06' '26.06' '26.97' '26.97' '26.98'
 '27.28' '27.28' '27.28' '25.59' '25.59' '25.59' '25.07' '25.07' '25.07'
 '26.06' '26.06' '26.06' '26.94' '26.94' '26.94' '27.07' '27.08' '27.10'
 '26.85' '26.86' '26.87' '26.87' '26.87' '26.87' '27.28' '27.28' '27.28'
 '27.51' '27.51' '27.51' '27.74' '27.74' '27.74' '27.97' '27.97' '28.00'
 '28.20' '28.20' '28.20' '28.48' '28.49' '28.49' '28.85' '28.86' '28.88'
 '29.36' '29.36' '29.37' '29.77' '29.77' '29.77' '30.12' '30.12' '30.12'
 '30.53' '30.53' '30.53' '31.05' '31.05' '31.05' '31.22' '31.22' '31.22'
 '31.16' '31.17' '31.17' '31.46' '31.47' '31.48' '31.17' '31.17' '31.17'
 '30.88' '30.88' '30.88' '30.64' '30.64' '30.64' '30.29' '30.29' '30.28'
 '30.00' '30.00' '30.00' '29.59' '29.59' '29.59' '29.42' '29.42' '29.42'
 '29.37' '29.38' '29.39' '29.31' '29.31' '29.31' '29.25' '29.25' '29.25'
 '29.08' '29.08' '29.08' '28.84' '28.84' '28.84' '28.32' '28.32' '28.32'
 '27.68' '27.68' '27.68' '27.16' '27.16' '27.16' '26.52' '26.52' '26.52'
 '26.06' '26.06' '26.06' '26.00' '26.00' '26.00' '25.82' '25.82' '25.82'
 '25.36' '25.36' '25.36' '24.49' '24.49' '24.49' '23.73' '23.73' '23.73'
 '23.21' '23.21' '23.21' '22.42' '22.44' '22.42' '21.58' '21.58' '21.58'
 '21.12' '21.12' '21.12' '20.94' '20.94' '20.94' '24.01' '24.02' '24.01'
 '25.65' '25.65' '25.66' '25.30' '25.32' '25.33' '25.71' '25.71' '25.71'
 '25.98' '25.99' '25.98' '26.13' '26.14' '26.16' '26.17' '26.17' '26.17'
 '26.29' '26.29' '26.29' '26.52' '26.52' '26.52'] vs index [datetime.datetime(2013, 6, 18, 20, 28, 9)
 datetime.datetime(2013, 6, 18, 20, 28, 11)
 datetime.datetime(2013, 6, 18, 20, 28, 13)
 datetime.datetime(2013, 6, 18, 20, 58, 9)
 datetime.datetime(2013, 6, 18, 20, 58, 11)
 datetime.datetime(2013, 6, 18, 20, 58, 13)
 datetime.datetime(2013, 6, 18, 21, 28, 9)
 datetime.datetime(2013, 6, 18, 21, 28, 11)
 datetime.datetime(2013, 6, 18, 21, 28, 13)
 datetime.datetime(2013, 6, 18, 21, 58, 9)
 datetime.datetime(2013, 6, 18, 21, 58, 11)
 datetime.datetime(2013, 6, 18, 21, 58, 13)
 datetime.datetime(2013, 6, 18, 22, 28, 9)
 datetime.datetime(2013, 6, 18, 22, 28, 11)
 datetime.datetime(2013, 6, 18, 22, 28, 13)
 datetime.datetime(2013, 6, 18, 22, 58, 9)
 datetime.datetime(2013, 6, 18, 22, 58, 11)
 datetime.datetime(2013, 6, 18, 22, 58, 13)
 datetime.datetime(2013, 6, 18, 23, 28, 9)
 datetime.datetime(2013, 6, 18, 23, 28, 11)
 datetime.datetime(2013, 6, 18, 23, 28, 13)
 datetime.datetime(2013, 6, 18, 23, 58, 9)
 datetime.datetime(2013, 6, 18, 23, 58, 11)
 datetime.datetime(2013, 6, 18, 23, 58, 13)
 datetime.datetime(2013, 6, 19, 0, 28, 9)
 datetime.datetime(2013, 6, 19, 0, 28, 11)
 datetime.datetime(2013, 6, 19, 0, 28, 13)
 datetime.datetime(2013, 6, 19, 0, 58, 9)
 datetime.datetime(2013, 6, 19, 0, 58, 11)
 datetime.datetime(2013, 6, 19, 0, 58, 13)
 datetime.datetime(2013, 6, 19, 1, 28, 9)
 datetime.datetime(2013, 6, 19, 1, 28, 11)
 datetime.datetime(2013, 6, 19, 1, 28, 13)
 datetime.datetime(2013, 6, 19, 1, 58, 9)
 datetime.datetime(2013, 6, 19, 1, 58, 11)
 datetime.datetime(2013, 6, 19, 1, 58, 13)
 datetime.datetime(2013, 6, 19, 2, 28, 9)
 datetime.datetime(2013, 6, 19, 2, 28, 11)
 datetime.datetime(2013, 6, 19, 2, 28, 13)
 datetime.datetime(2013, 6, 19, 2, 58, 9)
 datetime.datetime(2013, 6, 19, 2, 58, 11)
 datetime.datetime(2013, 6, 19, 2, 58, 13)
 datetime.datetime(2013, 6, 19, 3, 28, 9)
 datetime.datetime(2013, 6, 19, 3, 28, 11)
 datetime.datetime(2013, 6, 19, 3, 28, 13)
 datetime.datetime(2013, 6, 19, 3, 58, 9)
 datetime.datetime(2013, 6, 19, 3, 58, 11)
 datetime.datetime(2013, 6, 19, 3, 58, 13)
 datetime.datetime(2013, 6, 19, 4, 28, 9)
 datetime.datetime(2013, 6, 19, 4, 28, 11)
 datetime.datetime(2013, 6, 19, 4, 28, 13)
 datetime.datetime(2013, 6, 19, 4, 58, 9)
 datetime.datetime(2013, 6, 19, 4, 58, 11)
 datetime.datetime(2013, 6, 19, 4, 58, 13)
 datetime.datetime(2013, 6, 19, 5, 28, 9)
 datetime.datetime(2013, 6, 19, 5, 28, 11)
 datetime.datetime(2013, 6, 19, 5, 28, 13)
 datetime.datetime(2013, 6, 19, 5, 58, 9)
 datetime.datetime(2013, 6, 19, 5, 58, 11)
 datetime.datetime(2013, 6, 19, 5, 58, 13)
 datetime.datetime(2013, 6, 19, 6, 28, 9)
 datetime.datetime(2013, 6, 19, 6, 28, 11)
 datetime.datetime(2013, 6, 19, 6, 28, 13)
 datetime.datetime(2013, 6, 19, 6, 58, 9)
 datetime.datetime(2013, 6, 19, 6, 58, 11)
 datetime.datetime(2013, 6, 19, 6, 58, 13)
 datetime.datetime(2013, 6, 19, 7, 28, 9)
 datetime.datetime(2013, 6, 19, 7, 28, 11)
 datetime.datetime(2013, 6, 19, 7, 28, 13)
 datetime.datetime(2013, 6, 19, 7, 58, 9)
 datetime.datetime(2013, 6, 19, 7, 58, 11)
 datetime.datetime(2013, 6, 19, 7, 58, 13)
 datetime.datetime(2013, 6, 19, 8, 28, 9)
 datetime.datetime(2013, 6, 19, 8, 28, 11)
 datetime.datetime(2013, 6, 19, 8, 28, 13)
 datetime.datetime(2013, 6, 19, 8, 58, 9)
 datetime.datetime(2013, 6, 19, 8, 58, 11)
 datetime.datetime(2013, 6, 19, 8, 58, 13)
 datetime.datetime(2013, 6, 19, 9, 28, 9)
 datetime.datetime(2013, 6, 19, 9, 28, 11)
 datetime.datetime(2013, 6, 19, 9, 28, 13)
 datetime.datetime(2013, 6, 19, 9, 58, 9)
 datetime.datetime(2013, 6, 19, 9, 58, 11)
 datetime.datetime(2013, 6, 19, 9, 58, 13)
 datetime.datetime(2013, 6, 19, 10, 28, 9)
 datetime.datetime(2013, 6, 19, 10, 28, 11)
 datetime.datetime(2013, 6, 19, 10, 28, 13)
 datetime.datetime(2013, 6, 19, 10, 58, 9)
 datetime.datetime(2013, 6, 19, 10, 58, 11)
 datetime.datetime(2013, 6, 19, 10, 58, 13)
 datetime.datetime(2013, 6, 19, 11, 28, 9)
 datetime.datetime(2013, 6, 19, 11, 28, 11)
 datetime.datetime(2013, 6, 19, 11, 28, 13)
 datetime.datetime(2013, 6, 19, 11, 58, 9)
 datetime.datetime(2013, 6, 19, 11, 58, 11)
 datetime.datetime(2013, 6, 19, 11, 58, 13)
 datetime.datetime(2013, 6, 19, 12, 28, 9)
 datetime.datetime(2013, 6, 19, 12, 28, 11)
 datetime.datetime(2013, 6, 19, 12, 28, 13)
 datetime.datetime(2013, 6, 19, 12, 58, 9)
 datetime.datetime(2013, 6, 19, 12, 58, 11)
 datetime.datetime(2013, 6, 19, 12, 58, 13)
 datetime.datetime(2013, 6, 19, 13, 28, 9)
 datetime.datetime(2013, 6, 19, 13, 28, 11)
 datetime.datetime(2013, 6, 19, 13, 28, 13)
 datetime.datetime(2013, 6, 19, 13, 58, 9)
 datetime.datetime(2013, 6, 19, 13, 58, 11)
 datetime.datetime(2013, 6, 19, 13, 58, 13)
 datetime.datetime(2013, 6, 19, 14, 28, 9)
 datetime.datetime(2013, 6, 19, 14, 28, 11)
 datetime.datetime(2013, 6, 19, 14, 28, 13)
 datetime.datetime(2013, 6, 19, 14, 58, 9)
 datetime.datetime(2013, 6, 19, 14, 58, 11)
 datetime.datetime(2013, 6, 19, 14, 58, 13)
 datetime.datetime(2013, 6, 19, 15, 28, 9)
 datetime.datetime(2013, 6, 19, 15, 28, 11)
 datetime.datetime(2013, 6, 19, 15, 28, 13)
 datetime.datetime(2013, 6, 19, 15, 58, 9)
 datetime.datetime(2013, 6, 19, 15, 58, 11)
 datetime.datetime(2013, 6, 19, 15, 58, 13)
 datetime.datetime(2013, 6, 19, 16, 28, 9)
 datetime.datetime(2013, 6, 19, 16, 28, 11)
 datetime.datetime(2013, 6, 19, 16, 28, 13)
 datetime.datetime(2013, 6, 19, 16, 58, 9)
 datetime.datetime(2013, 6, 19, 16, 58, 11)
 datetime.datetime(2013, 6, 19, 16, 58, 13)
 datetime.datetime(2013, 6, 19, 17, 28, 9)
 datetime.datetime(2013, 6, 19, 17, 28, 11)
 datetime.datetime(2013, 6, 19, 17, 28, 13)
 datetime.datetime(2013, 6, 19, 17, 58, 9)
 datetime.datetime(2013, 6, 19, 17, 58, 11)
 datetime.datetime(2013, 6, 19, 17, 58, 13)
 datetime.datetime(2013, 6, 19, 18, 28, 9)
 datetime.datetime(2013, 6, 19, 18, 28, 11)
 datetime.datetime(2013, 6, 19, 18, 28, 13)
 datetime.datetime(2013, 6, 19, 18, 58, 9)
 datetime.datetime(2013, 6, 19, 18, 58, 11)
 datetime.datetime(2013, 6, 19, 18, 58, 13)
 datetime.datetime(2013, 6, 19, 19, 28, 9)
 datetime.datetime(2013, 6, 19, 19, 28, 11)
 datetime.datetime(2013, 6, 19, 19, 28, 13)
 datetime.datetime(2013, 6, 19, 19, 58, 9)
 datetime.datetime(2013, 6, 19, 19, 58, 11)
 datetime.datetime(2013, 6, 19, 19, 58, 13)
 datetime.datetime(2013, 6, 19, 20, 28, 9)
 datetime.datetime(2013, 6, 19, 20, 28, 11)
 datetime.datetime(2013, 6, 19, 20, 28, 13)
 datetime.datetime(2013, 6, 19, 20, 58, 9)
 datetime.datetime(2013, 6, 19, 20, 58, 11)
 datetime.datetime(2013, 6, 19, 20, 58, 13)
 datetime.datetime(2013, 6, 19, 21, 28, 9)
 datetime.datetime(2013, 6, 19, 21, 28, 11)
 datetime.datetime(2013, 6, 19, 21, 28, 13)
 datetime.datetime(2013, 6, 19, 21, 58, 9)
 datetime.datetime(2013, 6, 19, 21, 58, 11)
 datetime.datetime(2013, 6, 19, 21, 58, 13)
 datetime.datetime(2013, 6, 19, 22, 28, 9)
 datetime.datetime(2013, 6, 19, 22, 28, 11)
 datetime.datetime(2013, 6, 19, 22, 28, 13)
 datetime.datetime(2013, 6, 19, 22, 58, 9)
 datetime.datetime(2013, 6, 19, 22, 58, 11)
 datetime.datetime(2013, 6, 19, 22, 58, 13)
 datetime.datetime(2013, 6, 19, 23, 28, 9)
 datetime.datetime(2013, 6, 19, 23, 28, 11)
 datetime.datetime(2013, 6, 19, 23, 28, 13)
 datetime.datetime(2013, 6, 19, 23, 58, 9)
 datetime.datetime(2013, 6, 19, 23, 58, 11)
 datetime.datetime(2013, 6, 19, 23, 58, 13)
 datetime.datetime(2013, 6, 20, 0, 28, 9)
 datetime.datetime(2013, 6, 20, 0, 28, 11)
 datetime.datetime(2013, 6, 20, 0, 28, 13)
 datetime.datetime(2013, 6, 20, 0, 58, 9)
 datetime.datetime(2013, 6, 20, 0, 58, 11)
 datetime.datetime(2013, 6, 20, 0, 58, 13)
 datetime.datetime(2013, 6, 20, 1, 28, 9)
 datetime.datetime(2013, 6, 20, 1, 28, 11)
 datetime.datetime(2013, 6, 20, 1, 28, 13)
 datetime.datetime(2013, 6, 20, 1, 58, 9)
 datetime.datetime(2013, 6, 20, 1, 58, 11)
 datetime.datetime(2013, 6, 20, 1, 58, 13)
 datetime.datetime(2013, 6, 20, 2, 28, 9)
 datetime.datetime(2013, 6, 20, 2, 28, 11)
 datetime.datetime(2013, 6, 20, 2, 28, 13)
 datetime.datetime(2013, 6, 20, 2, 58, 9)
 datetime.datetime(2013, 6, 20, 2, 58, 11)
 datetime.datetime(2013, 6, 20, 2, 58, 13)
 datetime.datetime(2013, 6, 20, 3, 28, 9)
 datetime.datetime(2013, 6, 20, 3, 28, 11)
 datetime.datetime(2013, 6, 20, 3, 28, 13)
 datetime.datetime(2013, 6, 20, 3, 58, 9)
 datetime.datetime(2013, 6, 20, 3, 58, 11)
 datetime.datetime(2013, 6, 20, 3, 58, 13)
 datetime.datetime(2013, 6, 20, 4, 28, 9)
 datetime.datetime(2013, 6, 20, 4, 28, 11)
 datetime.datetime(2013, 6, 20, 4, 28, 13)
 datetime.datetime(2013, 6, 20, 4, 58, 9)
 datetime.datetime(2013, 6, 20, 4, 58, 11)
 datetime.datetime(2013, 6, 20, 4, 58, 13)
 datetime.datetime(2013, 6, 20, 5, 28, 9)
 datetime.datetime(2013, 6, 20, 5, 28, 11)
 datetime.datetime(2013, 6, 20, 5, 28, 13)
 datetime.datetime(2013, 6, 20, 5, 58, 9)
 datetime.datetime(2013, 6, 20, 5, 58, 11)
 datetime.datetime(2013, 6, 20, 5, 58, 13)
 datetime.datetime(2013, 6, 20, 6, 28, 9)
 datetime.datetime(2013, 6, 20, 6, 28, 11)
 datetime.datetime(2013, 6, 20, 6, 28, 13)
 datetime.datetime(2013, 6, 20, 6, 58, 9)
 datetime.datetime(2013, 6, 20, 6, 58, 11)
 datetime.datetime(2013, 6, 20, 6, 58, 13)
 datetime.datetime(2013, 6, 20, 7, 28, 9)
 datetime.datetime(2013, 6, 20, 7, 28, 11)
 datetime.datetime(2013, 6, 20, 7, 28, 13)
 datetime.datetime(2013, 6, 20, 7, 58, 9)
 datetime.datetime(2013, 6, 20, 7, 58, 11)
 datetime.datetime(2013, 6, 20, 7, 58, 13)
 datetime.datetime(2013, 6, 20, 8, 28, 9)
 datetime.datetime(2013, 6, 20, 8, 28, 11)
 datetime.datetime(2013, 6, 20, 8, 28, 13)
 datetime.datetime(2013, 6, 20, 8, 58, 9)
 datetime.datetime(2013, 6, 20, 8, 58, 11)
 datetime.datetime(2013, 6, 20, 8, 58, 13)
 datetime.datetime(2013, 6, 20, 9, 28, 9)
 datetime.datetime(2013, 6, 20, 9, 28, 11)
 datetime.datetime(2013, 6, 20, 9, 28, 13)
 datetime.datetime(2013, 6, 20, 9, 58, 9)
 datetime.datetime(2013, 6, 20, 9, 58, 11)
 datetime.datetime(2013, 6, 20, 9, 58, 13)
 datetime.datetime(2013, 6, 20, 10, 28, 9)
 datetime.datetime(2013, 6, 20, 10, 28, 11)
 datetime.datetime(2013, 6, 20, 10, 28, 13)
 datetime.datetime(2013, 6, 20, 10, 58, 9)
 datetime.datetime(2013, 6, 20, 10, 58, 11)
 datetime.datetime(2013, 6, 20, 10, 58, 13)
 datetime.datetime(2013, 6, 20, 11, 28, 9)
 datetime.datetime(2013, 6, 20, 11, 28, 11)
 datetime.datetime(2013, 6, 20, 11, 28, 13)
 datetime.datetime(2013, 6, 20, 11, 58, 9)
 datetime.datetime(2013, 6, 20, 11, 58, 11)
 datetime.datetime(2013, 6, 20, 11, 58, 13)
 datetime.datetime(2013, 6, 20, 12, 28, 9)
 datetime.datetime(2013, 6, 20, 12, 28, 11)
 datetime.datetime(2013, 6, 20, 12, 28, 13)
 datetime.datetime(2013, 6, 20, 12, 58, 9)
 datetime.datetime(2013, 6, 20, 12, 58, 11)
 datetime.datetime(2013, 6, 20, 12, 58, 13)
 datetime.datetime(2013, 6, 20, 13, 28, 9)
 datetime.datetime(2013, 6, 20, 13, 28, 11)
 datetime.datetime(2013, 6, 20, 13, 28, 13)
 datetime.datetime(2013, 6, 20, 13, 58, 9)
 datetime.datetime(2013, 6, 20, 13, 58, 11)
 datetime.datetime(2013, 6, 20, 13, 58, 13)
 datetime.datetime(2013, 6, 20, 14, 28, 9)
 datetime.datetime(2013, 6, 20, 14, 28, 11)
 datetime.datetime(2013, 6, 20, 14, 28, 13)
 datetime.datetime(2013, 6, 20, 14, 58, 9)
 datetime.datetime(2013, 6, 20, 14, 58, 11)
 datetime.datetime(2013, 6, 20, 14, 58, 13)
 datetime.datetime(2013, 6, 20, 15, 28, 9)
 datetime.datetime(2013, 6, 20, 15, 28, 11)
 datetime.datetime(2013, 6, 20, 15, 28, 13)
 datetime.datetime(2013, 6, 20, 15, 58, 9)
 datetime.datetime(2013, 6, 20, 15, 58, 11)
 datetime.datetime(2013, 6, 20, 15, 58, 13)
 datetime.datetime(2013, 6, 20, 16, 28, 9)
 datetime.datetime(2013, 6, 20, 16, 28, 11)
 datetime.datetime(2013, 6, 20, 16, 28, 13)
 datetime.datetime(2013, 6, 20, 16, 58, 9)
 datetime.datetime(2013, 6, 20, 16, 58, 11)
 datetime.datetime(2013, 6, 20, 16, 58, 13)
 datetime.datetime(2013, 6, 20, 17, 28, 9)
 datetime.datetime(2013, 6, 20, 17, 28, 11)
 datetime.datetime(2013, 6, 20, 17, 28, 13)
 datetime.datetime(2013, 6, 20, 17, 58, 9)
 datetime.datetime(2013, 6, 20, 17, 58, 11)
 datetime.datetime(2013, 6, 20, 17, 58, 13)
 datetime.datetime(2013, 6, 20, 18, 28, 9)
 datetime.datetime(2013, 6, 20, 18, 28, 11)
 datetime.datetime(2013, 6, 20, 18, 28, 13)
 datetime.datetime(2013, 6, 20, 18, 58, 9)
 datetime.datetime(2013, 6, 20, 18, 58, 11)
 datetime.datetime(2013, 6, 20, 18, 58, 13)
 datetime.datetime(2013, 6, 20, 19, 28, 9)
 datetime.datetime(2013, 6, 20, 19, 28, 11)
 datetime.datetime(2013, 6, 20, 19, 28, 13)
 datetime.datetime(2013, 6, 20, 19, 58, 9)
 datetime.datetime(2013, 6, 20, 19, 58, 11)
 datetime.datetime(2013, 6, 20, 19, 58, 13)
 datetime.datetime(2013, 6, 20, 20, 28, 9)
 datetime.datetime(2013, 6, 20, 20, 28, 11)
 datetime.datetime(2013, 6, 20, 20, 28, 13)
 datetime.datetime(2013, 6, 20, 20, 58, 9)
 datetime.datetime(2013, 6, 20, 20, 58, 11)
 datetime.datetime(2013, 6, 20, 20, 58, 13)
 datetime.datetime(2013, 6, 20, 21, 28, 9)
 datetime.datetime(2013, 6, 20, 21, 28, 11)
 datetime.datetime(2013, 6, 20, 21, 28, 13)
 datetime.datetime(2013, 6, 20, 21, 58, 9)
 datetime.datetime(2013, 6, 20, 21, 58, 11)
 datetime.datetime(2013, 6, 20, 21, 58, 13)
 datetime.datetime(2013, 6, 20, 22, 28, 9)
 datetime.datetime(2013, 6, 20, 22, 28, 11)
 datetime.datetime(2013, 6, 20, 22, 28, 13)
 datetime.datetime(2013, 6, 20, 22, 58, 9)
 datetime.datetime(2013, 6, 20, 22, 58, 11)
 datetime.datetime(2013, 6, 20, 22, 58, 13)
 datetime.datetime(2013, 6, 20, 23, 28, 9)
 datetime.datetime(2013, 6, 20, 23, 28, 11)
 datetime.datetime(2013, 6, 20, 23, 28, 13)
 datetime.datetime(2013, 6, 20, 23, 58, 9)
 datetime.datetime(2013, 6, 20, 23, 58, 11)
 datetime.datetime(2013, 6, 20, 23, 58, 13)
 datetime.datetime(2013, 6, 21, 0, 28, 9)
 datetime.datetime(2013, 6, 21, 0, 28, 11)
 datetime.datetime(2013, 6, 21, 0, 28, 13)
 datetime.datetime(2013, 6, 21, 0, 58, 9)
 datetime.datetime(2013, 6, 21, 0, 58, 11)
 datetime.datetime(2013, 6, 21, 0, 58, 13)
 datetime.datetime(2013, 6, 21, 1, 28, 9)
 datetime.datetime(2013, 6, 21, 1, 28, 11)
 datetime.datetime(2013, 6, 21, 1, 28, 13)
 datetime.datetime(2013, 6, 21, 1, 58, 9)
 datetime.datetime(2013, 6, 21, 1, 58, 11)
 datetime.datetime(2013, 6, 21, 1, 58, 13)
 datetime.datetime(2013, 6, 21, 2, 28, 9)
 datetime.datetime(2013, 6, 21, 2, 28, 11)
 datetime.datetime(2013, 6, 21, 2, 28, 13)
 datetime.datetime(2013, 6, 21, 2, 58, 9)
 datetime.datetime(2013, 6, 21, 2, 58, 11)
 datetime.datetime(2013, 6, 21, 2, 58, 13)
 datetime.datetime(2013, 6, 21, 3, 28, 9)
 datetime.datetime(2013, 6, 21, 3, 28, 11)
 datetime.datetime(2013, 6, 21, 3, 28, 13)
 datetime.datetime(2013, 6, 21, 3, 58, 9)
 datetime.datetime(2013, 6, 21, 3, 58, 11)
 datetime.datetime(2013, 6, 21, 3, 58, 13)
 datetime.datetime(2013, 6, 21, 4, 28, 9)
 datetime.datetime(2013, 6, 21, 4, 28, 11)
 datetime.datetime(2013, 6, 21, 4, 28, 13)
 datetime.datetime(2013, 6, 21, 4, 58, 9)
 datetime.datetime(2013, 6, 21, 4, 58, 11)
 datetime.datetime(2013, 6, 21, 4, 58, 13)
 datetime.datetime(2013, 6, 21, 5, 28, 9)
 datetime.datetime(2013, 6, 21, 5, 28, 11)
 datetime.datetime(2013, 6, 21, 5, 28, 13)
 datetime.datetime(2013, 6, 21, 5, 58, 9)
 datetime.datetime(2013, 6, 21, 5, 58, 11)
 datetime.datetime(2013, 6, 21, 5, 58, 13)
 datetime.datetime(2013, 6, 21, 6, 28, 9)
 datetime.datetime(2013, 6, 21, 6, 28, 11)
 datetime.datetime(2013, 6, 21, 6, 28, 13)
 datetime.datetime(2013, 6, 21, 6, 58, 9)
 datetime.datetime(2013, 6, 21, 6, 58, 11)
 datetime.datetime(2013, 6, 21, 6, 58, 13)
 datetime.datetime(2013, 6, 21, 7, 28, 9)
 datetime.datetime(2013, 6, 21, 7, 28, 11)
 datetime.datetime(2013, 6, 21, 7, 28, 13)
 datetime.datetime(2013, 6, 21, 7, 58, 9)
 datetime.datetime(2013, 6, 21, 7, 58, 11)
 datetime.datetime(2013, 6, 21, 7, 58, 13)
 datetime.datetime(2013, 6, 21, 8, 28, 9)
 datetime.datetime(2013, 6, 21, 8, 28, 11)
 datetime.datetime(2013, 6, 21, 8, 28, 13)
 datetime.datetime(2013, 6, 21, 8, 58, 9)
 datetime.datetime(2013, 6, 21, 8, 58, 11)
 datetime.datetime(2013, 6, 21, 8, 58, 13)
 datetime.datetime(2013, 6, 21, 9, 28, 9)
 datetime.datetime(2013, 6, 21, 9, 28, 11)
 datetime.datetime(2013, 6, 21, 9, 28, 13)
 datetime.datetime(2013, 6, 21, 9, 58, 9)
 datetime.datetime(2013, 6, 21, 9, 58, 11)
 datetime.datetime(2013, 6, 21, 9, 58, 13)
 datetime.datetime(2013, 6, 21, 10, 28, 9)
 datetime.datetime(2013, 6, 21, 10, 28, 11)
 datetime.datetime(2013, 6, 21, 10, 28, 13)
 datetime.datetime(2013, 6, 21, 10, 58, 9)
 datetime.datetime(2013, 6, 21, 10, 58, 11)
 datetime.datetime(2013, 6, 21, 10, 58, 13)
 datetime.datetime(2013, 6, 21, 11, 28, 9)
 datetime.datetime(2013, 6, 21, 11, 28, 11)
 datetime.datetime(2013, 6, 21, 11, 28, 13)
 datetime.datetime(2013, 6, 21, 11, 58, 9)
 datetime.datetime(2013, 6, 21, 11, 58, 11)
 datetime.datetime(2013, 6, 21, 11, 58, 13)
 datetime.datetime(2013, 6, 21, 12, 28, 9)
 datetime.datetime(2013, 6, 21, 12, 28, 11)
 datetime.datetime(2013, 6, 21, 12, 28, 13)
 datetime.datetime(2013, 6, 21, 12, 58, 9)
 datetime.datetime(2013, 6, 21, 12, 58, 11)
 datetime.datetime(2013, 6, 21, 12, 58, 13)
 datetime.datetime(2013, 6, 21, 13, 28, 9)
 datetime.datetime(2013, 6, 21, 13, 28, 11)
 datetime.datetime(2013, 6, 21, 13, 28, 13)
 datetime.datetime(2013, 6, 21, 13, 58, 9)
 datetime.datetime(2013, 6, 21, 13, 58, 11)
 datetime.datetime(2013, 6, 21, 13, 58, 13)
 datetime.datetime(2013, 6, 21, 14, 28, 9)
 datetime.datetime(2013, 6, 21, 14, 28, 11)
 datetime.datetime(2013, 6, 21, 14, 28, 13)
 datetime.datetime(2013, 6, 21, 14, 58, 9)
 datetime.datetime(2013, 6, 21, 14, 58, 11)
 datetime.datetime(2013, 6, 21, 14, 58, 13)],
error was: 'numpy.ndarray' object has no attribute 'find'
Consider setting raise_on_error=Falseto suppress

In [149]:
df2['CO2'].plot(figsize=(15,6))


Out[149]:
<matplotlib.axes.AxesSubplot at 0x8dd27d0>

In [155]:
# calculates 5 minute averages of all the data
df2_5min = df2.resample('5min', how = 'mean')
df2_5min['Temperature']


---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-155-630203014398> in <module>()
      1 # calculates 5 minute averages of all the data
      2 df2_5min = df2.resample('5min', how = 'mean')
----> 3 df2_5min['Temperature']

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/frame.py in __getitem__(self, key)
   1926         else:
   1927             # get column
-> 1928             return self._get_item_cache(key)
   1929 
   1930     def _getitem_slice(self, key):

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/generic.py in _get_item_cache(self, item)
    568             return cache[item]
    569         except Exception:
--> 570             values = self._data.get(item)
    571             res = self._box_item_values(item, values)
    572             cache[item] = res

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in get(self, item)
   1381 
   1382     def get(self, item):
-> 1383         _, block = self._find_block(item)
   1384         return block.get(item)
   1385 

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in _find_block(self, item)
   1523 
   1524     def _find_block(self, item):
-> 1525         self._check_have(item)
   1526         for i, block in enumerate(self.blocks):
   1527             if item in block:

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in _check_have(self, item)
   1530     def _check_have(self, item):
   1531         if item not in self.items:
-> 1532             raise KeyError('no item named %s' % com.pprint_thing(item))
   1533 
   1534     def reindex_axis(self, new_axis, method=None, axis=0, copy=True):

KeyError: u'no item named Temperature'

In [156]:
# clip to time when instrument was in water and measurement was continuous
df1_5min = df1_5min['2013-06-21 15:00:00':'2013-06-26 02:00:00']

In [157]:
df1_5min[['CO2','Temperature']].plot(figsize=(15,4),secondary_y = 'Temperature');


---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-157-0065cf5c7909> in <module>()
----> 1 df1_5min[['CO2','Temperature']].plot(figsize=(15,4),secondary_y = 'Temperature');

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/frame.py in __getitem__(self, key)
   1919         if isinstance(key, (np.ndarray, list)):
   1920             # either boolean or fancy integer index
-> 1921             return self._getitem_array(key)
   1922         elif isinstance(key, DataFrame):
   1923             return self._getitem_frame(key)

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/frame.py in _getitem_array(self, key)
   1951             return self.take(indexer, axis=0, convert=False)
   1952         else:
-> 1953             indexer = self.ix._convert_to_indexer(key, axis=1)
   1954             return self.take(indexer, axis=1, convert=True)
   1955 

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/indexing.py in _convert_to_indexer(self, obj, axis)
    581                 mask = check == -1
    582                 if mask.any():
--> 583                     raise KeyError('%s not in index' % objarr[mask])
    584 
    585                 return indexer

KeyError: "['Temperature'] not in index"

In [105]:
df1_5min['Pressure'].plot(figsize=(15,4));


---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-105-c819f48f9644> in <module>()
----> 1 df1_5min['Pressure'].plot(figsize=(15,4));

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/frame.py in __getitem__(self, key)
   1926         else:
   1927             # get column
-> 1928             return self._get_item_cache(key)
   1929 
   1930     def _getitem_slice(self, key):

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/generic.py in _get_item_cache(self, item)
    568             return cache[item]
    569         except Exception:
--> 570             values = self._data.get(item)
    571             res = self._box_item_values(item, values)
    572             cache[item] = res

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in get(self, item)
   1381 
   1382     def get(self, item):
-> 1383         _, block = self._find_block(item)
   1384         return block.get(item)
   1385 

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in _find_block(self, item)
   1523 
   1524     def _find_block(self, item):
-> 1525         self._check_have(item)
   1526         for i, block in enumerate(self.blocks):
   1527             if item in block:

/home/local/python27_epd/lib/python2.7/site-packages/pandas/core/internals.py in _check_have(self, item)
   1530     def _check_have(self, item):
   1531         if item not in self.items:
-> 1532             raise KeyError('no item named %s' % com.pprint_thing(item))
   1533 
   1534     def reindex_axis(self, new_axis, method=None, axis=0, copy=True):

KeyError: u'no item named Pressure'

In [107]:
# look at correlation between Temp and CO2
corrcoef(df1_5min['Temperature'],df1_5min['CO2'])


Out[107]:
array([[ nan,  nan],
       [ nan,  nan]])

In [109]:
plot(df1_5min['Temperature'],df1_5min['CO2'],'go');
grid();



In [14]: