In [13]:
import matplotlib.pyplot as plt
import pandas as pd
%matplotlib


Using matplotlib backend: Qt4Agg

In [14]:
df = pd.read_csv("madison_PI_2014-04-30_to_2015-04-30_aggregate.csv")
df.columns


Out[14]:
Index([u'PI', u'CPU Hours: Total', u'Job Size: Per Job (Core Count)'], dtype='object')

In [15]:
plt.plot(df["PI"], df["CPU Hours: Total"], 'ro')
plt.show()


---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-15-d9194ca4bc8f> in <module>()
----> 1 plt.plot(df["PI"], df["CPU Hours: Total"], 'ro')
      2 plt.show()

c:\Anaconda\lib\site-packages\matplotlib\pyplot.pyc in plot(*args, **kwargs)
   2985         ax.hold(hold)
   2986     try:
-> 2987         ret = ax.plot(*args, **kwargs)
   2988         draw_if_interactive()
   2989     finally:

c:\Anaconda\lib\site-packages\matplotlib\axes.pyc in plot(self, *args, **kwargs)
   4136 
   4137         for line in self._get_lines(*args, **kwargs):
-> 4138             self.add_line(line)
   4139             lines.append(line)
   4140 

c:\Anaconda\lib\site-packages\matplotlib\axes.pyc in add_line(self, line)
   1495             line.set_clip_path(self.patch)
   1496 
-> 1497         self._update_line_limits(line)
   1498         if not line.get_label():
   1499             line.set_label('_line%d' % len(self.lines))

c:\Anaconda\lib\site-packages\matplotlib\axes.pyc in _update_line_limits(self, line)
   1506         Figures out the data limit of the given line, updating self.dataLim.
   1507         """
-> 1508         path = line.get_path()
   1509         if path.vertices.size == 0:
   1510             return

c:\Anaconda\lib\site-packages\matplotlib\lines.pyc in get_path(self)
    741         """
    742         if self._invalidy or self._invalidx:
--> 743             self.recache()
    744         return self._path
    745 

c:\Anaconda\lib\site-packages\matplotlib\lines.pyc in recache(self, always)
    418                 x = ma.asarray(xconv, np.float_)
    419             else:
--> 420                 x = np.asarray(xconv, np.float_)
    421             x = x.ravel()
    422         else:

c:\Anaconda\lib\site-packages\numpy\core\numeric.pyc in asarray(a, dtype, order)
    460 
    461     """
--> 462     return array(a, dtype, copy=False, order=order)
    463 
    464 def asanyarray(a, dtype=None, order=None):

ValueError: could not convert string to float: Halzen, Francis  

In [ ]: