Simplifying Conditional Filtering in Pandas DataFrames: A Better Approach to Finding Matching Companies

Creating a New Column in a Smaller DataFrame Based on Conditions Met by Another Larger DataFrame