EasyNo. 1777LeetCode Premium
Product's Price for Each Store — LeetCode 1777 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | store | enum | | price | int | +-------------+---------+ In SQL, (product_id, store) is the primary key for this table. store is a category of type ('store1', 'store2', 'store3') where each represents the store this product is available at.Example
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| product_id | int |
| store | enum |
| price | int |
+-------------+---------+
In SQL, (product_id, store) is the primary key for this table.
store is a category of type ('store1', 'store2', 'store3') where each represents the store this product is available at.
price is the price of the product at this store.Python solution
import duckdb
import pandas as pd
def solution(products: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Products", products)
return con.execute("""SELECT
product_id,
SUM(IF(store = 'store1', price, NULL)) AS store1,
SUM(IF(store = 'store2', price, NULL)) AS store2,
SUM(IF(store = 'store3', price, NULL)) AS store3
FROM Products
GROUP BY 1;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 1777. Product's Price for Each Store?
LeetCode 1777. Product's Price for Each Store is rated Easy on LeetCode.
- What topics does LeetCode 1777. Product's Price for Each Store cover?
LeetCode 1777. Product's Price for Each Store is tagged Database on LeetCode.
- Is LeetCode 1777. Product's Price for Each Store a premium problem?
Yes. LeetCode 1777. Product's Price for Each Store is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.