Python Programming approach - data manipulation in excel

Python Programming approach - data manipulation in excel

I'm using the python packages xlrd and xlwt to read and write from excel
spreadsheets using python. I can't figure out how to write the code to
solve my problem though.
So my data consists of a column of state abbreviations and a column of
numbers, 1 through 7. There are about 200-300 entries per state, and i
want to figure out how many ones, twos, threes, and so on exist for each
state. I'm struggling with what method I'd use to figure this out.
normally i would post the code i already have but i don't even know where
to begin.