In [3]:

    

import numpy as np
import matplotlib.pyplot as plt
import xlrd as xlrd
import datetime as dt
import pandas as pd


    

In [18]:

    

dateparse = lambda x: pd.datetime.strptime(x, '%Y-%m-%d %H:%M:%S')

dataset = pd.read_csv('data1.csv', usecols=[1,2],parse_dates=[1], engine='python', skipfooter=3)


    

In [20]:

    

plt.plot(dataset)
#print(dataset)
plt.show()


    

    




---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-20-d3b928a0acd9> in <module>()
----> 1 plt.plot(dataset)
      2 #print(dataset)
      3 plt.show()

/usr/local/lib/python3.5/dist-packages/matplotlib/pyplot.py in plot(*args, **kwargs)
   3159         ax.hold(hold)
   3160     try:
-> 3161         ret = ax.plot(*args, **kwargs)
   3162     finally:
   3163         ax.hold(washold)

/usr/local/lib/python3.5/dist-packages/matplotlib/__init__.py in inner(ax, *args, **kwargs)
   1817                     warnings.warn(msg % (label_namer, func.__name__),
   1818                                   RuntimeWarning, stacklevel=2)
-> 1819             return func(ax, *args, **kwargs)
   1820         pre_doc = inner.__doc__
   1821         if pre_doc is None:

/usr/local/lib/python3.5/dist-packages/matplotlib/axes/_axes.py in plot(self, *args, **kwargs)
   1381 
   1382         for line in self._get_lines(*args, **kwargs):
-> 1383             self.add_line(line)
   1384             lines.append(line)
   1385 

/usr/local/lib/python3.5/dist-packages/matplotlib/axes/_base.py in add_line(self, line)
   1701             line.set_clip_path(self.patch)
   1702 
-> 1703         self._update_line_limits(line)
   1704         if not line.get_label():
   1705             line.set_label('_line%d' % len(self.lines))

/usr/local/lib/python3.5/dist-packages/matplotlib/axes/_base.py in _update_line_limits(self, line)
   1723         Figures out the data limit of the given line, updating self.dataLim.
   1724         """
-> 1725         path = line.get_path()
   1726         if path.vertices.size == 0:
   1727             return

/usr/local/lib/python3.5/dist-packages/matplotlib/lines.py in get_path(self)
    936         """
    937         if self._invalidy or self._invalidx:
--> 938             self.recache()
    939         return self._path
    940 

/usr/local/lib/python3.5/dist-packages/matplotlib/lines.py in recache(self, always)
    632                 y = ma.asarray(yconv, np.float_).filled(np.nan)
    633             else:
--> 634                 y = np.asarray(yconv, np.float_)
    635             y = y.ravel()
    636         else:

/usr/local/lib/python3.5/dist-packages/numpy/core/numeric.py in asarray(a, dtype, order)
    480 
    481     """
--> 482     return array(a, dtype, copy=False, order=order)
    483 
    484 def asanyarray(a, dtype=None, order=None):

ValueError: could not convert string to float: '15/08/2016 05:00:00'

In [27]:

    




    

In [25]:

    




    

In [ ]:

    




    

In [ ]: