01204212/homework/sorting

This is part of 01204212

The data

Source: This data is taken from The Guardian.

Download: us-election.csv

First few lines:

State Postal,County Name,FIPS,Obama vote,Romney vote
AK,Alaska,0,91696,121234
AK,Alaska,2000,91696,121234
AL,Alabama,0,793620,1252453
AL,Autauga,1001,6354,17366
AL,Baldwin,1003,18329,65772
AL,Barbour,1005,5873,5539
AL,Bibb,1007,2200,6131
AL,Blount,1009,2961,20741
AL,Bullock,1011,4058,1250
AL,Butler,1013,4367,5081
AL,Calhoun,1015,15500,30272
AL,Chambers,1017,6853,7596
AL,Cherokee,1019,2126,7494
AL,Chilton,1021,3391,13910

Sample output

County                                     Obama     Romney   Obama%   Romney%
-------------------------------------------------------------------------------
Shannon (SD)                                2922        188   93.955     6.045
District of Columbia (DC)                 222332      17337   92.766     7.234
Penobscot Nation Vot Dst (ME)                253         23   91.667     8.333
Bronx (NY)                                288378      26304   91.641     8.359
Provincetown (MA)                           2121	210   90.991     9.009
Prince George's (MD)                      317342      32236   90.779     9.221
Monhegan Plt. (ME)                            49          5   90.741     9.259
Isle Au Haut (ME)                             48          5   90.566     9.434
Petersburg (VA)                            14377       1526   90.404     9.596
Indian Township Vtng Dst (ME)                208         25   89.270    10.730
Jefferson (MS)                              3508        431   89.058    10.942
Baltimore City (MD)                       201042      25501   88.743    11.257