Performing Vectorized Lookups with Pandas DataFrames and Series: A Comprehensive Guide to Merging Datasets