Pandas Solution with 99.86% runtime beats, easy to understand
Approach\n Describe your approach to solving the problem. \n1. In the company dataframe find out the com_id with the name RED\n2. In the orders dataframe, we wi
# Approach\n<!-- Describe your approach to solving the problem. -->\n1. In the company dataframe find out the com_id with the name RED\n2. In the orders dataframe, we will select the sales_ids that interacted with red_com_id\n3. Let\'s select the lines that are NOT contained in orders\n# Code\n```\nimport pandas as pd\n\ndef sales_person(sales_person: pd.DataFrame, company: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:\n    red_com_id = company[company[\'name\'] == "RED"][\'com_id\']\n    orders = orders[orders[\'com_id\'].isin(red_com_id)][\'sales_id\']\n    return sales_person[~(sales_person[\'sales_id\'].isin(orders))][\'name\'].to_frame()\n```
['Pandas']