title: How to read and plot arrays from pandas df fast
body: <p>I have following data frame in pandas that contains array reading it directly from a sqlite db using pd.read_sql():</p>
  
  <pre><code>      ArrayID  Value
   0        0      0
   1        0      1
   2        0      2
   3        0      3
   4        0      4
   5        0      5
   6        1      0
   7        1      1
   8        1      2
   9        1      3
  </code></pre>
  
  <p>I would like to know a fast way to get the arrays so I can plot it:</p>
  
  <pre><code>Array0 [0,1,2,3,4,5]
  
  Array1 [0,1,2,3]
  </code></pre>
  
  <p>The only way I could think was (really slow when the table has 1000 arrays with arrays varying on length having maxixum length of 500):</p>
  
  <pre><code>import pandas as pd    
  import matplotlib.pyplot as plt
  
  # loop on
  for id in df.ArrayID:
      array = df.loc[df["ArrayID"]==id, "Value"].values()
      plt.plot(array)
  
  plt.show()
  </code></pre>
  
  <p>Or is the matplotlib beeing the issue?</p>