Skip to content

1757. Recyclable and Low Fat Products

EasyLeetCode
Column NameType
product_idint
low_fatsenum
recyclableenum

product_id is the primary key (column with unique values) for this table.

low_fats is an ENUM (category) of type ('Y', 'N') where 'Y' means this product is low fat and 'N' means it is not.

recyclable is an ENUM (category) of types ('Y', 'N') where 'Y' means this product is recyclable and 'N' means it is not.

Write a solution to find the ids of products that are both low fat and recyclable.

Return the result table in any order.

The result format is in the following example.

Example 1:

Input: Products table:

product_idlow_fatsrecyclable
0YN
1YY
2NY
3YY
4NN

Output:

product_id
1
3

Explanation: Only products 1 and 3 are both low fat and recyclable.

How to solve the problem

SQL or Pandas

Code

Python
import pandas as pd

def find_products(products: pd.DataFrame) -> pd.DataFrame:
    result = products[(products['low_fats'] == 'Y') & (products['recyclable'] == 'Y')][['product_id']]
    return result
sql
SELECT product_id 
FROM Products 
WHERE low_fats = 'Y' AND recyclable = 'Y';

Complexity

Time complexity: O(1)

Space complexity: O(1)

Comments

No comments yet. Be the first to comment!