LeetCode 607 - Sales Person (Python and SQL) [Easy]

LeetCode 607 - Sales Person: leetcode.com/p...
Interested in discussing a Data or AI project? Feel free to reach out via email or simply complete the contact form on my website.
📧 Email: [e-mail]
🌐 Website & Blog: ryannolandata....
🍿 WATCH NEXT
LeetCode Playlist: • Leetcode Data Science ...
LeetCode 610: • LeetCode 610 - Triangl...
LeetCode 176: • LeetCode 176 - Second ...
LeetCode 608: • LeetCode 608 - Tree No...
MY OTHER SOCIALS:
👨‍💻 LinkedIn: / ryan-p-nolan
🐦 Twitter: / ryannolan_
⚙️ GitHub: github.com/Rya...
🖥️ Discord: / discord
📚 *Data and AI Courses: datacamp.pxf.i...
📚 *Practice SQL & Python Interview Questions: stratascratch....
WHO AM I?
As a full-time data analyst/scientist at a fintech company specializing in combating fraud within underwriting and risk, I've transitioned from my background in Electrical Engineering to pursue my true passion: data. In this dynamic field, I've discovered a profound interest in leveraging data analytics to address complex challenges in the financial sector.
This KZbin channel serves as both a platform for sharing knowledge and a personal journey of continuous learning. With a commitment to growth, I aim to expand my skill set by publishing 2 to 3 new videos each week, delving into various aspects of data analytics/science and Artificial Intelligence. Join me on this exciting journey as we explore the endless possibilities of data together.
*This is an affiliate program. I may receive a small portion of the final sale at no extra cost to you.

[@RyanAndMattDataScience]

Hey guys I hope you enjoyed the video! If you did please subscribe to the channel! Join our Data Science Discord Here: discord.com/invite/F7dxbvHUhg If you want to watch a full course on Python Pandas check out Datacamp: datacamp.pxf.io/XYD7Qg Want to solve Python data interview questions: stratascratch.com/?via=ryan I'm also open to freelance data projects. Hit me up at [e-mail] *Both Datacamp and Stratascratch are affiliate links.

[@SMHamid-vt6yy]

import pandas as pd def sales_person(sales_person: pd.DataFrame, company: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame: company=company.rename(columns={"name":"colour"}) df=orders.merge(company, on="com_id").merge(sales_person, on="sales_id") res=list(set(sales_person.name)-set(df[df.colour=="RED"].name)) return pd.DataFrame({'name':res}) This is a simpler solution for pandas any thoughts on this ?

[@kian69topgun1]

dude, your entire screen of code was not even visible

[@RyanAndMattDataScience]

All of it is on the screen for Sql and barely any is missing for Python and I say what I’m typing