manasRK

#List unique values in a DataFrame column
pd.unique(df.column_name.ravel())

#Convert Series datatype to numeric, getting rid of any non-numeric values
df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

#Grab DataFrame rows where column has certain values
valuelist = ['value1', 'value2', 'value3']
df = df[df.column.isin(value_list)]

manasRK

manasRK

#Public Data Sources

##Legislative

• United States on github They have a great US module that has state abbrevs, names, etc. O'Reilly article about the project
• The State Decoded
  • definition parsing
• Legislative Documents in XML at the United States House of Representatives
• US Government Web Services and XML Data Sources