title: Generating Pivot Tables in Python - Pandas? Numpy? Xlrd? from csv
body: <p>I have been searching for hours, literally the entire day on how to generate a pivot table in Python. I am very new to python so please bear with me. </p>
  
  <p>What I want is to take a csv file, extract the first column and generate a pivot table using the count or frequency of the numbers in that column, and sort descending</p>
  
  <pre><code>import pandas
  
  import numpy 
  
  
  from numpy import recfromtxt
  a = recfromtxt('1.csv', skiprows=1, usecols=0, delimiter=',')
  
  
  print a
  </code></pre>
  
  <p>^ what i get here is a list of the first column [2 2 2 6 7]</p>
  
  <p>What i need is an export of 2 columns  </p>
  
  <p>2--3</p>
  
  <p>6--1</p>
  
  <p>7--1</p>