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

PandasQL: A Powerful Extension for Data Manipulation and Analysis