title: How to pass an array in python pandas to plot two axes?
body: <p>I am trying to create an XY chart using Python and the Pygal library. The source data is contained in a CSV file with three columns; ID, Portfolio and Value. Unfortunately I can only plot one axis and I suspect it's an issue with the array. Can anyone point me in the right direction? Do I need to use numpy? Thank you!</p>
  
  <pre><code>import pygal
  import pandas as pd
  data = pd.read_csv("profit.csv")
  data.columns = ["ID", "Portfolio", "Value"]
  xy_chart = pygal.XY()
  
  xy_chart.add('Portfolio', data['Portfolio','Value'] &lt;&lt; I suspect this is wrong
  )
  xy_chart.render_in_browser()
  </code></pre>
  
  <p>With</p>
  
  <pre><code>import pygal
  import pandas as pd
  data = pd.read_csv("profit.csv")
  data.columns = ["ID", "Portfolio", "Value"]
  xy_chart = pygal.XY()
  
  xy_chart.add('Portfolio', data['Portfolio']
  )
  xy_chart.render_in_browser()
  </code></pre>
  
  <p>I get:</p>
  
  <p>A graph with a series of horizontal data points/values; i.e. it has the X values but no Y values.</p>
  
  <p>With:</p>
  
  <pre><code>import pygal
  import pandas as pd
  data = pd.read_csv("profit.csv")
  data.columns = ["ID", "Portfolio", "Value"]
  xy_chart = pygal.XY()
  
  xy_chart.add('Portfolio', data['Portfolio','Value']
  )
  xy_chart.render_in_browser()
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>KeyError: ('Portfolio', 'Value')
  </code></pre>
  
  <p>Sample data:</p>
  
  <pre><code>ID  Portfolio   Value
  1   1   -2560.042036
  2   2   1208.106958
  3   3   5702.386949
  4   4   -8827.63913
  5   5   -3881.665733
  6   6   5951.602484
  </code></pre>