Pandas | LeetCode 1683. 15자를 초과한 트윗 찾기
·
BI & Visualization/Python
Table: Tweets+----------------+---------+| Column Name | Type |+----------------+---------+| tweet_id | int || content | varchar |+----------------+---------+tweet_id is the primary key (column with unique values) for this table.content consists of alphanumeric characters, '!', or ' ' and no other special characters.This table contains all the tweets in a social media app...
Pandas | LeetCode 1148. 자신이 쓴 글을 본 작가 찾기
·
BI & Visualization/Python
Table: Views+---------------+---------+| Column Name | Type |+---------------+---------+| article_id | int || author_id | int || viewer_id | int || view_date | date |+---------------+---------+There is no primary key (column with unique values) for this table, the table may have duplicate rows.Each row of this table indicates that some viewer viewed an article ..
Pandas | LeetCode 183. 주문하지 않은 고객 찾기
·
BI & Visualization/Python
Table: Customers+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table indicates the ID and name of a customer. Table: Orders+-------------+------+| Column Name | Type |+-------------+------+| id | int || ..
Pandas | LeetCode 1757. 연산자를 사용하여 조건 만족하는 행 추출하기
·
BI & Visualization/Python
Table: Products+-------------+---------+| Column Name | Type |+-------------+---------+| product_id | int || low_fats | enum || recyclable | enum |+-------------+---------+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..
Pandas | LeetCode 595. World 테이블에서 큰 나라 찾기
·
BI & Visualization/Python
Table: World+-------------+---------+| Column Name | Type |+-------------+---------+| name | varchar || continent | varchar || area | int || population | int || gdp | bigint |+-------------+---------+name is the primary key (column with unique values) for this table.Each row of this table gives information about the name of a country, the continent to which i..
올리브한입