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]:
Content source: rsignell-usgs/notebook
Similar notebooks: