_175. Combine Two Tables.md

175. Combine Two Tables

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 76.91 %

---

Solutions

• e175.py
• e175.sql

Python

e175.py

import pandas as pd

def combine_two_tables(person: pd.DataFrame, address: pd.DataFrame) -> pd.DataFrame:
    return pd.merge(left=person, right=address, how='left', on='personId')[['firstName', 'lastName', 'city', 'state']]

SQL

e175.sql

SELECT firstName, lastName, city, state
    FROM Person LEFT OUTER JOIN Address ON Person.personId = Address.personId;