In [22]:

    

from pandas import DataFrame, read_csv

import matplotlib.pyplot as plt
import pandas as pd
import numpy as np

pd.set_option('display.line_width', 5000) 
pd.set_option('display.max_columns', 60) 

%matplotlib inline


    

    
Out[22]:





200.0

In [27]:

    

# Read in the data
Location = "data/contributions_6-16-14.csv"
df = read_csv(Location)

# Remove all non-mayor race contributions
mayor_ids = ['1357609', '1354678', '1362261', '1359017', '1342695']
df = df[df['Filer_ID'].isin(mayor_ids)]

def toFloat(x):
    x = x.replace(',', '')
    x = x.replace('$', '')
    x = x.replace('(', '')
    x = x.replace(')', '')
    return float(x)

# Convert dollars contributed to a float
df['Tran_Amt1'] = df['Tran_Amt1'].map(toFloat)

df.info()


    

    




<class 'pandas.core.frame.DataFrame'>
Int64Index: 1540 entries, 1746 to 3711
Data columns (total 78 columns):
Filer_ID                  1540 non-null object
Filer_NamL                1540 non-null object
Report_Num                1540 non-null int64
Committee_Type            1540 non-null object
Rpt_Date                  1540 non-null object
From_Date                 1540 non-null object
Thru_Date                 1540 non-null object
Elect_Date                1073 non-null object
tblCover_Office_Cd        0 non-null float64
tblCover_Offic_Dscr       0 non-null float64
Rec_Type                  1540 non-null object
Form_Type                 1540 non-null object
Tran_ID                   1540 non-null object
Entity_Cd                 1540 non-null object
Tran_NamL                 1540 non-null object
Tran_NamF                 1444 non-null object
Tran_NamT                 7 non-null object
Tran_NamS                 0 non-null object
Tran_Adr1                 0 non-null float64
Tran_Adr2                 0 non-null float64
Tran_City                 1540 non-null object
Tran_State                1539 non-null object
Tran_Zip4                 1540 non-null object
Tran_Emp                  1401 non-null object
Tran_Occ                  1444 non-null object
Tran_Self                 1540 non-null object
Tran_Type                 3 non-null object
Tran_Date                 1540 non-null object
Tran_Date1                0 non-null float64
Tran_Amt1                 1540 non-null float64
Tran_Amt2                 1540 non-null object
Tran_Dscr                 1 non-null object
Cmte_ID                   0 non-null object
Tres_NamL                 0 non-null float64
Tres_NamF                 0 non-null float64
Tres_NamT                 0 non-null float64
Tres_NamS                 0 non-null float64
Tres_Adr1                 0 non-null float64
Tres_Adr2                 0 non-null float64
Tres_City                 0 non-null float64
Tres_State                0 non-null float64
Tres_Zip                  0 non-null float64
Intr_NamL                 0 non-null object
Intr_NamF                 0 non-null float64
Intr_NamT                 0 non-null float64
Intr_NamS                 0 non-null float64
Intr_Adr1                 0 non-null float64
Intr_Adr2                 0 non-null float64
Intr_City                 0 non-null object
Intr_State                0 non-null object
Intr_Zip4                 0 non-null float64
Intr_Emp                  0 non-null float64
Intr_Occ                  0 non-null float64
Intr_Self                 1540 non-null object
Cand_NamL                 0 non-null float64
Cand_NamF                 0 non-null float64
Cand_NamT                 0 non-null float64
Cand_NamS                 0 non-null float64
tblDetlTran_Office_Cd     0 non-null object
tblDetlTran_Offic_Dscr    0 non-null object
Juris_Cd                  0 non-null object
Juris_Dscr                0 non-null float64
Dist_No                   0 non-null float64
Off_S_H_Cd                0 non-null float64
Bal_Name                  0 non-null float64
Bal_Num                   0 non-null float64
Bal_Juris                 0 non-null float64
Sup_Opp_Cd                0 non-null float64
Memo_Code                 0 non-null float64
Memo_RefNo                3 non-null object
BakRef_TID                0 non-null float64
XRef_SchNm                0 non-null float64
XRef_Match                0 non-null float64
Loan_Rate                 0 non-null float64
Int_CmteId                0 non-null float64
Tran_Location             0 non-null float64
Tres_Location             0 non-null float64
Intr_Location             0 non-null float64
dtypes: float64(43), int64(1), object(34)

In [ ]: