{ "metadata": { "name": "", "signature": "sha256:28f034a531b1925724959079a55f964ded07e33205fc78a28e8e1109a5cb8032" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "heading", "level": 1, "metadata": {}, "source": [ "Example: 2012 Federal Election Commission Database" ] }, { "cell_type": "code", "collapsed": false, "input": [ "from __future__ import division\n", "from numpy.random import randn\n", "import numpy as np\n", "import os\n", "import matplotlib.pyplot as plt\n", "np.random.seed(12345)\n", "plt.rc('figure', figsize=(10, 6))\n", "from pandas import *\n", "import pandas\n", "np.set_printoptions(precision=4)\n", "%cd book_scripts/fec" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "/home/phillip/Documents/code/py/pandas-book/rev_539000/book_scripts/fec\n" ] } ], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "fec = read_csv('P00000001-ALL.csv')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 5 }, { "cell_type": "code", "collapsed": false, "input": [ "fec" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | cmte_id | \n", "cand_id | \n", "cand_nm | \n", "contbr_nm | \n", "contbr_city | \n", "... | \n", "receipt_desc | \n", "memo_cd | \n", "memo_text | \n", "form_tp | \n", "file_num | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "HARVEY, WILLIAM | \n", "MOBILE | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "736166 | \n", "
1 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "HARVEY, WILLIAM | \n", "MOBILE | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "736166 | \n", "
2 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "SMITH, LANIER | \n", "LANETT | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "749073 | \n", "
3 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "BLEVINS, DARONDA | \n", "PIGGOTT | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "749073 | \n", "
4 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "WARDENBURG, HAROLD | \n", "HOT SPRINGS NATION | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "736166 | \n", "
5 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "BECKMAN, JAMES | \n", "SPRINGDALE | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "736166 | \n", "
6 | \n", "C00410118 | \n", "P20002978 | \n", "Bachmann, Michelle | \n", "BLEVINS, DARONDA | \n", "PIGGOTT | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "736166 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1001724 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "HEFFERNAN, JILL PRINCE MRS. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001725 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "ELWOOD, MIKE MR. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001726 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "GORMAN, CHRIS D. MR. | \n", "INFO REQUESTED | \n", "... | \n", "REATTRIBUTION / REDESIGNATION REQUESTED (AUTOM... | \n", "NaN | \n", "REATTRIBUTION / REDESIGNATION REQUESTED (AUTOM... | \n", "SA17A | \n", "751678 | \n", "
1001727 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "DUFFY, DAVID A. MR. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001728 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "GRANE, BRYAN F. MR. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001729 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "TOLBERT, DARYL MR. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001730 | \n", "C00500587 | \n", "P20003281 | \n", "Perry, Rick | \n", "ANDERSON, MARILEE MRS. | \n", "INFO REQUESTED | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "SA17A | \n", "751678 | \n", "
1001731 rows \u00d7 16 columns
\n", "