title: GroupBy results to dictionary of lists
body: <p>I have an excel sheet that looks like so:</p>
  
  <pre><code>Column1 Column2 Column3
  0       23      1
  1       5       2
  1       2       3
  1       19      5
  2       56      1
  2       22      2
  3       2       4
  3       14      5
  4       59      1
  5       44      1
  5       1       2
  5       87      3
  </code></pre>
  
  <p>And I'm looking to extract that data, group it by column 1, and add it to a dictionary so it appears like this:</p>
  
  <pre><code>{0: [1],
  1: [2,3,5],
  2: [1,2],
  3: [4,5],
  4: [1],
  5: [1,2,3]}
  </code></pre>
  
  <p>This is my code so far</p>
  
  <pre><code>excel = pandas.read_excel(r"e:\test_data.xlsx", sheetname='mySheet', parse_cols'A,C')
  myTable = excel.groupby("Column1").groups
  print myTable
  </code></pre>
  
  <p>However, my output looks like this:</p>
  
  <pre><code>{0: [0L], 1: [1L, 2L, 3L], 2: [4L, 5L], 3: [6L, 7L], 4: [8L], 5: [9L, 10L, 11L]}
  </code></pre>
  
  <p>Thanks!</p>