🔥 Pandas Easy and Concise Solution For Beginners 💯
\uD83D\uDD3C IF YOU FIND THIS POST HELPFUL PLEASE UPVOTE \uD83D\uDC4D\n\nimport pandas as pd\n\ndef sales_person(sales_person: pd.DataFrame, company: pd.DataFra
**\uD83D\uDD3C IF YOU FIND THIS POST HELPFUL PLEASE UPVOTE \uD83D\uDC4D**\n```\nimport pandas as pd\n\ndef sales_person(sales_person: pd.DataFrame, company: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:\n    \n    intermediate_merge = sales_person.merge(right=orders, how="outer", on="sales_id")\n\n    final_merge = intermediate_merge.merge(right=company, how="left", on="com_id")\n\n    red = final_merge[final_merge["name_y"] == "RED"][["name_x"]]\n\n    non_red = sales_person[["name"]].merge(right=red, how="outer", left_on="name", right_on="name_x", indicator=True)\n\n    return non_red[non_red["_merge"] == "left_only"][["name"]]\n```\n**Thank you for reading! \uD83D\uDE04 Comment if you have any questions or feedback.**
['Python', 'Python3']