Using pandasql to Assign Output to New Column in DataFrame

Creating New Columns in Pandas DataFrames by Looking Up Values in Another Column