3415. Find Products with Three Consecutive Digits 🔒

题目描述

Table: Products

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| product_id  | int     |
| name        | varchar |
+-------------+---------+
product_id is the unique key for this table.
Each row of this table contains the ID and name of a product.

Write a solution to find all products whose names contain a sequence of exactly three digits in a row. 

Return the result table ordered by product_id in ascending order.

The result format is in the following example.

 

Example:

Input:

products table:

+-------------+--------------------+
| product_id  | name               |
+-------------+--------------------+
| 1           | ABC123XYZ          |
| 2           | A12B34C            |
| 3           | Product56789       |
| 4           | NoDigitsHere       |
| 5           | 789Product         |
| 6           | Item003Description |
| 7           | Product12X34       |
+-------------+--------------------+

Output:

+-------------+--------------------+
| product_id  | name               |
+-------------+--------------------+
| 1           | ABC123XYZ          |
| 5           | 789Product         |
| 6           | Item003Description |
+-------------+--------------------+

Explanation:

• Product 1: ABC123XYZ contains the digits 123.
• Product 5: 789Product contains the digits 789.
• Product 6: Item003Description contains 003, which is exactly three digits.

Note:

• Results are ordered by product_id in ascending order.
• Only products with exactly three consecutive digits in their names are included in the result.

解法

方法一：正则匹配

我们可以使用正则表达式来匹配包含三个连续数字的产品名称。

MySQLPython3

# Write your MySQL query statement below
SELECT product_id, name
FROM Products
WHERE name REGEXP '(^|[^0-9])[0-9]{3}([^0-9]|$)'
ORDER BY 1;

import pandas as pd


def find_products(products: pd.DataFrame) -> pd.DataFrame:
    filtered = products[
        products["name"].str.contains(r"(^|[^0-9])[0-9]{3}([^0-9]|$)", regex=True)
    ]
    return filtered.sort_values(by="product_id")

评论